2024/4/9

<%@ page import="java.sql.*" %>
<%@ page import="java.io.PrintWriter" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%
String jobid = request.getParameter("username");
String password = request.getParameter("password");

try {
Class.forName("com.mysql.cj.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/fish", "root", "password");
Statement stmt = conn.createStatement();
String sql = "SELECT * FROM message1 WHERE jobid='" + jobid + "' AND password='" + password + "'";
ResultSet rs = stmt.executeQuery(sql);
if (rs.next()) {
session.setAttribute("username", jobid);
response.sendRedirect("changePassword.jsp");
} else {
out.println("Invalid username or password");
}
} catch (Exception e) {
out.println("有错误 " + e.getMessage());
}
%>