import java.io.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class SQLUpdate extends HttpServlet {
public void doGet(HttpServletRequest request,
HttpServletResponse response)
throws IOException, ServletException {
HttpSession session = request.getSession(true) ;
Connection conn = (Connection) session.getAttribute("connection") ;
if(conn == null) {
response.sendError(HttpServletResponse.SC_OK,
"Session timed out.") ;
} else {
String update = request.getParameter("update") ;
try {
Statement stat = conn.createStatement();
int rows = stat.executeUpdate(update) ;
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("");
out.println("" + rows + " rows updated.") ;
out.println("
");
out.println("");
out.println("");
} catch (SQLException e) {
response.sendError(HttpServletResponse.SC_OK,
"Query failed: " + e.getMessage()) ;
}
}
}
}