首页>代码>jsp+servlet开发java web网上书店系统>/网上书城/系统源码/goods/src/cn/itcast/goods/admin/admin/dao/AdminDao.java
package cn.itcast.goods.admin.admin.dao; import java.sql.SQLException; import org.apache.commons.dbutils.QueryRunner; import org.apache.commons.dbutils.handlers.BeanHandler; import cn.itcast.goods.admin.admin.domain.Admin; import cn.itcast.jdbc.TxQueryRunner; public class AdminDao { private QueryRunner qr = new TxQueryRunner(); /** * 通过管理员登录名和登录密码查询 * @param adminname * @param adminpwd * @return * @throws SQLException */ public Admin find(String adminname, String adminpwd) throws SQLException { String sql = "select * from t_admin where adminname=? and adminpwd=?"; return qr.query(sql, new BeanHandler<Admin>(Admin.class), adminname, adminpwd); } }