JDBC

JDBC INSERT, SELECT 연습하기

1.1 Vo_1

SQL SELECT 구문으로 List<Vo> 객체에 저장하여 조회
executeQuery();

• Application.java
  • jdbc 계정 연결 클래스
• Dao.java
  • Dao 클래스
• Vo.java
  • Vo 클래스
• run.java
  • 실행 클래스

실습 테이블 : emp01

1.1. Application.java

package Vo_1;

import java.sql.Connection;
import java.sql.DriverManager;

  public class Application {
      Connection conn;
      public static String JDBC_URL = "jdbc:oracle:thin:@localhost:1521:XE";
      public static String JDBC_USER = "song";
      public static String JDBC_PW ="1234";

      public Application() {

          try {

              Class.forName("oracle.jdbc.driver.OracleDriver");
              conn = DriverManager.getConnection(JDBC_URL, JDBC_USER, JDBC_PW);			
          } catch (Exception e) {
              // TODO Auto-generated catch block
              e.printStackTrace();
          }

      }

      public Connection getConn() {
          return conn;
      }
  }  

1.2. Vo.java

package Vo_1;

import java.sql.Date;

public class Vo {
	private long EMPNO;
	private String ENAME;
	private String JOB;
	private String MGR;
	private Date HIREDATE;
	private long SAL;
	private long COMM;
	private long DEPTNO;
	
	public long getEMPNO() {
		return EMPNO;
	}
	public void setEMPNO(long eMPNO) {
		EMPNO = eMPNO;
	}
	public String getENAME() {
		return ENAME;
	}
	public void setENAME(String eNAME) {
		ENAME = eNAME;
	}
	public String getJOB() {
		return JOB;
	}
	public void setJOB(String jOB) {
		JOB = jOB;
	}
	public String getMGR() {
		return MGR;
	}
	public void setMGR(String mGR) {
		MGR = mGR;
	}
	public Date getHIREDATE() {
		return HIREDATE;
	}
	public void setHIREDATE(Date hIREDATE) {
		HIREDATE = hIREDATE;
	}
	public long getSAL() {
		return SAL;
	}
	public void setSAL(long sAL) {
		SAL = sAL;
	}
	public long getCOMM() {
		return COMM;
	}
	public void setCOMM(long cOMM) {
		COMM = cOMM;
	}
	public long getDEPTNO() {
		return DEPTNO;
	}
	public void setDEPTNO(long dEPTNO) {
		DEPTNO = dEPTNO;
	}

	@Override
	public String toString() {
		return "Vo [EMPNO=" + EMPNO + ", ENAME=" + ENAME + ", JOB=" + JOB + ", MGR=" + MGR + ", HIREDATE=" + HIREDATE
				+ ", SAL=" + SAL + ", COMM=" + COMM + ", DEPTNO=" + DEPTNO + "]";
	}

}

1.3. Dao.java

package Vo_1;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

  public class Dao {
      Connection conn;
      PreparedStatement ps;
      ResultSet rs;

      public Dao() {
          conn = new Application().getConn();
      }

      public List<Vo> getUsers() {
          List<Vo> list = new ArrayList<>();

          String sql = "SELECT * FROM emp01";

          try {
              ps = conn.prepareStatement(sql);
              rs = ps.executeQuery();


              while(rs.next()) {
                  Vo vo = new Vo();
                  vo.setEMPNO(rs.getInt("empno"));
                  vo.setENAME(rs.getString("ename"));

                  list.add(vo);

                  for(Vo v : list) {
                      System.out.println(v);
                  }
              }

          } catch (SQLException e) {
              // TODO Auto-generated catch block
              e.printStackTrace();
          }

          return list;

      }

  }

1.4. run.java

package Vo_1;

  public class run {
      public static void main(String[] args) {
          Dao dao = new Dao();
          dao.getUsers();
      }
  }

References

• 🎈2020.12.17