2023年高级网站设计实验报告_第1页
2023年高级网站设计实验报告_第2页
2023年高级网站设计实验报告_第3页
2023年高级网站设计实验报告_第4页
2023年高级网站设计实验报告_第5页
已阅读5页，还剩10页未读， 继续免费阅读

下载本文档

版权说明：本文档由用户提供并上传，收益归属内容提供方，若内容存在侵权，请进行举报或认领

文档简介

《高级网站设计》实验报告班级：信管姓名：—实验时间：2023年5月2日指导教师:一、实验目的式.掌握Servlet>JavaBean的应用。.掌握EL表达式。.掌握MVC应用。二、实验内容.编写Servlel,显示一个ExceI或者PDF的成绩单表格。.编写JavaBean,实现用户登录解决。.运用MVC架构，实现用户登录、注册解决。三、操作环节1、编写Servlet,显示一个Exce1或者PDF的成绩单表格packageZhu1in;importjava,io.IOException;importjava.io.PrintWriter；importjavax.servlet.ServletException;importjavax.serv1ct.annotation.WcbServlet；importjavax.servlet,h(tp.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.serv1et.http.HttpServletResponse;/***Servletimp1ementationclassmm<%«useru=newuser();=(user)request.getAttributeC'user");Stringname=u.getName()；%><metahttp-equiv="Content-Type"content="text/html;charset=UTF-8">欢迎登录</head>body>欢迎您v%=name%>/body>/htm1>Tcstsever1et.jsp%@pagelanguage="java"contentType="text/html;charsef=UTF-8"pageEncoding="UTF-8"%><!DOCTYPEhtmlPUBLICn-//W3C//DTDHTML4.01Transitiona1//EN><htm1><head><metahttp-equiv="Content-Type"content=text/html；charset=UTF-8"><title>Inserttit1ehere</title></head><body><head>tit1e>welcome</title>/head><body><formid="form/"name="fonnl"method="post"action="loginAction"><tab1ewidth="378〃border="0"a1ign="center'^<tr><tdheight="80"colspan="2"align="center">欢迎登录</td></1r><tr><tdwidth="95"height=w39wxlabe1>用户名V/1abe1></td><tdwidth="267"><\abe\><inputlype="text"name="user"/></label></td></tr>tr>tdheight="36"><1abel>密码</1abe1></td><td><1abe1><inputtype="password"name="pwd"/></labelX/1d></1r><tr><tdheight="48"colspan=〃2"aIign=°center^labe1><inputtype="submit"name="Submit"value="提交'/><inputtype=°set“name="Subinit2〃value="重置”/></labelx/td></tr><tdheight="72"co1span="2"a1ign="c还没注册?先<ahref="register.jspMtarget="_b1，〃*>注册v/a>吧v/td></tr></table></form></body></html>欢迎登录用户名密码提且重置还没注册？先注册吧loginAction.javapackageaction;importjava.io.IOException;importjavax.servlet.RequestDispatcher;importjavax.serv1et.ServletException;importjavax.servlet,http.HttpServlet;importjavax.serv1et.http.HttpServletRcquest;importjavax.servlet.http.HttpServletResponse;importDao.userDao；importUser.user;publicclass1oginActionextendsHttpServlet{»privatestaticfina1longserialVersionUID=1L；boo1eanisExit=faIse;叩ublic1oginAction(){。super();)roteetcdvoiddoGct(HttpServ1ctRcqucstrequest,HttpServ1etResponseresponse)throwsServletException,IOExccption{doPost(request,response);protectedvoiddoPost(HttpServletRequestrequest,。0HttpServletResponseresponse)throwsServletException,I0Exception{«rcquest.setCharacterEncoding("utf-8");sresponse.setCharacterEncoding("utf-8");esponsc.setContcntTypc("tcxt/html;charsct=utf—8");◎useru=newuser();

guserDaoudguserDaoudguserDaoudnewuserDao();guserDaoudnewuserDao();。isExit=false;gStringname=request.getParameter("usern);«Stringpwd=request.getParameter("pwd");if(name==""IIpwd=="°){®response.sendRedirect("servlelTesl.jsp");。return;}e1se{ou.setName(name);gu.selPwd(pwd);gisExit=ud.qucryUser(u);if(isExit)(。。equest.setAttribute("useru,u);。RequestDispateherdispatcher=request。。.getRequestDispateher("admin,jsp");gdispatcher.forward(request,response);o。}eIse{。response.sendRedirect("fail.jsp")；»System.out.println(isExit+'*action");°))RcgisterAction.javapackageaction;importjava.io.IOException;importjavax.servlet.RequestDispatcher;importjavax.servIet.ServietException;importjavax.servlet.http.HttpServ1ct;importjavax.ttpServletRequest;importjavax.scrvlct.http.HttpServ1etResponsc;importDao.userDao;importUser.user;publicclassregisterActionextendsHttpServlet{叩rivatestaticfinallongseria1VersionUID=IL;opublicregisterAction(){»supcr();0)sprotectedvoiddoGet(HnpServ1etRequestrequest,。HttpServ1etResponseresponse)throwsServ1etException,IOException{。doPost(request,response)；0)aprotectedvoiddoPost(HttpServlctRequestrequest,HttpServ1etResponseresponse)throwsServletException,10Exception{g「equest.se(CharacterEneoding("utf-8");®response.setCharacterEncoding("utf-8")；。response.setContentType("text/html;charset=utf-8")；。useru=newuser();userDaoud=newuserDao();。Stringname=request.getParametcr("user")；Stringpwd=requesi.gelParameier("pwd");«if(name==|Ipwd=={◎oresponse,senJRedirect("serv1etTest.jsp")；greturn;g}else)ou.sctNamc(name);u.setPwd(pwd);。BooleanisSave=ud.saveUser(u);gif(isSave){3request.setAttribute("user",u)；。®®RequestDispateherdispatcher=requestwM.geiRequestDispatcher("admin.jsp")：®。dispatcher.forward(request,response);g)else{oresponse.sendRcdircct("fail.jsp");b}°}}userDAO.javapackageDao；importjava.sq1.Connection；importjava.sq1.PreparedStatement；importjava.sq1.ResultSet;importjava.sql.SQLException;importutiLDB;importUser.user;publiec1assuserDao{»boo1eanb=false;pub1icbooleanqueryUser(useru){ab=faIse；a»Stringsql="select*fromuserwhereusername=?andpassword=?»dConnectionconn=DB.getConn();。PreparedStatementpstmt=nu11；wpstmt=DB.prepare(conn,sql);Mry{pstmt.setString(1,u.getName());opstmt.setString(2,u.getPwd());。Resultsetrs=pstmt.executeQuery();&while(rs.next()){。b=true;。^System.out.println(u.getPwd()+"DAO");g}catch(SQLExceptione){。。e.printStackTrace();1®rcturnb；pub1icboo1eansaveUser(useru){。b=fa1se;sStringsq1="insertintouservalues(nul1,?,?)Connectionconn=DB.gctConn()；®PreparedStatementpstmt=null;叩stmt=DB.prepare(conn,sq1);try(«®«conn.setAutoCommit(fa1se);pstmt.setString(1,u.getName。)；pstmt.seiString(2,u.getPwd())；pstmt.executeUpdate();conn.setAutoCommit(true);=true;}catch(SQLExceptione){。e.printStackTrace();。}«returnb；*}User.javapackageUser;publicclassuser{aStringusername=null;◎Stringpwd=nu11；publicStringgctNamc(){areturnusername;)publicvoidsctName(Stringusernamc){。this.username=username;)。publicStringgetPwd(){^returnpwd;0)pub1icvoidsetPwd(Stringpwd){wthis.pwd=pwd;0)I四、实验收获和建议*/@WebServlet("/downscore")publicc1assmmextendsHttpServ1et(叩rivatestaticfinallongserialVersionUI77=1L；®privatestaticfina1StringCONTBNT_TYPE="app1ication/vnd.ms-down1oad；charset=GB18030";叩rivatestaticfinalStringCONTENT_FILE_NAME="attachinent;filename=score.xls"；。protectedvoidservice(HttpServ1etRequestrequest,0HHpServletResponseresponse)throwsServ1etException,IOExceplion{gresponse.setContentType(CONTENT_TYPE)；©response.setHeader("Content-Disposition",CONTENT_FILE_NAME);3PrintWriterout=response,getWriter();axmt.println("<tab1ewidth=300border=l>");®out.println姓名V/td><td>英语成绩v/tdx/tr>");&out.println("<tr><td>^K-FLV/tdxtd>89</td></1r>");out.print王梦</td><td>92V/td></tr>");out.print1n("</tab1e>H);aout.close();

您要打开还是保存此文件?您要打开还是保存此文件?您要打开还是保存此文件?称型源

类score.xlsMicrosoftExcel工作表localhost打开⑺保存6〕|取消里贴板1Al麴I1件开苒些要某不2、编写JavaBean,您要打开还是保存此文件?称型源

类score.xlsMicrosoftExcel工作表localhost打开⑺保存6〕|取消里贴板1Al麴I1件开苒些要某不User.javapackagemymodel;publicclassUser{^privateStringusername；叩rivatcStringpassword;pub1icStringgetUsername(){arcturnusername;«)opub1icvoidsetUsername(Stringusername)(this.username=usemame;◎pub1icStringgetPassword(){returnreturnreturnPassword;returnPassword;叩ublievoidsetPassword(Stringpassword){ssword=password叩ublievoidIExeloginjsp<%@pagelanguage="java"contentType="text/html;charset=utf-8〃pageEncoding="〃tf-8"%><!DOCTYPEhtmlPUBLIC"-//W3C//DTDHTML4.01Transitiona1//EN"'•"><jsp:useBeanid="user"class="mymodel.User"scope="request"/><jsp:setPropertyproperty="name="user"/><%@pageimport="Java,sql.*"%><html><head><metahttp-equiv="Conient—Typeucontent="text/htin1;charset=utf—8”><title>Inserttit1chere</tit1e></head><body>v%Stringurl="jdbc:mysq1：//Ioca1host/mmH;®Stringusr="root"；Stringpwd二“007”；Nry{Connectionconn=DrivcrManager.gctConncction(urI,usr,pwd);^Stringsq1=Mse1ectidfromuserwhereusername=?andpassword=?n;PreparedStatementps=conn,prepareStatement(sql);ops.sctString(l,user.getUsername());©ops.setString(2,user.ge(Password());。ResuItSetrs=ps.executcQuery()；gif(rs.next()){gqesponse.sendRedirect("admin.jsp");a}elseeresponse.sendRedirect("1ogin.jsp");conn.c1ose();}catch(Exceptione){e.printStackTrace()；。}%></body></html>Login.jsp

用户名密码I濯直I重置<%@pagelanguage=用户名密码I濯直I重置pageEncoding="utf-8"0/o><!DOCTYPEhtmlPUBLIC"-//W3C//DTDHTML4.0ITransitiona1//EN"IH1><html><head><metahttp-equiv="Content-Type"content="text/html;charset=utf-8〃><title>用户登录v/title></head><body><formname=,7ogin"method二力ost"action="exelogin.jsp">用户名<inpultype="textnname="usemame,>>密码<inputtype="password"name="password">inputtype=,,5ubmit"va1ue="登录”><inputtype="reset"value="直聋"〉/form>/body>/htm1>恭喜你登录成功。。<%@pagelanguage="java"contentType=,7ext/htm1;charset=utf-8pageEncoding="utf-8"%><!DOCTYPEhtmlPUBLIC'1-//W3C//DTDHTML4.01Transitiona1//EN><htm1><head><metah11p-equiv="Content-Type"content="text/html;charset=utf-8"><tit1e>Inser11idehere</title></head>body>恭喜你登录成功。。。。。。/body></html>3、运用MVC架构，实现用户登录、注册解决Register.jsp%@page1anguage="java"contentType="text/html：charset=UTF-8"pageEncoding="UTF-8"%><!DOCTYPEhtmlPUBLIC"-//W3C//DTDHTML4.01Transitional//EN><html><head><metahttp-equiv="Content-Type"conte

人人文库> 全部分类> 办公材料 > 办公文档

温馨提示

  • 1. 本站所有资源如无特殊说明，都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
  • 2. 本站的文档不包含任何第三方提供的附件图纸等，如果需要附件，请联系上传者。文件的所有权益归上传用户所有。
  • 3. 本站RAR压缩包中若带图纸，网页内容里面会有图纸预览，若没有图纸预览就没有图纸。
  • 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
  • 5. 人人文库网仅提供信息存储空间，仅对用户上传内容的表现方式做保护处理，对用户上传分享的文档内容本身不做任何修改或编辑，并不能对任何下载内容负责。
  • 6. 下载文件中如有侵权或不适当内容，请与我们联系，我们立即纠正。
  • 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。

最新文档

评论

0/150

提交评论