爱站程序员基地代码如下
<%@ page contentType=\"text/html;charset=GBK\" language=\"java\" errorPage=\"\" %><%@ page import=\"java.sql.*\" %><html><head><title> racle </title><style type=\"text/css\">td{background: white;}th{background: white;}</style></head><body><%Class.forName(\"oracle.jdbc.driver.OracleDriver\");Connection conn=DriverManager.getConnection(\"jdbc:oracle:thin:@localhost:1521:orcl\",\"ydtcscs\",\"wms\");Statement stmt=conn.createStatement();ResultSet rs=stmt.executeQuery(\"select spid,spbh,spmch,dw,jlgg,shengccj,\'\' from spkfk where rownum < 20\");%><table bgcolor=\"#808080\" border=\"0\" width=\"80%\" cellspacing=\"1\" cellpadding=\"1\" align=\"center\"><tr><th>商品id</th><th>商品编号</th><th>商品名称</th><th>单位</th><th>包装量</th><th>生产厂家</th><th>无效索引</th></tr><% while(rs.next()){ %><tr><td><%=rs.getString(1)%></td><td><%=rs.getString(2)%></td><td><%=rs.getString(3)%></td><td><%=rs.getString(4)%></td><td><%=rs.getString(5)%></td><td><%=rs.getString(6)%></td><td><%=rs.getString(7)%></td></tr><% } %></table></body></html>
效果展示
数据库查询sql选中一个含有数据的表，显示几列数据就写几个列, 列对应123…
