数据库_JavaBean连接MySQL

 

package com.zzhoujsp_jbean.javabean;

 

import java.sql.*;

 

public class DBAccess

{

    private String drv="com.mysql.jdbc.Driver";

    private String url="jdbc:mysql://localhost:3306/demo";

    private String usr="root";

    private String pwd="120120";

   

    private Connection conn=null;

    private Statement stm=null;

    private ResultSet rs=null;

   

    public boolean createConn(){

       boolean b=false;

       try{

           Class.forName(drv).newInstance();

           conn=DriverManager.getConnection(url,usr,pwd);

           b=true;

       }

       catch(Exception e){}

       return b;

    }

    public boolean update(String sql){

       boolean b=false;

       try{

           stm=conn.createStatement();

           stm.execute(sql);

           b=true;

       }

       catch(Exception e){}

       return b;

    }

    public void query(String sql){

       try{

           stm=conn.createStatement();

           rs=stm.executeQuery(sql);

       }

       catch(Exception e){}

    }

    public boolean next(){

       boolean b=false;

       try{

           if(rs.next())b=true;

       }

       catch(Exception e)

       {}

       return b;

    }

    public String getValue(String field){

       String value=null;

       try{

           if(rs!=null)value=rs.getString(field);

       }

       catch(Exception e)

       {}

       return value;

    }

    public void closeRs(){

       try{

           if(rs!=null)rs.close();

       }

       catch(Exception e){}

    }

    public void closeStm()

    {

       try

       {

           if(stm!=null)stm.close();

       }

       catch(Exception e){}

    }

    public void closeConn(){

       try{

           if(conn!=null)conn.close();

       }

       catch(Exception e){}

    }

    public String getDrv() {

       return drv;

    }

    public void setDrv(String drv) {

       this.drv = drv;

    }

    public String getUrl() {

       return url;

    }

    public void setUrl(String url) {

       this.url = url;

    }

    public String getUsr() {

       return usr;

    }

    public void setUsr(String usr) {

       this.usr = usr;

    }

    public String getPwd() {

       return pwd;

    }

    public void setPwd(String pwd) {

       this.pwd = pwd;

    }

    public Connection getConn() {

       return conn;

    }

    public void setConn(Connection conn) {

       this.conn = conn;

    }

    public Statement getStm() {

       return stm;

    }

    public void setStm(Statement stm) {

       this.stm = stm;

    }

    public ResultSet getRs() {

       return rs;

    }

    public void setRs(ResultSet rs) {

       this.rs = rs;

    }

}