jsp+javabean+mysql数据库连接

package common;

import java.sql.*;

public class DBManager { private String myDriver=null; private String myConnStr=null; private Connection myConn=null; private Statement myStmt=null; private ResultSet myResults=null;

public DBManager(){ //加载mysql驱动 String DBDRIVER = "org.gjt.mm.mysql.Driver" ; String DBURL = "jdbc:mysql://127.0.0.1/school?useUnicode=true&characterEncoding=GBK"; String DBUSER = "root" ; String DBPASSWORD = "root" ; try{ Class.forName(DBDRIVER); }catch(ClassNotFoundException e){ System.out.println("加载mysql驱动"+e.getMessage());

} }

public boolean execInsert(String insertString){ //数据添加 try{ myConn=DriverManager.getConnection(myConnStr); myStmt=myConn.createStatement(); myStmt.executeUpdate(insertString); } catch(SQLException e){ System.out.println("添加数据"+e.getMessage()); return false; } return true; }

public ResultSet execQuery(String queryString){ //数据查询 try{ myConn=DriverManager.getConnection(myConnStr); myStmt=myConn.createStatement(); myResults=myStmt.executeQuery(queryString);

} catch(SQLException ex){ System.out.println("查询数据"+ex.getMessage()); } return myResults; }

public boolean execUpdata(String updataString){ //数据更新 try{ myConn=DriverManager.getConnection(myConnStr); myStmt=myConn.createStatement(); myStmt.executeUpdate(updataString); myStmt.close(); myConn.close(); } catch(SQLException ex){ System.out.println("更新数据"+ex.getMessage()); return false; }

return false; }

public void execDelect(String deleteString){ //删除数据 try{ myConn=DriverManager.getConnection(myConnStr); myStmt=myConn.createStatement(); myStmt.executeUpdate(deleteString); //executeDelect myStmt.close(); myConn.close(); } catch(SQLException ex){ System.out.println("删除数据"+ex.getMessage()); } }

public void closeManager(){ //关闭创建对象 try{ myStmt.close(); myConn.close(); } catch(SQLException ex){ ex.printStackTrace(); } } public void closeStatement(){ try{ myStmt.close(); } catch(SQLException ex){ ex.printStackTrace(); } } public void closeConnection(){ try{ myConn.close(); } catch(SQLException ex){ ex.printStackTrace(); } } }