首页>代码>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);
}
}

最近下载
最近浏览