JAVAWeb開發(fā)酒店管理系統(tǒng)總結(jié)報(bào)告

上傳人：1*** IP屬地：江蘇上傳時(shí)間：2022-11-08 格式：DOCX 頁(yè)數(shù)：52 大小：264.52KB 積分：15 舉報(bào) 版權(quán)申訴

JAVAWeb開發(fā)酒店管理系統(tǒng)總結(jié)報(bào)告_第2頁(yè)

JAVAWeb開發(fā)酒店管理系統(tǒng)總結(jié)報(bào)告_第3頁(yè)

JAVAWeb開發(fā)酒店管理系統(tǒng)總結(jié)報(bào)告_第4頁(yè)

JAVAWeb開發(fā)酒店管理系統(tǒng)總結(jié)報(bào)告_第5頁(yè)

已閱讀5頁(yè)，還剩47頁(yè)未讀，繼續(xù)免費(fèi)閱讀

版權(quán)說(shuō)明：本文檔由用戶提供并上傳，收益歸屬內(nèi)容提供方，若內(nèi)容存在侵權(quán)，請(qǐng)進(jìn)行舉報(bào)或認(rèn)領(lǐng)

文檔簡(jiǎn)介

課程設(shè)計(jì)報(bào)告書班級(jí)軟件1201學(xué)號(hào)姓名李明坤學(xué)號(hào)姓名顧敬程學(xué)號(hào)姓名曹笑誠(chéng)一設(shè)計(jì)內(nèi)容1設(shè)計(jì)課題2設(shè)計(jì)目的3小組分工4程序代碼5效果截圖6總結(jié)感受二設(shè)計(jì)步驟1.設(shè)計(jì)課題：紅酒公司管理系統(tǒng)2.設(shè)計(jì)目的：管理員的登錄，然后實(shí)現(xiàn)酒店管理員對(duì)本酒店VIP客戶，酒品及員工的增刪改查功能，以及分頁(yè)功能。酒品的模糊搜索和備注功能。以及有一個(gè)Filter。3.小組分工：顧敬程：管理員的登錄，然后實(shí)現(xiàn)酒店管理員對(duì)本酒店酒品的增刪改查功能，以及分頁(yè)功能，酒品的模糊搜索和備注功能，能夠在當(dāng)前取得管理員名字與備注內(nèi)容一起顯示，和一個(gè)Filter。李明坤：實(shí)現(xiàn)酒店管理員對(duì)本酒店VIP客戶的增刪改查功能，以及分頁(yè)功能，圖片的查找，JSP美化。曹笑誠(chéng)：實(shí)現(xiàn)酒店管理員對(duì)本酒店員工的增刪改查功能，以及分頁(yè)功能，首頁(yè)的設(shè)計(jì)。4.程序部分主要代碼：Jsp頁(yè)面：（1）歡迎界面：<body><center><imgheight="500"width="1300"src="images/huanyin.jpg"><ahref="managerLogin.jsp"class="STYLE1">登錄</a></center></body>（2）登錄頁(yè)面<div><spanstyle="color:red">${requestScope.msg}<formaction="ManagerServlet?flag=6"method="post"><center><spanclass="STYLE10"><fontface="楷體"size="5">管理員登錄頁(yè)面 <spanclass="STYLE10"><fontsize="4"face="楷體">管理員：<inputtype="text"name="managername"> <spanclass="STYLE10"><fontsize="4"face="楷體">密碼：<inputtype="password"name="password"> <inputtype="submit"value="登錄"><inputtype="reset"value="重置"> </center></form></div>（3）首頁(yè)面<divid="top"><ulclass="topNav"><li><ahref="ListUser.jsp"class="hover">vip管理</a></li><li><ahref="ListProduct.jsp">酒品管理</a></li><li><ahref="ListMessage.jsp">員工管理</a></li><liclass="noImg"><ahref="../managerLogin.jsp">返回登錄</a></li></ul><label>Search</label><inputtype="submit"name="signup"value=""class="signup"/><h1></h1></div>（4）vip管理①進(jìn)入頁(yè)面<divid="topMain"><divid="top"><ahref="index.html"><imgsrc="images/red_juice.gif"alt="redjuice"width="202"height="81"border="0"class="logo"/></a><ahref="#"><imgsrc="images/login.gif"alt="login"width="106"height="80"border="0"class="login"/></a><ulclass="topNav"><li><ahref="../Userservlet?flag=5"class="topNav">查看所有VIP信息</a></li><li><ahref="manager.jsp">返回首頁(yè)</a></li>②顯示頁(yè)面<body><spanclass="STYLE22">顯示vip信息<tableborder="1"><tr><td>用戶ID</td><td>用戶名</td><td>vip卡號(hào)</td><td>修改操作</td><td>刪除操作</td></tr><c:forEachitems="${requestScope.pageBean.data}"var="u"><tr><td>${u.id}</td><td>${u.username}</td><td>${u.password}</td><td><ahref="updateUser.jsp?userid=${u.id}&username=${u.username}&password=${u.password}">修改</a></td><td><ahref="../Userservlet?flag=4&userid=${u.id}">刪除</a></td>當(dāng)前頁(yè)：<inputid="pageNo"type="text"name="pageNo"value="${pageBean.pageNo}"/>總記錄數(shù)：${pageBean.totalCount}條共有${pageBean.totalPage}頁(yè)</center><c:iftest="${pageBean.previous}"><center><ahref="../Userservlet?flag=5&pageNo=${pageBean.pageNo-1}">上一頁(yè)</a></center></c:if><c:iftest="${pageBean.next}"><center><ahref="../Userservlet?flag=5&pageNo=${pageBean.pageNo+1}">下一頁(yè)</a></center></c:if><center><ahref="../Userservlet?flag=5&pageNo=${pageBean.totalPage}">最后一頁(yè)</a></center></td></tr></table></div></div>③修改頁(yè)面<div><spanclass="STYLE19">修改卡號(hào) <formaction="../Userservlet"method="post"><inputtype="hidden"name="flag"value="3">vipID:<inputtype="text"name="userid"value="${param.userid}"readonly="readonly"/> Vip名:<inputtype="text"name="username"value="${param.username}"readonly="readonly"/> vip原卡號(hào):<inputtype="text"name="oldpwd"value="${param.password}"readonly="readonly"/> vip新卡號(hào):<inputtype="text"name="newpwd"/> <inputtype="submit"value="修改"><inputtype="reset"value="重填"></form></div>④增添頁(yè)面<formaction="../Userservlet?flag=2"method="post">請(qǐng)輸入vip名:<inputtype="text"name="username"/> 請(qǐng)輸入您卡號(hào):<inputtype="text"name="password"> <inputtype="submit"value="添加"><inputtype="reset"value="重填"> （4）酒品管理①進(jìn)入頁(yè)面<li><ahref="../ProductServlet?flag=5"class="topNav">查看所有酒品信息</a></li><li><ahref="manager.jsp">返回主頁(yè)</a></li>②顯示頁(yè)面<spanclass="STYLE21">顯示酒品信息 </center><tableborder="1"><tr><td>酒品ID<td></td>酒名</td><td>酒品圖片<td></td>酒品介紹<td></td></td>酒品價(jià)格<td>酒品本周得分<td></td>修改操作<td></td></td>刪除操作</tr><c:forEachitems="${requestScope.pageBean.data}"var="u"><tr><td>${u.id}<td></td>${u.cpname}<td></td><imgwidth="200"height="200"src="${u.cppicture}"></img><td></td>${u.cpintroduce}</td><td>${u.cpprice}<td></td>${u.cpflid}<td></td><ahref="updateproduct.jsp?cpid=${u.id}&cpname=${u.cpname}&cppicture=${u.cppicture}&cpprice=${u.cpprice}&cpflid=${u.cpflid}">修改</a></td><td><ahref="ProductServlet?flag=4&cpid=${u.id}">刪除</a><palign="center">當(dāng)前頁(yè)：<inputid="pageNo"type="text"name="pageNo"value="${pageBean.pageNo}"/>總記錄數(shù)：${pageBean.totalCount}條共有${pageBean.totalPage}頁(yè)<palign="center"><c:iftest="${pageBean.previous}"><ahref="ProductServlet?flag=5&pageNo=${pageBean.pageNo-1}">上一頁(yè)</a></c:if><c:iftest="${pageBean.next}"><ahref="ProductServlet?flag=5&pageNo=${pageBean.pageNo+1}">下一頁(yè)</a></c:if><ahref="ProductServlet?flag=5&pageNo=${pageBean.totalPage}">最后一頁(yè)</a></td></tr></table></div>③修改頁(yè)面<pclass="STYLE17"><fontface="楷體">修改酒品 <formaction="../ProductServlet?flag=3"method="post"><fontsize="4"face="楷體"><spanclass="STYLE18">酒品ID:<inputtype="text"name="cpid"value="${param.cpid}"readonly="readonly"/><pclass="STYLE18"><inputtype="text"酒品新名:name="newcpname"/> 酒品新介紹::<inputtype="text"name="newcpintroduce"/> 酒品新圖片路徑:<inputtype="text"name="newcppicture"> 酒品原價(jià)格:<inputtype="text"name="oldcpprice"value="${param.cpprice}"readonly="readonly"/> 酒品新價(jià)格:<inputtype="text"name="newcpprice"/> 酒品原得分<inputtype="text"name="oldcpflid"value="${param.cpflid}"readonly="readonly"/> 酒品新得分:<inputtype="text"name="newcpflid"/> <inputtype="submit"value="修改"><inputtype="reset"value="重填"> </form></div></center>④增添頁(yè)面<spanclass="STYLE13"><fontsize="5"><fontface="楷體">添加一個(gè)酒品 <formaction="../ProductServlet?flag=2"method="post"><fontsize="4"face="楷體"><spanclass="STYLE14">請(qǐng)輸入酒品名:<inputtype="text"name="cpname"/> 請(qǐng)輸入酒介紹:<inputtype="text"name="cpintroduce"/> 請(qǐng)輸入酒圖片:<inputtype="text"name="cppicture"/> 請(qǐng)輸入酒價(jià)格:<inputtype="text"name="cpprice"> 請(qǐng)輸酒品得分:<inputtype="text"name="cpflid"><fontsize="4"face="楷體"> <inputtype="submit"value="添加"><inputtype="reset"value="重填">⑤搜索顯示+備注功能+備注顯示<fontsize="4"face="楷體"color="#ff8040">圖片：<imgwidth="200"height="200"src="${u.cppicture}"></img> <fontsize="4"face="楷體"color="#ffff00">價(jià)格：${u.cpprice} <fontsize="4"face="楷體"color="#ff8040">簡(jiǎn)介：${u.cpintroduce} id:${u.id}<formaction="CpServlet?flag=12&cpid=${u.id}"method="post"><inputtype="hidden"name="cpplid"value="${u.id}"><tableborder="1"rules="rows"><tr><td><fontsize="4"face="楷體"color="#ffff00">備注內(nèi)容：</td><td><textareaname="cpplcontent"rows="8"cols="34"></textarea></td></tr><tralign="center"height="30"><tdcolspan="2"><fontsize="4"face="楷體"color="#ff8040"><inputtype="submit"value="確認(rèn)"><fontsize="4"><inputtype="reset"value="重置"></td></table></form></c:forEach><c:forEachitems="${requestScope.cppllist}"var="c"><fontface="楷體"size="4"color="#ff8000">備注內(nèi)容：${c.cpplcontent}<fontsize="4"face="楷體"color="#ffff00">管理員${c.cpplusername} </c:forEach></div> （5）員工管理①進(jìn)入頁(yè)面<li><ahref="../MessageServlet?flag=5"class="topNav">查看所有員工信息</a></li><li><ahref="manager.jsp">返回主頁(yè)</a></li>②顯示頁(yè)面<spanclass="STYLE20">顯示員工信息 <tableborder="1"><tr><td>員工ID</td><td>用戶名</td><td>員工電話</td><td>修改操作</td><td>刪除操作</td></tr><c:forEachitems="${requestScope.pageBean.data}"var="u"><tr><td>${u.id}</td><td>${u.username}</td><td>${u.password}</td><td><ahref="updateMessage.jsp?userid=${u.id}&username=${u.username}&password=${u.password}">修改</a></td><td><ahref="../MessageServlet?flag=4&userid=${u.id}">刪除</a></td></tr></c:forEach></table><ahref="registerMessage.jsp">添加新員工</a><ahref="manager.jsp">返回主頁(yè)</a><palign="center">當(dāng)前頁(yè)：<inputid="pageNo"type="text"name="pageNo"value="${pageBean.pageNo}"/><palign="center">總記錄數(shù)：${pageBean.totalCount}條<palign="center">共有${pageBean.totalPage}頁(yè)<c:iftest="${pageBean.previous}"><ahref="../MessageServlet?flag=5&pageNo=${pageBean.pageNo-1}"> 上一頁(yè)</a></c:if><c:iftest="${pageBean.next}"><ahref="../MessageServlet?flag=5&pageNo=${pageBean.pageNo+1}">下一頁(yè)</a></c:if><ahref="../MessageServlet?flag=5&pageNo=${pageBean.totalPage}">最后一頁(yè)</a></td></tr></div>③修改頁(yè)面<pclass="STYLE16">修改員工信息 <formaction="../MessageServlet?flag=3"method="post">用戶ID:<inputtype="text"name="userid"value="${param.userid}"readonly="readonly"/> 用戶名:<inputtype="text"name="username"value="${param.username}"readonly="readonly"/> 員工原電話:<inputtype="text"name="oldpwd"value="${param.password}"readonly="readonly"/> 員工新電話:<inputtype="text"name="newpwd"/> <inputtype="submit"value="修改"><inputtype="reset"value="重填"></form>④增添頁(yè)面<pclass="STYLE12">添加一個(gè)新員工<formaction="../MessageServlet?flag=2"method="post">請(qǐng)輸入員工名:<inputtype="text"name="username"/>請(qǐng)輸入您電話:<inputtype="text"name="password"> <inputtype="submit"value="添加">后臺(tái)：（1）FilterpublicvoiddoFilter(ServletRequestreq,ServletResponseresp,FilterChainchain)throwsIOException,ServletException{HttpServletRequestrequest=(HttpServletRequest)req;HttpServletResponseresponse=(HttpServletResponse)resp;HttpSessionsession=request.getSession();if(null!=session.getAttribute("manager")){chain.doFilter(request,response);}else{request.setAttribute("msg","您沒有權(quán)限訪問！");request.getRequestDispatcher("../index.jsp").forward(request,response);}}publicvoidinit(FilterConfigarg0)throwsServletException{System.out.println("log-init");（2）Servlet1vip//增添vipprivatevoidinserttwo(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{Stringusername=request.getParameter("username");Stringpassword=request.getParameter("password");Useruser=newUser();user.setUsername(username);user.setPassword(password);intb=us.inserttwo(user);listPage(request,response);}//分頁(yè)privatevoidlistPage(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{//TODOAuto-generatedmethodstubStringpageNoStr=request.getParameter("pageNo");if(pageNoStr!=null){pageNo=Integer.valueOf(pageNoStr);}PageBean<User>pageBean=newPageBean<User>();List<User>list=us.listPage(null,pageNo,pageSize);pageBean.setData(list);pageBean.setPageNo(pageNo);pageBean.setPageSize(pageSize);pageBean.setTotalCount(us.count());request.setAttribute("pageBean",pageBean);request.getRequestDispatcher("xsUser.jsp").forward(request,response);}//刪除一個(gè)vip信息privatevoiddeleteOne(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{//TODOAuto-generatedmethodstubintid=Integer.parseInt(request.getParameter("userid"));us.deleteOne(id);//findAll(request,response);listPage(request,response);}//修改一個(gè)vip的密碼privatevoidupdateOne(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{//TODOAuto-generatedmethodstubintid=//Integer.parseInt(request.getParameter("userid"));intid=Integer.parseInt(request.getParameter("userid"));Stringusername=request.getParameter("username");//Stringoldpwd=request.getParameter("oldpwd");Stringnewpwd=request.getParameter("newpwd");Useruser=newUser();user.setPassword(newpwd);user.setUsername(username);us.updateOne(user,id);//findAll(request,response);listPage(request,response);}//查詢?nèi)縱ip信息privatevoidfindAll(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{//TODOAuto-generatedmethodstubList<User>list=us.findAll();request.setAttribute("list",list);request.getRequestDispatcher("xsUser.jsp").forward(request,response);}2酒品//分頁(yè)privatevoidlistPage(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{StringpageNoStr=request.getParameter("pageNo");if(pageNoStr!=null){pageNo=Integer.valueOf(pageNoStr);}PageBean<Product>pageBean=newPageBean<Product>();List<Product>list=us.listPage(null,pageNo,pageSize);pageBean.setData(list);pageBean.setPageNo(pageNo);pageBean.setPageSize(pageSize);pageBean.setTotalCount(us.count());request.setAttribute("pageBean",pageBean);request.getRequestDispatcher("xsProduct.jsp").forward(request,response);}//刪除一個(gè)酒品信息privatevoiddeleteOne(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{intid=Integer.parseInt(request.getParameter("cpid"));us.deleteOne(id);//findAll(request,response);listPage(request,response);}//修改一個(gè)酒品信息privatevoidupdateOne(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{//TODOAuto-generatedmethodstubintid=Integer.parseInt(request.getParameter("cpid"));Stringnewcpname=request.getParameter("newcpname");Stringnewcpintroduce=request.getParameter("newcpintroduce");Stringnewcppicture=request.getParameter("newcppicture");Stringnewcpflid=request.getParameter("newcpflid");Stringnewcpprice=request.getParameter("newcpprice");Productcp=newProduct();cp.setCpintroduce(newcpintroduce);cp.setCppicture(newcppicture);cp.setCpprice(newcpprice);cp.setCpflid(newcpflid);cp.setCpname(newcpname);us.updateOne(cp,id);//findAll(request,response);listPage(request,response);}//添加一個(gè)酒品信息privatevoidinsertOne(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{Stringcpname=request.getParameter("cpname");Stringcpintroduce=request.getParameter("cpintroduce");Stringcppicture=request.getParameter("cppicture");Stringcpprice=request.getParameter("cpprice");Stringcpflid=request.getParameter("cpflid");Productcp=newProduct();cp.setCpintroduce(cpintroduce);cp.setCpname(cpname);cp.setCppicture(cppicture);cp.setCpprice(cpprice);cp.setCpflid(cpflid);intb=us.insertOne(cp);//findAll(request,response);listPage(request,response);}//查詢?nèi)烤破沸畔ublicvoidfindAll(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{List<Product>list=us.findAll();request.setAttribute("list",list);request.getRequestDispatcher("xsProduct.jsp").forward(request,response);}//搜索菜品信息publicvoidfindAll10(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{Stringsscpname=request.getParameter("sscpname");List<Cp>list=us.findAll10(sscpname);request.setAttribute("list",list);request.getRequestDispatcher("cp3.jsp").forward(request,response);}//搜索后提取備注和菜品信息privatevoidfindOne(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{intid=Integer.parseInt(request.getParameter("cpid"));List<Cp>list=us.findOne(id);request.setAttribute("list",list);List<Cppl>cppllist=cs.findOne(id);request.setAttribute("cppllist",cppllist);request.getRequestDispatcher("cp3.jsp").forward(request,response);}//添加一個(gè)備注信息并獲取管理員名字PrivatevoidinsertOne(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{HttpSessionsession=request.getSession();Stringcpplcontent=request.getParameter("cpplcontent");if(null!=session.getAttribute("user")){Stringcpplusername=((Manager)session.getAttribute("manager")).getManagername();}else{}intcpplflid=Integer.parseInt(request.getParameter("cpplid"));Cpplcppl=newCppl();cppl.setCpplcontent(cpplcontent);cppl.setCpplusername(cpplusername);cppl.setCpplflid(cpplflid);intb=us.insertOne(cppl);findOne(request,response);}}3員工//增加員工privatevoidinserttwo(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{Stringusername=request.getParameter("username");Stringpassword=request.getParameter("password");Messagemessage=newMessage();message.setUsername(username);message.setPassword(password);intb=us.inserttwo(message);listPage(request,response);}privatevoidlistPage(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{//TODOAuto-generatedmethodstubStringpageNoStr=request.getParameter("pageNo");if(pageNoStr!=null){pageNo=Integer.valueOf(pageNoStr);}PageBean<Message>pageBean=newPageBean<Message>();List<Message>list=us.listPage(null,pageNo,pageSize);pageBean.setData(list);pageBean.setPageNo(pageNo);pageBean.setPageSize(pageSize);pageBean.setTotalCount(us.count());request.setAttribute("pageBean",pageBean);request.getRequestDispatcher("xsMessage.jsp").forward(request,response);}//刪除一個(gè)員工信息privatevoiddeleteOne(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{//TODOAuto-generatedmethodstubintid=Integer.parseInt(request.getParameter("userid"));us.deleteOne(id);//findAll(request,response);listPage(request,response);}//修改一個(gè)員工的密碼privatevoidupdateOne(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{//TODOAuto-generatedmethodstubintid=//Integer.parseInt(request.getParameter("userid"));intid=Integer.parseInt(request.getParameter("userid"));Stringusername=request.getParameter("username");//Stringoldpwd=request.getParameter("oldpwd");Stringnewpwd=request.getParameter("newpwd");Messagemessage=newMessage();message.setPassword(newpwd);message.setUsername(username);us.updateOne(message,id);//findAll(request,response);listPage(request,response);}//查詢?nèi)繂T工信息privatevoidfindAll(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{//TODOAuto-generatedmethodstubList<Message>list=us.findAll();request.setAttribute("list",list);request.getRequestDispatcher("xsMessage.jsp").forward(request,response);}}④管理員privatevoidmanagerLogin(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{HttpSessionsession=request.getSession();StringmanagerName=request.getParameter("managername");StringpassWord=request.getParameter("password");Managermanager=us.managerLogin(managerName,passWord);if(manager!=null){session.setAttribute("manager",manager);request.getRequestDispatcher("manager/manager.jsp").forward(request,response);}else{request.setAttribute("msg","用戶名和密碼不正確！請(qǐng)輸入用戶名與密碼！");request.getRequestDispatcher("managerLogin.jsp").forward(request,response);}（3）Dao.Impl1Vip//查詢publicList<User>findAll(){Connectionconn=JdbcUti.getInstance().getConn();Stringsql="select*fromusertab11";List<User>list=newArrayList<User>();Statementstmt=null;ResultSetrs=null;try{stmt=conn.createStatement();rs=stmt.executeQuery(sql);while(rs.next()){Useruser=newUser();user.setId(rs.getInt("id"));user.setUsername(rs.getString("username"));user.setPassword(rs.getString("password"));list.add(user);}}catch(SQLExceptione){//TODOAuto-generatedcatchblocke.printStackTrace();}finally{JdbcUti.getInstance().free(conn,stmt,rs);}returnlist;}//刪除一個(gè)vippublicintdeleteOne(intid){Connectionconn=JdbcUti.getInstance().getConn();Stringsql="deletefromusertab11whereid=?";PreparedStatementpstmt=null;ResultSetrs=null;intb=0;try{pstmt=conn.prepareStatement(sql);pstmt.setInt(1,id);b=pstmt.executeUpdate();}catch(SQLExceptione){//TODOAuto-generatedcatchblocke.printStackTrace();}finally{JdbcUti.getInstance().free(conn,pstmt,rs);}returnb;}//修改一個(gè)vippublicintupdateOne(Useruser,intid){Connectionconn=JdbcUti.getInstance().getConn();Stringsql="updateusertab11setpassword=?whereid=?";PreparedStatementpstmt=null;ResultSetrs=null;intb=0;try{pstmt=conn.prepareStatement(sql);pstmt.setString(1,user.getPassword());pstmt.setInt(2,id);b=pstmt.executeUpdate();}catch(SQLExceptione){//TODOAuto-generatedcatchblocke.printStackTrace();}finally{JdbcUti.getInstance().free(conn,pstmt,rs);}returnb;}//分頁(yè)總數(shù)publicintcount(){Connectionconn=JdbcUti.getInstance().getConn();Stringsql="selectcount(*)fromusertab11";PreparedStatementpstmt=null;ResultSetrs=null;intb=0;try{pstmt=conn.prepareStatement(sql);rs=pstmt.executeQuery();if(rs.next()){b=rs.getInt(1);}}catch(SQLExceptione){//TODOAuto-generatedcatchblocke.printStackTrace();}finally{JdbcUti.getInstance().free(conn,pstmt,rs);}returnb;}//分頁(yè)publicList<User>listPage(Stringsql,intpageNo,intpageSize){Connectionconn=JdbcUti.getInstance().getConn();List<User>list=newArrayList<User>();Statementstmt=null;ResultSetrs=null;intpagePos=(pageNo-1)*pageSize;if(sql==null){sql="select*fromusertab11orderbyidlimit"+pagePos+","+pageSize;}try{stmt=conn.createStatement();rs=stmt.executeQuery(sql);while(rs.next()){Useruser=newUser();user.setId(rs.getInt("id"));user.setUsername(rs.getString("username"));user.setPassword(rs.getString("password"));list.add(user);}}catch(SQLExceptione){//TODOAuto-generatedcatchblocke.printStackTrace();}finally{JdbcUti.getInstance().free(conn,stmt,rs);}returnlist;}//增加vippublicintinserttwo(Useruser){Connectionconn=JdbcUti.getInstance().getConn();Stringsql="insertintousertab11(username,password)values(?,?)";PreparedStatementpstmt=null;ResultSetrs=null;intb=0;try{pstmt=conn.prepareStatement(sql);pstmt.setString(1,user.getUsername());pstmt.setString(2,user.getPassword());b=pstmt.executeUpdate(

人人文庫(kù)> 全部分類> 圖紙下載 > 畢業(yè)設(shè)計(jì)

溫馨提示

1. 本站所有資源如無(wú)特殊說(shuō)明，都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請(qǐng)下載最新的WinRAR軟件解壓。
2. 本站的文檔不包含任何第三方提供的附件圖紙等，如果需要附件，請(qǐng)聯(lián)系上傳者。文件的所有權(quán)益歸上傳用戶所有。
3. 本站RAR壓縮包中若帶圖紙，網(wǎng)頁(yè)內(nèi)容里面會(huì)有圖紙預(yù)覽，若沒有圖紙預(yù)覽就沒有圖紙。
4. 未經(jīng)權(quán)益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
5. 人人文庫(kù)網(wǎng)僅提供信息存儲(chǔ)空間，僅對(duì)用戶上傳內(nèi)容的表現(xiàn)方式做保護(hù)處理，對(duì)用戶上傳分享的文檔內(nèi)容本身不做任何修改或編輯，并不能對(duì)任何下載內(nèi)容負(fù)責(zé)。
6. 下載文件中如有侵權(quán)或不適當(dāng)內(nèi)容，請(qǐng)與我們聯(lián)系，我們立即糾正。
7. 本站不保證下載資源的準(zhǔn)確性、安全性和完整性, 同時(shí)也不承擔(dān)用戶因使用這些下載資源對(duì)自己和他人造成任何形式的傷害或損失。

JAVAWeb開發(fā)酒店管理系統(tǒng)總結(jié)報(bào)告

文檔簡(jiǎn)介

溫馨提示

最新文檔

評(píng)論

JAVAWeb開發(fā)酒店管理系統(tǒng)總結(jié)報(bào)告

文檔簡(jiǎn)介

溫馨提示

最新文檔

評(píng)論

相關(guān)文檔