展开全部
给你个baseDao类吧packagedao;
importjava.sql.Connection;
importjava.sql.DriverManager;
importjava.sql.PreparedStatement;
importjava.sql.ResultSet;
publicclassBaseDao{
privateStringdriver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
privateStringurl="jdbc:sqlserver://localhost:1433;databaseName=EasyBuy";
privateStringuser="sa";
privateStringpassword="sa";
/**
*获取数据库连接对象
*
*@return
*/
publicConnectiongetcConnection(){
Connectionconn=null;
try{
Class.forName(driver);
conn=DriverManager.getConnection(url,user,password);
}catch(Exceptione){
e.printStackTrace();
}
returnconn;
}
/**
*关闭数62616964757a686964616fe59b9ee7ad9431333337373537据库连接对象
*@paramrs
*@parampstmt
*@paramconn
*/
publicvoidcloseAll(ResultSetrs,PreparedStatementpstmt,Connectionconn){
try{
if(rs!=null){
rs.close();
}
if(pstmt!=null){
pstmt.close();
}
if(conn!=null){
conn.close();
}
}catch(Exceptione){
e.printStackTrace();
}
}
/**
*增删改方法
*@paramsql
*@paramobjects
*@return
*/
publicintexecuteUpdate(Stringsql,Object[]objects){
intnum=0;
PreparedStatementpstmt=null;
Connectionconn=getcConnection();
try{
pstmt=conn.prepareStatement(sql);
for(inti=0;i
pstmt.setObject(i+1,objects[i]);
}
num=pstmt.executeUpdate();
}catch(Exceptione){
e.printStackTrace();
}finally{
closeAll(null,pstmt,conn);
}
returnnum;
}
}