2020.11动态网站开发与设计实验五

201819102037 尹凤波

index.jsp
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.PreparedStatement" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%
  request.setCharacterEncoding("utf-8");
  String username =request.getParameter("username");
  String password =request.getParameter("password");
  Class.forName("com.mysql.jdbc.Driver");
  String url ="jdbc:mysql://localhost:3306/book";
  Connection connection = DriverManager.getConnection(url,"root","root");
  String sql="select * from user where username= ? and password= ?";
  PreparedStatement ps =connection.prepareStatement(sql);
  ps.setString(1,username);
  ps.setString(2,password);
  ResultSet rs = ps.executeQuery();
  if (rs.next()){
    session.setAttribute("username",username);
    out.print("登陆成功");
    response.sendRedirect("home.jsp");
  }else {
    out.print("登陆失败,3秒之后跳转登陆页面");
    response.setHeader("refresh","3;url=login.jsp");
  }

%>
login.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>登录页面</title>
    <link rel="stylesheet" href="css/bootstrap.css">
    <script src="js/jquery.min.js"></script>
    <script src="js/bootstrap.js"></script>
    <script src="js/bootstrap.bundle.js"></script>
    <style>
        .container{
            width: 20%;
            height: 20%;
            margin-top: 10%;  }
    </style>
</head>
<body>
<div class="container">
    <div class="row clearfix">
        <div class="col-md-12 column">
            <form role="form" method="post" action="index.jsp">
                <h3 style="text-align: center">登录</h3>
                <div class="form-group">
                    <label for="exampleInputEmail1">用户名:</label><input type="text" name="username" class="form-control" id="exampleInputEmail1" type="email" />
                </div>
                <div class="form-group">
                    <label for="exampleInputPassword1">密码:</label><input type="password" name="password" class="form-control" id="exampleInputPassword1" type="password" />
                </div>
                <button class="btn btn-default" type="submit">提交</button>
            </form>
        </div>
    </div>
</div>
</body>
</html>
register.jsp
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.Statement" %>
<jsp:useBean id="user" class="com.user"></jsp:useBean>
<jsp:setProperty name="user" property="*"></jsp:setProperty>
<%
    Class.forName("com.mysql.jdbc.Driver");
    String url="jdbc:mysql://localhost:3306/book";
    Connection connection= DriverManager.getConnection(url,"root","root");
    Statement stmt=connection.createStatement();
    String sql="insert into user(username,password,gender,age) values('"+user.getUsername()+"','"+user.getPassword()+"',2,11)";
    int count=stmt.executeUpdate(sql);
    if(count>0){
        out.print("注册成功");
    }else{
        out.print("注册失败");
    }
%>
add.jsp
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.PreparedStatement" %>
<%@ page import="java.sql.SQLException" %>
<jsp:useBean id="user" class="com.user"></jsp:useBean>
<jsp:setProperty name="user" property="*"></jsp:setProperty><%--
  <%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%
    Class.forName("com.mysql.jdbc.Driver");
    String url ="jdbc:mysql://localhost:3306/book";
    Connection connection = DriverManager.getConnection(url,"root","root");
    connection.setAutoCommit(false);
    String sql ="insert into user (username,password,gender,age,id ) values (?,?,?,?,?)";
    PreparedStatement ps =connection.prepareStatement(sql);
    ps.setString(1,user.getUsername());
    ps.setString(2,user.getPassword());
    ps.setInt(3,user.getGender());
    ps.setInt(4,user.getAge());
    ps.setInt(5,0);

    ps.addBatch();
    ps.setString(1,user.getUsername()+"111");
    ps.setString(2,user.getPassword()+"111");
    ps.setInt(3,user.getGender());
    ps.setInt(4,user.getAge());
    ps.setInt(5,0);
    ps.addBatch();
    int[] count ={0};
    try{
        count =ps.executeBatch();
        connection.commit();
    }catch (SQLException e){
        connection.rollback();
        e.printStackTrace(); }
    if(count[0] >0){
        out.print("添加成功");
    }else {
        out.print("添加失败");
    }
    response.setHeader("refresh","3;url=home.jsp");
%>
delete.jsp
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.PreparedStatement" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%
    Class.forName("com.mysql.jdbc.Driver");
    String url ="jdbc:mysql://localhost:3306/book";
    Connection connection = DriverManager.getConnection(url,"root","root");
    String sql ="delete from user where id =?";
    PreparedStatement ps =connection.prepareStatement(sql);
    int id =Integer.parseInt(request.getParameter("id"));
    ps.setInt(1,id);
    int count =ps.executeUpdate();
    if(count>0){
        out.print("删除成功");
    }else{
        out.print("删除失败");
    }
%>
<html>
<head>
    <title>Title</title>
</head>
</html>
edit.jsp
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.PreparedStatement" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="com.user" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>编辑页面</title>
    <link rel="stylesheet" href="css/bookstrap.css">
    <script src="js/jquery.min.js"></script>
    <script src="js/bookstrap.js"></script>
    <script src="js/bookstrap.bundle.js"></script>
    <style>
        .container {
            width: 50%;
            margin-top: 20px;
        }
        </style>
</head>
<body>
<div class="container">
    <div class="row clearfix">
        <div class="col-md-12 column">
    <h3 style="text-align: center">编辑页面</h3>
    <form method="post" action="update.jsp">
 <%
     int id=Integer.parseInt(request.getParameter("id"));
     Class.forName("com.mysql.jdbc.Driver");
     String url="jdbc:mysql://localhost:3306/book";
     Connection connection = DriverManager.getConnection(url,"root","root");
     String sql ="select * from user where id = ?";
     PreparedStatement ps=connection.prepareStatement(sql);
     ps.setInt(1,id);
     ResultSet rs = ps.executeQuery();
     while (rs.next()){
         out.print("<input type='hidden' name='id' value="+rs.getString("id")+">");
         out.print("用户名:<input type='text'class='form-control' name='username' value="+rs.getString("username")+">");
         out.print("密码:<input type='text'class='form-control' name='password' value="+rs.getString("password")+">");

         out.print("性别:<input type='text'class='form-control' name='gender' value="+rs.getString("gender")+">");
         out.print("年龄:<input type='text'class='form-control' name='age' value="+rs.getString("age")+">");
     }
 %>
        <button type="submit" style="width: 100%" class="btn btn-info">提交</button>
    </form>
        </div>
    </div>
</div>
</body>
</html>
update.jsp
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.PreparedStatement" %>
<%@ page import="java.sql.SQLException" %>
<jsp:useBean id="user" class="com.user"></jsp:useBean>
<jsp:setProperty name="user" property="*"></jsp:setProperty><%--
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%
    Class.forName("com.mysql.jdbc.Driver");
    String url ="jdbc:mysql://localhost:3306/book";
    Connection connection = DriverManager.getConnection(url,"root","root");
    String sql ="update user set username =?,password =?,gender =?,age =? where id =?";
    PreparedStatement ps =connection.prepareStatement(sql);
    ps.setString(1,user.getUsername());
    ps.setString(2,user.getPassword());
    ps.setInt(3,user.getGender());
    ps.setInt(4,user.getAge());
    ps.setInt(5,user.getId());
    int count =ps.executeUpdate();
    if (count >0){
        out.print("修改成功");
    }
    else{
        out.print("修改失败");
    }
    response.setHeader("refresh","3;url=home.jsp");
%>

3、利用MVC的设计模式实现用户的管理功能
创建模型
Userbean.java
package com.bean;
public class UserBean {
    private int id;
    private String username;
    private String password;
    private int gender;
    private int age;
    private int status;
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    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;
    }
    public int getGender() {
        return gender;
    }
    public void setGender(int gender) {
        this.gender = gender;
    }
    public int getAge() {
        return age;
    }
    public void setAge(int age) {
        this.age = age;
    }
    public int getStatus() {
        return status;
    }
    public void setStatus(int status) {
        this.status = status;
    }
}
创建控制
loginservlet.Java
package com.servlet;
import com.util.DBUtil;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
@WebServlet(name = "LoginServlet",value = "/login")
public class LoginServlet extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doGet(request,response);
    }
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        System.out.println("servlet 请求");
        request.setCharacterEncoding("utf-8");
        String username = request.getParameter("username");
        String password = request.getParameter("password");
        HttpSession session = request.getSession();
        if("1".equals(request.getParameter("invalidate")) && session.getAttribute("username") != null){
            session.invalidate();
                       response.sendRedirect("login.jsp");
        }
        try {
            Connection connection = DBUtil.getConnection();
            String sql = "select * from user where username = ? and password = ?";
            PreparedStatement ps = connection.prepareStatement(sql);
            ps.setString(1,username);
            ps.setString(2,password);

            ResultSet rs = ps.executeQuery();
            PrintWriter out = response.getWriter();
            if(rs.next()){
                session.setAttribute("username",username);
                response.sendRedirect("home.jsp");
            }else{
                out.print("登录失败,3秒之后跳转登录页面...");
                response.setHeader("refresh","3;url=login.jsp");
            }
            DBUtil.close(connection,ps,rs);
        }catch (Exception e){
            e.printStackTrace();
        }
    }
userservlet.java
package com.servlet;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
@WebServlet("/user")
public class UserServlet extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

    }
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    }
}

工具类
dbutil.java
package com.util;
import java.sql.*;
public class DBUtil {
    public static Connection getConnection(){
        Connection connection = null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
            String url = "jdbc:mysql://localhost:3306/book";
            connection = DriverManager.getConnection(url,"root","root");
        }catch (Exception e){
            e.printStackTrace();
        }
        return connection;
    }
    public static void close(Connection connection, PreparedStatement ps, ResultSet rs){
        if(rs != null){
            try{
                rs.close();
            }catch (SQLException e){
                e.printStackTrace();
            }
        }
        if(ps != null){
            try {
                ps.close();
            }catch (SQLException e){
                e.printStackTrace();
            }
        }
        if(connection != null){
            try {
                connection.close();
            }catch (SQLException e){
                e.printStackTrace();
            }
        }
    }
}
过滤器
charestfilter.java
package com.filter;
import javax.servlet.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
public class CharsetFilter implements Filter {
    public void destroy() {
    }

    public void doFilter(ServletRequest req, ServletResponse resp, FilterChain chain) throws ServletException, IOException {
        HttpServletRequest request = (HttpServletRequest) req;
        HttpServletResponse response = (HttpServletResponse)resp;
        request.setCharacterEncoding("utf-8");
        response.setContentType("text/html;charset=UTF-8");
        chain.doFilter(request, response);
    }
    public void init(FilterConfig config) throws ServletException {
    }

}
loginfilter.java
package com.filter;
import javax.servlet.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.IOException;
public class LoginFilter implements Filter {
    String[] ignores;
    public void doFilter(ServletRequest req, ServletResponse resp, FilterChain chain) throws ServletException, IOException {
        HttpServletRequest request = (HttpServletRequest) req;
        HttpServletResponse response = (HttpServletResponse)resp;
        HttpSession session = request.getSession();
        String uri = request.getRequestURI();
        if(session.getAttribute("username") != null || isIgnore(uri)){
            chain.doFilter(request, response);
        }else{
            response.sendRedirect("login.jsp");
        }
    }
    private boolean isIgnore(String uri){
        for (String str:ignores) {
            if(uri.indexOf(str) != -1){
                return true;
            }
        }
        return false;
    }
    public void init(FilterConfig config) throws ServletException {
        String ignore = config.getInitParameter("ignore");
        ignores = ignore.split(",");
    }
}
监听器
usercountlistener.java
package com.listener;
import javax.servlet.ServletContext;
import javax.servlet.ServletContextEvent;
import javax.servlet.ServletContextListener;
import javax.servlet.annotation.WebListener;
import javax.servlet.http.*;
@WebListener
public class UserCountListener implements ServletContextListener,HttpSessionListener,HttpSessionAttributeListener {
    @Override
    public void sessionCreated(HttpSessionEvent se) {
        ServletContext application = se.getSession().getServletContext();
        int userCount = (int)application.getAttribute("userCount");
        userCount++;
        application.setAttribute("userCount",userCount);
        System.out.println("用户登录,系统当前在线人数:"+userCount);
    }
    @Override
    public void sessionDestroyed(HttpSessionEvent se) {
        ServletContext application = se.getSession().getServletContext();
        int userCount = (int)application.getAttribute("userCount");
        if(userCount != 0){
            userCount--;
        }else{
            userCount = 0;
        }
        application.setAttribute("userCount",userCount);
        System.out.println("用户注销,系统当前在线人数:"+userCount);
    }
    @Override
    public void contextInitialized(ServletContextEvent sce) {
        ServletContext application = sce.getServletContext();
        application.setAttribute("userCount",0);
    }
    @Override
    public void contextDestroyed(ServletContextEvent sce) {

    }
    @Override
    public void attributeAdded(HttpSessionBindingEvent se) {
        System.out.println("session添加属性");
    }
    @Override
    public void attributeRemoved(HttpSessionBindingEvent se) {
    }
    @Override
    public void attributeReplaced(HttpSessionBindingEvent se) {
    }
}

web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
         version="4.0">
    <filter>
    <filter-name>charsetFilter</filter-name>
    <filter-class>filter.CharsetFilter</filter-class>
    </filter>
    <filter-mapping>
        <filter-name>charsetFilter</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>

    <filter>
        <filter-name>loginFilter</filter-name>
        <filter-class>filter.LoginFilter</filter-class>
        <init-param>
        <param-name>ignore</param-name>
        <param-value>/css,/js,/login.jsp,/login</param-value>
        </init-param>
    </filter>
    <filter-mapping>
        <filter-name>loginFilter</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>

</web-app>

结论分析:对于监听器的编写过程中有些代码还是运用的不是特别熟练,总会出现对象联系错误的问题。
改进建议:通过上课老师的大致讲解、以及代码的练习,让问题化简到了最小。

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值