📄 guanliselect.jsp
字号:
<%@ page contentType="text/html;charset=GB2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.lang.Exception.*"%>
<%@ page import="java.text.*"%>
<%@ page import="java.util.*"%>
<%
//数据库连接
String url="jdbc:odbc:xuesheng";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
Connection con=DriverManager.getConnection(url);
Statement stmt=con.createStatement();
ResultSet result=stmt.executeQuery("select * from xinxi_book");
ResultSetMetaData resultmd=result.getMetaData();
%>
<html>
<head>
<title>借书查询信息</title>
<style type="text/css">
<!--
body {
background-image: url(33935932.jpg);
}
}
-->
</style>
</head>
<body>
<center>
<h2>请输入查询的信息<h>
</h2>
<table border="border">
<form method="POST" action="guanliselect.jsp">
<tr>
<td>
输入图书编号:</td>
<td>
<input type="text" name="condition1"></td>
</tr>
<tr>
<td>
输入图书名称:</td>
<td>
<input type="text" name="condition2"></td>
</tr>
</table>
<p>
<input type="submit" value="提交">
</form>
</p>
<p>
</p>
<p>
<%
Calendar cal = Calendar.getInstance();
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd ");
String mDateTime=formatter.format(cal.getTime());
if(request.getParameter("condition1")!=null)
{
String condition1=request.getParameter("condition1");
String condition2=request.getParameter("condition2");
%>
<table border="1">
<%
int count=resultmd.getColumnCount();
out.print("<td>用户ID</td>");
out.print("<td>用户姓名</td>");
out.print("<td>图书编号</td>");
out.print("<td>图书名称</td>");
out.print("<td>借书时间</td>");
condition2 = new String(condition2.getBytes("ISO-8859-1"), "GBK");
String sql="select * from xinxi_jieshu where +jieshu_book_id="+"'"+condition1+"'";
ResultSet result1=stmt.executeQuery(sql);
//out.println(sql);
out.println("<br>");
while(result1.next())
{
out.println("<tr>");
out.println("<td>"+result1.getString(1)+"</td>");
out.println("<td>"+result1.getString(2)+"</td>");
out.println("<td>"+result1.getString(3)+"</td>");
out.println("<td>"+result1.getString(4)+"</td>");
out.println("<td>"+mDateTime+"</td>");
out.println("</tr>");
}
%>
</table>
</center>
<%
stmt.close();
con.close();
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -