package com.chapter04;

import java.sql.*;
import java.util.*;

import com.servlet.*;


public class MemberCtrl {
	 private DBConnectionMgr pool = null;
	 private Connection con = null;
	 private PreparedStatement pstmt = null;
	 private StringBuffer query = null;
	 /*
	  * ȸ¿øÁ¤º¸ ÀÔ·Â ±¸Çö
	  * @param : MemberVO vo
	  * @return : count
	  */ 
	 public int insertDB(MemberVO uiVO){
		 int count = 0;
		 int i = 0;
		 query = new StringBuffer();
		 query.append("INSERT INTO member values(?,?,?,?,?)");
		 pool = DBConnectionMgr.getInstance();
		 try {
			 con = pool.getConnection();
			 pstmt = con.prepareStatement(query.toString());
			 pstmt.setString(++i,uiVO.getMem_id());
			 pstmt.setString(++i,uiVO.getMem_pw());
			 pstmt.setString(++i,HangulConversion.toKor(uiVO.getMem_name()));
			 pstmt.setString(++i,uiVO.getMem_email());
			 pstmt.setString(++i,uiVO.getMem_tel());
			 count = pstmt.executeUpdate();
		 }catch(SQLException s){
		   System.out.println("=====================================================");
		   System.out.println(query.toString());
		   System.out.println("=====================================================");
		   System.out.println(s.toString());
		 }catch(Exception e) {
			System.out.println(e.toString());
		 }finally{
			 pool.freeConnection(con,pstmt);
		 }
		   return count;
	 }
}