购物车4次改进，数据库存储

来源：互联网发布：移动关闭数据上网功能编辑：程序博客网时间：2024/05/29 13:56

MYSQL数据库

test

User Name char 10 P

Password char 10

-===============================logcheck.jsp========================

<%--
    Document   : Check
    Created on : 2009-12-6, 15:27:54
    Author     : Administrator
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">

<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <%@page import="java.util.*"%>
        <%@page import="java.io.*"%>
        <title>登陆</title>
    </head>
    <body>
        <%
           java.sql.Connection conn=null;
           java.lang.String strConn;
           java.sql.PreparedStatement preparedStmt=null;

java.sql.ResultSet sqlRst=null;

           try{
           Class.forName("org.gjt.mm.mysql.Driver").newInstance();
           conn=java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","lilin");
           preparedStmt=conn.prepareStatement("select Name,Password from User where Name like?");

String Name=request.getParameter("userID");
String Pass=request.getParameter("password");

                    preparedStmt.setString(1,"%"+Name+"%");

                    sqlRst=preparedStmt.executeQuery();

                    while(sqlRst.next()){
                        String Name1=new String(sqlRst.getString("Name").getBytes("iso-8859-1"));
                           if(Name1.equals(Name)){
                                    if(Pass.equals(sqlRst.getString("Password"))){

                                       %>
                                        <jsp:forward page="Catalog.jsp"></jsp:forward>
                                       <%
                                    }
                           }
                    }

                                          %>
                                           <jsp:forward page="Register.html"></jsp:forward>
                                          <%

                 }catch(java.sql.SQLException e){
                        out.println(e.toString());
                 }finally{if(sqlRst!=null)try{sqlRst.close();}catch(java.sql.SQLException e1){
                                    out.println(e1.toString());
                            }finally{
                                    try{
                                            if(preparedStmt!=null)preparedStmt.close();
                                           }catch(java.sql.SQLException e2){
                                                   out.println(e2.toString());
                                           }finally{
                                                       try{
                                                            if(conn!=null)conn.close();
                                                        }catch (java.sql.SQLException e3){

out.println(e3.toString());

}

                                               }
                                        }

密码错误

<a href="http://localhost:8080/20077610418_2/jsp/dl.html">回到登陆界面

%>
</body>
</html>

===================================getzhuce.jsp==============================

<%--
    Document   : Register
    Created on : 2009-12-6, 15:29:24
    Author     : Administrator
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page import="java.util.*" %>
<%@page import="java.io.*" %>
<%@page import="java.lang.*" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">

        <title>注册</title>
    </head>
    <body>
      <%

        String   Name=request.getParameter("userID");
        String   Pass=request.getParameter("password");

           java.sql.Connection conn=null;
           java.lang.String strConn;
           java.sql.PreparedStatement preparedStmt=null;

java.sql.ResultSet sqlRst=null;

                    preparedStmt.setString(1,Name);
                    preparedStmt.setString(2,Pass);

preparedStmt.executeUpdate();

out.println(e3.toString());

}

}
}

                      %>
        <%=Name%>

注册成功

<a href="dl.html">返回登陆界面

</body>
</html>