JAVA/JSP
DB, delete하기 jsp,java mvc버전
java나유
2022. 8. 30. 16:59
delete.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ include file="./dbconfig.jsp"%>
<%
request.setCharacterEncoding("UTF-8");
String idx="1";
String sql="delete from reservation where ridx=?";
PreparedStatement ps = con.prepareStatement(sql);
ps.setString(1, idx);
int n=0;
n=ps.executeUpdate();
if(n>0){
out.print("예약을 취소하셨습니다.");
}
%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>delete</title>
</head>
<body>
</body>
delete.java
package reservation;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class delete2 extends HttpServlet {
private static final long serialVersionUID = 1L;
public delete2() {
}
@Override
protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
req.setCharacterEncoding("utf-8");
resp.setContentType("text/html;charset=utf-8");
PrintWriter pw = resp.getWriter();
int n=0;
dbconfig dbc=null;
Connection c=null;
String idx="2";
try {
dbc=new dbconfig();
c=dbc.getConnection();
String sql="delete from reservation where ridx=?";
PreparedStatement ps = c.prepareStatement(sql);
ps.setString(1, idx);
ps.executeUpdate();
pw.write("정상적으로 예약이 취소되었습니다.");
}
catch(Exception e) {
}
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
}
}
728x90