JSP制作带有数据库网页javaee课程设计 下载本文

(4)管理:

图书查询

 

 

查询图书:

图书查询结果

 

<%@page import=\

<% String sbook=request.getParameter(\

String isbook=new String(sbook.getBytes(\

Class.forName(\ Connection

con=DriverManager.getConnection(\est\ Statement

sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); ResultSet rs;

response.getContentType(); request.getCharacterEncoding();

response.setContentType(\ request.setCharacterEncoding(\

rs=sql.executeQuery(\ where bookno='\ if(rs.next()) {rs.previous();

out.print(\ out.print(\ out.print(\书号\ out.print(\书名\ out.print(\作者\

out.print(\出版社\ out.print(\库存量\ out.print(\ while(rs.next()) { String a,b,c,d,e; a=rs.getString(1); out.print(\ b=rs.getString(2); out.print(\ c=rs.getString(3); out.print(\ d=rs.getString(4); out.print(\ e=rs.getString(5); out.print(\ out.print(\ } } else { %>

<%

} con.close(); %>

载入:

图书载入