📄 xinwenshow.jsp~6~

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

💻 JSP~6~

字号:

<%@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 + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -