JSP打印一张表。很简单，搞了两天，要加油了！

用JSP打印一张表，结果打印了两天，最后发现是rs.executeQuery(),写成了rs.excuteQuery()了。失败，老是怀疑自己版本什么的，结果是自己没自信。

代码打印一下吧。

<%!

public static final String DBDRIVER="com.mysql.cj.jdbc.Driver";

public static final String DBURL="jdbc:mysql://localhost:3306/studemo?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC";

public static final String DBUSER="root";
public static final String DBPASS="jssq9061";
%>
<%
Connection conn=null;
PreparedStatement pstmt=null;  //这里定义了，后面就不要再定义，防止重复了。
ResultSet rs=null;
%>
<%
try{
Class.forName(DBDRIVER);
conn=DriverManager.getConnection(DBURL,DBUSER,DBPASS);
String sql="select s1,c1,score from sc";
pstmt=conn.prepareStatement(sql);
rs=pstmt.executeQuery();
int ds1,dc1;
float dsc;
%>

<table width="733" height="166" border="1">

<tr>
<td colspan="3"><div align="center" class="c1">成绩情况表</div></td>
</tr>
<tr>
<td>s1</td>
<td>c1</td>
<td>score</td>
</tr>
<tr>
<%
while(rs.next()){
ds1=rs.getInt(1);
dc1=rs.getInt(2);
dsc=rs.getFloat(3);
%>

<td ><%=ds1%></td>
<td ><%=dc1%></td>
<td ><%=dsc%></td>
</tr>
<% }%>
</table>

<%
}catch(Exception e){System.out.println(e);}
finally{
conn.close();
rs.close();
pstmt.close();
}
%>