Web数据库实验报告servlet.doc

实验报告（三）院系：信息学院 课程名称：Web数据库技术 日期：班 级信息A1022姓 名刘杰专 业信息管理与信息系统学 号29实 验 室实验名称Servlet应用成 绩 评 定教 师 签 名实验目的1、 掌握servlet的配置方法2、 掌握web服务器的配置过程3、 掌握HttpServlet类的用法4、 掌握session等对象的用法5、 掌握请求转发功能的应用6、掌握SerlvetConfig上下文的用法实验内容Servlet配置、servlet设计、会话管理、请求流转、上下文应用实验过程、结果及分析一、1、 请建立一个servlet类用于显示当前的系统时间。写出它的url配置写法package servlet;import java.io.IOException;import java.io.PrintWriter;import java.util.Date;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;public class servletDate extends HttpServlet public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException request.setCharacterEncoding(UTF-8); response.setCharacterEncoding(UTF-8);response.setContentType(text/html);PrintWriter out = response.getWriter(); String dateString=null; Date date=new Date();dateString=date.toLocaleString();out.print(当前时间是：+dateString);out.flush();out.close();public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException url配置方法：首先在servlet包下新建servlet类：servletDate servletDate servlet.servletDate 然后进行映射，第一个斜杠是web应用的根路径； servletDate /servlet/servletDate 实验过程、结果及分析二、1、 请输入用户名和密码，如果用户名和密码是“zhangsan”和”123456”,则进入一个欢迎界面，否则要求用户重新输入。涉及的方法：(1)response.sendRedirect(login.htm); (2)request.getRequestDispatcher(welcome.htm).forward(request, response); (3) HttpSession session = request.getSession();session.setAttribute(islogin, true); (4)boolean isLogin=session.getAttribute(islogin); Login.html: MyHtml.html !- This is my HTML page. 用户名   密码   Welcome.javapackage servlet;import java.io.IOException;import java.io.PrintWriter;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.servlet.http.HttpSession;public class Welcome extends HttpServlet public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException this.doPost(request, response);public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException HttpSession session=request.getSession();String isLogin=(String) session.getAttribute(isLogin);response.setContentType(text/html);PrintWriter out = response.getWriter();out.println();out.println();out.println( A Servlet);out.println();out.println(欢迎进入Java Web世界！);out.println(isLogin:+isLogin);out.println( );out.println();out.flush();out.close();Login.javapackage servlet;import java.io.IOException;import java.io.PrintWriter;import java.util.Date;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.servlet.http.HttpSession;public class login1 extends HttpServlet public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException this.doPost(request, response);public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException request.setCharacterEncoding(UTF-8);/字符编码问题，解决中文乱码问题response.setCharacterEncoding(UTF-8);String Name=request.getParameter(name); String Pwd=request.getParameter(pwd); if(zhangsan.equals(Name)&123456.equals(Pwd)HttpSession session=request.getSession(); session.setAttribute(isLogin, true); request.getRequestDispatcher(/welcome).forward(request, response);/转发 else response.sendRedirect(request.getContextPath()+/login1.html);/重定向 2、领会多用户并发访问的机制，请建立一个HttpServlet“servletUsers”类，在该类的成员代码如下：public class serveltUsers extends HttpServlet private Integer x=1;public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException this.doPost(request, response);public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException response.setContentType(text/html);response.setCharacterEncoding(utf-8);PrintWriter out = response.getWriter();out.println();out.println();out.println( A Servlet);out.println( );out.println(当前x的值是+x);out.flush();synchronized (x) Thread thread=Thread.currentThread(); try thread.sleep(1000*5); catch (InterruptedException e) / TODO Auto-generated catch blocke.printStackTrace(); x+;out.println(当前serlvet实例阻塞5秒后，当前x的值是+x);out.println( );out.println();out.flush();out.close();请在5秒内用两个浏览器窗口浏览该HttpServlet类，看看效果如何。为什么是这个效果！第一个窗口显示：当前x的值是1 当前serlvet实例阻塞5秒后，当前x的值是2第二窗口显示：当前x的值是2 当前serlvet实例阻塞5秒后，当前x的值是3分析与解析：用户一访问x时，第一次x为初值1，用户一在休眠五秒钟内释放了对x的控制权，休眠后，当前x的值是3用户二在五秒内再次访问x时，因为对核心语句加锁，必须等待用户一休眠后以及对x加1后才能访问x,这时用户二访问的x为已经加了1，值为2，当前serlvet实例阻塞5秒后，当前x的值是3三、1、 请设计一种过滤器实现权限控制机制。如果用户进入web应用没有登入时，要求用户必须进入登入页面。package filter;import java.io.IOException;import java.util.Date;import javax.servlet.Filter;import javax.servlet.FilterChain;import javax.servlet.FilterConfig;import javax.servlet.ServletException;import javax.servlet.ServletRequest;import javax.servlet.ServletResponse;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.servlet.http.HttpSession;public class encoderFilter implements Filter/过滤器的使用public void destroy() /销毁，在销毁之前可以保存数据到数据库public void doFilter(ServletRequest req, ServletResponse res,FilterChain chain) throws IOException, ServletException HttpServletRequest request=(HttpServletRequest)req;HttpServletResponse response=(HttpServletResponse)res;request.setCharacterEncoding(UTF-8);/字码设置，解决乱码问题response.setCharacterEncoding(utf-8); HttpSession session=request.getSession(); if(session.isNew() response.sendRedirect(request.getContextPath()+/login.html);/重定向 chain.doFilter(request, response);/过滤器的方法public void init(FilterConfig arg0) throws ServletException /初始化方法配置WEB.xml encoder filter.encoderFilter encoder /* 过滤web应用下的文件 2、 请设计一种机制进行网站访问者统计监听器类package Listener;import javax.servlet.ServletContext;import javax.servlet.ServletContextEvent;import javax.servlet.ServletContextListener;import javax.servlet.http.HttpSession;import javax.servlet.http.HttpSessionEvent;import javax.servlet.http.HttpSessionListener;public class application implements ServletContextListener,HttpSessionListener public void contextDestroyed(ServletContextEvent sce) / TODO Auto-generated method stubpublic void contextInitialized(ServletContextEvent sce) / TODO Auto-generated method stubServletContext application=sce.getServletContext();application.setAttribute(count, 0);System.out.print(web 应用初始化*);public void sessionCreated(HttpSessionEvent se) / TODO Auto-generated method stubSystem.out.print(一个新的session对象产生*);ServletContext application=se.getSession().getServletContext();HttpSession session=se.getSession();session.setAttribute(count, 10);Integer count =(Integer)application.getAttribute(count);int cou=count+1;application.setAttribute(count, cou);public void sessionDestroyed(HttpSessionEvent se) / TODO Auto-generated method stub统计类：package servlet;import java.io.IOException;import java.io.PrintWriter;import javax.servlet.ServletContext;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.servlet.http.HttpSession;public class hello3 extends HttpServlet /* * The doGet method of the servlet. * * This method is called when a form has its tag value method equals to get. * * param request the request send by the client to the server * param response the response send by the server to the client * throws ServletException if an error occurred * throws IOException if an error occurred */public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException this.doPost(request, response);/* * The doPost method of the servlet. * * This method is called when a form has its tag value method equals to post. * * param request the request send by the client to the server * param response the response send by the server to the client * throws ServletException if an error occurred * throws IOException if an error occurred */public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException HttpSession session=request.getSession();Integer i=(Integer)session.getAttribute(count);int count=i+1;session.setAttribute(count, count);ServletContext application=this.getServletContext();response.setContentType(text/html);PrintWriter out = response.getWriter();out.println();out.println();out.println( A Servlet);out.println( );out.print( servletContext-count +application.getAttribute(count)+);out.print( session-coun+session.getAttribute(count)+);out.print(hello1 );out.print(hello2 );out.println( );out.println();out.flush();out.close();在web.xml监听器配置：Listener.application实验报告（四）院系：信息学院 课程名称：Web数据库技术 日期：班 级信A1022姓 名刘杰专 业信息管理与信息系统学 号29实 验 室实验名称Jsp应用成 绩 评 定教 师 签 名实验目的1、 request、response对象的应用2、 EL表达式的使用3、Javabeans使用实验内容内置对象的使用、el表达式、javabean应用实验过程、结果及分析一、1.编写一个含有文本输入框、密码框的登陆页面login.html编写login.html文件用户名：密码： 2.编写一个登陆验证页面logincheck.jsp，如果用户输入的用户名为admin,密码为123,则转到index.jsp文件，否则，提示登陆失败。编写logincheck.jsp文件编写index.jsp文件登陆成功！欢迎进入系统实验过程、结果及分析二、1、请通过javaBean、EL表达式和JSTL来显示整个学生表中的信息pojo类:public class User implements Serializable private String name;private String password;private String cause;private String info;public String getInfo() return info;public void setInfo(String info) = info;public String getPassword() return password;public void setPassword(String password) this.password = password;public String getUsername() return name;public void setUsername(String username) = username;public String getCause() return cause;public boolean login()if(briup.equals(name)&briup.equals(password) info=success login;return true;else cause=user or passwore not match;return false;login.jsp Cause: UserName PassWord Logincheck.jsp loginsuccess.jsp UserName: Password: 实验报告（五）院系：信息学院 课程名称：Web数据库技术 日期：班 级信A1022姓 名刘杰专 业信息管理与信息系统学 号29实 验 室实验名称MVC模式应用成 绩 评 定教 师 签 名实验目的1、 掌握MVC模式的设计理念2、掌握各层的设计方法实验内容转账系统的设计开发实验过程、结果及分析1、输入两个账户及金额，将一个账户的资金转入到另一个账户上。User类String name;/账户名 String pwd;/密码 int money;/金额账户表(账户名char(10),密码 varchar(20),金额 int)package pojo;public class amount private String name;private int money;public String getName() return name;public void setName(String name) = name;public int getMoney() return money;public void setMoney(int money) this.money = money;package dao;import java.util.List;import amountException.amountException;import pojo.amount;public interface amountDao /查找指定条件的账户List findAmountsByCondition(String sqlCondition,List values)throws amountException;/删除指定账户名void deleteAmount(String amountName)throws amountException;/保存账户到账户表中int saveAmount(amount amount)throws amountException;/把amount中的钱改变money,如果money为正数表示加钱，否则表示减钱void changMoney(amount amount,int money)throws amountException;void Close();package dao; import java.sql.*;import java.util.List;import util.connectionFactory;import amountException.amountException;public class DBtemplate protected Connection conn;protected PreparedStatement pres;protected ResultSet rs;protected Statement stam;public DBtemplate(Connection conn) super();this.conn = conn;public void closeAll()closeAll(rs,pres,conn);public void closeAll(ResultSet rs,PreparedStatement pres,Connection conn)if(rs!=null)try rs.close(); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();if(pres!=null)try pres.close(); catch (SQLException e) e.printStackTrace();if(conn!=null)try conn.close(); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();public void closeAll(ResultSet rs,Statement pres,Connection conn)if(rs!=null)try rs.close(); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();if(pres!=null)try pres.close(); catch (SQLException e) e.printStackTrace();if(conn!=null)try conn.close(); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();protected ResultSet executeQuery(String sql,List values)throws amountExceptioninitPreparedStatement(sql, values);/*System.out.print(values);*/try return pres.executeQuery();/ catch (SQLException e) throw new amountException(e);private void initPreparedStatement(String sql,List values)throws amountExceptiontry pres=conn.prepareSta