login.jsp

来自「JSP初学者」· JSP 代码 · 共 34 行

<%@page import="java.util.*" %>
<%@page import="xinwen.*" %>
<%@page import="java.sql.*"%>
<%@page language="java" contentType="text/html; charset=GBK" %>
<%//运行错误
request.setCharacterEncoding("GBK");
String pass=request.getParameter("passWord");
String name=request.getParameter("name");
Connection con=null;
PreparedStatement pStatement=null;
try{
    con=ConnectionManager.getConnection();
    String sql="select * from  User where loginname=? and password=?";
    pStatement=con.prepareStatement(sql);
    pStatement.setString(1, name);
    pStatement.setString(2, pass);
    ResultSet rs=pStatement.executeQuery();
    if(rs.next()){
        User loginedUser= new User(name,pass);
        session.setAttribute("LOGINED_USER",loginedUser );
        response.sendRedirect("createLevelOneTitle.jsp");

        }else{
        response.sendRedirect("login.jsp");
        }

    }catch(Exception r){
        out.println("发生错误！错误原因："+r.getMessage());
        }finally{
            ConnectionManager.closeStatement(pStatement);
            ConnectionManager.closeConnection(con);
            }

%>