xinwenshow.jsp~6~
来自「JAVA实验图形 =各种 的 JAVA简单代码 出初学者必备！！！！！！！！！」· JSP~6~ 代码 · 共 53 行
JSP~6~
53 行
<%@page language="java" contentType="text/html; charset=GBK"%><%@page import="java.sql.*"%><%@page import="java.io.*"%><%request.setCharacterEncoding("gb2312");%><html><title>新闻显示</title><body><table border="1" cellpadding="2" cellspacing="3" align="center"><tr bgcolor=#9f9f9f><td>新闻ID</td><td>新闻名称</td><td>新闻类型</td><td>新闻图片</td></tr><%!String xinwenid,xinwenname,xinwentype,xinwenshuoming;%><%Statement stmt=null;String sql = "select * from xinwen "; 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语句 ResultSet p = stmt.executeQuery(sql); while(p.next()){ xinwenid=p.getString("xinwenid"); xinwenname=p.getString("xinwenname"); xinwentype=p.getString("xinwentype"); out.println("<TR>"); out.print("<td >"+xinwenid+"</td>"); out.print("<td >"+xinwenname+"</td>"); out.print("<td>"+xinwentype+"</td>"); out.print("<td><img src=ImageShow.jsp?id="+xinwenid+" height=50></td>"); out.print("</tr>"); } } catch (Exception e) {}%> </table></body></html>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?