📄 4.jsp~6~

📁 JAVA实验图形 =各种的 JAVA简单代码出初学者必备！！！！！！！！！

💻 JSP~6~

字号:

<%@page contentType="text/html; charset=GBK"%><%@page import="java.sql.*"%><link href="2.css" rel="stylesheet" type="text/css" /><html><center><body>　<div id="Header"></div><%String sql = "select * from waitbuybook";        Statement stmt=null;        PreparedStatement pstmt=null;        ResultSet rs=null;        //加载JDBC-ODBC桥驱动        try {            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");            //定义JDBC URL        }catch (Exception e) {        out.println(e.getMessage());        }          try{        String url = "jdbc:odbc:s";            //得到与数据库的连接            Connection con = DriverManager.getConnection(url);            //显示UPL和连接信息            System.out.print("URL:" + url);            System.out.print("Connection:" + con);            //得到一个Statement对象            stmt = con.createStatement();            //执行SQL语句            System.out.print("SQL:" + sql);           rs = stmt.executeQuery(sql);%><table width=600 border="2" cellpadding="2" cellspacing="3" bgcolor=#6681D9 align="center"><tr bgcolor=#6681D9 ><td height=20 colspan=5><div align=center><font SIZE="20" color="red">教材等待购买统计表</font></td></tr>  <tr bgcolor=#D9E0F9 >    <td align=center><font color="#309aff">学号</font></td>      <td align=center><font color="#309aff">教材号</font></td>    <td align=center><font color="#309aff">缺数量</font></td></tr><% while(rs.next()){out.print("<td align=center> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"+rs.getString("sno")+"</td>");out.print("<td align=center> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"+rs.getString("bnum")+"</td>");out.print("<td align=center> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"+rs.getString("booknum")+"</td></tr>");}}catch (Exception e) {}%></table><a href="jsp2.jsp">返回主页</a><br><a href="###" onclick=document.execCommand("print")>打印</a><br></html></body>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -