dbutils java_JAVA DBUtils

packagecom.oracle.dao;importjava.sql.Connection;importjava.sql.SQLException;importjava.util.List;importorg.apache.commons.dbutils.QueryRunner;importorg.apache.commons.dbutils.handlers.ArrayHandler;importorg.apache.commons.dbutils.handlers.ArrayListHandler;importorg.apache.commons.dbutils.handlers.BeanHandler;importorg.apache.commons.dbutils.handlers.BeanListHandler;importorg.apache.commons.dbutils.handlers.ColumnListHandler;importorg.apache.commons.dbutils.handlers.ScalarHandler;importcom.oracle.domain.User;importsrc.com.oracle.tools.JDBCutils;public classdao {//新增用户

public int addUser(User user) throwsSQLException {

Connection conn=JDBCutils.getConn();

QueryRunner qr= newQueryRunner();

String sql= "insert into user(uname ,pwd) values(?,?)";int row =qr.update(conn, sql, user.getUname(), user.getPwd());

conn.close();returnrow;

}//修改用户

public int updateUser(User user) throwsSQLException {

Connection conn=JDBCutils.getConn();

QueryRunner qr= newQueryRunner();

String sql= "update user set uname=?,pwd=? where uid=?";

Object[] obj={ user.getUname(), user.getPwd(), user.getUid() };int row =qr.update(conn, sql, obj);

conn.close();returnrow;

}//删除用户

public int deleteuser(intuid) {

Connection conn=JDBCutils.getConn();

QueryRunner qr= newQueryRunner();

String sql= "delete from user where uid=?";try{returnqr.update(conn, sql, uid);

}catch(SQLException e) {//TODO Auto-generated catch block

e.printStackTrace();

}returnuid;

}//查询1 ArrayHandler//结果集第一行封装成Object[]数组

public Object[] getuser1() throwsSQLException {

Connection conn=JDBCutils.getConn();

QueryRunner qr= newQueryRunner();

String sql= "select* from user ";

Object[] obj= qr.query(conn, sql, newArrayHandler());

conn.close();returnobj;

}//查询2 ArrayListHandler//结果集中每一条数据封装到Object数组中，再封装到List集合中

public List getuser2() throwsSQLException {

Connection conn=JDBCutils.getConn();

QueryRunner qr= newQueryRunner();

String sql= "select* from user ";

List list = qr.query(conn, sql, newArrayListHandler());

conn.close();returnlist;

}//查询3 BeanHandler (User.class)

public User getuser3() throwsSQLException {

Connection conn=JDBCutils.getConn();

QueryRunner qr= newQueryRunner();

String sql= "select* from user ";

User user= qr.query(conn,sql , new BeanHandler(User.class));

conn.close();returnuser;

}//查询4 BeanListHandler ,讲结果集中的每一条记录封装到指定的JAVABean中，再将JAVABean封装List

public List getuser4() throwsSQLException{

Connection conn=JDBCutils.getConn();

QueryRunner qr= newQueryRunner();

String sql= "select* from user ";

List list = qr.query(conn, sql,new BeanListHandler(User.class));

conn.close();returnlist;

}//查询5 ColumnListHandler将指定字段的结果集封装成list集合

public List getuser5() throwsSQLException {

Connection conn=JDBCutils.getConn();

QueryRunner qr= newQueryRunner();

String sql= "select uname from user ";

List list = qr.query(conn, sql,new ColumnListHandler());

conn.close();returnlist;

}//查询6 ScalarHandler查询单数据

public int getuser6() throwsSQLException {

Connection conn=JDBCutils.getConn();

QueryRunner qr= newQueryRunner();

String sql= "select count(*) from user ";long count = qr.query(conn, sql, new ScalarHandler());

conn.close();int c = (int)count;returnc;

}

}