간단 게시판 리스트 출력 소스

<%@ page import = "java.io.*, java.util.*, java.text.*, java.sql.*, md.database.*"%>
<%

Database db = null;
Statement stmt = null;
PreparedStatement pstt = null;
ResultSet rs = null;

db = new Database("BASIC");
stmt = db.con.createStatement(); // Statement 객체 생성

String sql = " select * from table "
rs = stmt.executeQuery(sql);

<table>
<tr>
<td>  1    </td>
<td>  2    </td>
<td>  3    </td>
</tr>

while(rs.next()){
out.println("<tr>");
out.println("<td>");
out.println(rs.getString("1"));
out.println("</td>");
out.println("<td>");
out.println(rs.getString("2"));
out.println("</td>");
out.println("<td>");
out.println(rs.getString("3"));
out.println("</td>");
out.println("</tr>);.
}

</table>

%>