Importjava.beans.PropertyVetoException;Importjava.sql.Connection;Importjava.sql.SQLException;ImportJavax.sql.ConnectionPoolDataSource;Importjavax.swing.text.DefaultEditorKit.InsertBreakAction;ImportCom.mchange.v2.c3p0.ComboPooledDataSource; Public classConnectData { Public Static voidMain (string[] args) {System.out.println (connectdata.getconnection ()); } Private StaticString username= "LF"; Private StaticString password= "LF"; Public StaticConnection getconnection () {//Create a connection poolCombopooleddatasource DataSource =NewCombopooleddatasource (); //by mapping to drive Try{Datasource.setdriverclass ("Oracle.jdbc.driver.OracleDriver"); } Catch(propertyvetoexception e) {e.printstacktrace (); } //Set URLDatasource.setjdbcurl ("JDBC:ORACLE:THIN:@192.168.10.105:1521:ORCL"); //set up Database user accountDatasource.setuser (userName); //Set Database PasswordDatasource.setpassword (password); Datasource.setinitialpoolsize (5); Datasource.setmaxpoolsize (13); Datasource.setminpoolsize (3); Try { //Get Connections returndatasource.getconnection (); } Catch(SQLException e) {e.printstacktrace (); } return NULL; }}
Java C3P0 Connection Pool