<%@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>
