[JAVA] 오라클 DB연결2

EMP 테이블에서 사번, 이름, 급여, 급여등급을 검색하여

console 창에 출력

#executeQuery

package db_test2;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class JDBC_Ex2 {

	public static void main(String[] args) {
		
		Connection conn;
		Statement stmt = null;
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			String db_url = "jdbc:oracle:thin:@localhost:1521:xe";
			String db_id = "SYSTEM";
			String db_pw = "test1234";
			conn = DriverManager.getConnection(db_url, db_id, db_pw);
			System.out.println("DB 연결 완료");
			
			
			stmt = conn.createStatement();
			ResultSet srs = stmt.executeQuery
					("SELECT EMPNO,ENAME, SAL, GRADE "
					+ "FROM EMP "
					+ "INNER JOIN SALGRADE ON SAL BETWEEN LOSAL AND HISAL");
			printData(srs, "EMPNO","ENAME","SAL","GRADE");
			
			
			

		} catch (ClassNotFoundException e) {
			System.out.println("JDBC 드라이버 로드 오류");
		} catch (SQLException e) {
			System.out.println("DB 연결 오류");
		}
	}
	
	
	// 레코드의 각 열의 값 화면의 출력
	private static void printData(ResultSet srs, String col1, String col2, String col3, String col4)
			throws SQLException {
		while (srs.next()) {
			if (!col1.equals(""))
				System.out.print(srs.getString("EMPNO"));
			if(!col2.equals(""))
				System.out.print("\t|\t" + srs.getString("ENAME"));
			if(!col3.equals(""))
				System.out.print("\t|\t" + srs.getString("SAL"));
			if(!col4.equals(""))
				System.out.println("\t|\t" + srs.getString("GRADE"));
			else
				System.out.println();
			
		}
	}
	
	

}