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;
	 
	 private Statement stmt = null;
	 private ResultSet rs = 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;
	 }
	 
	 /*
	  * ȸ¿øÁ¤º¸¸ñ·Ï
	  * @return ArryList 
	  */
	public ArrayList memberList() {
		ArrayList memAList = null;
		pool = DBConnectionMgr.getInstance();
		query = new StringBuffer();
		query.append("SELECT mem_name, mem_id, mem_email, mem_tel");
		query.append(" FROM member");
		memAList = new ArrayList();
		int count = 0;
		try {
			con = pool.getConnection();
			pstmt = con.prepareStatement(query.toString());
			rs = pstmt.executeQuery();
			while(rs.next()) {
				memAList.add(rs.getString(1));
				memAList.add(rs.getString(2));
				memAList.add(rs.getString(3));
				memAList.add(rs.getString(4));
			}
		} catch (SQLException s) {
			System.out.println("====================================");
			System.out.println("query : " + query.toString());
			System.out.println("====================================");
			System.out.println(s.toString());
		} catch (Exception e) {
			System.out.println(e.toString());
		}finally{
			pool.freeConnection(con,pstmt,rs);
		}
		return memAList; 
	 }
}