【文章內(nèi)容簡介】 char2(20) unique,userPassword varchar2(20),utID varchar2(20), 用戶類型編號（外鍵4） varchar2(100) unique)。/*用戶類型表*/create table tb_user_type( utID varchar2(20) primary key, utName varchar2(20) not null)。/*購物信息表*/create table tb_shoppinginfo(bookNumber int,bookID varchar2(20), 商品編號（外鍵3）userID varchar2(20) 用戶編號（外鍵2）)。 建立外鍵約束/*書籍書籍類型1*/alter table tb_booksinfo add constraint f_book_type foreign key(typeID) references tb_book_type(typeID)。/*購物信息用戶2*/alter table tb_shoppinginfo add constraint f_shoppinginfo_user foreign key(userID) references tb_user_main(userID)。/*購物信息書籍3*/ alter table tb_shoppinginfo add constraint f_shoppinginfo_book foreign key(bookID) references tb_booksinfo(bookID)。/*用戶用戶類型4*/alter table tb_user_main add constraint f_user_userType foreign key(utID) references tb_user_type(utID)。/*訂單書籍訂單5*/alter table tb_order_detail add constraint f_detail_order foreign key(orderID) references tb_order_main(orderID)。/*訂單書籍書籍6*/alter table tb_order_detail add constraint f_detail_booksinfo foreign key(bookID) references tb_booksinfo(bookID)。/*訂單收貨信息7*/alter table tb_order_main add constraint f_order_deliver foreign key(deliverID) references tb_deliverinfo(deliverID)。/*訂單訂單狀態(tài)8*/alter table tb_order_main add constraint f_order_state foreign key(osID) references tb_order_state(osID)。/*收貨信息用戶9*/alter table tb_deliverinfo add constraint f_deliver_state foreign key(userID) references tb_user_main(userID)。 創(chuàng)建序列/*書籍信息表序列*/create sequence booksinfo_seq start with 1 increment by 1 maxvalue 200000 minvalue 1 nocycle。/*訂單表序列*/create sequence order_main_seq start with 1 increment by 1 maxvalue 200000 minvalue 1 nocycle。/*訂單狀態(tài)序列*/ create sequence order_state_seq start with 1 increment by 1 maxvalue 200 minvalue 1 nocycle。/*收貨信息表序列*/create sequence deliverinfo_seq start with 1 increment by 1 maxvalue 200000 minvalue 1 nocycle。 /*用戶表序列 */create sequence user_main_seq start with 1 increment by 1 maxvalue 2000 minvalue 1 nocycle。 /*書籍類型表序列*/ create sequence book_type_seq start with 1 increment by 1 maxvalue 200000 minvalue 1 nocycle。 四、 系統(tǒng)實現(xiàn) 登陸實現(xiàn)代碼public class AdminLoginServlet extends HttpServlet {private static final long serialVersionUID = 1L。public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {doPost(request,response)。 }public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {String userName = (username)。String userPassword = (password)。String path= ()。String sql = select * from tb_user_main where userName=? and userPassword=? and utID=?。ListUserMainlist=(sql,newString[]{userName,userPassword,1},)。if((list)){HttpSession session = ()。(user,(0))。(/admin/logined/).forward(request, response)。}else{(message,用戶名或密碼錯誤)。 (/admin/).forward(request, response)。} }} 注銷實現(xiàn)代碼 public class AdminLogoutServlet extends HttpServlet {public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {doPost(request,response)。 }public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {HttpSession session = ()。()。(/shopbooks/admin/)。 }} 管理員訂單管理實現(xiàn)public class AdminOrderServlet extends HttpServlet {public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {doPost(request,response)。 }public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {String op = (op)。String path = ()。if(modify.equals(op)){domodify(request,response,path)。}else if(cancle.equals(op)){docancle(request,response,path)。}}/** * 取消訂單 * @param request * @param response * @throws IOException * @throws ServletException */private void docancle(HttpServletRequest request,HttpServletResponse response,String path) throws ServletException, IOException { String orderID = (orderID)。ListOrderMain oList=(select* from tb_order_main where orderID=?, new String[]{orderID},)。if((oList)){(update tb_order_main set osID=? where orderID=?, new String[]{5,orderID})。 (/admin/logined/).forward(request,response)。 } }/** * 修改 * @param request * @param response * @throws IOException * @throws ServletException */private void domodify(HttpServletRequest request,HttpServletResponse response,String path) throws ServletException, IOException {String orderID = (orderID)。String orderState = (orderState)。String sql=update tb_order_main set osID=? where orderID=?。int result = (sql, new String[]{orderState,orderID})。if(result0){(message,修改成功)。 (/admin/logined/).forward(request,response)。 }else{(message,修改失敗)。 (/admin/logined/).forward(request,response)。} }}管理員書籍顯示實現(xiàn)public class AdmShowBookServlet extends HttpServlet {public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {doPost(request,response)。 }public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {String op = (op)。if(all.equals(op)){quryAll(request,response)。}else if(updateType.equals(op)){ //下架updateType(request,response)。 }else if(updateTypes.equals(op)){ //上架updateTypes(request,response)。 } }/** * 查詢所有 * @param request * @param response * @throws IOException * @throws ServletException */private void quryAll(Ht