chklogin.jsp~5~

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

<%@ page contentType="text/html; charset=GBK" %>
<%@page import="taobaoproject.*" %>
<%
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 = "";
        }
        response.setContentType(CONTENT_TYPE);
        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) {
        }
%>