📄 bookssearch.jsp
字号:
<%@ page contentType = "text/html; charset =GBK" %>
<%@ page language = "java" import = "java.sql.*" %>
<%
request.setCharacterEncoding("GBK");
response.setCharacterEncoding("GBK");
%>
<html>
<head>
<title>Search & Change books information</title>
</head>
<body>
<table border="0" width="1035" id="table1" height="345">
<tr>
<td width="238" rowspan="2">
<img border="0" src="../images/Snap1.jpg" width="238" height="78"> </td>
<td width="652" height="59" colspan="5"></td>
<td width="130" height="59">
<TABLE cellSpacing=0 cellPadding=3 border=0 valign="top" id="table2" width="6">
<TBODY>
<TR>
<TD class=globalLinks vAlign=center noWrap align=right>
</TD></TR></TBODY></TABLE>
</td>
</tr>
<tr>
<td width="159" height="27"></td>
<td width="75" height="27" align="center" bgcolor="#008080"></td>
<td width="95" height="27" align="center" bgcolor="#C0C0C0"></td>
<td width="86" height="27" align="center" bgcolor="#C0C0C0"></td>
<td width="221" height="27"></td>
<td width="130" height="27"></td>
</tr>
<tr>
<td width="1025" colspan="7" height="32" align="center" bgcolor="#008080"></td>
</tr>
<tr>
<td width="1025" colspan="7" height="67"></td>
</tr>
<tr>
<td width="1025" colspan="7">
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0 id="table5">
<TBODY>
<TR height=30><TD bgColor=#eeeecc><b><font face="华文隶书" size="6">B</font></b><font face="华文隶书" size="6"><b>ook
Information Result:</b></font></TD></TR></TBODY></TABLE></td>
</tr>
<tr>
<td width="1025" colspan="7" align="center"><CENTER>
<TABLE align=middle class=tableBackground border=0 id="table6" width="793">
<TBODY>
<TR>
<TD>
<p align="center">
</TD></TR>
<TR>
<TD vAlign=center align=middle height="57">
<%
String n1 = request.getParameter("bookID");
%>
<%
String mySqlDriver = "com.mysql.jdbc.Driver";
String url ="jdbc:mysql://localhost:3306/library?user=root&password=123456&useUnicode=true&characterEncoding=gbk";
Connection conn;
try{
Class.forName(mySqlDriver);
}
catch(Exception e){
out.println("Driver Error");
}
conn = DriverManager.getConnection(url);
if(conn==null){
out.println("get Conn erroe");
}
Statement stm = conn.createStatement();
ResultSet re = null;
re = stm.executeQuery("SELECT * FROM books WHERE bookID='"+n1+"'");
String n2=null;
String n3=null;
String n4=null;
String n5=null;
String n6=null;
String n7=null;
while(re.next()){
n2 = re.getString("bookname");
n3 = re.getString("bookauthor");
n4 = re.getString("bookcon");
n5 = re.getString("bookyear");
n6 = re.getString("bookpivotal");
n7 = re.getString("bookstate"); };
%>
<%
re.close();
stm.close();
conn.close();
%>
</TABLE>
<TABLE class=tableBackground border=0 id="table7">
<TBODY>
<TR>
<TD>
<p align="center"><font face="黑体" size="5">Change Book information</font></p>
<form method="POST" action="bookschange.jsp">
<p align="center">Book ID :
<input type="text" name="bookID" size="8" value="<%=n1%>"><font color="#FF0000">(don't
change!)</font></p>
<%if(n2 ==null) out.println("<p align=center><font color=#FF0000>No such book!!please go back!</font></p>"); %>
<p align="center">Book Name :<input type="text" name="bookname" size="30" value="<%=n2%>"></p>
<p align="center">Book Author:
<input type="text" name="bookauthor" size="30" value="<%=n3%>"></p>
<p align="center">Book Concern :
<input type="text" name="bookcon" size="30" value="<%=n4%>"></p>
<p align="center">Book Concern time :
<input type="text" name="bookyear" size="8" value="<%=n5%>"></p>
<p align="center">The Book Pivotal :
<input type="text" name="bookpivotal" size="26" value="<%=n6%>"></p>
<p align="center">The Book State : <font ><%=n7%></font></p><p>
<input type="submit" value="submit" name="B6" style="float: right"></p>
</form>
</TD></TR></TBODY></TABLE></CENTER><table><td>
<p></td>
</tr>
<tr>
<td width="1025" colspan="7" align="center"> <font face="Courier New">
<a href="books.htm">GO BACK BOOK OPERATE AGAIN</a></font><p>Library</td>
</tr>
<tr>
<td width="1025" colspan="7" align="center"></td>
</tr>
<tr>
<td width="1025" colspan="7" align="center"><FONT size=1>© 2007.5-2007.6 142042 All rights
reserved.</FONT></td>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -