[정보처리산업기사 | 실기] INSERT/UPDATE 분기 처리

INSERT

<input type="hidden" name="action" value="insert">

UPDATE

<input type="hidden" name="action" value="update">

 

from 태그 내, hidden filed를 두고 파라미터를 받기위해 name을 설정하고 value를 지정한다.

form 태그의 action 속성에 둘 다 같은 jsp 파일을 지정한다.

 

<%@page import="java.sql.ResultSet"%>
<%@include file="db.jsp" %>
<%@page import="java.sql.PreparedStatement"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%
request.setCharacterEncoding("UTF-8");
String custno = request.getParameter("custno");
String custname = request.getParameter("custname");
String phone = request.getParameter("phone");
String address = request.getParameter("address");
String joindate = request.getParameter("joindate");
String grade = request.getParameter("grade");
String city = request.getParameter("city");

String action = request.getParameter("action");

if(action.equals("insert")) {
	action = "insert into member_tbl_02 values(?,?,?,?,?,?,?)";
	try {
		PreparedStatement pstmt = c.prepareStatement(action);
		pstmt.setString(1, custno);
		pstmt.setString(2, custname);
		pstmt.setString(3, phone);
		pstmt.setString(4, address);
		pstmt.setString(5, joindate);
		pstmt.setString(6, grade);
		pstmt.setString(7, city);
		
		pstmt.executeQuery();
	} catch(Exception e) {
		e.printStackTrace();
	}
} else if(action.equals("update")){
	action = "update member_tbl_02 set custname=?, phone=?, address=?, joindate=?, grade=?, city=? where custno = ?";
	try {
		PreparedStatement pstmt = c.prepareStatement(action);
		pstmt.setString(1, custname);
		pstmt.setString(2, phone);
		pstmt.setString(3, address);
		pstmt.setString(4, joindate);
		pstmt.setString(5, grade);
		pstmt.setString(6, city);
		pstmt.setString(7, custno);
		
		pstmt.executeUpdate();
	} catch(Exception e) {
		e.printStackTrace();
	}
}
%>

<jsp:forward page="index.jsp"></jsp:forward>

if문에 Connection은 아닌 것 같은데.. DB에 보내야 할 컬럼 순서가 달라서 어쩔 수 없었다.