jsp实现对数据库add操作

以新闻为例

首先创建News，然后实现其中方法

package cn.hpu.model;


public class News {
    private int id;
    private String title;
    private String context;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getTitle() {
return title;
}
public void setTitle(String title) {
this.title = title;
}
public String getContext() {
return context;
}
public void setContext(String context) {
this.context = context;
}
    
}

然后创建操作接口

package cn.hpu.service;


import cn.hpu.model.News;


import java.util.List;


public interface NewsMa {
    public List<News> getNews();
    
    public boolean add(News news);
}

实现接口中的方法

package cn.hpu.service;


import java.sql.Connection;
import java.sql.PreparedStatement;
import java.util.List;


import cn.hpu.model.News;
import cn.hpu.util.DBO;




public class NewsMaImpl implements NewsMa{
public List<News> getNews() {
// TODO Auto-generated method stub
return null;
}


public boolean add(News news) {

return true;
}


  }

链接数据库

package cn.hpu.util;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;


public class DBO {
// ����MySQL����ݿ������
public static final String DBDRIVER = "org.gjt.mm.mysql.Driver" ;
//����mysql����ݿ����ӵ�ַ��
public static final String DBDURL = "jdbc:mysql://localhost:3306/jsp_news" ;
//mysql��ݿ�������û���
public static final String DBUSER = "root" ;
//mysql��ݿ����������
public static final String DBPASS = "1234" ;

static{
try {
Class.forName(DBDRIVER);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}

public static Connection getConnection(){
Connection conn=null;
try {
conn=DriverManager.getConnection(DBDURL,DBUSER,DBPASS);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}

public static void close(ResultSet rs,Statement st,Connection conn){

try {

if(rs!=null){
rs.close();
}
if(st!=null){
st.close();
}
if(conn!=null){
conn.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

} 

public static void close(Statement st,Connection conn){
close(null,st,conn);
}


}

创建登陆页面并实现验证。此处省略

     实现添加的时候别忘了接口add里面的

public boolean add(News news) {
// TODO Auto-generated method stub
boolean flag=false;
Connection conn=null;
PreparedStatement pst =null;
try {
conn=DBO.getConnection();
String sql=("insert into news (title,context) value(?,?)");
pst=conn.prepareStatement(sql);
pst.setString(1,news.getTitle());
pst.setString(2, news.getContext());
int rows=pst.executeUpdate();
if(rows>0){
flag=true;
}
} catch (Exception e) {
// TODO: handle exception
}finally{
DBO.close(pst, conn);
}
return flag;
}


  }