??
字號:
第8章 網(wǎng)上書店
head.txt：
<table align="center" border="0" width="740" height="18" bgcolor=yellow cellspacing="1">
<tr>
<td width="100%">
<a href="<%=response.encodeURL("http://192.168.1.100:8080/showBookList.jsp")%>">書目瀏覽</a> |
<a href="<%=response.encodeURL("http://192.168.1.100:8080/userRegister.jsp")%>">用戶注冊</a> |
<a href="<%=response.encodeURL("http://192.168.1.100:8080/userLogin.jsp")%>">用戶登錄 </a> |
<a href="<%=response.encodeURL("http://192.168.1.100:8080/buybook.jsp")%>">訂購圖書 </a> |
<a href="<%=response.encodeURL("http://192.168.1.100:8080/modifyForm.jsp")%>">修改訂單 </a> |
<a href="<%=response.encodeURL("http://192.168.1.100:8080/showOrderForm.jsp")%>">查看訂單</a>|
<a href="<%=response.encodeURL("http://192.168.1.100:8080/modifyPassword.jsp")%>">修改密碼 </a> |
<a href="<%=response.encodeURL("http://192.168.1.100:8080/modifyMessage.jsp")%>">修改個人信息</a> |</td>
</tr>
</table>
主頁（效果如圖8.5所示）
bookmain.jsp:
<%@ page contentType="text/html;charset=GB2312" %>
<HTML>
<BODY bgcolor =green>
<%@ include file="head.txt" %>
<H1>
<CENTER> 歡迎光臨網(wǎng)上書店</CENTER>
</BODY>
</HTML>
注冊頁面使用的beans
Register.java：
import java.sql.*;
public class Register
{ String logname,
realname,
password,
email,
phone,
address;
String message;
Connection con;
Statement sql;
ResultSet rs;
public Register()
{ //加載橋接器：
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}
}
//設(shè)置屬性值、獲取屬性值的方法：
public void setLogname(String name)
{ logname=name;
}
public String getLogname()
{return logname;
}
public void setRealname(String name)
{ realname=name;
}
public String getRealname()
{return realname;
}
public void setPassword(String pw)
{ password=pw;
}
public String getPassword()
{return password;
}
public void setEmail(String em)
{ email=em;
}
public String getEmail()
{return email;
}
public void setPhone(String ph)
{ phone=ph;
}
public String getPhone()
{return phone;
}
public void setAddress(String ad)
{ address=ad;
}
public String getAddress()
{return address;
}
public String getMessage()
{return message;
}
//添加記錄到數(shù)據(jù)庫的user表：
public void addItem()
{try{
con=DriverManager.getConnection("jdbc:odbc:shop","","");
sql=con.createStatement();
String s=
"'"+logname+"'"+","+"'"+realname+"'"+","+"'"+password+"'"+","+"'"+
email+"'"+","+"'"+phone+"'"+","+"'"+address+"'";
String condition="INSERT INTO user VALUES"+"("+s+")";
sql.executeUpdate(condition);
message="注冊成功了";
con.close();
}
catch(SQLException e)
{message="你還沒有注冊，或該用戶已經(jīng)存在，請你更換一個名字";
}
}
}
注冊頁面（效果如圖8.6所示）
userRegister.jsp：
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="Register" %>
<%! //處理字符串的方法：
public String codeString(String s)
{ String str=s;
try{byte b[]=str.getBytes("ISO-8859-1");
str=new String(b);
return str;
}
catch(Exception e)
{ return str;
}
}
%>
<HTML>
<BODY ><Font size=1>
<%@ include file="head.txt" %>
<Font size=1>
<%String str=response.encodeURL("userRegister.jsp");
%>
<P>輸入您的信息，帶*號項必須填寫：
<FORM action="<%=str%>" Method="post">
<BR>登錄名稱<Input type=text name="logname">*
<BR>真實姓名<Input type=text name="realname">*
<BR>設(shè)置密碼<Input type=password name="password">*
<BR>電子郵件<Input type=text name="email">*
<BR>聯(lián)系電話<Input type=text name="phone">*
<BR>通信地址<Input type=text name="address">*
<BR><Input type=submit name="g" value="提交">
</Form>
<jsp:useBean id="login" class="Register" scope="request" >
</jsp:useBean>
<% //提交信息后，進行注冊操作：
String logname="",realname="",password="",email="",phone="",address="";
if(!(session.isNew()))
{ logname=request.getParameter("logname");
if(logname==null)
{logname="";
}
logname=codeString(logname);
realname=request.getParameter("realname");
if(realname==null)
{realname="";
}
realname=codeString(realname);
password=request.getParameter("password");
if(password==null)
{password="";
}
password=codeString(password);
email=request.getParameter("email");
if(email==null)
{email="";
}
email=codeString(email);
phone=request.getParameter("phone");
if(phone==null)
{phone="";
}
phone=codeString(phone);
address=request.getParameter("address");
if(address==null)
{address="";
}
address=codeString(address);
}
%>
<% //為了以后處理漢字方便，我們采用了第1種方式初始化beans
if(!(logname.equals(""))&&!(address.equals(""))&&!(phone.equals(""))
&&!(realname.equals(""))&&!(password.equals("")))
{%>
<jsp:setProperty name= "login" property="logname" value="<%=logname%>" />
<jsp:setProperty name= "login" property="realname" value="<%=realname%>" />
<jsp:setProperty name= "login" property="password" value="<%=password%>" />
<jsp:setProperty name= "login" property="email" value="<%=email%>" />
<jsp:setProperty name= "login" property="phone" value="<%=phone%>" />
<jsp:setProperty name= "login" property="address" value="<%=address%>" />
<%
login.addItem();
}
else
{out.print("你還沒有填寫信息，或信息填寫不完整");
}
%>
<% //返回注冊信息
if(!(session.isNew()))
{
%>
<jsp:getProperty name= "login" property="message" />
<%
}
%>
</Body>
</HTML>
登錄頁面使用的beans
Login.java：
import java.sql.*;
public class Login
{ String logname,
realname,
password,
phone,
address;
String success="false",message="";
Connection con;
Statement sql;
ResultSet rs;
public Login()
{ //加載橋接器：
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}
}
//設(shè)置屬性值、獲取屬性值的方法：
public void setLogname(String name)
{ logname=name;
}
public String getLogname()
{return logname;
}
public void setPassword(String pw)
{ password=pw;
}
public String getPassword()
{return password;
}
public void setRealname(String name)
{ realname=name;
}
public String getRealname()
{return realname;
}
public void setPhone(String ph)
{ phone=ph;
}
public String getPhone()
{return phone;
}
public void setAddress(String ad)
{ address=ad;
}
public String getAddress()
{return address;
}
public String getSuccess()
{return success;
}
//查詢數(shù)據(jù)庫的user表：
public String getMessage()
{try{
con=DriverManager.getConnection("jdbc:odbc:shop","","");
sql=con.createStatement();
String condition=
"SELECT * FROM user WHERE logname = "+"'"+logname+"'";
rs=sql.executeQuery(condition);
int rowcount=0;
String ps=null;
while(rs.next())
{ rowcount++;
logname=rs.getString("logname");
realname=rs.getString("realname");
ps=rs.getString("password");
phone=rs.getString("phone");
address=rs.getString("address");
}
if((rowcount==1)&&(password.equals(ps)))
{ message="ok";
success="ok";
}
else
{message="輸入的用戶名或密碼不正確";
success="false";
}
con.close();
return message;
}
catch(SQLException e)
{ message="輸入的用戶名或密碼不正確";
success="false";
return message;
}
}
}
登錄頁面（效果如圖8.7所示）
userLogin.jsp：
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="Login" %>
<%! //處理字符串的方法：
public String codeString(String s)
{ String str=s;
try{byte b[]=str.getBytes("ISO-8859-1");
str=new String(b);
return str;
}
catch(Exception e)
{ return str;
}
}
%>
<HTML>
<BODY ><Font size=1>
<%@ include file="head.txt" %>
<Font size=1>
<%String string=response.encodeURL("userLogin.jsp");
%>
<P>輸入用戶名和密碼：
<FORM action="<%=string%>" Method="post">
<BR>登錄名稱<Input type=text name="logname">
<BR>輸入密碼<Input type=password name="password">
<BR><Input type=submit name="g" value="提交">
</Form>
<jsp:useBean id="login" class="Login" scope="session" >
</jsp:useBean>
<% //提交信息后，驗證信息是否正確：
String message="",
logname="",
password="";
if(!(session.isNew()))
{logname=request.getParameter("logname");
if(logname==null)
{logname="";
}
logname=codeString(logname);
password=request.getParameter("password");
if(password==null)
{password="";
}
password=codeString(password);
}
%>
<%
if(!(logname.equals("")))
{
%>
<jsp:setProperty name= "login" property="logname" value="<%=logname%>" />
<jsp:setProperty name= "login" property="password" value="<%=password%>" />
<%
message=login.getMessage();
if(message==null)
{message="";
}
}
%>
<% if(!(session.isNew()))
{ if(message.equals("ok"))
{ String str=response.encodeURL("buybook.jsp");
response.sendRedirect(str);
}
else
{out.print(message);
}
}
%>
</Body>
</HTML>
訂購頁面使用的beans (該beans負責查閱用戶準備訂購的圖書)
BuyBook.java：
import java.sql.*;
public class BuyBook
{ long id=0;
String order_number,
book_name;
Connection con;
Statement sql;
ResultSet rs;
public BuyBook()
{ //加載橋接器：
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}
}
//設(shè)置屬性值、獲取屬性值的方法：
public void setId(long n)
{id=n;
}
public long getId()
{return id;
}
public void setBook_name(String name)
{ book_name=name;
}
public String getBook_name()
{return book_name;
}
public void setOrder_number(String number)
{ order_number=number;
}
public String getOrder_number()
{return order_number;
}
//通過書的id號查詢數(shù)據(jù)庫的book表：
public StringBuffer getMessageBybook_id()
{
StringBuffer buffer=new StringBuffer();
try{
con=DriverManager.getConnection("jdbc:odbc:shop","","");
sql=con.createStatement();
String condition="SELECT * FROM book WHERE id = "+id;
rs=sql.executeQuery(condition);
buffer.append("<Table Border><FONT size=1> ");
buffer.append("<TR>");
buffer.append("<TH width=50>"+"<Font size=1>"+"id"+"</FONT>");
buffer.append("<TH width=50>"+"<Font size=1>"+"訂購號"+"</FONT>");
buffer.append("<TH width=70>"+"<Font size=1>"+"書名"+"</FONT>");
buffer.append("<TH width=60>"+"<Font size=1>"+"作者"+"</FONT>");
buffer.append("<TH width=60>"+"<Font size=1>"+"出版社"+"</FONT>");
buffer.append("<TH width=50>"+"<Font size=1>"+"出版時間"+"</FONT>");
buffer.append("<TH width=20>"+"<Font size=1>"+"價錢"+"</FONT>");
buffer.append("<TH width=50>"+"<Font size=1>"+"分類"+"</FONT>");
buffer.append("</TR>");
while(rs.next())
{ order_number=rs.getString(2);
book_name=rs.getString(3);
String 作者=rs.getString(4);
String 出版社=rs.getString(5);
Date 時間=rs.getDate(6);
String 價格=rs.getString("price");
String 分類=rs.getString("category");
buffer.append("<TR>");
buffer.append("<TD >"+"<Font size=1>"+rs.getLong(1)+"</FONT>");
buffer.append("<TD >"+"<Font size=1>"+order_number+"</FONT>");
buffer.append("<TD >"+"<Font size=1>"+book_name+"</FONT>");
buffer.append("<TD >"+"<Font size=1>"+作者+"</FONT>");
buffer.append("<TD >"+"<Font size=1>"+出版社+"</FONT>");
buffer.append("<TD >"+"<Font size=1>"+時間+"</FONT>");
buffer.append("<TD >"+"<Font size=1>"+價格+"</FONT>");
buffer.append("<TD >"+"<Font size=1>"+分類+"</FONT>");
buffer.append("</TR>");
}
buffer.append("</TABLE>");
buffer.append("</FONT>");
con.close();
return buffer;
}
catch(SQLException e)
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -