四种连接数据库的方法(国外英语资料).doc

四种连接数据库的方法 I. environment 1, database drive jar file 2 and DBCP methods Commons-dbcp.jar: implementation of the connection pool Commons-pool.jar: dependency libraries for connection pool implementations resource file 3 and c3p0 methods: C3p0-.jar Configuration file: c3p0-config.xml Two, connection operation 1.DriverManager method; Import java.sql.Connection; Import java.sql.DriverManager; Import java.sql.SQLException; Public, class, DBConnection { Private, static, String, driverClass = com.mysql.jdbc.Driver; Private, static, String, url = jdbc:mysql://localhost:3306/test; Private, static, String, username = root; Private, static, String, password = 123456; Private, static, Connection, Conn = null; Static{ {try Drive / registration Dont put the conn / / = DriverManager.getConnection (URL, username, password); / / here. Prevent all users from using an Connection Class.forName (driverClass); } catch (Exception, e) { Throw new RuntimeException (E); } } Public, static, Connection, getConnection (), throws, SQLException{ Conn = DriverManager.getConnection (URL, username, password); Return conn; } } 2. using the DataSource subclass method; Resource file DBCperties DriverClass = com.mysql.jdbc.Driver Url = jdbc:mysql://localhost:3306/test Username = root Password = 123456 Analog data connection pool DataSourcePool.java Package cn.langzi.jdbc.DataSource; Import java.io.InputStream; Import java.io.PrintWriter; Import java.lang.reflect.InvocationHandler; Import java.lang.reflect.Method; Import java.lang.reflect.Proxy; Import java.sql.Connection; Import java.sql.DriverManager; Import java.sql.SQLException; Import java.util.LinkedList; Import java.util.Properties; Import javax.sql.DataSource; Import javax.sql.DataSource; Public, class, DataSourcePool, implements, DataSource { Private, static, String, url = null; Private, static, String, username = null; Private, static, String, password = null; Private, static, int, size = 10; Private, static, LinkedListConnection, list = new, L