tmp99jq71ngki.htm

用jsp技术开发的网络书店 用户注册登录 浏览购书 购物车 下订单 留言功能

<MM:BeginLock translatorClass="MM_JSPSCRIPT" type="script" depFiles="" orig="%3C%25@ page contentType=%22text/html; charset=GB2312%22 %25%3E" ><MM_JSPSCRIPT><MM:EndLock>
<MM:BeginLock translatorClass="MM_JSPSCRIPT" type="script" depFiles="" orig="%3C%25@ page import=%22java.util.*,java.sql.*%22%25%3E" ><MM_JSPSCRIPT><MM:EndLock>
<MM:BeginLock translatorClass="MM_JSPSCRIPT" type="script" depFiles="" orig="%3C%25
request.setCharacterEncoding(%22GB2312%22);
Class.forName(%22sun.jdbc.odbc.JdbcOdbcDriver%22);
Connection conn = DriverManager.getConnection(%22jdbc:odbc:bookshop%22,%22sa%22,%22%22);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=null; 
%25%3E" ><MM_JSPSCRIPT><MM:EndLock>
<div align="center"> 
<table width="750" border="0" cellspacing="1" cellpadding="1">
  <tr> 
    <td colspan="2"><div align="center"><MM:BeginLock translatorClass="MM_SSI" type="ssi" orig="%3C%25@include file=%22top.jsp%22 %25%3E" fileRef="top.jsp" depFiles="file:///C|/site/多特/bookshop/top.jsp"><table width="749" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td colspan="14"><table width="748" height="43" border="0" cellpadding="0" cellspacing="0">
        <tr> 
          <td width="31%"><img src="images/top_r1.jpg" width="229" height="59"></td>
          <td width="4%"><img src="images/top_r3.jpg" width="30" height="59"></td>
          <td width="4%"><img src="images/top_r4.jpg" width="31" height="59"></td>
          <td width="8%"><img src="images/top_r5.jpg" width="57" height="59"></td>
          <td width="5%"><img src="images/top_r6.jpg" width="40" height="59"></td>
          <td width="6%"><img src="images/top_r7.jpg" width="48" height="59"></td>
          <td width="6%"><img src="images/top_r8.jpg" width="45" height="59"></td>
          <td width="10%"><img src="images/top_r9.jpg" width="73" height="59"></td>
          <td width="10%"><img src="images/top_r10.jpg" width="76" height="59"></td>
          <td width="8%"><img src="images/top_r11.jpg" width="61" height="59"></td>
          <td width="8%"><img src="images/top_r12.jpg" width="60" height="59"></td>
        </tr>
        <tr> 
          <td><img src="images/top_r2.jpg" width="229" height="17"></td>
          <td colspan="10" bgcolor="#f1f1f1">&nbsp;</td>
        </tr>
        <tr bgcolor="#666666"> 
          <td height="1" colspan="11" nowrap></td>
        </tr>
      </table></td>
  </tr>
  <tr> 
    <td width="109" height="25" valign="bottom"><a href="index.jsp"><img src="images/indexbutton.jpg" width="109" height="20" border="0" align="absbottom"></a> 
    </td>
    <td width="11"> <div align="center"></div></td>
    <td width="85" valign="bottom"><a href="excellent.jsp"><img src="images/jingpinbn.jpg" width="85" height="19" border="0"></a></td>
    <td width="11"> <div align="center"></div></td>
    <td width="77" valign="bottom"><a href="newbook.jsp"><img src="images/newbookbn.jpg" width="77" height="19" border="0"></a></td>
    <td width="11"> <div align="center"></div></td>
    <td width="81" valign="bottom"><a href="search.jsp"><img src="images/findbn.jpg" width="81" height="19" border="0"></a></td>
    <td width="11"> <div align="center"></div></td>
    <td width="82" valign="bottom"><a href="myorder.jsp"><img src="images/mybn.jpg" width="82" height="19" border="0"></a></td>
    <td width="11" valign="bottom"> <div align="center"></div></td>
    <td width="52" valign="bottom"><a href="shoppingcart.jsp"><img src="images/buybn.jpg" width="77" height="19" border="0"></a></td>
    <td width="11" valign="bottom"> <div align="center"></div></td>
    <td width="86" valign="bottom"><a href="leaveword.jsp"><img src="images/liuyanbn.jpg" width="87" height="19" border="0"></a></td>
    <td width="172" valign="bottom">&nbsp;</td>
  </tr>
  <tr bgcolor="#676767"> 
    <td height="3" colspan="14"></td>
  </tr>
  <tr bgcolor="#343434"> 
    <td height="3" colspan="14"></td>
  </tr>
  <tr bgcolor="#fc7500"> 
    <td height="14" colspan="14" nowrap>&nbsp;</td>
  </tr>
</table>
<MM:EndLock></div></td>
  </tr>
  <tr> 
    <td width="25%" valign="top"><MM:BeginLock translatorClass="MM_SSI" type="ssi" orig="%3C%25@include file=%22login.jsp%22 %25%3E" fileRef="login.jsp" depFiles="file:///C|/site/多特/bookshop/login.jsp"><SCRIPT LANGUAGE="javascript">
<!--
function CheckSubmit()
 {
  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>
<MM:BeginLock translatorClass="MM_JSPSCRIPT" type="script" depFiles="" orig="%3C%25@ page import=%22java.util.*,java.sql.*%22%25%3E" ><MM_JSPSCRIPT><MM:EndLock>
<MM:BeginLock translatorClass="MM_JSPSCRIPT" type="script" depFiles="" orig="%3C%25
String op = request.getParameter(%22op%22);

if(op!=null&&op.equals(%22login%22)){
String s_userid=request.getParameter(%22userid%22);
String s_password=request.getParameter(%22password%22);


rs=stmt.executeQuery(%22select * from userinfo where userid='%22+s_userid+%22' and password='%22+s_password+%22'%22);
if(rs.next()){
session.setAttribute(%22userid%22,s_userid);
response.sendRedirect(%22index.jsp%22);
}
else
{
//request.setAttribute(%22error%22,%22用户名或密码不正确!%22);
response.sendRedirect(%22error.jsp?error=%22+%22用户名或密码不正确!%22);
}

}

if(op!=null&&op.equals(%22exit%22)){
session.removeAttribute(%22userid%22);
session.removeAttribute(%22cart%22);
response.sendRedirect(%22index.jsp%22);
}

String s_userid=(String)session.getAttribute(%22userid%22);
%25%3E" ><MM_JSPSCRIPT><MM:EndLock>
<MM:BeginLock translatorClass="MM_JSPSCRIPT" type="script" depFiles="" orig="%3C%25
if(s_userid==null){
%25%3E" ><MM_JSPSCRIPT><MM:EndLock>
<table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#f6f6f6">
  <form name="loginform" action="index.jsp?op=login" method="post" >
  <tr> 
    <td colspan="2"><div align="left"><img src="images/login_r1.jpg" width="158" height="43"></div></td>
  </tr>
  <tr> 
    <td>用户名</td>
    <td><input name="userid" type="text" size="12"></td>
  </tr>
  <tr> 
    <td>密码</td>
    <td><input name="password" type="password" size="12"></td>
  </tr>
  <tr> 
    <td colspan="2">
	<input name="loginbutton" type="submit" value=" 登录 " onClick="return CheckSubmit();">
      新用户<a href="register.jsp">注册</a> </td>
  </tr>
  </form>
</table>
<MM:BeginLock translatorClass="MM_JSPSCRIPT" type="script" depFiles="" orig="%3C%25}else{%25%3E" ><MM_JSPSCRIPT><MM:EndLock>
<table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#f6f6f6">
  <tr> 
    <td ><div align="left"><MM:BeginLock translatorClass="MM_JSPSCRIPT" type="script" depFiles="" orig="%3C%25=s_userid%25%3E" ><MM_JSPSCRIPT><MM:EndLock>,您好!<br>欢迎来到网上书城...</div></td>
  </tr>
  <tr> 
      <td>您可以:</td>
  </tr>  
  <tr> 
    <td><a href="#">修改登陆密码</a></td>
  </tr>
  <tr> 
    <td ><a href="#">维护个人信息</a></td>
  </tr>
  <tr> 
    <td ><a href="myorder.jsp">查看历史订单</a></td>
  </tr>  
  <tr> 
    <td ><a href="shoppingcart.jsp">查看购书车</a></td>
  </tr>   
  <tr> 
    <td ><a href="leaveword.jsp">给管理员留言</a></td>
  </tr> 
  <tr> 
    <td ><a href="index.jsp?op=exit">注销退出</a></td>
  </tr>   
</table>
<MM:BeginLock translatorClass="MM_JSPSCRIPT" type="script" depFiles="" orig="%3C%25}%25%3E" ><MM_JSPSCRIPT><MM:EndLock>

<MM:EndLock><br><MM:BeginLock translatorClass="MM_SSI" type="ssi" orig="%3C%25@include file=%22search.jsp%22 %25%3E" fileRef="search.jsp" depFiles="file:///C|/site/多特/bookshop/search.jsp"><MM:BeginLock translatorClass="MM_JSPSCRIPT" type="script" depFiles="" orig="%3C%25
op = request.getParameter(%22op%22);

if(op!=null&&op.equals(%22search%22)){
String s_BookName=request.getParameter(%22bookname%22);
String s_Author=request.getParameter(%22author%22);
String s_Publisher=request.getParameter(%22publisher%22);
String s_where=%22%22;

if(!s_BookName.equals(%22%22))
s_where+=%22 and bookname like'%25%22+s_BookName+%22%25' %22;
if(!s_Author.equals(%22%22))
s_where+=%22 and author like'%25%22+s_Author+%22%25' %22;
if(!s_Publisher.equals(%22%22))
s_where+=%22 and publisherid like'%25%22+s_Publisher+%22%25' %22;

session.setAttribute(%22s_where%22,s_where);
response.sendRedirect(%22booklist.jsp%22);
}
%25%3E" ><MM_JSPSCRIPT><MM:EndLock>


<table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#f6f6f6">
  <form name="searchform" action="index.jsp?op=search" method="post">
  <tr> 
    <td colspan="2"><div align="left"><img src="images/search_r1.jpg" width="158" height="43"></div></td>
  </tr>
  <tr> 
    <td>书名</td>
    <td><input name="bookname" type="text" size="15"></td>
  </tr>
  <tr> 
    <td>作者</td>
    <td><input name="author" type="text" size="15"></td>
  </tr>
  <tr> 
    <td>出版社</td>
    <td><input name="publisher" type="text" size="15"></td>
  </tr>  
  <tr> 
    <td colspan="2">
	<input name="submit" type="submit" value=" 查找 ">
	<a href="booksearch.jsp">高级搜索</a>
	</td>
  </tr>
  </form>
</table><MM:EndLock></td>
    <td width="75%" valign="top">

  <table width="100%" border="0" cellspacing="3" cellpadding="3">
  <tr> 
            <td colspan="2"><div align="left"><img src="images/lanmu_r1.jpg" width="85" height="29"></div></td>
  </tr>
<MM:BeginLock translatorClass="MM_JSPSCRIPT" type="script" depFiles="" orig="%3C%25
int i_num=2;
rs=stmt.executeQuery(%22select * from book where type=2 %22);