Update.jsp
<%@page import="java.util.ArrayList"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ include file="./dbconfig.jsp" %>
<%
request.setCharacterEncoding("UTF-8");
String user="홍길동";
String pw="a123456";
String rno="123456";
String person="4"; //인원수 3에서 4로 바꾸기
String email="hong@nate.com"; //메일주소 바꾸기
String sql="update reservation set rperson= ?,remail=? where rnm=? and rpw=? and rno=?";
PreparedStatement ps= con.prepareStatement(sql);
ps.setString(1, person);
ps.setString(2, email);
ps.setString(3, user);
ps.setString(4, pw);
ps.setString(5, rno);
int n=0;
n=ps.executeUpdate();
if(n >0){
out.print("고객 정보가 올바르게 수정되었습니다");
}
else{
out.print("올바른 값이 아닙니다.");
}
%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>update</title>
</head>
<body>
</body>
</html>
Footer
© 2022 GitHub, Inc.
Footer navigation
Terms
Privacy
Security
Status
Docs
Update.java
package reservation;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
import java.sql.Connection;
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 update2 extends HttpServlet {
private static final long serialVersionUID = 1L;
public update2() {
}
@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 email="hong@gmail.com";
String idx="2";
try {
dbc=new dbconfig();
c=dbc.getConnection();
String sql = "update reservation set remail=? where ridx=?";
PreparedStatement ps= c.prepareStatement(sql);
ps.setString(1, email);
ps.setString(2, 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' 카테고리의 다른 글
| onkeyup, onkeydown, onkeypress, onmouseover (0) | 2022.09.05 |
|---|---|
| CKEDITOR 초간단 추가하기/ 게시판 글쓰기 에디터 (0) | 2022.09.02 |
| DB, delete하기 jsp,java mvc버전 (0) | 2022.08.30 |
| DB, insert하기 jsp,java mvc버전 (0) | 2022.08.30 |
| session, cookie 장,단점 및 사용 예시 (0) | 2022.08.17 |
댓글