📄 show.jsp
字号:
<%@ page import="java.sql.Connection,
java.sql.Statement,
java.sql.ResultSet,
com.connectBean"%>
<%--
User: qing
Date: 2005-6-30
Time: 14:06:41
--%>
<%@ page contentType="text/html;charset=gb2312" language="java" errorPage="error.jsp" %>
<jsp:useBean id="myCon" class="com.connectBean" scope="page"/>
<html>
<head><title>login</title></head>
<body>
<% //get the information from other page
String name = request.getParameter("username");
String pw = request.getParameter("password");
Connection con = connectBean.getconnect();
Statement statement=con.createStatement();
String isCorrect= "select BookTable.name as bname,BookTable.id as bid," +
"TypeTable.name as tname,BookTable.writer as bwriter," +
"BookTable.other as bother,BookTable.booknumber as bnumber," +
"BookTable.price as bprice from BookTable,TypeTable" +
" where BookTable.typeId = TypeTable.id";
ResultSet result=statement.executeQuery(isCorrect);
%>
<table width="700" border="1" align="center">
<tr>
<th height="33" scope="col">书名</div></th>
<th scope="col">书号</th>
<th scope="col">类别名</th>
<th scope="col">作者</th>
<th scope="col">其他</th>
<th scope="col">数量</th>
<th scope="col">价格</th>
</tr>
<%
while(result.next())
{
out.println("<tr><td><div align='center'>"+result.getString("bname")+"</td>" +
"<td><div align='center'>"+result.getString("bid")+"</td>" +
"<td><div align='center'>"+result.getString("tname")+"</td>" +
"<td><div align='center'>"+result.getString("bwriter")+"</td>" +
"<td><div align='center'>"+result.getString("bother")+"</td>" +
"<td><div align='center'>"+result.getString("bnumber")+"</td>" +
"<td><div align='center'>"+result.getDouble("bprice")+"</td></tr>");
}
%>
</table>
<hr>
<table align="center" border="0" width="850">
<tr><td align="center">
<form action="show.jsp" method="post">
<textarea rows="4" name="isCorrect" cols="60">
</textarea>
<br>
<input type="submit" value="查询">
<input type="reset" value="重置">
</form></td>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -