JSP中对MySQL数据操作的封装

这次我们做一个课程项目，我们小组决定利用JSP进行开发，其中的重点是对数据库中的数据的操作，数据库的连接成为重点，我利用一个SqlManager类，对数据库的操作进行了封装，这现在只适用于MYSQL数据库的链接，如果想改变链接到其他数据库，可以自己添加。代码如下

package sample;
import java.sql.*;


public class SqlManager {
private static SqlManager p = null;//静态成员，支持单态模式
private static String jdbcDriver = null;
private String DBhost = "localhost";
private String DBname = "lib";
private String DBport = "3306";
private String DBuser = "root";
private String DBpasswd = "123";

private Connection Sqlconn = null;
private Statement Sqlstmt = null;
private String strCon = null;

private SqlManager(){
jdbcDriver = "com.mysql.jdbc.Driver";
strCon = "jdbc:mysql://"+ DBhost + ":"+ DBport + "/" + DBname;
}
public static SqlManager createInstance(){
if(p == null){
p = new SqlManager();
p.initDB();
}
return p;
}

public void initDB(){
System.out.println(strCon);
System.out.println(jdbcDriver);
try{
Class.forName("com.mysql.jdbc.Driver");
}catch(Exception ex){
System.err.println("Can't Find Database Driver");
}
}
public void connectDB(){
try{
System.out.println("SqlManager:Connecting to database...");
Sqlconn = DriverManager.getConnection(strCon,DBuser,DBpasswd);
Sqlstmt = Sqlconn.createStatement();//创建查询
}catch(SQLException ex){
System.err.println("connectDB"+ ex.getMessage());
}
System.out.println("SqlManager:Connect to database successful.");
}

public void closeDB(){
try{
System.out.println("SqlManager:Close connection to database..");
Sqlstmt.close();
Sqlconn.close();
}catch(SQLException ex){
System.err.println("closeDB" + ex.getMessage());
}
System.out.println("SqlManager: Close connection successful");
}
public int executeUpdate(String sql){
int ret = 0;
try{
ret = Sqlstmt.executeUpdate(sql);
}catch(SQLException ex){
System.err.println("executeUpdate:" + ex.getMessage());
}
return ret;
}

public ResultSet executeQuery(String sql){
ResultSet rs = null;
try{
rs = Sqlstmt.executeQuery(sql);
}catch(SQLException ex){
System.err.println("executeQuery:"+ ex.getMessage());
}
return rs;
}
public static void main(String[] args){
SqlManager.createInstance().connectDB();
SqlManager.createInstance().closeDB();
}
}