C3P0连接池简单测试

标题接着上次自己做了一个DBUtils

DBUtils是一个小型的类库，是Apache组织提供的一个对JDBC进行简单封装的开源工具类库，使用它能够简化JDBC应用程序的开发，同时也不会影响程序的性能。它使JDBC编程更加方便，简单。
话不多说，直接上代码，
Javabean包----users .java

package DBUtils;

public class user {
	private int id;
	
	private String name;
	private String password;
	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 getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	@Override
	public String toString() {
		return "user [id=" + id + ", name=" + name + ", password=" + password + "]";
	}
}

数据库连接

package DBUtils;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DBconn {
/**
 * @param args
 */
	
	private final String url="jdbc:mysql://localhost:3306/studenglu";
	private final String name="root";
	private final String password="325282";
	private  Connection con;

public DBconn(){
	
	try {
		  //加载驱动程序；
		  Class.forName("com.mysql.jdbc.Driver");
		  //获得数据库连接；
		con=DriverManager.getConnection(url,name,password);
		  }catch (ClassNotFoundException|SQLException e) {
			// TODO: handle exception
			System.out.println("驱动加载失败");
		}
}


public  void close() {

	if (this.con!=null) {
		try {
			this.con.close();
		} catch (SQLException e) {
			// TODO: handle exception
			System.out.println("数据库关闭失败");
		}
	}
}

public Connection getConnection() {
	

	// TODO Auto-generated method stub
	return this.con;
}


}

测试类

package DBUtils;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.ArrayList;

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

public class DBTest {
       
	public static void main(String[] args) {
		user dd=new user();
		dd.setId(100);
		dd.setName("大西瓜");
		dd.setPassword("333");
		//insertData();
		//updateData();
		selectData();
		//deleteData();
		//insertDataWithParams(dd);
	}
	public static void insertData() {
        // 获取数据库连接
        Connection conn = connectDB();
        // 创建SQL执行工具
        QueryRunner runner = new QueryRunner();
        String sql = "insert into users(id,name,password) values (?,?,?)";
        Object[] paramS = {"1001","脉","666"};
        int num;
        try {
            num = runner.update(conn, sql,paramS);
            System.out.println("成功插入" + num + "条数据！");
        } catch (SQLException e) {
            e.printStackTrace();
        }
        // 关闭数据库连接
        DbUtils.closeQuietly(conn);
    }

    public static void insertDataWithParams(user bb) {
        // 获取数据库连接
        Connection conn = connectDB();
        // 创建SQL执行工具
        QueryRunner runner = new QueryRunner();
        String sql = "insert into users(id,name,password) values(?,?,?)";
      
        
        Object[] params = {bb.getId(),bb.getName(),bb.getPassword()};
        try {
            int num = runner.update(conn, sql, params);
            System.out.println("成功插入" + num + "条数据！");
        } catch (SQLException e) {
            e.printStackTrace();
        }
        DbUtils.closeQuietly(conn);
    }

    public static void updateData() {
        // 获取数据库连接
        Connection conn = connectDB();
        // 创建SQL执行工具
        QueryRunner runner = new QueryRunner();
        String sql = "update users set name='青梅绿茶' where id=1001";
        try {
            int num = runner.update(conn, sql);
            System.out.println("成功更新" + num + "条数据！");
        } catch (SQLException e) {
            e.printStackTrace();
        }
        DbUtils.closeQuietly(conn);
    }

    public static void deleteData() {
        // 获取数据库连接
        Connection conn = connectDB();
        // 创建SQL执行工具
        QueryRunner runner = new QueryRunner();
        String sql = "delete from users where name='青梅绿茶'";
        try {
            int num = runner.update(conn, sql);
            System.out.println("成功删除" + num + "条数据！");
        } catch (Exception e) {
            e.printStackTrace();
        }
        DbUtils.closeQuietly(conn);
    }

    public static void selectData() {
        // 获取数据库连接
        Connection conn = connectDB();
        // 创建SQL执行工具
        QueryRunner runner = new QueryRunner();
        String sql = "select * from users where id=1001";
        ArrayList<user> userList;
        try {
            userList =  (ArrayList<user>) runner.query(conn, sql,new BeanListHandler<user>(user.class));
            System.out.println("userList size is:"+userList.size());
            for (user user : userList) {
                System.out.println(user);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        DbUtils.closeQuietly(conn);
    }

    public static Connection connectDB() {
    	 String driverClassName = "com.mysql.cj.jdbc.Driver";
         String url = "jdbc:mysql://127.0.0.1:3306/studenglu";
         String userName = "root";
         String password = "325282";
         Connection conn = null;
         try {
             Class.forName(driverClassName);
             conn = DriverManager.getConnection(url, userName, password);
         } catch (Exception e) {
             e.printStackTrace();
         }
         System.out.println("获取数据库连接成功！");
         return conn;
    }
	
}

数据库就建了一个表，包含了id,name,password,以id为主键，方便测试。

如果我的代码，能帮到你，不求点赞，来个访客可还行！！！