Oracle - 데이터 베이스 연결

2020.08.03(월)

E-R Diagram

1. 데이터베이스

 1) try~catch

 2) ~VO

 3) ArrayList

 

EmpVO

package com.sist.db;
/*
 * EMPNO             NOT NULL NUMBER(4) => int
   ENAME             VARCHAR2(10)=> String
   JOB               VARCHAR2(9) => String
   MGR               NUMBER(4) => int
   HIREDATE          DATE => java.util.Date
   SAL               NUMBER(7,2) => int (double)
   COMM              NUMBER(7,2) => int (double)
   DEPTNO            NUMBER(2) => int (double)
 */
import java.util.*;
public class EmpVO {
	private int empno; // 사번
	private String ename; // 이름
	private String job; // 직위
	private int mgr; // 사수번호
	private Date hiredate; // 입사일
	private int sal; // 급여
	private int comm; // 성과금
	private int deptno; // 부서번호
	public int getEmpno() {
		return empno;
	}
	public void setEmpno(int empno) {
		this.empno = empno;
	}
	public String getEname() {
		return ename;
	}
	public void setEname(String ename) {
		this.ename = ename;
	}
	public String getJob() {
		return job;
	}
	public void setJob(String job) {
		this.job = job;
	}
	public int getMgr() {
		return mgr;
	}
	public void setMgr(int mgr) {
		this.mgr = mgr;
	}
	public Date getHiredate() {
		return hiredate;
	}
	public void setHiredate(Date hiredate) {
		this.hiredate = hiredate;
	}
	public int getSal() {
		return sal;
	}
	public void setSal(int sal) {
		this.sal = sal;
	}
	public int getComm() {
		return comm;
	}
	public void setComm(int comm) {
		this.comm = comm;
	}
	public int getDeptno() {
		return deptno;
	}
	public void setDeptno(int deptno) {
		this.deptno = deptno;
	}
	
}

 

EmpMain

package com.sist.db;
import java.sql.*;
import java.util.*;

public class EmpMain {

	public static void main(String[] args) {
		try {
			// 오라클 연결 => 드라이버 설치
			Class.forName("oracle.jdbc.driver.OracleDriver");
			// 오라클 연결
			// 오라클 주소
			String url = "jdbc:oracle:thin:@localhost:1521:XE";
			Connection conn = DriverManager.getConnection(url, "hr", "happy");
			// 오라클에 명령문 전송
			String sql = "SELECT empno, ename, job, sal FROM emp "
					+"WHERE empno=7788";
			PreparedStatement ps = conn.prepareStatement(sql); // 오라클에 
			// 실행된 데이터를 읽어 오기
			ResultSet rs = ps.executeQuery();
			// 출력
			while(rs.next()) {
				System.out.println(rs.getInt(1)+" "+rs.getString(2)+" "+rs.getString(3)+" "+rs.getInt(4));
			}
		}catch(Exception ex) {
			System.out.println(ex.getMessage());
		}

	}

}