chklogin.jsp~8~

来自「模仿Taobao购物网」· JSP~8~ 代码 · 共 34 行

<%@page import="taobaoproject.*" %>
<%@page import="java.sql.*" %>
<%
java.sql.PreparedStatement past;
java.sql.ResultSet rst;
        String userid = request.getParameter("userid");
        if (userid == null) {
            userid = "";
        }
        String password = request.getParameter("password");
        if (password == null) {
            password = "";
        }
        DB_Bean dbBean = new DB_Bean();
        java.sql.Connection conn = dbBean.getConn();
        try {
            past = conn.prepareStatement("select * from tb_Member where Name = ? and Psaaword = ?");
            past.setString(1,userid);
            past.setString(2,password);
            rst = past.executeQuery();
            if(!rst.next()) {
                String errmsg = "error1";
                response.sendRedirect("login.jsp?errmsg=" + errmsg);
                return;
            }
            request.getSession(true);
            String chk = "true";
            session.putValue("errmsg",chk);
            session.putValue("username",rst.getString("Name"));
            response.sendRedirect("index.jsp");
        } catch (SQLException ex) {
        }
%>