c3p0+Dbutils

开发工具： Tomcat 9.0    eclipse    Mysql-8.0.12 

Jar包

User.class（实体类）

package com.zjp;

public class User {
	
	private int id;
	private String name;
	private String pass;
	
	public User() {
		super();
	}
	
	public User(int id, String name, String pass) {
		super();
		this.id = id;
		this.name = name;
		this.pass = pass;
	}
	
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getPass() {
		return pass;
	}
	public void setPass(String pass) {
		this.pass = pass;
	}

	@Override
	public String toString() {
		return "User [id=" + id + ", name=" + name + ", pass=" + pass + "]";
	}
	
	

}

 

Conn.class（C3P0连接池）

package com.zjp;

import java.sql.Connection;

import com.mchange.v2.c3p0.ComboPooledDataSource;

public class Conn {
	
	private static String user = "root";
	private static String password = "123";
	private static String url = "jdbc:mysql://127.0.0.1:3306/hr?;
	private static String dir = "com.mysql.cj.jdbc.Driver";

	public static Connection getConn() throws Exception {
		
		
		ComboPooledDataSource dataSource = new ComboPooledDataSource();
		
		dataSource.setDriverClass(dir);
		dataSource.setJdbcUrl(url);
		dataSource.setUser(user);
		dataSource.setPassword(password);
		
		return dataSource.getConnection();
		
		
	}

}

 

TestDbutils.class（使用Dbutils类）

package com.zjp;

import java.util.List;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanListHandler;


public class  TestDbutils{

	public List<User> select() {
		
		QueryRunner queryRunner = new QueryRunner();

        String sql = "select id,name,pass from user";
		
		try {
			
			List<User> result = queryRunner.query(Conn.getConn(), sql,new BeanListHandler<>(User.class));
			
			return result;
			
		}catch (Exception e) {
        		
			return null;
			
		}	
		
	}

}

   

Test.class（测试类）

package com.zjp;

import java.util.List;

public class Test {


	public static void main(String[] args) {
		
		TestDbUtils testDbutils = new TestDbUtils();
		
		List<User> userList = testDbUtils.select();
		
		for(User user :userList) {
			
			System.out.println(user.toString());
			
		}
		

	}

}