JDBC连接数据库与前端页面交互

@WebServlet("/gitHub")

public class LoginServlet extends HttpServlet {
    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        // 1. 获取HTML表单中的用户输入的用户名和密码
        String inputUserword = req.getParameter("username");
        String inputPassword = req.getParameter("password");
        // 2. 连接数据库，查询用户信息
        ResultSet resultSet = null;
        Statement statement = null;
        String dbpassword = "";
        try {
            Class.forName("oracle.jdbc.OracleDriver");
            Connection connection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","fafa","9824");
            statement = connection.createStatement();
            String str = "SELECT * FROM \"t_account\" WHERE \"username\" = '%s'";
            String sql = String.format(str, inputUserword);
            System.out.println("----->sql:" + sql);
            resultSet = statement.executeQuery(sql);
            if (resultSet.next()){
                dbpassword = resultSet.getString("password");
            }
        }catch (Exception e){
            e.printStackTrace();

        }finally {
            if (resultSet != null) {
                try {
                    resultSet.close();
                } catch (Exception throwables) {
                    throwables.printStackTrace();
                }
            }

            if (statement != null){
                try {
                    statement.close();
                } catch (Exception throwables) {
                    throwables.printStackTrace();
                }
            }


        }
        // 3. 比较用户名和密码，
        if (inputPassword.equals(dbpassword)){//登陆成功
            // 请求转发 ，将用户请求转发到main.html
            req.getRequestDispatcher("main.html").forward(req,resp);
        }else {//登陆失败
            // 重定向， 将用户的请求重新定向到登录页面
            resp.sendRedirect("gitHub.html?gitHub=fail");
        }



    }
}