import java.io.*; import java.sql.*; import javax.servlet.http.*; public class DBSelect extends HttpServlet { @Override public void doGet(HttpServletRequest req, HttpServletResponse res) throws IOException { Connection conn = null; res.setContentType("text/html; charset=Windows-31J"); PrintWriter out = res.getWriter(); out.println(""); out.println(""); out.println(""); try { String user = "sa", password=""; Class.forName("org.hsqldb.jdbcDriver"); String url = "jdbc:hsqldb:hsql://localhost"; conn = DriverManager.getConnection(url, user, password); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery("SELECT * FROM customer"); while (rs.next()) { out.print(""); out.print(""); out.print(""); out.print(""); out.print(""); out.print(""); out.print(""); } } catch (ClassNotFoundException e) { out.println("クラスが見つかりません。"); } catch (SQLException e) { out.println("データベース操作中にエラーがありました。"); } finally { try { if (conn != null) { conn.close(); } } catch (SQLException e) {} } out.println("
idfirstlaststreetcity
"+rs.getString("id")+""+rs.getString("firstname") + ""+rs.getString("lastname") + ""+rs.getString("street") + ""+rs.getString("city") + "
"); out.println(""); out.close(); } }