java-kgli工具类总结

《java-kgli工具类总结》由会员上传分享，免费在线阅读，更多相关内容在应用文档-天天文库。

1、C3p0连接池DB工具类：JDBCUtils:packagecn.kgli.utils;importjava.io.InputStream;importjava.lang.reflect.Field;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.ResultSetMetaData;importjava.sql.SQLExceptio

2、n;importjava.sql.Statement;importjava.util.ArrayList;importjava.util.List;importjava.util.Properties;importcom.mchange.v2.c3p0.ComboPooledDataSource;publicclassJdbcUtils{privatestaticComboPooledDataSourceds=null;static{try{/*ds=newComboPooledDataSource();ds.setDriverClass

3、("com.mysql.jdbc.Driver");ds.setJdbcUrl("jdbc:mysql://localhost:3306/day16");ds.setUser("root");ds.setPassword("root");ds.setInitialPoolSize(10);ds.setMinPoolSize(5);ds.setMaxPoolSize(20);*/ds=newComboPooledDataSource();}catch(Exceptione){thrownewExceptionInInitializerErr

4、or(e);}}publicstaticConnectiongetConnection()throwsSQLException{returnds.getConnection();}publicstaticvoidrelease(Connectionconn,Statementst,ResultSetrs){if(rs!=null){try{rs.close();}catch(Exceptione){e.printStackTrace();}rs=null;}if(st!=null){try{st.close();}catch(Except

5、ione){e.printStackTrace();}}if(conn!=null){try{conn.close();}catch(Exceptione){e.printStackTrace();}}}//替换dao中的增删改方法publicstaticvoidupdate(Stringsql,Objectparams[])throwsSQLException{Connectionconn=null;PreparedStatementst=null;ResultSetrs=null;try{conn=getConnection();st

6、=conn.prepareStatement(sql);for(inti=0;i

7、Statementst=null;ResultSetrs=null;try{conn=getConnection();st=conn.prepareStatement(sql);for(inti=0;i

8、tjava.io.InputStream;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.Resul