第二次冲刺 09

今日进行了主要内部代码的优化修改。

package com.example.math.repositiory;

import com.example.math.bean.SendBean;
import com.example.math.jdbc.JDBCtools;

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 Send_res {

    //    add
    public static void SendMsg(String mer_phone, String time, String address, String user_phone, String name, int total) throws Exception {
        Connection conn = null;
        PreparedStatement pre = null;
        try {
            conn = JDBCtools.getConnect();
            String sql = "insert into car_send(mer_phone,time,address,user_phone,name,total) values (?,?,?,?,?,?)";
            pre = conn.prepareStatement(sql);
            pre.setString(1, mer_phone);
            pre.setString(2, time);
            pre.setString(3, address);
            pre.setString(4, user_phone);
            pre.setString(5, name);
            pre.setInt(6, total);
            pre.executeUpdate();
        } catch (SQLException e) {
            throw new RuntimeException(e);
        } finally {
            JDBCtools.release(conn, pre, null);
        }
    }

    public static List<String> findAllName() throws Exception {
        List<String> list = new ArrayList<>();
        Connection conn = JDBCtools.getConnect();
        PreparedStatement pre = null;
        ResultSet res = null;
        String sql = "select mer_phone from mer_login";
        try {
            pre = conn.prepareStatement(sql);
            res = pre.executeQuery();
            while (res.next()) {
                String name = res.getString("mer_phone");
                list.add(name);
            }

        } catch (SQLException e) {
            throw new RuntimeException(e);
        } finally {
            JDBCtools.release(conn, pre, res);
        }
        return list;
    }

    //  查询
    public static List<SendBean> find_his(String user_name) throws Exception {
        List<SendBean> list = new ArrayList<>();
        Connection connection = JDBCtools.getConnect();
        PreparedStatement preparedStatement = null;
        ResultSet resultSet = null;
        String sql = "select mer_phone,time,name,total,judge_bu,address from car_send where user_phone = ?";
        try {
            preparedStatement = connection.prepareStatement(sql);
            preparedStatement.setString(1, user_name);
            resultSet = preparedStatement.executeQuery();
            while (resultSet.next()) {
                String merPhone = resultSet.getString("mer_phone");
                String Times = resultSet.getString("time");
                String op_name = resultSet.getString("name");
                int total = resultSet.getInt("total");
                String address_BU  = resultSet.getString("address");
                boolean judgement = resultSet.getBoolean("judge_bu");
                SendBean sendBean = new SendBean(merPhone, Times, user_name, op_name,address_BU,total,judgement);
                list.add(sendBean);
            }
        } catch (SQLException e) {
            throw new RuntimeException(e);
        } finally {
            JDBCtools.release(connection, preparedStatement, resultSet);
        }
        return list;
    }
}

package queren;
import java.io.IOException;
import java.io.PrintWriter;

import jakarta.servlet.ServletException;
import jakarta.servlet.annotation.WebServlet;
import jakarta.servlet.http.HttpServlet;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;
@WebServlet("/Seres")
public class Sere extends HttpServlet{
    Daoq d=new Daoq();
    public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{
        String method=request.getParameter("method");
        switch (method){
        case "qw":
            String id=request.getParameter("id");
            String flag=request.getParameter("flag");
            if(flag.equals("T")) {
                d.Up(id,"F");
            }else if(flag.equals("F")){
                d.Up(id, "T");
            }
            break;
        case "zc":
            String name=request.getParameter("username");
            String password=request.getParameter("password");
            String address=request.getParameter("address");
            System.out.printf(address);
            d.add(name, password, address);
            request.getRequestDispatcher("login.html").forward(request, response);
            break;
        case "queren":
            String username=request.getParameter("username");
            String passwords=request.getParameter("password");
            //response.getWriter().println("<script>alert('此用户您无权限查看')</script>");
            //response.getWriter().println("<script>window.location.href='./index.jsp'</script>");
            if(d.check(username, passwords)) {
                request.setAttribute("test", username);
                request.getRequestDispatcher("lay.jsp").forward(request, response);
            }else {
                response.setContentType("text/html;charset=utf-8");
                PrintWriter out = response.getWriter();
                out.println("<script language=javascript>alert('密码错误');window.location='login.html'</script>");
            }
            
            break;
    }
    }
    @Override
    public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{
        doPost(request,response);
}
}