您的当前位置：首页正文

清华版郭克华JavaWeb程序设计上机习题答案

来源：画鸵萌宠网
 Chapter2

Frame、

作者的个人简介 Login、

Please Log In


   Login:
Password:

         

Main、 (Section C) Regiter、

New Member


ID              

Password        
Re-Password     
First Name      

Last Name       

Address         
City            

State          

Country         

Email Address   
Select Interest

Technology Enterprise Research Government People Life Style Opinion

Question       

Answer          

                

Top、

Login
Register

Treemenu、

作者的个人简介

作者的个人简介、 作者：

局局局

Chapter3

1、

您输入的金额为： 

                 
找零的数量为：

             50元张

             20元张

             10元张

              5元张

              1元张

2、

book1: 
book2: 
book3: 
book4: 
book5: 

       

总价:  

2S（循环）、

       

总价:  

3、

4、

book 1:   
book 2:   
book 3:   
book 4:   
book 5:   
book 6:   
book 7:   

book 8:   
book 9:   
book10 :  

         

最高价格:
最低价格:
平均价格:

4S（循环）、

         

最高价格:
最低价格:
平均价格:

Chapter4

4-1、

(1)<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%>

<%

for(int i=1;i<=100;i++){ out.print(\"欢迎(JSP)
\"); } %>

(2)<%@ page language=\"java\" contentType=\"text/html; charset=gb2312\" errorPage=\"l6.jsp\"%> <%

for(int i=0;i<100;i++){ out.println(\"欢迎
\"); } %>

(3)<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%>

4-2

(1)<%@page language=\"java\" contentType=\"text/html;charset=gb2312\" errorPage=\"l6.jsp\"%>

您输入的金额为：

<%!

int[]monReturn=new int[5];

int[]monElements=new int[]{50,20,10,5,1}; void moneyDeal(int mon){ for(int i=0;i<5;i++){

monReturn[i]=(int)Math.floor(mon/monElements[i]); mon=mon%monElements[i]; } } %>

<%String s=request.getParameter(\"money\"); if(s!=null){

int mon=Integer.parseInt(s); moneyDeal(mon); for(int i=0;i<5;i++){ %>

应找零为：<%=monElements[i]%>元<%=monReturn[i]%>张
<% } } %>

(2)<%@page language=\"java\" contentType=\"text/html;charset=gb2312\" errorPage=\"l6.jsp\"%> <%!

String str;

int[]monReturn=new int[5];

int[]monElements=new int[]{50,20,10,5,1}; void moneyDeal(int mon){ for(int i=0;i<5;i++){

monReturn[i]=(int)Math.floor(mon/monElements[i]); mon=mon%monElements[i]; }

} %>

>

您输入的金额为：

<%String s=request.getParameter(\"money\"); if(s!=null){

int mon=Integer.parseInt(s); moneyDeal(mon); for(int i=0;i<5;i++){ %>

应找零为：<%=monElements[i]%>元<%=monReturn[i]%>张
<% } } %>

(3)<%@page language=\"java\" contentType=\"text/html;charset=gb2312\" errorPage=\"l6.jsp\"%> <%!

int[]monReturn=new int[5];

int[]monElements=new int[]{50,20,10,5,1}; void moneyDeal(int mon){ for(int i=0;i<5;i++){

monReturn[i]=(int)Math.floor(mon/monElements[i]); mon=mon%monElements[i]; } } %>

您输入的金额为：

<%String s=request.getParameter(\"money\"); if(s!=null){

int mon=Integer.parseInt(s); moneyDeal(mon); for(int i=0;i<5;i++){ %>

应找零为：<%=monElements[i]%>元<%=monReturn[i]%>张
<% } } %>

(4)<%@page language=\"java\" contentType=\"text/html;charset=gb2312\" errorPage=\"l6.jsp\"%> <%!

String str;

int[]monReturn=new int[5];

int[]monElements=new int[]{50,20,10,5,1}; void moneyDeal(int mon){ for(int i=0;i<5;i++){

monReturn[i]=(int)Math.floor(mon/monElements[i]); mon=mon%monElements[i]; } } %>

您输入的金额为：

<%String s=request.getParameter(\"money\"); if(s!=null){

int mon=Integer.parseInt(s); moneyDeal(mon); for(int i=0;i<5;i++){ %>

应找零为：<%=monElements[i]%>元<%=monReturn[i]%>张
<% } } %> 4-3、

<%@ page language=\"java\" contentType=\"text/html; charset=gb2312\" errorPage=\"l6.jsp\"%> <%

//String str=\"欢迎\"; for(int i=0;i<100;i++){ %>

欢迎
<% } %>
4-4、

<%@ page language=\"java\" contentType=\"text/html; charset=gb2312\" errorPage=\"l6.jsp\"%> <%

for(int i=1;i<10;i++){ %>

\"><%=i%>
<% } %>
4-5、

<%@ page language=\"java\" contentType=\"text/html; charset=gb2312\" errorPage=\"l6.jsp\"%> <%

for(int i=1;i<10;i++){

%>

<%=\"\"+i+\"
\"%> <% } %>

<%String str=request.getParameter(\"n\"); if(str!=null){

int n=Integer.parseInt(str);%>

该数字的平方为：<%=n*n%>

<%}%>
4-6、

<%@ page contentType=\"text/html; charset=gb2312\" isErrorPage=\"true\"%> <%

out.println(\"网页出现异常！\"); %>

Chapter5

5-1、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%> 登录：

账号：

密码：

5-2、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%> 登录：

账号：

密码：

是否注册为会员：是

5-3、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%>

<%--<%String str=\"N\";

int number=Integer.parseInt(str); %>--%>

5-3-1、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%>

<% String str=request.getParameter(\"number\"); int number=Integer.parseInt(str); %> <%

for(int i=1;i<=number;i++)out.print(\"欢迎
\"); %> 5-4、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%> <%!

int[]monReturn=new int[5];

int[]monElements=new int[]{50,20,10,5,1}; void moneyDeal(int mon){ for(int i=0;i<5;i++){

monReturn[i]=(int)Math.floor(mon/monElements[i]); mon=mon%monElements[i]; } } %>

应付款
实际付款

<%String m1=request.getParameter(\"money1\"); String m2=request.getParameter(\"money2\"); if(m1!=null&&m2!=null){ int m11=Integer.parseInt(m1); int m22=Integer.parseInt(m2); int mon=m22-m11; moneyDeal(mon);%>

应找零<%=mon %>,
<% for(int i=0;i<5;i++){%>

<%=monElements[i]%>元<%=monReturn[i]%>张, <% } } %>

5-5、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%> 登录：

账号：

密码：

5-5-2、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%>

<%String str=request.getParameter(\"account\"); %>

用户姓名：

\">

5-5-3、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%> <%

String str1=request.getParameter(\"account1\"); String str2=request.getParameter(\"name\");

out.println(\"用户账号:\"+str1+\"
\"+\"用户姓名:\"+str2); %>

Chapter6

6-1、

<%@ page language=\"java\" import=\"java.sql.*\" pageEncoding=\"gb2312\"%> <%

Class.forName(\"sun.jdbc.odbc.jdbcodbcDriver\");

Connection conn=DriverManager.getConnection(\"jdbc:odbc:DSSchool\"); Statement stat=conn.createStatement(); String sql=\"SELECT*\";

ResultSet rs=stat.executeQuery(sql); while(rs.next()){

String stuno=rs.getString(\"STUNO\");

String stuname=rs.getString(\"STUNAME\"); String stusex=rs.getString(\"STUSEX\");

out.print(stuno+\"\"+stuname+\"\"+stusex+\"
\"); }

stat.close(); conn.close(); %> 6-2、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%>

输入姓名:

6-2-1、

<%@ page language=\"java\" import=\"java.sql.*\" pageEncoding=\"gb2312\"%> <%

request.setCharacterEncoding(\"gb2312\");

String name=request.getParameter(\"stuname\"); Class.forName(\"sun.jdbc.odbc.jdbcodbcDriver\");

Connection conn=DriverManager.getConnection(\"jdbc:odbc:DSSchool\"); Statement stat=conn.createStatement();

String sql=\"SELECT STUNO,STUNAME,STUSEX FORM T_STUDENT WHERE STUNO='\"+name+\"'\";

ResultSet rs=stat.executeQuery(sql);

while(rs.next()){

String stuno=rs.getString(\"STUNO\");

String stuname=rs.getString(\"STUNAME\"); String stusex=rs.getString(\"STUSEX\");

out.print(stuno+\"\"+stuname+\"\"+stusex+\"
\"); }

stat.close(); conn.close(); %> 6-3、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%>

输入学号： 输入姓名：
6-3-1、

<%@ page language=\"java\" import=\"java.sql.*\" pageEncoding=\"gb2312\"%>

<% request.setCharacterEncoding(\"gb2312\"); String sno=request.getParameter(\"sno\");

String name=request.getParameter(\"name\");

Class.forName(\"sun.jdbc.odbc.jdbcodbcDriver\");

Connection conn=DriverManager.getConnection(\"jdbc:odbc:DSSchool\"); Statement stat=conn.createStatement();

String sql=\"SELECT STUNO,STUNAME FORM T_STUDENT WHERE STUNO='\"+name+\"'\";

ResultSet rs=stat.executeQuery(sql); if(!rs.next())

out.println(\"学号不存在，登录失败！\"); else{

String stuname=rs.getString(\"STUNAME\"); if(stuname.equals(name))

out.print(\"恭喜，登陆成功！\"); else

out.println(\"姓名不存在！\"); }

stat.close(); conn.close(); %>

Chapter7

7-1、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%> <%

String address=request.getRemoteAddr(); int index=address.indexOf('.');

String addressCut=address.substring(0,index); if(addressCut.equals(\"192\"))

out.print(\"抱歉，你被禁止访问！\"); %> 7-2、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%>

输入图书价格：

7-2-1、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%> <%

String str=request.getParameter(\"price\"); %>

输入汇率：
\">

7-2-2、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%> <%

String str1=request.getParameter(\"price\"); String str2=request.getParameter(\"forecast\"); double d1=Double.parseDouble(str1); double d2=Double.parseDouble(str2); double r=d1/d2; out.print(r); %> 7-3、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%>

用户名：

密码：

<%

String name=request.getParameter(\"name\");

String password=request.getParameter(\"password\"); if(name!=null&&password!=null){ if(name.equals(password)){

response.sendRedirect(\"7-3-1.jsp\"); }

else out.println(\"登陆错误!\"); } %> 7-3-1、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%> 欢迎登陆！ 7-4、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%>

选择背景颜色:

直接访问欢迎页面

7-4-1、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%>

<%! String color=\"\";%> <%

color=request.getParameter(\"bgcolor\"); if (color==null) {

Cookie[] cookies=request.getCookies(); for( int i=0;iif(cookies[i].getName().equals(\"color\")) {color=cookies[i].getValue(); break;} } } else {

Cookie cookie=new Cookie(\"color\ cookie.setMaxAge(360000); response.addCookie(cookie); } %>

7-5、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%> <%

String act=null; String pwd=null;

Cookie [] cookies=request.getCookies(); if(cookies!=null){

for(int i=0;iif(cookies[i].getName().equals(\"act\")) act=cookies[i].getValue();

else if(cookies[i].getName().equals(\"pwd\")) pwd=cookies[i].getValue(); if(act!=null&&pwd!=null) break;}

if(act!=null&&pwd!=null)

{ if(act!=null&&pwd!=null&&act.equals(pwd))

response.sendRedirect(\"7-5-1.jsp?act=\"+act+\"&pwd=\"+pwd); } } %>

请您输入账号:
请您输入密码:
是否保存登录状态
<%

act=request.getParameter(\"account\"); pwd=request.getParameter(\"password\"); String save=request.getParameter(\"save\");

if(act!=null&&pwd!=null&&act.equals(pwd)){ if(save!=null&&save.equals(\"yes\"))

{Cookie cookie1=new Cookie(\"act\ Cookie cookie2=new Cookie(\"pwd\ cookie1.setMaxAge(360000); cookie2.setMaxAge(360000); response.addCookie( cookie1); response.addCookie( cookie2); } response.sendRedirect(\"7-5-1.jsp?act=\"+act+\"&pwd=\"+pwd); } %>

7-5-1、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%>

<% String act=request.getParameter(\"act\"); String pwd=request.getParameter(\"pwd\"); if(act!=null&&pwd!=null) out.print(\"登录成功\"); else

response.sendRedirect(\"7-5.jsp\"); %>

Chapter8

8-1、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%>

计算机书籍

java web价格30元 购买删除
java价格30元 购买删除
计算机网络价格30元 购买删除
c语言价格30元 购买删除
数据库编程价格30元 购买删除
数据结构价格30元 购买删除
C#编程价格30元 购买删除
查看购物车 历史书籍
8-1-1、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%>

历史书籍

三国演义价格30元 购买删除
水浒传价格30元 购买删除
清朝史价格30元 购买删除
明朝史价格30元 购买删除
元朝史价格30元 购买删除
近代史价格30元 购买删除
现代史价格30元 购买删除
查看购物车 计算机书籍
8-1-2、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%> <%@page import=\"java.awt.print.Book\"%>

购物车中的内容为：
 <%

ArrayList books=(ArrayList)session.getAttribute(\"books\"); if(books==null){

out.print(\"你的购物车中还没有内容\"+\"
\"); } else

for(int i=0;i\"); } %>

后退 8-1-3、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%> <%@page import=\"java.io.StringWriter\"%> <%

ArrayList books=(ArrayList)session.getAttribute(\"books\"); if(books==null){

books=new ArrayList(); session.setAttribute(\"books\ }

String book=request.getParameter(\"a\"); if(book!=null){

book=new String(book.getBytes(\"iso-8859-1\")); books.add(book); } %>

已成功加入购物车，稍后进行付款。
 后退 <% %> 8-1-4、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%> <%@page import=\"java.awt.print.Book\"%> <%

String str=request.getParameter(\"a\");

str=new String(str.getBytes(\"ISO-8859-1\"));

ArrayList books=(ArrayList)session.getAttribute(\"books\"); if (books==null){

out.println(\"你并没有 购买这本书\"); } else

for(int i=0;isession.setAttribute(\"books\ break; } } %>

你要的书已在购物车中被删除
 后退 8-2、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%>

帐号:

密码：

<%

String straccount=request.getParameter(\"account\"); String strpassword=request.getParameter(\"password\");

if(straccount!=null&&strpassword!=null&&straccount.equals(strpassword)) {

session.setAttribute(\"sb\ response.sendRedirect(\"8-2-1.jsp\"); }

%> 8-2-1、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%>

欢迎登录

<%

String account=(String)session.getAttribute(\"sb\"); if(account==null){

response.sendRedirect(\"8-2.jsp\"); } else

//session.invalidate();

session.removeAttribute(\"sb\");

String str=request.getParameter(\"a\"); if(str!=null) {

out.print(\"\"); } %>

8-3、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%>

帐号:

密码：

<%

String straccount=request.getParameter(\"account\"); String strpassword=request.getParameter(\"password\");

if(straccount!=null&&strpassword!=null&&straccount.equals(strpassword)) {

ArrayList sbs=(ArrayList)application.getAttribute(\"sbs\"); if(sbs==null) {

sbs=new ArrayList();

application.setAttribute(\"sbs\ }

if(straccount!=null){

straccount=new String(straccount.getBytes(\"ISO-8859-1\")); sbs.add(straccount); }

response.sendRedirect(\"8-3-1.jsp\"); } %>

8-3-1、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%>

聊天室

当前在线成员有：
<%

ArrayList sbs=(ArrayList)application.getAttribute(\"sbs\"); for( int i=0;iout.println(sbs.get(i)+\"
\"); }

out.print(\"共有\"+sbs.size()+\"人在线\"); %>

Chapter9

9-1、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%>

输入图书名称：

<%

ArrayList booksQuery=(ArrayList)session.getAttribute(\"booksQuery\"); if(booksQuery!=null) {

for(int i=0;iString book=\"\";

ArrayList bookinfo=(ArrayList)booksQuery.get(i); for(int j=0;j\"); } } %> 9-2、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%>

输入图书名称：

<%

ArrayList booksQuery=(ArrayList)session.getAttribute(\"booksQuery\"); if(booksQuery!=null) {

for(int i=0;iString book=\"\";

ArrayList bookinfo=(ArrayList)booksQuery.get(i); for(int j=0;jout.println(\"添加到购物车
\");

}

out.println(\"查看购物车\"); } %> 9-2-1、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%> <%

ArrayList booksBuy=(ArrayList)session.getAttribute(\"booksBuy\"); if(booksBuy!=null) {

for(int i=0;iString book=(String)booksBuy.get(i);

out.println(book+\"删除\"+\"
\"); } } %>

返回首页 9-4、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%>

输入图书名称：

<%

ArrayList booksQuery=(ArrayList)session.getAttribute(\"booksQuery\"); if(booksQuery!=null) {

for(int i=0;iString book=(String)booksQuery.get(i); out.println(book);

out.println(\"
\"); } } %> 9-5、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%>

账户：
密码:

<%

String account=request.getParameter(\"account\"); String pwd=request.getParameter(\"pwd\"); if(account!=null&&pwd!=null) {

if(account.equals(\"cliff\")&&pwd.equals(\"cliff\")) {

session.setAttribute(\"account\ session.setAttribute(\"pwd\

response.sendRedirect(\"05Success.jsp\"); } else

out.println(\"请确认输入了正确的用户和密码！\"); } %> 9-5-1、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%>

欢迎您的光临， <%

String account=(String)session.getAttribute(\"account\"); out.println(account); %> 9-6、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%>

账户：
密码:

是否保存登录状态

<%

String account=request.getParameter(\"account\"); String pwd=request.getParameter(\"pwd\"); String flag=request.getParameter(\"save\"); if(account!=null&&pwd!=null) {

if(account.equals(\"cliff\")&&pwd.equals(\"cliff\")) {

session.setAttribute(\"account\ session.setAttribute(\"pwd\ if(flag!=null&&flag.equals(\"yes\")) {

Cookie account_cookie=new Cookie(\"account\ account_cookie.setMaxAge(6000);

Cookie pwd_cookie=new Cookie(\"pwd\ pwd_cookie.setMaxAge(6000);

response.addCookie(account_cookie); response.addCookie(pwd_cookie); }

response.sendRedirect(\"06Success.jsp\"); } else

out.println(\"请确认输入了正确的用户和密码！\"); } %>

9-6-1、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%>

欢迎您的光临， <%

String account=(String)session.getAttribute(\"account\"); out.println(account); %> Servlets、

9-2*BookAdd.java package servlets;

import java.io.IOException; import java.io.PrintWriter; import java.util.ArrayList;

import javax.servlet.ServletException; import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession;

public class BookAdd extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { HttpSession session=request.getSession(); ArrayList booksBuy=(ArrayList)session.getAttribute(\"booksBuy\"); if(booksBuy==null) { booksBuy=new ArrayList(); session.setAttribute(\"booksBuy\ } String addbook=request.getParameter(\"addbook\"); addbook=new String(addbook.getBytes(\"ISO-8859-1\"),\"gb2312\");//返回addbook的ISO编码，然后创建gb2312的新串 //System.out.println(addbook); if(!booksBuy.contains(addbook)) booksBuy.add(addbook); response.sendRedirect(\"/ch09/02.jsp\");

} }

9-2*BookDel.java package servlets;

import java.io.IOException; import java.io.PrintWriter; import java.util.ArrayList;

import javax.servlet.ServletException; import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession;

public class BookDel extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String bookdel=request.getParameter(\"bookdel\"); bookdel=new String(bookdel.getBytes(\"ISO-8859-1\"),\"GBK\"); HttpSession session=request.getSession(); ArrayList booksbuy=(ArrayList)session.getAttribute(\"booksBuy\"); booksbuy.remove(bookdel); response.sendRedirect(\"/ch09/booksSee.jsp\"); } }

9-2*BookQuery.java package servlets;

import javax.servlet.*; import javax.servlet.http.*; import java.io.*; import java.sql.*;

import java.util.ArrayList;

public class BookQuery extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request,response); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { PrintWriter out = response.getWriter(); String bookname=request.getParameter(\"bookname\");

try { Class.forName(\"sun.jdbc.odbc.JdbcOdbcDriver\"); Connection conn = DriverManager.getConnection(\"jdbc:odbc:DSSchool\"); Statement stat = conn.createStatement(); String sql = \"SELECT BookId,BookName,BookPrice FROM T_BOOK WHERE BookName Like '%\"+bookname+\"%'\"; ResultSet rs = stat.executeQuery(sql); HttpSession session=request.getSession(); ArrayList books=new ArrayList(); while(rs.next()) { ArrayList book=new ArrayList(); book.add(rs.getString(\"BookId\")+\"|\"); book.add(rs.getString(\"BookName\")+\"|\"); book.add(rs.getString(\"BookPrice\")); books.add(book); } session.setAttribute(\"booksQuery\ //response.sendRedirect(\"/ch09/01.jsp\"); response.sendRedirect(\"/ch09/02.jsp\"); } catch (Exception e){ out.println(e.getMessage()); } } }

9-2*BookSee.java package servlets;

import java.io.IOException; import java.io.PrintWriter;

import javax.servlet.ServletException; import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse;

public class BookSee extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.sendRedirect(\"/ch09/booksSee.jsp\"); } }

9-4*BookQuery.java

package servlets;

import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import java.util.ArrayList;

import javax.servlet.RequestDispatcher; import javax.servlet.ServletContext; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession;

public class BookQuery4 extends HttpServlet { String dcnStr,urlStr;//类中的全局变量 public void init() throws ServletException { dcnStr=this.getInitParameter(\"driverClassName\"); urlStr=this.getInitParameter(\"url\"); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { PrintWriter out = response.getWriter(); String bookname=request.getParameter(\"bookname\"); try { Class.forName(dcnStr); Connection conn = DriverManager.getConnection(urlStr); Statement stat = conn.createStatement(); String sql = \"SELECT BookId,BookName,BookPrice FROM T_BOOK WHERE BookName Like '%\"+bookname+\"%'\"; ResultSet rs = stat.executeQuery(sql); HttpSession session=request.getSession(); ArrayList books=new ArrayList(); while(rs.next()) { String bi= rs.getString(\"BookId\"); String bn= rs.getString(\"BookName\"); String bp= rs.getString(\"BookPrice\"); String book=bi+\"|\"+bn+\"|\"+bp;

books.add(book); } session.setAttribute(\"booksQuery\ response.sendRedirect(\"/ch09/04.jsp\"); } catch (Exception e){ out.println(e.getMessage()); } } }

Filter、

SessionFilter.java package filter;

import java.io.IOException; import javax.servlet.Filter;

import javax.servlet.FilterChain; import javax.servlet.FilterConfig; import javax.servlet.ServletException; import javax.servlet.ServletRequest; import javax.servlet.ServletResponse;

import javax.servlet.http.HttpServletRequest;//注意引入的类包 import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession;

public class SessionFilter implements Filter { public void init(FilterConfig filterConfig) throws ServletException { // TODO Auto-generated method stub } public void doFilter(ServletRequest request, ServletResponse response, FilterChain chain) throws IOException, ServletException { HttpSession session = ((HttpServletRequest)request).getSession();//request的转换 String account=(String)session.getAttribute(\"account\"); String pwd=(String)session.getAttribute(\"pwd\"); if(account==null||pwd==null) ((HttpServletResponse)response).sendRedirect(\"05.jsp\");//response的转换 chain.doFilter(request, response); } public void destroy() { // TODO Auto-generated method stub }

}

CookieFilter.java package filter;

import java.io.IOException; import javax.servlet.Filter;

import javax.servlet.FilterChain; import javax.servlet.FilterConfig; import javax.servlet.ServletException; import javax.servlet.ServletRequest; import javax.servlet.ServletResponse; import javax.servlet.http.Cookie;

import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession;

public class CookieFilter implements Filter{ public void init(FilterConfig filterConfig) throws ServletException { // TODO Auto-generated method stub } public void destroy() { // TODO Auto-generated method stub } public void doFilter(ServletRequest request, ServletResponse response, FilterChain chain) throws IOException, ServletException { String account=null; String pwd=null; HttpSession session = ((HttpServletRequest)request).getSession(); account=(String)session.getAttribute(\"account\"); if(account==null)//session不存在，说明是直接访问欢迎页面！！反之，正常登录成功，无需审查Cookie { Cookie [] cookies=((HttpServletRequest)request).getCookies(); if(cookies!=null)//存在cookie { for(int i=0;iif(account!=null&&pwd!=null)//存在用户和密码 { if(account.equals(\"cliff\")&&pwd.equals(\"cliff\")) { session.setAttribute(\"account\ session.setAttribute(\"pwd\ } } else ((HttpServletResponse)response).sendRedirect(\"06.jsp\"); } else ((HttpServletResponse)response).sendRedirect(\"06.jsp\"); } chain.doFilter(request, response); } }

Web.xml、

EncodingFilter filter.EncodingFilter

SessionFilter filter.SessionFilter

CookieFilter filter.CookieFilter

EncodingFilter /*

SessionFilter /05Success.jsp

CookieFilter /06Success.jsp

BookQuery

servlets.BookQuery

BookAdd

servlets.BookAdd

BookSee

servlets.BookSee

BookDel

servlets.BookDel

BookQuery4

servlets.BookQuery4

driverClassName

sun.jdbc.odbc.JdbcOdbcDriver

url

jdbc:odbc:DSSchool

BookQuery /servlets/BookQuery

BookAdd /servlets/BookAdd

BookSee /servlets/BookSee

BookDel /servlets/BookDel

BookQuery4 /servlets/BookQuery4

index.html index.jsp

BASIC

Chapter10

10-3、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%> <%@ page import=\"beans.Student,dao.StudentDao\" %>

请输入学号：
请输入姓名：

<%

request.setCharacterEncoding(\"gb2312\"); String sno=request.getParameter(\"sno\");

String sname=request.getParameter(\"sname\"); if(sno!=null&&sname!=null) {

out.println(sname);

StudentDao studentdao=new StudentDao(); Student student=studentdao.queryStudent(sno); if(sname.equals(student.getStuname())) {

session.setAttribute(\"sname\ response.sendRedirect(\"03Success.jsp\"); } } %>

10-3-1、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%>

欢迎您,<% out.println(session.getAttribute(\"sname\")); %> 10-4、

<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"gb2312\"%> <%@ page import=\"beans.Student,dao.StudentDao\" %>

请输入姓名：
<%

ArrayList students=(ArrayList)session.getAttribute(\"students\"); if(students!=null) {

for(int i=0;iStudent student=(Student)students.get(i); out.println(student.getStuno()+\" \"+student.getStuname()+\" student.getStusex()+\"
\"); } } %>

Servlets、

SearchStudent.java package servlets;

import java.io.IOException; import java.io.PrintWriter; import java.util.ArrayList;

import javax.servlet.ServletException; import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import dao.StudentInfoDao;

\"+

public class SearchStudent extends HttpServlet { public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding(\"gb2312\"); String stuname=request.getParameter(\"sname\"); if(stuname!=null) { StudentInfoDao infodao=new StudentInfoDao(); ArrayList infoList=null; try { infoList = infodao.queryAllStudents(stuname); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } if(infoList!=null) { HttpSession session=request.getSession(); session.setAttribute(\"students\ } } response.sendRedirect(\"/ch10/04.jsp\"); } }

Beans、 Student.java （略。。。。） Dao、

StudentInfoDao.java package dao;

import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet;

import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import beans.Student;

public class StudentInfoDao { public ArrayList queryAllStudents(String stuname) throws Exception { Connection conn = null; ArrayList students= new ArrayList(); try { //获取连接

Class.forName(\"sun.jdbc.odbc.JdbcOdbcDriver\"); String url=\"jdbc:odbc:DSSchool\"; conn = DriverManager.getConnection(url, \"\ // 运行SQL语句 String sql = \"SELECT STUNO,STUNAME,STUSEX from T_STUDENT Where STUNAME LIKE '%\"+stuname+\"%'\"; Statement stat = conn.createStatement(); ResultSet rs = stat.executeQuery(sql); while (rs.next()) { //实例化VO Student student = new Student(); student.setStuno(rs.getString(\"STUNO\")); student.setStuname(rs.getString(\"STUNAME\")); student.setStusex(rs.getString(\"STUSEX\")); students.add(student); } rs.close(); stat.close(); } catch (SQLException e) { e.printStackTrace(); } finally { try {// 关闭连接 if (conn != null) { conn.close(); conn = null; } } catch (Exception ex) { } } return students; } }

因篇幅问题不能全部显示，请点此查看更多更全内容

查看全文

Copyright © 2019- huatuo8.com 版权所有
湘ICP备2023022238号-1

Top