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();
        }
    }
}