<%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html" %> <html:html> <head><title>データベースへのアクセス</title></head> <body> <% MyDBAccess0 db = new MyDBAccess0(); db.open(); /* Statement stmt = con.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); ResultSet rs = stmt.executeQuery("select * from member"); */ ResultSet rs = db.getResultSet("select * from member order by member_id"); String tableHTML = "<table border=1>"; tableHTML += "<tr bgcolor=\"000080\"><td><font color=\"white\">ID</font></td>" + "<td nowrap><font color=\"white\">名前</font></td>" + "<td nowrap><font color=\"white\">カナ</font></td>" + "<td colspan=2><font color=\"white\">出欠</font></td>";
while(rs.next()) { int id = rs.getInt("member_id"); String name = rs.getString("name"); String kana= rs.getString("kana"); int state = rs.getInt("attendance"); String comment = rs.getString("comment");