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
'JAVA > JSP' 카테고리의 다른 글
| CKEDITOR 초간단 추가하기/ 게시판 글쓰기 에디터 (0) | 2022.09.02 |
|---|---|
| DB, update하기 jsp,java mvc버전 (0) | 2022.08.30 |
| DB, insert하기 jsp,java mvc버전 (0) | 2022.08.30 |
| session, cookie 장,단점 및 사용 예시 (0) | 2022.08.17 |
| Forward / Include 차이점 (0) | 2022.08.12 |
댓글