环境:eclipse j2ee LUNA mysql 5.0.22 所需要的jar包 http://download.csdn.net/download/six_666666/9959117
先上mysql图
配置测试类
package dbcp;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class Test{
public static void main(String[] args) {
Connection conn = DBManager.conn;
try {
PreparedStatement ps = conn
.prepareStatement("SELECT * FROM account;");
ResultSet rs = ps.executeQuery();
while (rs.next()) {
String id = rs.getString("id");
System.out.println(id);
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
driverClassName=com.mysql.jdbc.Driver
#数据库连接地址
url=jdbc:mysql://localhost/zdy
#用户名
username=root
#密码
password=root
#连接池的最大数据库连接数。设为0表示无限制
maxActive=30
#最大空闲数,数据库连接的最大空闲时间。超过空闲时间,数据库连
#接将被标记为不可用,然后被释放。设为0表示无限制
maxIdle=10
#最大建立连接等待时间。如果超过此时间将接到异常。设为-1表示无限制
maxWait=1000
#超过removeAbandonedTimeout时间后,是否进 行没用连接(废弃)的回收(默认为false,调整为true)
removeAbandoned=true
#超过时间限制,回收没有用(废弃)的连接(默认为 300秒,调整为180)
removeAbandonedTimeout=180
import java.sql.Connection;
import java.util.Properties;
import javax.sql.DataSource;
import org.apache.commons.dbcp.BasicDataSourceFactory;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
private static final Log log = LogFactory.getLog(DBManager.class);
private static DataSource dataSource;
public static Connection conn;
static {
Properties dbProperties = new Properties();
try {
dbProperties.load(DBManager.class.getClassLoader()
.getResourceAsStream("dbcp/dbcp.properties"));
dataSource = BasicDataSourceFactory.createDataSource(dbProperties);
conn = dataSource.getConnection();
} catch (Exception e) {
log.error("初始化连接池失败:" + e);
}
}
}