1、public interface IAdmin public boolean adminInsert(AdminList admin); public boolean adminUpdate(AdminList admin); public boolean adminDelete(String adminid); public boolean adminSelect(AdminList admin); public List adminSelectAll();实现接口。AdminImp.java:import java.sql.*;import java.util.ArrayList;publ
2、ic class AdminImp implements IAdmin Override public boolean adminDelete(String adminid) / TODO Auto-generated method stub boolean b=false; String sql=delete from adminTable where adminid=+adminid+; try pst=con.prepareStatement(sql); int rs=pst.executeUpdate(); if(rs=1) b=true; catch(Exception e)Syst
3、em.out.println(e.getMessage(); return b; public boolean adminInsert(AdminList admin) insert into adminTable values(?,?) pst.setString(1, admin.getAdminname(); pst.setString(2, admin.getAdminid(); pst.setString(3, admin.getPassword(); public boolean adminSelect(AdminList admin) select adminname from
4、adminTable where adminid=? and password=? pst.setString(1, admin.getAdminid(); pst.setString(2, admin.getPassword(); ResultSet rs=pst.executeQuery(); if(rs.next() admin.setAdminname(rs.getString(1); /System.out.println(admin.getAdminname(); adminSelectAll() List all=new ArrayList userSelectAll(); pu
5、blic UserList userfindbyid(String userid);实现用户接口。UserImp.jsp:public class UserImp implements IUser public UserList userfindbyid(String userid) select * from usertable where userid=+userid+ UserList ul=new UserList(); while(rs.next() ul.setUsername(rs.getString(1); ul.setUserid(rs.getString(2); ul.se
6、tPassword(rs.getString(3); ul.setPhoneno(rs.getString(4); ul.setEmail(rs.getString(5); catch(Exception e)System.out.println(e.getMessage(); return ul; public UserImp(Connection con) public boolean userDelete(String userid) delete from userTable where userid= public boolean userInsert(UserList user)
7、insert into userTable values(? pst.setString(1, user.getUsername(); pst.setString(2, user.getUserid(); pst.setString(3, user.getPassword(); pst.setString(4, user.getPhoneno(); pst.setString(5, user.getEmail(); public boolean userSelect(UserList user) select username from userTable where userid=? pst
8、.setString(1, user.getUserid(); pst.setString(2, user.getPassword(); user.setUsername(rs.getString(1); userSelectAll() select * from userTable UserList user=new UserList(); user.setUserid(rs.getString(2); user.setPassword(rs.getString(3); user.setPhoneno(rs.getString(4); user.setEmail(rs.getString(5
9、); all.add(user); public boolean userUpdate(UserList user) update userTable set username=?,Phoneno=?,email=? where Userid=? pst.setString(3, user.getPhoneno(); pst.setString(4, user.getEmail(); pst.setString(5, user.getUserid();对接口类的实现,实现了对用户表的增删改查等功能。UserFactory.java:public class UserFactory public
10、 static IUser getInstance() return new UserProxy();3.3 order -订单表的DAO对数据库中的orderTable表建接口类、工厂类、实现类等。IOrder.java:package order;public interface IOrder public boolean orderInsert(OrderList order); public boolean orderUpdate(OrderList order); public boolean orderDelete(String userid); public String ord
11、erSelect(OrderList order);OrderList orderSelectAll();OrderImp.java:public class OrderImp implements IOrder public OrderImp(Connection con) public boolean orderDelete(String userid) delete from orderTable where userid= public boolean orderInsert(OrderList order) insert into orderTable values(? pst.se
12、tString(1, order.getUserid(); pst.setString(2, order.getProductname(); pst.setInt(3, order.getNumber(); pst.setString(4,order.getAddress(); pst.setString(5, order.getTime(); pst.setString(6,order.getIscomplete(); public String orderSelect(OrderList order) String b=null;select productname from orderTable where userid=?
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1