jsp3.jsp~7~
来自「JAVA实验图形 =各种 的 JAVA简单代码 出初学者必备！！！！！！！！！」· JSP~7~ 代码 · 共 67 行
JSP~7~
67 行
<%@page contentType="text/html; charset=GBK"%><%@page import="java.sql.*"%><body><%!String file;%> <% String sql = "select * from s;"; 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); ResultSet p = stmt.executeQuery(sql); ResultSetMetaData meta = p.getMetaData(); %><table width=1000 border="2" cellpadding="2" cellspacing="3" bgcolor=#6681D9 align="center"><tr bgcolor=#6681D9 ><td height=20 colspan=8><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><td align=center><font color="#309aff">教材出版社</font></td><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(p.next()) { file=p.getString("filename"); out.print("<td align=center> "+p.getString("bnum")+"</td>"); out.print("<td align=center> "+p.getString("bname")+"</td>"); out.print("<td align=center> "+p.getString("bjiage")+"</td>"); out.print("<td align=center> "+p.getString("cbs")+"</td>"); out.print("<td align=center> "+p.getString("booknum")+"</td>"); out.print("<td align='center'><img src='"+p.getString("filename")+"' </td>");%> out.print("<td align=center> "+p.getString("shuoming")+"</td></tr>"); } } catch (Exception e) {}%></table><a href="jsp1.jsp">返回申请教材</a><a href="jsp2.jsp">返回主页</a></body>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?