public static Connection getConnection(){
Connection conn = null;
try{
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","123456");
}catch(ClassNotFoundException e){
e.printStackTrace();
}catch(SQLException e){
e.printStackTrace();
}
return conn;
}
public static void close(Connection conn,PreparedStatement pst,ResultSet rs){
try{
if(rs !=null)
rs.close();
if(pst !=null )
pst.close();
if(conn !=null)
conn.close();
}catch(SQLException e){
e.printStackTrace();
}
}
}
操作數據庫
public class NewsDAO implements INewsDAO{
private Connection conn;
private PreparedStatement pst;
private ResultSet rs;
private String sql;
private Connection conn;
private PreparedStatement pst;
private ResultSet rs;
private String sql;
@Override
public boolean addNews(News n) {
sql="insert into News(title,mold,content,status,issuer) values(?,?,?,?,?)";
boolean flag = false;
try{
conn=ConnectionUtil.getConnection();
pst=conn.prepareStatement(sql);
pst.setString(1, n.getTitle());
pst.setString(2, n.getMold());
pst.setString(3, n.getContent());
pst.setString(4, n.getStatus());
pst.setString(5, n.getIssuer());
flag = pst.execute();
return flag;
}catch(SQLException e){
e.printStackTrace();
}finally{
ConnectionUtil.close(conn, pst, rs);
}
return flag;
}
public boolean addNews(News n) {
sql="insert into News(title,mold,content,status,issuer) values(?,?,?,?,?)";
boolean flag = false;
try{
conn=ConnectionUtil.getConnection();
pst=conn.prepareStatement(sql);
pst.setString(1, n.getTitle());
pst.setString(2, n.getMold());
pst.setString(3, n.getContent());
pst.setString(4, n.getStatus());
pst.setString(5, n.getIssuer());
flag = pst.execute();
return flag;
}catch(SQLException e){
e.printStackTrace();
}finally{
ConnectionUtil.close(conn, pst, rs);
}
return flag;
}