book2.jsp

来自「asp做的的一个网站登录 连接数据库就可以直接使用了」· JSP 代码 · 共 38 行

JSP
38
字号
<%@ page language="java" import="java.sql.*" pageEncoding="gbk"%>
<html>
  <head>
    <title>图书详细信心</title>
  </head> 
  <body>
    <%
  request.setCharacterEncoding("gbk");
  String id=request.getParameter("id");
  Connection conn=null;
  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  String strConn="jdbc:odbc:sun";
  conn=DriverManager.getConnection(strConn,"","");
  Statement stmt=conn.createStatement();
  String sql="SELECT * FROM book where id='"+id+"' ";
  ResultSet rs=stmt.executeQuery(sql); 
  rs.next();
  String bookname=rs.getString("name");
  %>
  <center><font  size=5>有关<font color=red size=5>《<%=bookname %>》</font>的详细信息</font></center>
 <table  width="70%" height="50" border="6" align="center" bgcolor="#FFFFFF" frame="hsides" bordercolor="#9900FF">
    <th>图书编号:</th>
    <th>图书名称:</th>
    <th>出版社:</th>
    <th>发行年份:</th>
    <th>图片:</th>
    <tr>
    <td nowrap align="center"><%=id %></td>
    <td nowrap align="center">《<%=bookname %>》</td>
    <td nowrap align="center"><%=rs.getString("chubanshe") %></td>
    <td nowrap align="center"><%=rs.getString("faxingnian") %>年</td>
    <td nowrap rowspan="2"><img src="<%=rs.getString("tupian") %>"></img></td></tr>
    <tr><td nowrap colspan="4" valign="top"><b>详细介绍:</b><br><%=rs.getString("xiangxiziliao") %></td></tr>
    </table>
  <%rs.close();stmt.close();conn.close(); %>
  </body>
</html>

⌨️ 快捷键说明

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