JDBC DAO insert 추가 예제

[2pro]

dao(2).zip

 package dao.test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

public class MemberDAO {
 private  static  MemberDAO    instance ;
// private   static  Connection  conn;
 private     Connection  conn;
 private  Statement    stmt;
 /**
  *   private적인 생성자를 만드는 이유:
  *   한개의 app에서 여러개의 connection을 유발시키지 않으려고 
 *   instance 와 connection 까지 설정
  */
 private MemberDAO(){
  
   String url="jdbc:oracle:thin:@122.36.151.6:1521:oracle";
   String user="scott";
   String password="tiger";
   try {
    Class.forName("oracle.jdbc.driver.OracleDriver");
    conn=DriverManager.getConnection(url, user, password);
    System.out.println("connection ok");
   } catch (ClassNotFoundException e) {
    // TODO Auto-generated catch block
    System.err.println(e.getMessage()+" ::  Driver Loading 실패");
   }catch (SQLException e) {
    // TODO Auto-generated catch block
    System.err.println(e.getMessage()+" :: connection 문제"+
      url+"/"+user+"/"+password);
   }
  
 }
 /**
  *  member테이블의 모든 내용을 리턴
  *   메소드명 : memberAllList()
  * @return
  */
 public ArrayList<MemberBean> memberAllList(){
  String sql="select * from member";
  ResultSet rest=null;
  try {
   stmt=conn.createStatement();
   rest=stmt.executeQuery(sql);
   ArrayList<MemberBean>temp=new ArrayList<MemberBean>();
   while(rest.next()){
    MemberBean  bean = new MemberBean();
    bean.setMid(rest.getString("mid"));
    bean.setMname(rest.getString("mname"));
    bean.setMadd(rest.getString("madd"));
    temp.add(bean);
   }
   return temp;
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   System.out.println(e.getMessage()+"::  sql 문장 오류"+sql);
  }finally{
   try {
    if(rest!=null)rest.close();
    if(stmt!=null)stmt.close();
   } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }
   System.out.println("memberAllList() finally end");
  }
  return null;
 }
 /**
  *   회원번호가 일치하는 회원의 정보를 리턴
  */
 public  MemberBean   member(String mid){
  String sql="select  *  from  member  where  mid='"+mid+"'";
  ResultSet  rest=null;
  try {
   stmt=conn.createStatement();
   rest=stmt.executeQuery(sql);
   MemberBean  temp=new MemberBean();
   if(rest.next()){
    temp.setMid(   rest.getString("mid") );
    temp.setMname( rest.getString("mname"));
    temp.setMadd( rest.getString("madd"));
   }
   return temp;
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   System.out.println(e.getMessage()+"::  sql 문장 오류"+sql);
  }finally{
   
    try {
     if(rest!=null)rest.close();
     if(stmt!=null)stmt.close();
    } catch (SQLException e) {
     // TODO Auto-generated catch block
     e.printStackTrace();
    }
   
  }
  return  null;
 }
 /**
  * 신규회원을 처리하는 메소드
  *   memberInsert(MemberBean)
  *  
  */
 public boolean memberInsert(MemberBean bean){
  String sql_stat="insert  into  member  values " +
 "('"+bean.getMid()+"','"+bean.getMname()+"','"+bean.getMadd()+"')";
  String sql ="insert into member  values (?,?,?)";
  PreparedStatement  pstmt=null;
  //ResultSet rest=null;
  try{
  // stmt=conn.createStatement();
   pstmt=conn.prepareStatement(sql);
   
   //int count=stmt.executeUpdate(sql_stat);
   pstmt.setString( 1  , bean.getMid());
   pstmt.setString(2, bean.getMname());
   pstmt.setString( 3  , bean.getMadd());
   int  count=pstmt.executeUpdate();
   if(count>=1)return true;
  }catch (SQLException e) {
   e.printStackTrace();
  }
  
  return false;
 }
 
 
 
 
 /**
  * 회원번호와 이름이 일치 그 회원삭제
  */
 /**
  * 회원번호와 이름이 일치 그 회원  주소 편집
  */
 
 public  static   MemberDAO  getInstance(){
  //return  new MemberDAO();
  if(instance==null){
   instance=new  MemberDAO();
   /*String url="jdbc:oracle:thin:@122.36.151.6:1521:oracle";
   String user="scott";
   String password="tiger";
   try {
    Class.forName("oracle.jdbc.driver.OracleDriver");
    conn=DriverManager.getConnection(url, user, password);
    System.out.println("connection ok");
   } catch (ClassNotFoundException e) {
    // TODO Auto-generated catch block
    System.err.println(e.getMessage()+" ::  Driver Loading 실패");
   }catch (SQLException e) {
    // TODO Auto-generated catch block
    System.err.println(e.getMessage()+" :: connection 문제"+
      url+"/"+user+"/"+password);
   }*/
  }
  return instance;
 }
}

//////////////////////////////

package dao.test;

import java.util.ArrayList;

public class MemberUseApp {

 public static void main(String[] args) {
  // TODO Auto-generated method stub
  //MemberDAO   dao = new MemberDAO;
  MemberDAO   dao1=MemberDAO.getInstance();
  MemberDAO   dao2=MemberDAO.getInstance();
  MemberDAO   dao3=MemberDAO.getInstance();
  MemberBean  bean= dao1.member("m003");
   System.out.println(bean.getMname());
  
  ArrayList<MemberBean> list= dao2.memberAllList();
  MemberBean  bean2=new MemberBean();
   bean2.setMid("m1234");
   bean2.setMname("sample");
   bean2.setMadd("주소");
   
  System.out.println(dao3.memberInsert(bean2));
 }

}