mysql连接池配置.docxVIP

1.先在tomcat目录下的context.xml文件中加上Resource name=jdbc/pub ?auth=Container ?type=javax.sql.DataSource?maxActive=100 ?maxIdle=30 ?maxWait=10000?username=root ?password=123 ?driverClassName=com.mysql.jdbc.Driver?url=jdbc:mysql://localhost:3306/pub/来配置数据源2.引入相关数据源的包commons-dbutils-1.1.fixed.jar，编写一公共类来获取数据源public class GetDataSource {?public static QueryRunner getQueryRunner() {?DataSource ds = null;?QueryRunner qr = null;?try {?// 通过在context.xml文件，设定的数据源对象的名字，获取数据源对象?Context context = new InitialContext();?ds = (DataSource) context.lookup(java:/comp/env/jdbc/pub);?qr = new QueryRunner(ds);?} catch (Exception e) {?e.printStackTrace();?System.out.println(获取数据源时出错);?}?return qr;?}}3.要对一张表进行操作，可以建一个类来对一张表进行增删改查操作，多个表可以建立多个类，如：public class UserJdbc {??public void addUser(String name,String username,String password,String email,String birthday) {?try{?String sql = insert into t-user(name,username,password,email,birthday) values (?,?,?,?,?);?// 为SQL语句中的？设定参数?String params[] = { name,username,password,email,birthday};?// DButils中核心类，生成对象时传递数据源对象?QueryRunner qr = GetDataSource.getQueryRunner();?// 调用它的update，完成SQL的运行。其他使用update方法的SQL语句：insert?// into/update/delete qr.update(sql, params); // query()?// Connection conn=ds.getConnection();?// PreparedStatement stmt=conn.prepareStatement(sql);?// stmt.setString(1, title);?// stmt.setString(2, content);?// stmt.setString(3, category_id);?// result = stmt.executeUpdate();?} catch (SQLException e) {?e.printStackTrace();?}}??public void deleteUser(int id) {?String sql = delete? from t-user? where id = + id;?QueryRunner qr = GetDataSource.getQueryRunner();?try {?qr.update(sql);?} catch (SQLException e) {?e.printStackTrace();?}}??public void update(String name,String username,String password,String email,String birthday){??String sql = update t-user set name=?,username=?,password=?,email=?,birthday=? where id=?;?String params[] = { name,username,password,email,birthday };?QueryRunner qr = GetDataSource.getQueryRunner();?try {?qr.update(sql, p