31_jsp_java_DTO(bean)_DAO_insert처리_jsp

Mdao 안에 insert 처리 메서드를 작성한다.

쿼리문을 작성하는 클래스

패키지 명	kr.or.ksmart.dao
클래스 명	Mdao

package kr.or.ksmart.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import kr.or.ksmart.dto.Member;

public class Mdao {
	PreparedStatement pstmt=null;
	//01_01 mInsert 입력 처리 메서드 ( 입력 2개 )
	public void mInsert(Member m,Connection conn) throws SQLException {
		//03 단계 쿼리 실행 준비 ~ 07 단계 객체 종료
		pstmt=conn.prepareStatement("INSERT INTO tb_member VALUES(?,?,?,?,?)");
		pstmt.setString(1,m.getM_id());
		pstmt.setString(2,m.getM_pw());
		pstmt.setString(3,m.getM_level());
		pstmt.setString(4,m.getM_name());
		pstmt.setString(5,m.getM_email());
		int result=pstmt.executeUpdate();
		System.out.println(result);
		pstmt.close();
		conn.close();

	}
}

 

//m_insert_action.jsp
<%@page import="kr.or.ksmart.dao.Mdao"%>
<%@page import="kr.or.ksmart.driverdb.DriverDB"%>
<%@ page language="java" contentType="text/html; charset=EUC-KR"
	pageEncoding="EUC-KR"%>
<%@ page import="java.sql.Connection"%>
<%@ page import="java.sql.PreparedStatement"%>
<%@ page import="java.sql.SQLException"%>
<jsp:useBean id="m" class="kr.or.ksmart.dto.Member" />
<jsp:setProperty name="m" property="*" />
<%
	request.setCharacterEncoding("euc-kr");
	Connection conn = null;
	DriverDB db = new DriverDB();
	conn = db.driverDbcon();

	Mdao mdao = new Mdao();
	mdao.mInsert(m,conn);

	response.sendRedirect(request.getContextPath() + "/msearch/m_search_list.jsp");
%>