大二下——课堂测试

 

横跨一个多月后，开始写web系统已经不太熟悉了 ，学过的东西变得很模糊了。

课堂测试代码如下：

package DB;

import entity.Denglu;

import java.sql.*;
import java.util.ArrayList;

public class DButil {
    private String driverStr = "com.mysql.jdbc.Driver";
    private String URL = "jdbc:mysql://localhost:3306/student?useunicuee=true&characterEncoding=UTF-8&serverTimezone=GMT&useSSL=false";
    private String username = "root";
    private String password = "123456";
    private Connection conn = null;
    private Statement stmt = null;
    public DButil() {
        try {
            Class.forName(driverStr);//查找并加载指定的类
            conn = DriverManager.getConnection(URL, username, password);//指定数据库的连接
            stmt = conn.createStatement();//封装 SQL 语句发送给数据库
        } catch (Exception ex) {
            System.out.println("数据库连接失败！");
        }
    }
    /**
     * 关闭数据库
     */
    public void close() {
        try {
            stmt.close();
            conn.close();
        } catch (Exception e) {

        }
    }
    /**
     * 执行更新操作
     * @param s
     * SQL语句
     * @return
     * 更新操作的结果
     */
    public int executeUpdate(String s) {
        int result = 0;
        try {
            result = stmt.executeUpdate(s);
        } catch (Exception ex) {
            System.out.println("更新出现异常！");
        }
        return result;
    }
    /**
     * 执行查询操作
     * @param s
     * SQL语句
     * @return
     * 查询结果
     */
    public ResultSet executeQuery(String s) {
        ResultSet rs = null;
        try {
            rs = stmt.executeQuery(s);
        } catch (Exception ex) {
            System.out.println("查询出现异常！");
        }
        return rs;
    }

    public static void main(String[] args) {
        ArrayList<Denglu> list = new ArrayList<Denglu>();
        String sql = "SELECT * FROM denglu where number=1";
        System.out.println(sql);
        DButil jdbc = new DButil();
        ResultSet rs = jdbc.executeQuery(sql);
        try {
            while (rs.next()) {
                Denglu bi = new Denglu();
                bi.setNumber(rs.getInt("number"));
                bi.setName(rs.getString("name"));
                bi.setPwd(rs.getString("pwd"));
                bi.setPwd2(rs.getString("pwd2"));
                bi.setDanwei(rs.getString("danwei"));
                list.add(bi);
            }
            rs.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        jdbc.close();
        for(Denglu s : list) {
            System.out.println(s.getName());
        }
    }
}

 

 

 

package entity;

import DB.DButil;

import java.io.Serializable;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

/**
 * (Denglu_dao)实体类
 *
 * @author makejava
 * @since 2022-03-04 08:22:31
 */
public class Denglu implements Serializable {
    private static final long serialVersionUID = 146036006916533330L;
    
    private String name;
    
    private String pwd;
    
    private String pwd2;
    
    private Integer number;
    
    private String danwei;


    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getPwd() {
        return pwd;
    }

    public void setPwd(String pwd) {
        this.pwd = pwd;
    }

    public String getPwd2() {
        return pwd2;
    }

    public void setPwd2(String pwd2) {
        this.pwd2 = pwd2;
    }

    public Integer getNumber() {
        return number;
    }

    public void setNumber(Integer number) {
        this.number = number;
    }

    public String getDanwei() {
        return danwei;
    }

    public void setDanwei(String danwei) {
        this.danwei = danwei;
    }


    public static int addorder(Denglu bi) {
        int result = 0;
        System.out.println( bi.getNumber());
        String sql = "insert into denglu values("+bi.getNumber()+",'"+ bi.getName() +"','" + bi.getPwd() + "')";
        System.out.println(sql);
        DButil jdbc = new DButil();
        result = jdbc.executeUpdate(sql);
        jdbc.close();
        return result;
    }

    public static int deleteorder(int number) {
        int result = 0;
        String sql = "delete from denglu where number=" + number;
        System.out.println(sql);
        DButil jdbc = new DButil();
        result = jdbc.executeUpdate(sql);
        jdbc.close();
        return result;
    }

    public static int updateorder(Denglu s) {
        int result = 0;
        String sql = "update denglu set name='"+s.getName()+"',pwd='"+s.getPwd()+"', number='"+s.getNumber()+"'";
        System.out.println(sql);
        DButil jdbc = new DButil();
        result = jdbc.executeUpdate(sql);
        jdbc.close();
        return result;
    }

    public static ArrayList<Denglu> getorder(int number) {
        ArrayList<Denglu> list = new ArrayList<Denglu>();

        String sql = "SELECT * FROM denglu";
        System.out.println(sql);
        DButil jdbc = new DButil();
        ResultSet rs = jdbc.executeQuery(sql);
        try {
            while (rs.next()) {
                Denglu bi = new Denglu();
                bi.setNumber(rs.getInt("number"));
                bi.setName(rs.getString("name"));
                bi.setPwd(rs.getString("pwd"));
                bi.setPwd2(rs.getString("pwd2"));
                bi.setDanwei(rs.getString("danwei"));
                list.add(bi);
            }
            rs.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        jdbc.close();
        for(Denglu room : list) {
            System.out.println(room.getName());
        }
        return list;
    }

    public static void main(String[] args) {

        getorder(1);
    }
}

 

 

 

package servlet;

import entity.Denglu;

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;
import java.util.ArrayList;

public class Servlet_Denglu {

    @WebServlet("*.d")
    public class servlet_g extends HttpServlet {
        @Override
        protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
            request.setCharacterEncoding("utf-8");
            String actionUrl = request.getServletPath();

            if (actionUrl.equals("/zhuce.d")) {
                ArrayList<Denglu> list = Denglu.getorder(1); // 调用Denglu的getorder方法查询，赋值给list
                request.setAttribute("list", list); // 在request增加属性list，其结果为list对象
                request.getRequestDispatcher("denglu_login.html").forward(request, response);//接收数据返回前端初始页面
            }
            else if(actionUrl.equals("/denglu_login.d")){
                ArrayList<Denglu> list = Denglu.getorder(1); // 调用Denglu的getorder方法查询，赋值给list
                request.setAttribute("list", list); // 在request增加属性list，其结果为list对象
                request.getRequestDispatcher("menu_all.html").forward(request, response);//接收数据返回前端初始页面
            }




        }
    }
}

 

 

package servlet;

import entity.Denglu;

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;
import java.util.ArrayList;

@WebServlet("*.l")
public class Servlet_liulanxuqiu extends HttpServlet {
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");
        String actionUrl = request.getServletPath();

        if (actionUrl.equals("/shenhe.l")) {
            ArrayList<Denglu> list = Denglu.getorder(1); // 调用Denglu的getorder方法查询，赋值给list
            request.setAttribute("list", list); // 在request增加属性list，其结果为list对象
            request.getRequestDispatcher("shenhe.html").forward(request, response);//接收数据返回前端初始页面
        }



    }
}

 

 

package servlet;

import entity.Denglu;

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;
import java.util.ArrayList;

    @WebServlet("*.s")
    public class Servlet_shenhe extends HttpServlet {
        @Override
        protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
            request.setCharacterEncoding("utf-8");
            String actionUrl = request.getServletPath();

            if (actionUrl.equals("/shenhe.d")) {
                ArrayList<Denglu> list = Denglu.getorder(1); // 调用Denglu的getorder方法查询，赋值给list
                request.setAttribute("list", list); // 在request增加属性list，其结果为list对象
                request.getRequestDispatcher("menu_all.html").forward(request, response);//接收数据返回前端初始页面
            }



        }
    }

 

 

package servlet;

import entity.Denglu;

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;
import java.util.ArrayList;


@WebServlet("*.x")
public class Servlet_xiugaimima extends HttpServlet {
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");
        String actionUrl = request.getServletPath();

        if (actionUrl.equals("/zhuce.x")) {
            ArrayList<Denglu> list = Denglu.getorder(1); // 调用Denglu的getorder方法查询，赋值给list
            request.setAttribute("list", list); // 在request增加属性list，其结果为list对象
            request.getRequestDispatcher("denglu_login.html").forward(request, response);//接收数据返回前端初始页面
        }



    }
}

 

 

package servlet;

import entity.Denglu;

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;
import java.util.ArrayList;
    @WebServlet("*.z")
    public class Servlet_zhengji extends HttpServlet {
        @Override
        protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
            request.setCharacterEncoding("utf-8");
            String actionUrl = request.getServletPath();

            if (actionUrl.equals("/zhengji.z")) {
                ArrayList<Denglu> list = Denglu.getorder(1); // 调用Denglu的getorder方法查询，赋值给list
                request.setAttribute("list", list); // 在request增加属性list，其结果为list对象
                request.getRequestDispatcher("liulanxuqiu.html").forward(request, response);//接收数据返回前端初始页面
            }



        }
    }