?? tmp99jq71ngki.htm
字號:
<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"> </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"> </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> </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);
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -