show.jsp

来自「用JSP实现的一个网上书店的程序」· JSP 代码 · 共 65 行

JSP
65 行
字号 
<%@ 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>

show.jsp - 源码说明

本页面展示了「用JSP实现的一个网上书店的程序」中的 show.jsp 源码文件，采用 JSP 编程语言编写，共 65 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫开发者社区收录了大量与JSP相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?