%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
Delete Database Page
<%@ page import = "java.sql.*, java.util.*" %>
<%
String id = request.getParameter("id");
String password = request.getParameter("password");
Class.forName("com.mysql.jdbc.Driver");
Connection conn = null;
PreparedStatement pstmt = null;
try {
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "admin");
pstmt = conn.prepareStatement("delete from jsp where id = ? ");
pstmt.setString(1, id);
pstmt.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} finally {
if(pstmt != null)
try {
pstmt.close();
} catch (Exception e) {}
if(conn != null)
try {
conn.close();
} catch (Exception e) {}
}
%>
ÀÔ·ÂÇϽŠID, Password Á¤º¸°¡ »èÁ¦µÇ¾ú½À´Ï´Ù.