example5_12.jsp

来自「JSP效果信息 各位请下载查看 比较不错的」· JSP 代码 · 共 36 行

JSP
36
字号
<%@page contentType="text/html;charset=gb2312" %>
<%@page import="java.sql.*" %>
<html>
  <body>
    <%
      Connection con;
      Statement sql;
      ResultSet rs;
      try{
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      }catch(ClassNotFoundException e){
      }
      try{
        con=DriverManager.getConnection("jdbc:odbc:star","","");out.print("单  rr价");
        sql=con.createStatement();
        rs=sql.executeQuery("select * from 品名");
        out.print("<Table Border>");
        out.print("<tr>");
          out.print("<TH width=100>"+"品名");
          out.print("<TH width=50>"+"单位");
          out.print("<TH width=50>"+"单价");
        out.print("</tr>");
        while(rs.next()){
         out.print("<tr>");
          out.print("<TD>"+rs.getString(1)+"</TD>");
          out.print("<TD>"+rs.getString(2)+"</TD>");
          out.print("<TD>"+rs.getString(3)+"</TD>");
        out.print("</tr>");
       }
       out.print("</Table>");
       con.close();
      }catch(SQLException ee){
      }
     %>
  </body>
</html>

⌨️ 快捷键说明

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