2024.3.14

第八天

所花时间：2小时

代码量：200+

博客量：1

了解到的知识点：

package db;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import bean.Tiaoji;

public class ShenqingDao {
    public int adduser(Tiaoji bean) {
        int i = 0;
        Connection con = null;
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        try {
            con = DB.getConn();
            String sql = "insert into tb_user.tiaoji(name, id, zhuanye, zongfen, sizheng, yingyu, shuxue, zonghe, jieguo) values(?,?,?,?,?,?,?,?,?)";
            pstmt = con.prepareStatement(sql);
            pstmt.setString(1, bean.getName());
            pstmt.setString(2, bean.getId());
            pstmt.setString(3, bean.getZhuanye());
            pstmt.setString(4, bean.getZongfen());
            pstmt.setString(5, bean.getSizhang());
            pstmt.setString(6, bean.getYingyu());
            pstmt.setString(7, bean.getShuxue());
            pstmt.setString(8, bean.getZonghe());
            pstmt.setString(9, bean.getJieguo());
            i = pstmt.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DB.close(rs, pstmt, con);
        }
        return i;
    }

    public ArrayList<Tiaoji> getall() {
        ArrayList<Tiaoji> list = new ArrayList<>();
        Connection con = null;
        Statement state = null;
        ResultSet rs = null;
        try {
            con = DB.getConn();
            String sql = "select * from tb_user.tiaoji";
            state = con.createStatement();
            rs = state.executeQuery(sql);
            while (rs.next()) {
                Tiaoji bean = new Tiaoji();
                bean.setName(rs.getString("name"));
                bean.setId(rs.getString("id"));
                bean.setZhuanye(rs.getString("zhuanye"));
                bean.setZongfen(rs.getString("zongfen"));
                bean.setSizhang(rs.getString("sizheng"));
                bean.setYingyu(rs.getString("yingyu"));
                bean.setShuxue(rs.getString("shuxue"));
                bean.setZonghe(rs.getString("zonghe"));
                bean.setJieguo(rs.getString("jieguo"));
                list.add(bean);
            }

        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        DB.close(rs, state, con);
        return list;
    }

    public Tiaoji SearchByName(String id) {
        // TODO Auto-generated method stub
        Connection con = null;
        Statement state = null;
        ResultSet rs = null;
        Tiaoji bean = new Tiaoji();
        try {
            con = DB.getConn();
            String sql = "select * from tb_user.tiaoji where id='" + id + "'";
            state = con.createStatement();
            rs = state.executeQuery(sql);
            while (rs.next()) {
                bean.setName(rs.getString("name"));
                bean.setId(rs.getString("id"));
                bean.setZhuanye(rs.getString("zhuanye"));
                bean.setZongfen(rs.getString("zongfen"));
                bean.setSizhang(rs.getString("sizheng"));
                bean.setYingyu(rs.getString("yingyu"));
                bean.setShuxue(rs.getString("shuxue"));
                bean.setZonghe(rs.getString("zonghe"));
                bean.setJieguo(rs.getString("jieguo"));
            }

        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        DB.close(rs, state, con);
        return bean;
    }

    public int update(Tiaoji bean) {
        // TODO Auto-generated method stub
        int i = 0;
        Connection con = null;
        ResultSet rs = null;
        PreparedStatement pstmt = null;
        try {
            con = DB.getConn();
            String sql = "update tb_user.tiaoji set name=?,id=?,zhuanye=?,zongfen=?,sizheng=? ,yingyu=? ,shuxue=? ,zonghe=?where id=?";
            pstmt = con.prepareStatement(sql);
            bean.setName(rs.getString("name"));
            bean.setId(rs.getString("id"));
            bean.setZhuanye(rs.getString("zhuanye"));
            bean.setZongfen(rs.getString("zongfen"));
            bean.setSizhang(rs.getString("sizheng"));
            bean.setYingyu(rs.getString("yingyu"));
            bean.setShuxue(rs.getString("shuxue"));
            bean.setZonghe(rs.getString("zonghe"));
            bean.setJieguo(rs.getString("jieguo"));
            i = pstmt.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DB.close(rs, pstmt, con);
        }
        return i;
    }

    public int del(String id) {
        Connection con = null;
        ResultSet rs = null;
        PreparedStatement pstmt = null;
        int i = 0;
        try {
            con = DB.getConn();
            String sql = "delete from tb_user.tiaoji where id='" + id + "'";
            pstmt = con.prepareStatement(sql);
            i = pstmt.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DB.close(rs, pstmt, con);
        }
        return i;
    }

    public ArrayList<Tiaoji> select(String content, String way) {
        ArrayList<Tiaoji> list = new ArrayList<>();
        Connection con = null;
        Statement state = null;
        ResultSet rs = null;
        String sql = "select * from tb_user.tiaoji";
        if (content != "" && "1".equals(way)) {
            sql += " where name='" + content + "'";
        } else if (content != "" && "2".equals(way)) {
            sql += " where id like'%" + content + "%'";
        } else if (content != "" && "3".equals(way)) {
            sql += " where zongfen='" + content + "'";
        } else {
            sql = "select * from tb_user.tiaoji";
        }
        try {
            con = DB.getConn();
            state = con.createStatement();
            rs = state.executeQuery(sql);
            while (rs.next()) {
                Tiaoji bean = new Tiaoji();
                bean.setName(rs.getString("name"));
                bean.setId(rs.getString("id"));
                bean.setZhuanye(rs.getString("zhuanye"));
                bean.setZongfen(rs.getString("zongfen"));
                bean.setSizhang(rs.getString("sizheng"));
                bean.setYingyu(rs.getString("yingyu"));
                bean.setShuxue(rs.getString("shuxue"));
                bean.setZonghe(rs.getString("zonghe"));
                bean.setJieguo(rs.getString("jieguo"));
                list.add(bean);
            }

        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        DB.close(rs, state, con);
        return list;
    }
}

package servlet;

import bean.Tiaoji;
import db.ShenqingDao;
import jakarta.servlet.annotation.WebServlet;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.IOException;
@WebServlet("/AddTiaojiServlet")
public class AddTiaojiServlet extends HttpServlet {
    ShenqingDao dao=new ShenqingDao();

    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");
        String name = request.getParameter("name");
        String id = request.getParameter("id");
        String zhuanye = request.getParameter("zhuanye");
        String zongfen = request.getParameter("zongfen");
        String sizheng = request.getParameter("sizheng");
        String yingyu = request.getParameter("yingyu");
        String shuxue = request.getParameter("shuxue");
        String zonghe = request.getParameter("zonghe");
        Tiaoji bean = new Tiaoji();
        bean.setName(name);
        bean.setId(id);
        bean.setZhuanye(zhuanye);
        bean.setZongfen(zongfen);
        bean.setSizhang(sizheng);
        bean.setYingyu(yingyu);
        bean.setShuxue(shuxue);
        bean.setZonghe(name);
        int result = dao.adduser(bean);
        if (result == 1) {
            request.setAttribute("message", "添加成功");
            request.getRequestDispatcher("xuesheng.jsp").forward(request, response);
        } else {
            request.setAttribute("message", "添加失败");
            request.getRequestDispatcher("addshenqing.jsp").forward(request, response);
        }
    }

    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        this.doGet(request, response);
    }
}