insert.JSP
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ include file="./dbconfig.jsp" %>
<%
request.setCharacterEncoding("UTF-8");
response.setContentType("text/html; charset=utf-8");
String sql = "insert into reservation(ridx,rnm,rpw,rno,remail,rtel,rperson,rindate) ";
sql +="values('0',?,?,?,?,?,?,?)";
PreparedStatement ps=con.prepareStatement(sql);
ps.setString(1,"홍길동");
ps.setString(2,"a123456");
ps.setString(3,"123456");
ps.setString(4,"hong@naver.com");
ps.setString(5,"01011112222");
ps.setString(6,"3");
ps.setString(7,"2022-08-15 11:42:00");
out.print(ps);
int n=0;
n=ps.executeUpdate();
if(n>0){
out.print("올바르게 저장되었습니다.");
}
else{
out.print("올바른 값이 아닙니다.");
}
%>
insert.java (Class)
web.xml에 매핑해주기.
protected void service에 만들어주기
package reservation;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
import java.sql.PreparedStatement;
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 insert2 extends HttpServlet {
private static final long serialVersionUID = 1L;
public insert2() {
}
@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();
dbconfig dbc=null;
Connection con2=null;
int n=0;
try {
dbc= new dbconfig(); //dbconfig.java
con2=dbc.getConnection(); //dbconfig class=>getConnection() (메소드를 가져옴)
String sql = "insert into reservation(ridx,rnm,rpw,rno,remail,rtel,rperson,rindate) ";
sql +="values('0',?,?,?,?,?,?,?)";
PreparedStatement ps=con2.prepareStatement(sql);
ps.setString(1,"홍길동");
ps.setString(2,"a123456");
ps.setString(3,"123456");
ps.setString(4,"hong@naver.com");
ps.setString(5,"01011112222");
ps.setString(6,"3");
ps.setString(7,"2022-08-15 11:42:00");
n=0;
n=ps.executeUpdate();
if(n>0){
pw.write("입력되었습니다.");
}
else{
}
}
catch(Exception e) {
}
finally {
try {
if(n>0) {
con2.close();
}
}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' 카테고리의 다른 글
DB, update하기 jsp,java mvc버전 (0) | 2022.08.30 |
---|---|
DB, delete하기 jsp,java mvc버전 (0) | 2022.08.30 |
session, cookie 장,단점 및 사용 예시 (0) | 2022.08.17 |
Forward / Include 차이점 (0) | 2022.08.12 |
현재 시각 mysql 에 입력하기 / 값 전달 (0) | 2022.08.11 |
댓글