BasicDataSource ds2 = new BasicDataSource();
ds2.setDriverClassName("com.mysql.jdbc.Driver");
ds2.setUrl("jdbc:mysql://localhost:3306/myweb01db");
ds2.setUsername("root");
ds2.setPassword("root");
ds2.setMaxActive(30);
ds2.setMaxIdle(20);
ds2.setMinIdle(10);
ds2.setMaxWait(10000);
没其他代码了,就这样子,有没有实现连接池?
1,添加jar包commons-collections.jar,commons-dbcp.jar,commons-pool.jar,mysql-connector-java-5.1.7-bin.jar,将jar包添加到tomcat的lib下。
2,配置tomcat里的server.xml在context的最下面 <Context path="/e_gou" docBase="e_gou"
debug="5" reloadable="true" crossContext="true">
<Resource name="jdbc/TestDB" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="root" password="root" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/egou?autoReconnect=true"/>
3,连接数据库代码里加入Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/myoracle");
Connection conn = ds.getConnection();
4,web.xml
<resource-ref>
<description>Oracle Datasource example</description>
<res-ref-name>jdbc/myoracle</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
你最好用Hibernate的配置文件,那样很好连接数据库的。
<session-factory>
<property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
<property name="connection.url">jdbc:oracle:thin:@localhost:1521:ora10g</property>
<property name="connection.username">scott</property>
<property name="connection.password">tiger</property>
<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="myeclipse.connection.profile">oracle</property>
</session-factory>