JAVA-c3p0-DataSourse 接口，实现数据库的增删改查

package com.qf.Bean;

public class User {

int id;
String username;
String password;

public User() {
	super();
	// TODO Auto-generated constructor stub
}
public User(int id, String username, String password) {
	super();
	this.id = id;
	this.username = username;
	this.password = password;
}
public int getId() {
	return id;
}
public void setId(int id) {
	this.id = id;
}
public String getUsername() {
	return username;
}
public void setUsername(String username) {
	this.username = username;
}
public String getPassword() {
	return password;
}
public void setPassword(String password) {
	this.password = password;
}
@Override
public String toString() {
	return "User [id=" + id + ", username=" + username + ", password=" + password + "]";
}

}

//工具类
package com.qf.JdbcUtils;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.sql.DataSource;

import com.mchange.v2.c3p0.ComboPooledDataSource;

public class Utils {
//初值null
public static DataSource ds = null;

static{
	//连接，连接池
	ds = new ComboPooledDataSource("mypool");
}
public static DataSource getDataSoure(){
	return ds;
}

//连接
public static Connection getConnection() throws SQLException{
	return ds.getConnection();
}
//关闭
public static void Close(Statement statement,Connection connection){
	if(statement != null){
		try {
			statement.close();
		} catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace();
		}
	}
	if(connection != null){
		try {
			connection.close();
		} catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace();
		}
	}
}

public static void Close(Statement statement,Connection connection,ResultSet set){
	Close(statement, connection);
	if(set != null){
		try {
			set.close();
		} catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace();
		}
	}
}

}

package com.qf.JdbcServer;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;

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

import com.qf.Bean.User;
import com.qf.JdbcUtils.Utils;

public class Server{
//getDataSoure()直接获取collection和statement
private QueryRunner qr = new QueryRunner(Utils.getDataSoure());
private int row = 0;
//数据库名
private final String TABLE_NAME =“user”;
//增
//抛出异常
public int AddUser(Object username,Object password) throws SQLException{
String sql = “insert into “+ TABLE_NAME+” values(null,?,?)”;
row =qr.update(sql, username,password);
return row;
}
//删
public int DelUser(int id) throws SQLException{
try {
String sql = “delete from “+ TABLE_NAME+” where id =?”;
row = qr.update(sql, id);

	} catch (Exception e) {
		// TODO: handle exception
		e.printStackTrace();
	}
	
	return row;
}

//改：根据id改密码
public int UpdateUser(int id,Object password) throws SQLException{
	try {
		String sql ="update "+ TABLE_NAME+" set password = ? where id = ?";
		row = qr.update(sql, password,id);
	} catch (Exception e) {
		// TODO: handle exception
		e.printStackTrace();
	}
	return row;
	
}
//查,全部

public void SelectAll() throws SQLException{
	String sql = "select * from "+ TABLE_NAME+"";
	//疯转了一个BeanListHandler类
	List<User> user = qr.query(sql, new BeanListHandler<User>(User.class));
	for (User u : user) {
		System.out.println("用户名ID："+u.getId()+"\t "+"用户名："+u.getUsername()+"\t"+"密码："+u.getPassword());
	}
}

public void SelectRow(int id){
	try {
		String sql = "select * from "+ TABLE_NAME+" where id = ?";
		List<User> user2 = qr.query(sql, new BeanListHandler<User>(User.class),id);
		for (User u : user2) {
			System.out.println("用户名ID："+u.getId()+"\t "+"用户名："+u.getUsername()+"\t"+"密码："+u.getPassword());
		}
	} catch (Exception e) {
		// TODO: handle exception
		e.printStackTrace();
	}
	
}

}

package com.qf.JdbcTest;

import java.sql.SQLException;
import java.util.Scanner;

import com.qf.Bean.User;
import com.qf.JdbcServer.Server;

public class Test {
public static void main(String[] args) {
Scanner scanner = new Scanner(System.in);
Server server = new Server();
User user = new User();
try {
//循环
for(;?{
System.out.println(“请输入1：增；请输入2：删；请输入3：改；请输入4：查询所有信息；请输入5：查询个人信息；请输入6：结束操作”);
int number = scanner.nextInt();
switch (number) {
case 1:
System.out.println(“请输入用户名：”);
String username = scanner.next();
System.out.println(“请输入密码：”);
String password = scanner.next();
int Add_row = server.AddUser(username, password);
break;
case 2:
System.out.println(“请输入ID：”);
int del_id = scanner.nextInt();
int Del_row = server.DelUser(del_id);
break;
case 3:
System.out.println(“请输入ID：”);
int update_id = scanner.nextInt();
System.out.println(“请输入password：”);
String update_password = scanner.next();
int update_row = server.UpdateUser(update_id, update_password);
break;
case 4:
server.SelectAll();
break;
case 5:
System.out.println(“请输入你要查询的人的信息的ID：”);
int id = scanner.nextInt();
server.SelectRow(id);
break;
case 6:
return;
default:
break;
}
}

	} catch (Exception e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	
	
}

}

<?xml version="1.0" encoding="UTF-8"?> com.mysql.jdbc.Driver jdbc:mysql://localhost:3307/xx root root 5 10