java web课程设计报告模板14级Word文档格式.docx
《java web课程设计报告模板14级Word文档格式.docx》由会员分享,可在线阅读,更多相关《java web课程设计报告模板14级Word文档格式.docx(32页珍藏版)》请在冰豆网上搜索。
publicinterfaceIAdmin{
publicbooleanadminInsert(AdminListadmin);
publicbooleanadminUpdate(AdminListadmin);
publicbooleanadminDelete(Stringadminid);
publicbooleanadminSelect(AdminListadmin);
publicList<
AdminList>
adminSelectAll();
}
————实现接口。
AdminImp.java:
importjava.sql.*;
importjava.util.ArrayList;
publicclassAdminImpimplementsIAdmin{
@Override
publicbooleanadminDelete(Stringadminid){
//TODOAuto-generatedmethodstub
booleanb=false;
Stringsql="
deletefromadminTablewhereadminid='
"
+adminid+"
'
;
try{
pst=con.prepareStatement(sql);
intrs=pst.executeUpdate();
if(rs==1){
b=true;
}
}catch(Exceptione){System.out.println(e.getMessage());
returnb;
}
publicbooleanadminInsert(AdminListadmin){
insertintoadminTablevalues(?
?
)"
pst.setString(1,admin.getAdminname());
pst.setString(2,admin.getAdminid());
pst.setString(3,admin.getPassword());
publicbooleanadminSelect(AdminListadmin){
selectadminnamefromadminTablewhereadminid=?
andpassword=?
pst.setString(1,admin.getAdminid());
pst.setString(2,admin.getPassword());
ResultSetrs=pst.executeQuery();
if(rs.next()){
admin.setAdminname(rs.getString
(1));
//System.out.println(admin.getAdminname());
adminSelectAll(){
List<
all=newArrayList<
();
select*fromadminTable"
while(rs.next())
{
AdminListadmin=newAdminList();
admin.setAdminid(rs.getString
(2));
admin.setPassword(rs.getString(3));
all.add(admin);
}
}
catch(Exceptionee){System.out.print(ee.getMessage());
returnall;
publicbooleanadminUpdate(AdminListadmin){
updateadminTablesetadminname=?
password=?
whereadminid=?
pst.setString(3,admin.getAdminid());
privateConnectioncon=null;
privatePreparedStatementpst=null;
publicAdminImp(Connectioncon){
this.con=con;
————对接口类的实现,实现了对管理员表的增删改查等功能。
AdminFactory.java:
publicclassAdminFactory{
publicstaticIAdmingetInstance(){
returnnewAdminProxy();
————产生实例。
4.遇到的技术问题以及解决方法
该模块开发顺利,没有遇到障碍。
3.2user---用户表的DAO
对数据库中的userTable表建接口类、工厂类、实现类等。
IUser.java:
packageuser;
publicinterfaceIUser{
publicbooleanuserInsert(UserListuser);
publicbooleanuserUpdate(UserListuser);
publicbooleanuserDelete(Stringuserid);
publicbooleanuserSelect(UserListuser);
UserList>
userSelectAll();
publicUserListuserfindbyid(Stringuserid);
————实现用户接口。
UserImp.jsp:
publicclassUserImpimplementsIUser{
publicUserListuserfindbyid(Stringuserid){
select*fromusertablewhereuserid='
+userid+"
UserListul=newUserList();
while(rs.next()){
ul.setUsername(rs.getString
(1));
ul.setUserid(rs.getString
(2));
ul.setPassword(rs.getString(3));
ul.setPhoneno(rs.getString(4));
ul.setEmail(rs.getString(5));
catch(Exceptione){System.out.println(e.getMessage());
returnul;
publicUserImp(Connectioncon){
publicbooleanuserDelete(Stringuserid){
deletefromuserTablewhereuserid='
publicbooleanuserInsert(UserListuser){
insertintouserTablevalues(?
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());
publicbooleanuserSelect(UserListuser){
selectusernamefromuserTablewhereuserid=?
pst.setString(1,user.getUserid());
pst.setString(2,user.getPassword());
user.setUsername(rs.getString
(1));
userSelectAll(){
select*fromuserTable"
UserListuser=newUserList();
user.setUserid(rs.getString
(2));
user.setPassword(rs.getString(3));
user.setPhoneno(rs.getString(4));
user.setEmail(rs.getString(5));
all.add(user);
publicbooleanuserUpdate(UserListuser){
updateuserTablesetusername=?
Phoneno=?
email=?
whereUserid=?
pst.setString(3,user.getPhoneno());
pst.setString(4,user.getEmail());
pst.setString(5,user.getUserid());
}————对接口类的实现,实现了对用户表的增删改查等功能。
UserFactory.java:
publicclassUserFactory{
publicstaticIUsergetInstance(){
returnnewUserProxy();
3.3order---订单表的DAO
对数据库中的orderTable表建接口类、工厂类、实现类等。
IOrder.java:
packageorder;
publicinterfaceIOrder{
publicbooleanorderInsert(OrderListorder);
publicbooleanorderUpdate(OrderListorder);
publicbooleanorderDelete(Stringuserid);
publicStringorderSelect(OrderListorder);
OrderList>
orderSelectAll();
OrderImp.java:
publicclassOrderImpimplementsIOrder{
publicOrderImp(Connectioncon){
publicbooleanorderDelete(Stringuserid){
deletefromorderTablewhereuserid='
publicbooleanorderInsert(OrderListorder){
insertintoorderTablevalues(?
pst.setString(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());
publicStringorderSelect(OrderListorder){
Stringb=null;
selectproductnamefromorderTablewhereuserid=?