高级网站设计实验报告

高级网站设计高级网站设计 实验报告实验报告 班级 班级 信管信管 姓名 姓名 实验时间 实验时间 20122012 年年 5 5 月月 2 2 日日 指导教师 指导教师 一 实验目的一 实验目的 1 掌握 Servlet JavaBean 的应用 2 掌握 EL 表达式 3 掌握 MVC 应用 二 实验内容二 实验内容 1 编写 Servlet 显示一个 Excel 或者 PDF 的成绩单表格 2 编写 JavaBean 实现用户登录处理 3 利用 MVC 架构 实现用户登录 注册处理 三 操作步骤操作步骤 1 1 编写 编写 ServletServlet 显示一个 显示一个 ExcelExcel 或者或者 PDFPDF 的成绩单表格的成绩单表格 package Zhulin import java io IOException import java io PrintWriter import javax servlet ServletException import javax servlet annotation WebServlet import javax servlet http HttpServlet import javax servlet http HttpServletRequest import javax servlet http HttpServletResponse Servlet implementation class mm WebServlet downscore public class mm extends HttpServlet private static final long serialVersionUID 1L private static final String CONTENT TYPE application vnd ms download charset GB18030 private static final String CONTENT FILE NAME attachment filename score xls protected void service HttpServletRequest request HttpServletResponse response throws ServletException IOException response setContentType CONTENT TYPE response setHeader Content Disposition CONTENT FILE NAME PrintWriter out response getWriter out println out println 姓名英语成绩 out println 张一凡89 out println 王梦92 out println out close 2 编写 编写 JavaBean 实现用户登录处理 实现用户登录处理 User java package mymodel public class User private String username private String password public String getUsername return username public void setUsername String username this username username public String getPassword return password public void setPassword String password this password password Exelogin jsp Insert title here Login jsp 用户登录 用户名 密码 Insert title here 恭喜你登录成功 3 利用 利用 MVC 架构 实现用户登录 注册处理架构 实现用户登录 注册处理 Register jsp Insert title here welcome 欢迎登录 用户名 密 码 还没注册 先注册吧 Admin jsp 欢迎登录 欢迎您 Testseverlet jsp Insert title here welcome 欢迎登录 用户名 密 码 还没注册 先注册吧 loginAction java package action import java io IOException import javax servlet RequestDispatcher import javax servlet ServletException import javax servlet http HttpServlet import javax servlet http HttpServletRequest import javax servlet http HttpServletResponse import Dao userDao import User user public class loginAction extends HttpServlet private static final long serialVersionUID 1L boolean isExit false public loginAction super protected void doGet HttpServletRequest request HttpServletResponse response throws ServletException IOException doPost request response protected void doPost HttpServletRequest request HttpServletResponse response throws ServletException IOException request setCharacterEncoding utf 8 response setCharacterEncoding utf 8 response setContentType text html charset utf 8 user u new user userDao ud new userDao isExit false String name request getParameter user String pwd request getParameter pwd if name pwd response sendRedirect servletTest jsp return else u setName name u setPwd pwd isExit ud queryUser u if isExit request setAttribute user u RequestDispatcher dispatcher request getRequestDispatcher admin jsp dispatcher forward request response else response sendRedirect fail jsp System out println isExit action RegisterAction java package action import java io IOException import javax servlet RequestDispatcher import javax servlet ServletException import javax servlet http HttpServlet import javax servlet http HttpServletRequest import javax servlet http HttpServletResponse import Dao userDao import User user public class registerAction extends HttpServlet private static final long serialVersionUID 1L public registerAction super protected void doGet HttpServletRequest request HttpServletResponse response throws ServletException IOException doPost request response protected void doPost HttpServletRequest request HttpServletResponse response throws ServletException IOException request setCharacterEncoding utf 8 response setCharacterEncoding utf 8 response setContentType text html charset utf 8 user u new user userDao ud new userDao String name request getParameter user String pwd request getParameter pwd if name pwd response sendRedirect servletTest jsp return else u setName name u setPwd pwd Boolean isSave ud saveUser u if isSave request setAttribute user u RequestDispatcher dispatcher request getRequestDispatcher admin jsp dispatcher forward request response else response sendRedirect fail jsp userDAO java package Dao import java sql Connection import java sql PreparedStatement import java sql ResultSet import java sql SQLException import util DB import User user public class userDao boolean b false public boolean queryUser user u b false String sql select from user where username and password Connection conn DB getConn PreparedStatement pstmt null pstmt DB prepare conn sql try pstmt setString 1 u getName pstmt setString 2 u getPwd ResultSet rs pstmt executeQuery while rs next b true System out println u getPwd DAO catch SQLException e e printStackTrace return b public boolean saveUser user u b false String sql insert into user values null Connection conn DB getConn PreparedStatement pstmt null pstmt DB prepare conn sql try conn setAutoCommit false pstmt setString 1 u getName pstmt setString 2 u getPwd pstmt executeUpdate conn setAutoCommit true b true catch SQLException e e printStackTrace ret