⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 morebwsd.jsp.bak

📁 一个完整JSP连接数据库的程序.包括连接
💻 BAK
字号:
🔍 
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.util.*,java.lang.*,java.sql.*" %>
<html>
<title>小小的太阳</title>
<body style="color: #FFFF">
<div align="center">
  <table border="3" borderColor="#ffffff" borderColorDark="#ffffff" borderColorLight="#ffffff" cellSpacing="0" height="1008" style="BORDER-BOTTOM-COLOR: #ffffff; BORDER-BOTTOM-STYLE: solid; BORDER-LEFT-COLOR: #ffffff; BORDER-LEFT-STYLE: solid; BORDER-RIGHT-COLOR: #ffffff; BORDER-RIGHT-STYLE: solid; BORDER-TOP-COLOR: #ffffff; BORDER-TOP-STYLE: solid" width="892">
    <tbody>
      <tr>
        <td align="middle" bgColor="#ccccff" height="1" width="80%" colspan="2">
        <%@ include file="head.html" %>
        </td>
      </tr>
      <tr>
        <td align="center" bgcolor="#fccccc" height="1" width="80%" colspan="2">
          <jsp:include page="head.jsp" />
          </jsp:include>
        </td>
      </tr>
      <tr>
        <td align="middle" bgColor="#ccffff" height="557" width="884" colspan="2">
        <table border="1" width="85%" height="90%" bordercolorlight="#f308080" style="border-style: solid" bordercolordark="#f308080" bordercolor="#f308080" cellspacing="1" cellpadding="0" > 
            <tr>
              <td align="left" height="1" colspan="2">书  名</td>
              <td align="left" height="1" width="17%">作  者</td>
              <td align="left" height="1" width="25%">出版社</td>
              <td align="left" height="1" width="18%">出版时间</td>
              <td align="left" height="1" width="15%">价  格</td>
            </tr>
        <jsp:useBean id="DbLink" scope="page" class="MyBook.DbLink" />
        <%
            DbLink.DbLink("sa","123456","MyDataBase");
            ResultSet rs = DbLink.DbQuery("select SM,ZZ,CBS,CBSJ,JG,BZ from Book"); 
            while(rs.next())
            {
              String SM =rs.getString("SM");
              String ZZ =rs.getString("ZZ");
              String CBS =rs.getString("CBS");
              String CBSJ = rs.getString("CBSJ").substring(0,10);
              float JG = rs.getFloat("JG");
              String BZ = rs.getString("BZ");
              out.println("<tr><font color=#000000 size=3><td align=\"left\" height=\"1\" colspan=\"2\">"
                           +SM   
                           +"</td><td align=\"left\" height=\"1\" width=\"17%\" >"
                           +ZZ 
                           +"</td><td align=\"left\" height=\"1\" width=\"25%\">"
                           +CBS
                           +"</td><td align=\"left\" height=\"1\" width=\"18%\">"
                           +CBSJ
                           +"</td><td align=\"left\" height=\"1\" width=\"15%\">"
                           +JG
                           +"</td></font></tr></tr>"
                           +"<tr><font color=#000000 size=3><td align=\"left\" height=\"1\" width=\"10%\">"
                           +"详细信息"
                           +"</td><td align=\"left\" height=\"1\" colspan=\"5\"><font color=\"#0099FF\">"
                           +BZ
                           +"</font></td></font></tr>");
            }
            rs.close();   
        %>
        </table>
        <br>
        <%
          String YHM=request.getParameter("YHM");
          String GLCS=request.getParameter("GLCS");
        %>
        <a href="BWSD.jsp?YHM=<%= YHM %>&GLCS=<%= GLCS %>">返  回</a>
        </td>
      </tr>
      <tr>
        <td align="middle" bgColor="#ccccff" height="1" width="80%" colspan="2">
         <%@ include file = "botton.html" %>
        </td>
      </tr>
    </tbody>
  </table>
</div>
</body>
</html>

⌨️ 快捷键说明

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