proxool java_Java数据库连接池-proxool

public classDBServer {privateDBOperation dbOperation;publicDBServer(String poolName) {

dbOperation= newDBOperation(poolName);

}/*** @Author:

* @Description: 关闭数据库连接*/

public voidclose() {

dbOperation.close();

}/***@paramsql

*@return*@throwsSQLException

* @Author:

* @Description: 数据库新增操作*/

public int insert(String sql) throwsSQLException {returndbOperation.executeUpdate(sql);

}/***@paramtableName

*@paramcolumns

*@paramparams

*@return*@throwsSQLException

*@throwsClassNotFoundException

* @Author:

* @Description: 数据库新增操作*/

public int insert(String tableName, String columns, HashMap params) throwsSQLException, ClassNotFoundException {

String sql=insertSql(tableName, columns);returndbOperation.executeUpdate(sql, params);

}/***@paramsql

*@return*@throwsSQLException

* @Author:

* @Description: 数据库删除操作*/

public int delete(String sql) throwsSQLException {returndbOperation.executeUpdate(sql);

}/***@paramtableName

*@paramcondition

*@return*@throwsSQLException

* @Author:lulei

* @Description: 数据库删除操作*/

public int delete(String tableName, String condition) throwsSQLException {if (null ==tableName) {return 0;

}

String sql= "delete from " + tableName + " " +condition;returndbOperation.executeUpdate(sql);

}/***@paramsql

*@return*@throwsSQLException

* @Author:

* @Description: 数据库更新操作*/

public int update(String sql) throwsSQLException {returndbOperation.executeUpdate(sql);

}/***@paramtableName

*@paramcolumns

*@paramcondition

*@paramparams

*@return*@throwsSQLException

*@throwsClassNotFoundException

* @Author:

* @Description: 数据库更新操作*/

public int update(String tableName, String columns, String condition, HashMap params) throwsSQLException, ClassNotFoundException {

String sql=updateSql(tableName, columns, condition);returndbOperation.executeUpdate(sql, params);

}/***@paramsql

*@return*@throwsSQLException

* @Author:

* @Description: 数据库查询操作*/

public ResultSet select(String sql) throwsSQLException {returndbOperation.executeQuery(sql);

}/***@paramtableName

*@paramcolumns

*@paramcondition

*@return*@throwsSQLException

* @Author:lulei

* @Description: 数据库查询操作*/

public ResultSet select(String tableName, String columns, String condition) throwsSQLException {

String sql= "select " + columns + " from " + tableName + " " +condition;returndbOperation.executeQuery(sql);

}/***@paramtableName

*@paramcolumns

*@paramcondition

*@return* @Author:

* @Description: 组装 update sql eg: update tableName set column1=?,column2=? condition*/

privateString updateSql(String tableName, String columns, String condition) {if (tableName == null || columns == null) {return "";

}

String[] column= columns.split(",");

StringBuilder sb= newStringBuilder();

sb.append("update ");

sb.append(tableName);

sb.append(" set ");

sb.append(column[0]);

sb.append("=?");for (int i = 1; i < column.length; i++) {

sb.append(", ");

sb.append(column[i]);

sb.append("=?");

}

sb.append(" ");

sb.append(condition);returnsb.toString();

}/***@paramtableName

*@paramcolumns

*@return* @Author:

* @Description: 组装 insert sql eg: insert into tableName (column1, column2) values (?,?)*/

privateString insertSql(String tableName, String columns) {if (tableName == null || columns == null) {return "";

}int n = columns.split(",").length;

StringBuilder sb= new StringBuilder("");

sb.append("insert into ");

sb.append(tableName);

sb.append(" (");

sb.append(columns);

sb.append(") values (?");for (int i = 1; i < n; i++) {

sb.append(",?");

}

sb.append(")");returnsb.toString();

}

}