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("id | first | last | street | city |
");
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(""+rs.getString("id")+" | ");
out.print(""+rs.getString("firstname") + " | ");
out.print(""+rs.getString("lastname") + " | ");
out.print(""+rs.getString("street") + " | ");
out.print(""+rs.getString("city") + " | ");
out.print("
");
}
} catch (ClassNotFoundException e) {
out.println("クラスが見つかりません。");
} catch (SQLException e) {
out.println("データベース操作中にエラーがありました。");
out.println("");
e.printStackTrace(out);
out.println("
");
} finally {
try {
if (conn != null) { conn.close(); }
} catch (SQLException e) {}
}
out.println("
");
out.println("");
out.close();
}
}