这是一个图书馆管理系统的jsp代码
源代码在线查看: booksearchresults.jsp~3~
Search Book results
.style3 {font-size: 24px}
.style4 {font-size: 18px}
-->
try{
Connection conn=Library.getConn();
Statement stmt;
stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from book where title ='" + Library.getbookstitle() + "'");
while (rs.next()){
Library.setbserialnumber(rs.getString("serialnumber"));
Library.setbsortnumber(rs.getString("sortnumber"));
Library.setbtitle(rs.getString("title"));
Library.setbauthor1(rs.getString("author1"));
Library.setbauthor2(rs.getString("author2"));
Library.setbauthor3(rs.getString("author3"));
Library.setbcover(rs.getString("cover"));
Library.setbbookconcern(rs.getString("bookconcern"));
Library.setbpublicday(rs.getString("publicday"));
Library.setbisbn(rs.getString("isbn"));
Library.setbtimes(rs.getString("times"));
Library.setbprize(rs.getString("prize"));
Library.setbinnumber(rs.getString("innumber"));}
}catch (Exception ex) {
response.sendRedirect("fail.jsp");
ex.printStackTrace();}
%>
Adduser
Modifyuser
Deletuser
Searchuser
Addbook
Deletebook
Borrowsearch
Search
Search Book Results
Serial NO.:
Sort NO.:
Title:
Author1:
Author2:
Author3:
Cover:
Book Conern:
Public Day:
ISBN:
Times:
Prize:
In NO.: