?? test.jsp~5~
字號:
<%@ 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 + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -