需要引入四个jar包
/********************************************/
package com.dxm.dbcp;
import javax.sql.DataSource;
import org.apache.commons.dbcp.BasicDataSource;
public class JDBCUtils {
private static BasicDataSource dataSource = new BasicDataSource();
public static DataSource getDataSource() {
return dataSource;
}
static{
dataSource.setDriverClassName("com.mysql.jdbc.Driver");
dataSource.setUrl("jdbc:mysql://localhost:3306/mybase");
dataSource.setUsername("root");
dataSource.setPassword("1234");
dataSource.setInitialSize(10);//初始化连接数
dataSource.setMaxActive(8);//最大连接数量
dataSource.setMaxIdle(5);//最大空闲
dataSource.setMinIdle(1);//最小空闲
}
}
/*********************************/
package com.dxm.dbcp;
import java.sql.SQLException;
import java.util.List;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.ArrayListHandler;
import com.sun.org.apache.bcel.internal.generic.NEW;
public class QueryRunnerDemo {
private static QueryRunner qRunner=new QueryRunner(JDBCUtils.getDataSource());
public static void insert(){
String sql = "insert into sort(sname,sprice,sdesc) values(?,?,?)";
Object[] params= {"水果",100,"刚刚上市的核桃"};
try {
int row = qRunner.update(sql,params);
System.out.println(row);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
throw new RuntimeException("数据添加失败");
}
}
public static void select(){
String sql="select * from sort";
try {
List<Object[]> query = qRunner.query(sql, new ArrayListHandler());
for (Object[] objects : query) {
for (Object object : objects) {
System.out.print(object+"\t");
}
System.out.println();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
throw new RuntimeException("查询数据失败!");
}
}
public static void main(String[] args) {
//insert();
select();
}
}