JSP第6章实验报告.docx

输入查询内容:

ISBN

书名

作者

出版社

出版时间

内容摘要

前方一致

后方一致

包含

<%

StringfindContent=request.getParameter（"findContent"）;

Stringcondition=request.getParameter（"condition"）;

StringfindMethod=request.getParameter（"findMethod"）;

if（findContent==null）{

findContent="";

}

if（condition==null）{

condition="";

}

if（findMethod==null）{

findMethod="";

}

%>

查询到的图书：

FindBookdataSource="information"

tableName="bookForm"

findContent="<%=findContent%>"

condition="<%=condition%>"

findMethod="<%=findMethod%>"/>

<%=giveResult%>

2）Tag文件参考代码

FindBook.tag

<%@tagimport="java.sql.*"%>

<%@tagpageEncoding="gb2312"%>

<%@attributename="dataSource"required="true"%>

<%@attributename="tableName"required="true"%>

<%@attributename="findContent"required="true"%>

<%@attributename="condition"required="true"%>

<%@attributename="findMethod"required="true"%>

<%@variablename-given="giveResult"variable-class="java.lang.StringBuffer"scope="AT_END"%>

<%

byteb[]=findContent.getBytes（"iso-8859-1"）;

findContent=newString（b）;

try{Class.forName（"sun.jdbc.odbc.JdbcOdbcDriver"）;

}

catch（ClassNotFoundExceptione）{

out.print（e）;

}

Connectioncon;

Statementsql;

ResultSetrs;

StringBufferqueryResult=newStringBuffer（）;//查询结果

Stringuri="jdbc:

odbc:

"+dataSource;

try{con=DriverManager.getConnection（uri,"",""）;

sql=con.createStatement（）;

Strings="";

if（findMethod.equals（"start"））

s="select*from"+tableName+"where"+condition+"Like'"+findContent+"%'";

if（findMethod.equals（"end"））

s="select*from"+tableName+"where"+condition+"Like'%"+findContent+"'";

if（findMethod.equals（"contains"））

s="select*from"+tableName+"where"+condition+"Like'%"+findContent+"%'";

rs=sql.executeQuery（s）;

queryResult.append（""）;

queryResult.append（""）;

queryResult.append（"ISBN"）;

queryResult.append（"图书名称"）;

queryResult.append（"作者"）;

queryResult.append（"价格"）;

queryResult.append（"出版社"）;

queryResult.append（"出版时间"）;

queryResult.append（"摘要"）;

queryResult.append（""）;

int字段个数=7;

while（rs.next（））{

queryResult.append（""）;

StringbookISBN="";

for（intk=1;k<=字段个数;k++）{

if（k==7）{

StringbookAbstract=rs.getString（k）;

Stringabs=""+bookAbstract+"";

queryResult.append（""+abs+""）;

}

else{

queryResult.append（""+rs.getString（k）+""）;

}

}

}

queryResult.append（""）;

jspContext.setAttribute（"giveResult",queryResult）;

con.close（）;

}

catch（SQLExceptionexp）{

jspContext.setAttribute（"giveResult",newStringBuffer（"请给出查询条件"））;

}

%>

实验2更新记录

实验要求

编写一个JSP页面updsteRecord.jsp和两个Tag文件UpdateRecord.tag、GetRecord.tag。

updateRecord.jsp负责调用GetRecord.tag文件，显示GetRecord.tag返回待更新的记录的有关字段的值；upateRecord.jsp调用UpdateRecord.tag文件，并显示UpdateRecord.tag返回的有关更新记录是否成功的信息。

1）updateRecord.jsp的具体要求

updateRecord.jsp页面提供一个表单，该表单允许用户输入某种图书的ISBN号以及针对该ISBN号的图书的更新信息；该页面负责将图书的ISBN号传递给GeRecord.tag，将图书的更新信息传递给UpdateRecord.tag。

2）GetRecord.tag的具体要求

GetRecord.tag文件使用attribute指令获得updateRecord.jsp页面传递过来的图书的ISBN号，并显示和该图书对应的记录。

3）UpdateRecord.tag具体要求

UpdateRecord.tag文件使用attribute指令获得updateRecord.jsp页面传递过来的图书更新信息，然后更新数据库中bookForm表中的记录，并返回更新是否成功的消息给updateRecord.jsp页面。

JSP页面效果示例

updateRecord.jsp的效果如图所示。

参考代码

可以按照实验要求，参考本代码编写代码。

1）JSP页面参考代码

updateRecord.jsp

<%@pagecontentType="text/html;charset=GB2312"%>

<%@taglibtagdir="/WEB-INF/tags"prefix="getRecord"%>

<%@taglibtagdir="/WEB-INF/tags"prefix="updateRecord"%>

<%}

%>

<%

bookISBN=request.getParameter（"bookISBN"）;

Stringenter=request.getParameter（"enter"）;

StringbookName=request.getParameter（"bookName"）;

StringbookAuthor=request.getParameter（"bookAuthor"）;

StringbookPrice=request.getParameter（"bookPrice"）;

StringbookPublish=request.getParameter（"bookPublish"）;

StringbookTime=request.getParameter（"bookTime"）;

StringbookAbstract=request.getParameter（"bookAbstract"）;

booleanok=（enter!

=null）;

if（ok）{

%>

UpdateRecordbookISBN="<%=bookISBN%>"bookName="<%=bookName%>"bookAuthor="<%=bookAuthor%>"

bookPrice="<%=bookPrice%>"bookPublish="<%=bookPublish%>"

bookTime="<%=bookTime%>"bookAbstract="<%=bookAbstract%>"/>

<%}

%>

2）Tag文件参考代码

GetRecord.tag

<%@tagimport="java.sql.*"%>

<%@tagpageEncoding="gb2312"%>

<%@attributename="bookISBN"required="true"%>

<%@variablename-given="oldBookName"scope="AT_END"%>

<%@variablename-given="oldBookAuthor"scope="AT_END"%>

<%@variablename-given="oldBookPrice"scope="AT_END"%>

<%@variablename-given="oldBookPublish"scope="AT_END"%>

<%@variablename-given="oldBookTime"scope="AT_END"%>

<%@variablename-given="oldBookAbstract"scope="AT_END"%>

<%

try{Class.forName（"sun.jdbc.odbc.JdbcOdbcDriver"）;

}

catch（ClassNotFoundExceptione）{

out.print（e）;

}

StringBufferstr=newStringBuffer（）;

Connectioncon;

Statementsql;

ResultSetrs;

Stringuri="jdbc:

odbc:

information";

try{

con=DriverManager.getConnection（uri,"",""）;

Stringquery=

"selectbookName,bookAuthor,bookPrice"+

",bookPublish,bookTime,bookAbstractfrombookFormWHEREbookISBN='"+bookISBN+"'";

sql=con.createStatement（）;

rs=sql.executeQuery（query）;

if（rs.next（））{

jspContext.setAttribute（"oldBookName",rs.getString（"bookName"））;

jspContext.setAttribute（"oldBookAuthor",rs.getString（"bookAuthor"））;

jspContext.setAttribute（"oldBookPrice",rs.getString（"bookPrice"））;

jspContext.setAttribute（"oldBookPublish",rs.getString（"bookPublish"））;

jspContext.setAttribute（"oldBookTime",rs.getString（"bookTime"））;

jspContext.setAttribute（"oldBookAbstract",rs.getString（"bookAbstract"））;

}

else{

jspContext.setAttribute（"oldBookName",""）;

jspContext.setAttribute（"oldBookAuthor",""）;

jspContext.setAttribute（"oldBookPrice",""）;

jspContext.setAttribute（"oldBookPublish",""）;

jspContext.setAttribute（"oldBookTime",""）;

jspContext.setAttribute（"oldBookAbstract",""）;

}

con.close（）;

}

catch（SQLExceptionexp）{

jspContext.setAttribute（"oldBookName",""）;

jspContext.setAttribute（"oldBookAuthor",""）;

jspContext.setAttribute（"oldBookPrice",""）;

jspContext.setAttribute（"oldBookPublish",""）;

jspContext.setAttribute（"oldBookTime",""）;

jspContext.setAttribute（"oldBookAbstract",""）;

}

jspContext.setAttribute（"bookISBN",bookISBN）;

%>

UpdateRecord.tag

<%@tagimport="java.sql.*"%>

<%@tagpageEncoding="gb2312"%>

<%@attributename="bookISBN"required="true"%>

<%@attributename="bookName"required="true"%>

<%@attributename="bookAuthor"required="true"%>

<%@attributename="bookPrice"required="true"%>

<%@attributename="bookPublish"required="true"%>

<%@attributename="bookTime"required="true"%>

<%@attributename="bookAbstract"required="true"%>

<%@variablename-given="giveResult"variable-class=

"java.lang.StringBuffer"scope="AT_END"%>

<%

byte[]c=bookName.getBytes（"iso-8859-1"）;

bookName=newString（c）;

c=bookAuthor.getBytes（"iso-8859-1"）;

bookAuthor=newString（c）;

c=bookPublish.getBytes（"iso-8859-1"）;

bookPublish=newString（c）