「Java」BaseDaoクラスでSQLServerに接続するコード

2017年5月1日

Javaコード
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class BaseDao {
private String drive="com.microsoft.sqlserver.jdbc.SQLServerDriver";
private String url="jdbc:sqlserver://172.17.2.200:1433;DatabaseName=ShopProTbl";
private String user="sa";
private String password="123456″;
protected Connection conn;
protected PreparedStatement ps;
protected ResultSet rs;
public Connection getCon(){
try {
Class.forName(drive);
conn=DriverManager.getConnection(url, user, password);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}

return conn;
}
public void allClos(ResultSet rs,PreparedStatement ps,Connection conn){

try {
if(rs!=null){
rs.close();
}
if(ps!=null){
ps.close();
}
if(conn!=null){
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
public int executeUpdate(String sql,Object…str){
int num=0;
try {
ps=getCon().prepareStatement(sql);
if(ps!=null){
for(int i=0;i<str.length;i++){
ps.setObject(i+1, str[i]); }
}
num=ps.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally
{
allClos(rs, ps, conn);
}
return num;
}

}