使用commons-dbutils
public class BankAccount {
private int id;
private String name;
private String password;
private double balance;
}-- 例子
QueryRunner run = new QueryRunner();
-- 加载MySQL
Class.froname("com.mysql.jdbc.Driver");
DriverManager.getConnection("jdbc:mysql://loachhost:3306/tb,"root,"123456");
-- 插入
String str="INSERT INTO bank_account1 (name,password,balance)VALUES(?,?,?);";
int update = run.update(Jdbc.getConn(), str,
bankAccount.getName(),
bankAccount.getPassword(),
bankAccount.getBalance());
-- 删除
String str="DELETE FROM bank_account1 WHERE Id=?;";
int update = run.update(Jdbc.getConn(), str, Id);
-- 修改
String str = "UPDATE bank_account1 SET name=?,password=?,balance=? WHERE id=?;";
int update = run.update(Jdbc.getConn(),str,
bankAccount.getName(),
bankAccount.getPassword(),
bankAccount.getBalance(),
Id);
-- 查询单个
ResultSetHandler<BankAccount> h = new BeanHandler<BankAccount>(BankAccount.class);
String str = "SELECT * FROM bank_account1 WHERE id=?;";
BankAccount query = run.query(Jdbc.getConn(), str, h, Id);
-- 查询全部
ResultSetHandler<List<BankAccount>> h = new BeanListHandler<BankAccount>(BankAccount.class);
String str = "SELECT * FROM bank_account1";
List<BankAccount> query = run.query(Jdbc.getConn(), str, h);