private QueryRunner qr=new QueryRunner();
来源:互联网 发布:lol西门淘宝代练室 编辑:程序博客网 时间:2024/05/18 03:09
package com.tfy.itheima.dao.impl;
//DAO不能牵扯任何业务逻辑
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import com.tfy.itheima.domain.Account;
import com.tfy.itheima.jdbc.util.DbcpUtil;
public class AccountDaoImpl {
private QueryRunner qr=new QueryRunner();
public Account findAccount(String name){
String sql="select * from account where name=?";
try{
return qr.query(DbcpUtil.getConnection(), sql, new BeanHandler<Account>(Account.class),name);
}catch(Exception e){
e.printStackTrace();
throw new RuntimeException(e);
}
}
public void update(Account account){
String sql="update account set money=? where name=?";
Object []params={account.getMoney(),account.getName()};
try{
qr.update(DbcpUtil.getConnection(), sql, params);
}catch(Exception e){
e.printStackTrace();
throw new RuntimeException(e);
}
}
/*public void transfer(String sourceAccount,String targetAccount,float money){
Connection conn=null;
try{
conn=DbcpUtil.getConnection();
conn.setAutoCommit(false);
String sql1="update account set money=money-? where name=?";
Object []params1={money,sourceAccount};
qr.update(conn,sql1, params1);
int i=1/0;
String sql2="update account set money=money+? where name=?";
Object []params2={money,sourceAccount};
qr.update(conn,sql2, params2);
}catch(Exception e){
e.printStackTrace();
try{
conn.rollback();
}catch(Exception e1){
e1.printStackTrace();
}
throw new RuntimeException(e);
}finally{
try {
conn.commit();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}*/
}
//DAO不能牵扯任何业务逻辑
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import com.tfy.itheima.domain.Account;
import com.tfy.itheima.jdbc.util.DbcpUtil;
public class AccountDaoImpl {
private QueryRunner qr=new QueryRunner();
public Account findAccount(String name){
String sql="select * from account where name=?";
try{
return qr.query(DbcpUtil.getConnection(), sql, new BeanHandler<Account>(Account.class),name);
}catch(Exception e){
e.printStackTrace();
throw new RuntimeException(e);
}
}
public void update(Account account){
String sql="update account set money=? where name=?";
Object []params={account.getMoney(),account.getName()};
try{
qr.update(DbcpUtil.getConnection(), sql, params);
}catch(Exception e){
e.printStackTrace();
throw new RuntimeException(e);
}
}
/*public void transfer(String sourceAccount,String targetAccount,float money){
Connection conn=null;
try{
conn=DbcpUtil.getConnection();
conn.setAutoCommit(false);
String sql1="update account set money=money-? where name=?";
Object []params1={money,sourceAccount};
qr.update(conn,sql1, params1);
int i=1/0;
String sql2="update account set money=money+? where name=?";
Object []params2={money,sourceAccount};
qr.update(conn,sql2, params2);
}catch(Exception e){
e.printStackTrace();
try{
conn.rollback();
}catch(Exception e1){
e1.printStackTrace();
}
throw new RuntimeException(e);
}finally{
try {
conn.commit();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}*/
}
- private QueryRunner qr=new QueryRunner();
- private QueryRunner qr=new QueryRunner();
- private QueryRunner qr= new QueryRunner(DbcpUtil.getDataSource());
- private QueryRunner qr=new QueryRunner(JdbcUtil.getDataSource());
- private QueryRunner qr=new QueryRunner(JdbcUtil.getDataSource());
- QueryRunner
- QueryRunner
- QueryRunner
- queryRUNNER
- queryrunner用法
- QueryRunner类
- QueryRunner使用
- QueryRunner使用
- QueryRunner-2
- QueryRunner的使用
- QueryRunner的使用
- QueryRunner的使用
- QueryRunner的使用
- Firefox OS应用市场截图曝光
- 虚拟机网络连接方式和网络设置
- 非阻塞情况下connect产生EINPROGRESS错误
- C/C++中怎样获取日期和时间
- codeforces 230C Shifts DP
- private QueryRunner qr=new QueryRunner();
- mac os x 10.8 安装python-mysqldb血泪史
- String sqlb="insert into employee (id,name,salary,department_id) values(?,?,?,?)";
- 四步创业法
- UVA 10154 Weights and Measures
- Human h = qr.query(sql1, new BeanHandler<Human>(Human.class), id);
- 应该知道的Linux技巧
- String sql3="insert into teacher_student (teacher_id,student_id) values(?,?)";
- C++中内存泄漏的检测方法介绍