Java课程设计-基于Java web的手机商城系统（前后端源码+数据库+文档） .zip

package adminDao; import java.sql.SQLException; import java.util.List; import org.apache.commons.dbutils.QueryRunner; import org.apache.commons.dbutils.handlers.BeanListHandler; import baen.Admin; import baen.Goodscon; import baen.User; import baen.Userorder; import c3p0Dbutil.C3p0; public class AdminDao implements AdminDaoInterface{ @Override public List<Admin> queryGetBy(String ano, String apwd) { // TODO Auto-generated method stub QueryRunner runner = new QueryRunner(C3p0.getDs()); List<Admin> adminList = null; String sql="select * from admin where Ano=? and Apwd=?"; try { adminList = (List<Admin>) runner.query(sql, new BeanListHandler<Admin>(Admin.class), new Object[]{ano,apwd}); return adminList; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return adminList; } @Override public List<Userorder> queryOrderAll() { // TODO Auto-generated method stub QueryRunner runner = new QueryRunner(C3p0.getDs()); String sql = "select * from userorder"; try { List<Userorder> userOrder = runner.query(sql, new BeanListHandler<Userorder>(Userorder.class)); return userOrder; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); return null; } } @Override public List<Userorder> queryOrderAll(String idNo) { // TODO Auto-generated method stub QueryRunner runner = new QueryRunner(C3p0.getDs()); String sql = "select * from userorder where Id = ? or Uno = ?"; try { List<Userorder> userOrder = runner.query(sql, new BeanListHandler<Userorder>(Userorder.class),new Object[]{idNo,idNo}); return userOrder; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); return null; } } @Override public List<Userorder> queryOrderAll(String id, String uno) { // TODO Auto-generated method stub QueryRunner runner = new QueryRunner(C3p0.getDs()); String sql = "select * from userorder where Id = ? or Uno = ?"; try { List<Userorder> userOrder = runner.query(sql, new BeanListHandler<Userorder>(Userorder.class),new Object[]{id,uno}); return userOrder; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); return null; } } @Override public List<Goodscon> queryCommAll(String gno, String exc, String gtype) { // TODO Auto-generated method stub //根据商品类别查询商品信息，后端管理员界面 List<Goodscon> listGoodscon = null; QueryRunner runner = new QueryRunner(C3p0.getDs()); System.out.println("queryCommAll(String gno, String exc, String gtype)"); String sql = "select * from goodscon where Gno like ? and GExplain like ? and GTid like ?"; try { listGoodscon = runner.query(sql, new BeanListHandler<Goodscon>(Goodscon.class),new Object[] {gno+"%","%"+exc+"%",gtype+"%"}); return listGoodscon; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); return null; } } @Override public int addUser(User user) { // TODO Auto-generated method stub //新用户注册 QueryRunner runner = new QueryRunner(C3p0.getDs()); String sql = "INSERT INTO user(Uno,Uname,Upwd,Utel,Uaddress,Urealname) VALUES(?,?,?,?,?,?)"; try { int i = runner.update(sql, new Object[] {user.getUtel(),user.getUname(),user.getUpwd(),user.getUtel(),user.getUaddress(),user.getUrealname()}); return i; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); return 0; } } @Override public List<User> getByUser(String uid, String uname) { // TODO Auto-generated method stub //管理员查询用户 QueryRunner runner = new QueryRunner(C3p0.getDs()); String sql = "select * from user where Uno = ? or Uname = ?"; try { return runner.query(sql, new BeanListHandler<User>(User.class),new Object[]{uid,uname}); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); return null; } } public List<User> getByUser(String uidname) { // TODO Auto-generated method stub //管理员查询用户 QueryRunner runner = new QueryRunner(C3p0.getDs()); String sql = "select * from user where Uno = ? or Uname = ?"; try { return runner.query(sql, new BeanListHandler<User>(User.class),new Object[]{uidname,uidname}); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); return null; } } public List<User> getByUser() { // TODO Auto-generated method stub //管理员查询所有的用户 QueryRunner runner = new QueryRunner(C3p0.getDs()); String sql = "select * from user"; try { return runner.query(sql, new BeanListHandler<User>(User.class)); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); return null; } } }