JSP网站系统数据库Mysql封装及连接主要代码

package DB;

import java.sql.*;

public class DBManager {

 Connection conn = null;
 Statement stmt = null;
 ResultSet rs = null;
 String DB = "连接数据库名"; // 数据库名
 String Password = "输入数据库密码"; // 数据库登陆密码
 String user = "root"; // 连接数据库用户名
 String setcharcter = "utf8"; // 数据库字符设置

 // 返回数据库连接对象
 public Connection Creatconn() {
  conn = null;
  try {
   Class.forName("com.mysql.jdbc.Driver").newInstance();
   String url = "jdbc:mysql://localhost:3306/" + DB + "?user=" + user
     + "&password=" + Password
     + "&useUnicode=true&characterEncoding=" + setcharcter;
   conn = DriverManager.getConnection(url);
   return conn;

  } catch (Exception fe) {
   System.err.println("Creatconn(): " + fe.getMessage());
   return null;
  }
 }

 // 返回状态集对象
 public Statement CreatStat() {
  stmt = null;
  try {
   if (conn == null) {
    conn = this.Creatconn();
   }
   stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
     ResultSet.CONCUR_UPDATABLE);
   return stmt;
  } catch (Exception fe) {
   System.err.println("CreatStat(): " + fe.getMessage());
   return null;
  }

 }

 // 返回记录集对象
 public ResultSet getResult(String sql) {
  rs = null;
  try {
   stmt = this.CreatStat();
   rs = stmt.executeQuery(sql);
   return rs;
  } catch (SQLException ex) {
   System.err.println("getResult: " + ex.getMessage());
   return null;
  }

 }
 /**
  * 关闭所有数据库连接相关对象
  */
 public void closeAll(Connection conn, PreparedStatement ps, ResultSet rs)
   throws SQLException {
  if (rs != null) {
   rs.close();
  }
  if (ps != null) {
   ps.close();
  }
  if (conn != null && !conn.isClosed()) {
   conn.close();
  }

 }

 // 执行更新 删除语句
 public boolean executeSql(String sql) {

  try {
   stmt = this.CreatStat();
   stmt.executeUpdate(sql);
   // conn.commit();
   return true;
  } catch (Exception e) {
   System.err.println("exectueSql: " + e.toString());
   return false;
  }

 }

 public void Release() throws SQLException {
  if (rs != null) {
   rs.close();
  }
  if (stmt != null) {
   stmt.close();
  }
  if (conn != null) {
   conn.close();
  }

 }
 /**
  * @param sql
  * @param paras 代表?里面的参数
  * @return
  * @throws SQLException
  * 操作insert,update,delete,支持?传参的用法
  */

 public int insertUpdateDelete(String sql, String[] paras)
   throws SQLException {
  Connection conn = null;
  PreparedStatement ps = null;
  int count = 0;
  try {
   conn = this.Creatconn();
   ps = conn.prepareStatement(sql);
   for (int i = 0; i < paras.length; i++) {
    ps.setString(i + 1, paras[i]);
   }
   count = ps.executeUpdate();
  } finally {
   closeAll(conn, ps, null);
  }
  return count;
 }
}