实习12

实习12
查询
代码结构

UserDaoimpl

package com.zhongruan.dao.impl;

import com.zhongruan.dao.UserDao;
import com.zhongruan.model.User;
import com.zhongruan.util.UserUtil;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class UserDaoImpl implements UserDao {

    @Override
    public User jd(String zh, String mm) {
        ResultSet resultSet = null;
        PreparedStatement statement = null;
        Connection connection = null;
        User user=null;
        try {
            connection = UserUtil.getConnection();
            String sql = "select * from dr where zh=? and mm=?";
            statement = connection.prepareStatement(sql);
            statement.setString(1,zh);
            statement.setString(2,mm);
            resultSet=statement.executeQuery();
            while (resultSet.next()) {
                user = new User();
                user.setId(resultSet.getInt(1));
                user.setZh(resultSet.getString(2));
                user.setMm(resultSet.getString(3));
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
            UserUtil.closeAll(resultSet, statement, connection);
        }
        return user;
    }
}

UserDao
package com.zhongruan.dao;

import com.zhongruan.model.User;
import com.zhongruan.util.UserUtil;

import java.sql.*;
import java.util.List;

public interface UserDao {
User jd(String zh,String mm);
}
User

package com.zhongruan.model;

public class User {
    private int id;
    private String zh;
    private String mm;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getZh() {
        return zh;
    }

    public void setZh(String zh) {
        this.zh = zh;
    }

    public String getMm() {
        return mm;
    }

    public void setMm(String mm) {
        this.mm = mm;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", zh='" + zh + '\'' +
                ", mm='" + mm + '\'' +
                '}';
    }
}

UserServletimpl

package com.zhongruan.service.impl;

import com.zhongruan.dao.UserDao;
import com.zhongruan.dao.impl.UserDaoImpl;
import com.zhongruan.model.User;
import com.zhongruan.service.UserService;
import com.zhongruan.util.UserUtil;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class UserServiceImpl implements UserService {
    UserDao userDao=new UserDaoImpl();
    @Override
    public Boolean login(String username, String password) {
        User user=userDao.jd(username,password);
        if (user==null){
            return false;
        }else if (user.getMm().equals(password)){
            return true;
        }else {
            return false;
        }
    }
    @Override
    public List<User> findUsers()  {
        ResultSet resultSet = null;
        PreparedStatement statement = null;
        Connection connection = null;
        List<User> users=new ArrayList<>();
        try {
            connection = UserUtil.getConnection();
            String sql = "select * from dr";
            statement = connection.prepareStatement(sql);
            resultSet = statement.executeQuery();
            while (resultSet.next()) {
                User user=new User();
                user.setId(resultSet.getInt(1));
                user.setZh(resultSet.getString(2));
                user.setMm(resultSet.getString(3));
                users.add(user);
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            UserUtil.closeAll(resultSet, statement, connection);
        }
        return users;
    }
    @Override
    public void delete(int id){
        Connection connection = UserUtil.getConnection();
        String sql = "delete from dr where id=?";
        PreparedStatement statement = null;
        try {
            statement = connection.prepareStatement(sql);
            statement.setInt(1,id);
            statement.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
            UserUtil.closeAll(null,statement,connection);
        }
    }
    @Override
    public void zj(String zh,String mm){
        Connection connection = UserUtil.getConnection();
        String sql = "insert into dr(zh,mm) values (?,?)";
        PreparedStatement statement = null;
        try {
            statement = connection.prepareStatement(sql);
            statement.setString(1,zh);
            statement.setString(2,mm);
            statement.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        finally {
            UserUtil.closeAll(null,statement,connection);
        }
    }
    @Override
    public void xg(int id,String zh,String mm) {
        Connection connection = UserUtil.getConnection();
        String sql = "update dr set zh=?,mm=? where id=?";
        PreparedStatement statement = null;
        try {
            statement = connection.prepareStatement(sql);
            statement.setInt(3,id);
            statement.setString(2,mm);
            statement.setString(1,zh);
            statement.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        finally {
            UserUtil.closeAll(null,statement,connection);
        }
    }
    @Override
    public User findUserById(int id){
        User user = null;
        Connection connection = null;
        PreparedStatement statement = null;
        ResultSet resultSet = null;
        try {
            connection = UserUtil.getConnection();
            String sql = "select * from dr where id=?";
            statement = connection.prepareStatement(sql);
            statement.setInt(1, id);
            resultSet = statement.executeQuery();
            while (resultSet.next()) {
                user = new User();
                user.setId(resultSet.getInt(1));
                user.setZh(resultSet.getString(2));
                user.setMm(resultSet.getString(3));
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            UserUtil.closeAll(resultSet, statement, connection);
        }
        return user;
    }
}

UserServlet
package com.zhongruan.service;

import com.zhongruan.dao.UserDao;
import com.zhongruan.dao.impl.UserDaoImpl;
import com.zhongruan.model.User;

import java.sql.SQLException;
import java.util.List;

public interface UserService {
Boolean login(String username, String password);
List findUsers();
User findUserById(int id);
void delete(int id);
void zj(String zh,String mm);
void xg(int id,String zh,String mm);
}
FindServlet

package com.zhongruan.servlet;

import com.zhongruan.model.User;
import com.zhongruan.service.UserService;
import com.zhongruan.service.impl.UserServiceImpl;

import javax.servlet.ServletException;
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.util.List;

public class FindServlet extends HttpServlet {
    UserService userService=new UserServiceImpl();
    @Override
    protected void doPost(HttpServletRequest requst, HttpServletResponse respost) throws ServletException, IOException {
        List<User> users=userService.findUsers();
        HttpSession session=requst.getSession();
        session.setAttribute("userlist",users);
        requst.getRequestDispatcher("allUser.jsp").forward(requst,respost);
    }
    @Override
    protected void doGet(HttpServletRequest requst, HttpServletResponse respost) throws ServletException, IOException {
        List<User> users=userService.findUsers();
        HttpSession session=requst.getSession();
        session.setAttribute("userlist",users);
        requst.getRequestDispatcher("allUser.jsp").forward(requst,respost);
    }
}

UserUtil

package com.zhongruan.util;

import java.sql.*;

public class UserUtil {
    public static Connection getConnection(){
        try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        Connection connection= null;
        try {
            connection = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/zjgm?characterEncoding=utf-8&user=root&password=123456");
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return connection;
    }
    public static void closeAll(ResultSet resultSet, Statement statement, Connection connection){
        if (resultSet!=null){
            try {
                resultSet.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        if (connection!=null){
            try {
                connection.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        if (statement!=null){
            try {
                statement.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}

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">
    <servlet>
        <servlet-name>LoginServlet</servlet-name>
        <servlet-class>com.zhongruan.servlet.LoginServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>LoginServlet</servlet-name>
        <url-pattern>/login</url-pattern>
    </servlet-mapping>
    <servlet>
        <servlet-name>DeleteServlet</servlet-name>
        <servlet-class>com.zhongruan.servlet.DeleteServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>DeleteServlet</servlet-name>
        <url-pattern>/delete</url-pattern>
    </servlet-mapping>
    <servlet>
        <servlet-name>FindServlet</servlet-name>
        <servlet-class>com.zhongruan.servlet.FindServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>FindServlet</servlet-name>
        <url-pattern>/find</url-pattern>
    </servlet-mapping>
    <servlet>
        <servlet-name>AddServlet</servlet-name>
        <servlet-class>com.zhongruan.servlet.AddServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>AddServlet</servlet-name>
        <url-pattern>/add</url-pattern>
    </servlet-mapping>
    <servlet>
        <servlet-name>UpServlet</servlet-name>
        <servlet-class>com.zhongruan.servlet.UpServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>UpServlet</servlet-name>
        <url-pattern>/up</url-pattern>
    </servlet-mapping>
    <servlet>
        <servlet-name>ToUpServlet</servlet-name>
        <servlet-class>com.zhongruan.servlet.ToUpServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>ToUpServlet</servlet-name>
        <url-pattern>/toup</url-pattern>
    </servlet-mapping>
</web-app>

fail.jsp

<%--
  Created by IntelliJ IDEA.
  User: 翁海啵
  Date: 2019/9/25
  Time: 11:09
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
登入失败!
</body>
</html>

index.jsp

<%--
  Created by IntelliJ IDEA.
  User: 翁海啵
  Date: 2019/9/25
  Time: 17:07
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!DOCTYPE html>
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <meta http-equiv="Pragma" content="no-cache">
    <meta http-equiv="Cache-Control" content="no-cache">
    <meta http-equiv="Expires" content="0">
    <title>后台管理</title>
    <link href="login.css" rel="stylesheet" type="text/css" />
</head>

<body>
<div class="login_box">
    <div class="login_l_img"><img src="images/login-img.png" /></div>
    <div class="login">
        <div class="login_logo"><a href="#"><img src="images/login_logo.png" /></a></div>
        <div class="login_name">
            <p>后台管理系统</p>
        </div>
        <form method="post" action="/login">
            <input name="username" type="text"  value="用户名" onfocus="this.value=''" onblur="if(this.value==''){this.value='用户名'}">
            <span id="password_text" onclick="this.style.display='none';document.getElementById('password').style.display='block';document.getElementById('password').focus().select();" >密码</span>
            <input name="password" type="password" id="password" style="display:none;" onblur="if(this.value==''){document.getElementById('password_text').style.display='block';this.style.display='none'};"/>
            <input value="登录" style="width:100%;" type="submit">
        </form>
    </div>
    <
</div>
</body>
</html>