Java中MySql的DBHelper类

《Java中MySql的DBHelper类》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、packagehzvtc.util;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.SQLException;importjava.util.ArrayList;importorg.apache.commons.dbutils.DbUtils;importorg.apache.commons.dbutils.QueryRunner;importorg.apache.commons.dbutils.ResultSetHandler;import

2、org.apache.commons.dbutils.handlers.BeanHandler;importorg.apache.commons.dbutils.handlers.BeanListHandler;importorg.apache.commons.logging.Log;importorg.apache.commons.logging.LogFactory;publicclassDbHelper{privateStringdbms;  //数据库类型privateStringdbmsDriver;//数据库驱动priv

3、ateStringhost;  //主机privateStringport;  //端口privateStringdb;  //数据库名privateStringuser;  //用户名privateStringpassword;//密码privateClassbeanClass=null;privateConnectionconn=null;privatefinalLoglogger=LogFactory.getLog(DbHelper.class);/***根据数据库类型设置驱动程序*@paramdbms数据库类型，如mysql

4、、postgresql等*/privatevoidfillDbmsDriver(Stringdbms){  if(dbms.equalsIgnoreCase("postgresql"))   dbmsDriver="org.postgresql.Driver";  elseif(dbms.equalsIgnoreCase("mysql"))   dbmsDriver="org.gjt.mm.mysql.Driver";}/***根据数据库类型设置端口*@paramdbms数据库类型*/privatevoidfillDbmsPort(

5、Stringdbms){  if(dbms.equalsIgnoreCase("postgresql"))   port="5432";  elseif(dbms.equalsIgnoreCase("mysql"))   port="3306";}/***设置数据连接时需要的参数*@paramdbms数据库类型*@paramhost主机*@paramdb数据库名*@paramuser用户名*@parampassword密码*/publicDbHelper(Stringdbms,Stringhost,Stringdb,Stringus

6、er,   Stringpassword){  this.dbms=dbms;  fillDbmsDriver(dbms);  this.host=host;  fillDbmsPort(dbms);  this.db=db;  this.user=user;  this.password=password;}/***设置数据连接时需要的参数*@paramdbms数据库类型*@paramhost主机*@paramport端口*@paramdb数据库名*@paramuser用户*@parampassword密码*/publicDbHe

7、lper(Stringdbms,Stringhost,Stringport,Stringdb,   Stringuser,Stringpassword){  this.dbms=dbms;  fillDbmsDriver(dbms);  this.host=host;  this.port=port;  this.db=db;  this.user=user;  this.password=password;}/***加载驱动*/publicvoidconnect(){  if(conn!=null)return;    Strin

8、gstrConn=    String.format("jdbc:%s://%s:%s/%s",dbms,host,port,db);  DbUtils.loadDriver(dbmsDriver);  try{   conn=Dri