login.jsp

网上书店购物系统

<%@ page contentType="text/html; charset=GB2312" %>
<SCRIPT LANGUAGE="javascript">
<!--
function CheckSubmit()
 { //focus()方法，将光标定位于输出栏目
  if( document.loginform.userid.value == "" )
     { alert("请输入用户名!"); document.loginform.userid.focus(); return false; }   
  if( document.loginform.password.value == "" )
     { alert("请输入密码!"); document.loginform.password.focus(); return false; } 	 
  if(document.loginform.userid.value.indexOf("'") != -1)
     { alert("用户名不能包含单引号,空格等字符!"); document.loginform.userid.focus(); return false; }   	 
  return true;                                                                                          
 } 
</SCRIPT>
<%@ page import="java.util.*,java.sql.*"%>
<%
  String op = request.getParameter("op");
  if(op!=null&&op.equals("login")){
    String s_userid=request.getParameter("userid");
    String s_password=request.getParameter("password");
    rs=stmt.executeQuery("select * from userinfo where userid='"+s_userid+"' and password='"+s_password+"'");
    if(rs.next()){
      session.setAttribute("userid",s_userid);
      response.sendRedirect("index.jsp");
    }
    else
    {
      response.sendRedirect("error.jsp?error="+"用户名或密码不正确!");
    }
  }
  if(op!=null&&op.equals("exit")){
    session.removeAttribute("userid");
    session.removeAttribute("cart");
    response.sendRedirect("index.jsp");
  }
  String s_userid=(String)session.getAttribute("userid");
%>
<%
  if(s_userid==null){
%>
<link href="maincss.css" rel="stylesheet" type="text/css">
<table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#f6f6f6" class="td">
  <form name="loginform" action="index.jsp?op=login" method="post" >
    <tr> 
      <td colspan="3"><div align="left"><img src="images/login_r1.jpg" width="158" height="43"></div></td>
    </tr>
    <tr> 
      <td width="8">&nbsp;</td>
      <td width="25%">用户名</td>
      <td width="75%"><input name="userid" type="text" class="formtext" size="12"></td>
    </tr>
    <tr> 
      <td>&nbsp;</td>
      <td>密码</td>
      <td><input name="password" type="password" class="formtext" size="12"></td>
    </tr>
    <tr> 
      <td>&nbsp;</td>
      <td colspan="2"> <input name="loginbutton" type="submit" value=" 登录 " onClick="return CheckSubmit();">
        新用户<a href="register.jsp">注册</a> </td>
    </tr>
  </form>
</table>
<%}else{%>
<table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#f6f6f6" class="td">
  <tr> 
    <td width="8" > <div align="left"></div></td>
    <td width="737" ><%=s_userid%>,您好!<br>
      欢迎来到网上书城...</td>
  </tr>
  <tr> 
    <td>&nbsp;</td>
    <td>您可以:</td>
  </tr>
  <tr> 
    <td>&nbsp;</td>
    <td><a href="passwordedit.jsp">修改登陆密码</a></td>
  </tr>
  <tr> 
    <td >&nbsp;</td>
    <td ><a href="userinfoedit.jsp">维护个人信息</a></td>
  </tr>
  <tr> 
    <td >&nbsp;</td>
    <td ><a href="myorder.jsp">查看历史订单</a></td>
  </tr>
  <tr> 
    <td >&nbsp;</td>
    <td ><a href="shoppingcart.jsp">查看购书车</a></td>
  </tr>
  <tr> 
    <td >&nbsp;</td>
    <td ><a href="leaveword.jsp">给管理员留言</a></td>
  </tr>
  <tr> 
    <td >&nbsp;</td>
    <td ><a href="index.jsp?op=exit">注销退出</a></td>
  </tr>
</table>
<%}%>