import java.io.*;
import java.sql.*;
import javax.servlet.http.*;
public class DBUpdate extends HttpServlet {
@Override
public void doGet(HttpServletRequest req, HttpServletResponse res) throws IOException {
doPost(req, res);
}
@Override
public void doPost(HttpServletRequest req, HttpServletResponse res) throws IOException {
Connection conn = null;
res.setContentType("text/html; charset=Windows-31J");
PrintWriter out = res.getWriter();
out.println("");
String id = req.getParameter("id");
String street = req.getParameter("street");
String city = req.getParameter("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();
stmt.executeUpdate("UPDATE customer SET street = '" + street +"', city ='"+ city
+"' WHERE id = "+ id);
} 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.println("| id | street | city |
|---|
");
out.println("| "+ id +" | "+ street + " | " + city + " |
");
out.println("
");
out.println("");
out.close();
}
}