본문 바로가기
JAVA/JSP

DB, insert하기 jsp,java mvc버전

by java나유 2022. 8. 30.

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

댓글