<%@page contentType = "text/html;charset=Big5"
import = "java.sql.*" %>
<HTML>
<%@page contentType = "text/html;charset=Big5"
import = "java.sql.*" %>
<HEAD>
<TITLE>取出並顯示資料表中的資料</TITLE>
</HEAD>
<BODY>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:a");
Statement smt = con.createStatement();
String sql;
sql = "SELECT 姓名,英文,數學,計概 from 123";
ResultSet rs = smt.executeQuery(sql);
int count=0, eng=0, math=0, bcc=0;
out.println("成績表<hr>");
out.println("<table border = '1'>");
out.println("<tr>"+
"<th>姓名</th><th>英文</th><th>數學</th><th>計概</th></tr>");
while(rs.next()){
count ++;
int e= rs.getInt("英文");
eng +=e;
int m= rs.getInt("數學");
math +=m;
int b= rs.getInt("計概");
bcc +=b;
out.println("<tr><td>" + rs.getString("姓名") +
"</td><td>" + e +
"</td><td>" + m +
"</td><td>" + b + "</td></tr>" );
}
out.println("<tr><td>平均" +
"</td><td>" + eng/count +
"</td><td>" + math/count +
"</td><td>" + bcc/count + "</td></tr>" );
con.close();
%>
</BODY>
</HTML>