test.jsp~5~

来自「学习Java 非常好的电子 讲义。欢迎大家下载。学习。」· JSP~5~ 代码 · 共 38 行

JSP~5~
38
字号
<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="java.sql.*" %>
<%@ page import="javabean.Connect"%>

<html>
<body bgcolor="#fff000"><center>

 <%
    Connect con=new Connect();
    ResultSet rs = con.executeQuery("select * from student;");
    ResultSetMetaData rsmd = rs.getMetaData();
    int colnum = rsmd.getColumnCount();
    boolean  more = rs.next();
  %>
<table border=2 >
<tr>
   <% for(int i=1; i<= colnum; i++){ %>
     <td>  <%out.print(rsmd.getColumnName(i));}%> </tr>

 <p>


<%    while (more) { %>
      <tr>
      <% for (int k = 1; k <= colnum; k++){ %>
         <td> <%out.print(rs.getString(k));} %>
        <% more = rs.next(); %>
       </tr>
 <% }
   rs.close();
%>
</table>
</center>


</body>
</html>

⌨️ 快捷键说明

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