JSP/DB (2)

chapter02 : insert_one

GAWON 2023. 5. 24. 18:54 
<%@page import="org.joonzis.db.DBConnect"%>
<%@page import="java.sql.*"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%
	// 전달 받은 파라미터들 가지고 insert 
	// 데이터 삽입이 성공을 하던, 실패를 하던
	// view_all.jsp로 이동 (데이터 삽입 확인 용도)
	request.setCharacterEncoding("utf-8");
	String id = request.getParameter("id");
	String pw = request.getParameter("pw");
	String name = request.getParameter("name");
	String age = request.getParameter("age");
	String addr = request.getParameter("addr");
	
	Connection conn = null;
	PreparedStatement ps = null;
	
	try {
		conn = DBConnect.getConnection();
		
		String sql = "insert into member" +
		" values(member_seq.nextval, ?, ?, ?, ?, ?, sysdate)";
		ps = conn.prepareStatement(sql);
		
		ps.setString(1, id);
		ps.setString(2, pw);
		ps.setString(3, name);
		ps.setInt(4, Integer.parseInt(age));
		ps.setString(5, addr);
		
		int result = ps.executeUpdate();
		
		response.sendRedirect("view_all.jsp");
	} catch (Exception e) {
		e.printStackTrace();
		response.sendRedirect("view_all.jsp");
	} finally {
		try {
			if(ps != null) {ps.close();}
			if(conn != null) {conn.close();}
		} catch (Exception e2) {
			e2.printStackTrace();
		}
	}
	

%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>

</body>
</html>