자바 JDBC 연동, 오라클 계정 생성

Database

자바 JDBC 연동, 오라클 계정 생성

philo0407 2020. 10. 4. 23:37

while(rs.next()) {
  String title = rs.getString("TITLE");
  System.out.println(title);
}

결과부터,

package ex1;

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

public class Program {

	public static void main(String[] args) {
		Connection conn = null;

		String url = "jdbc:oracle:thin:@localhost:1521:xe"; 
																												
		String id = "c##philz"; // 앞에 .. 망할 c##을 붙여줘야 함 ㅠㅠ
		String pw = "1234";

		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");

			conn = DriverManager.getConnection(url, id, pw);
			System.out.println(conn.isClosed() ? "접속종료" : "접속중");
																														

			conn.close();
			System.out.println(conn.isClosed() ? "접속종료" : "접속중");
																														

		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}

"아직 미해결"

	public static void main(String[] args) {
		String url = "jdbc:oracle:thin:@localhost:1521:xe"; 
		String id = "c##philz"; // 앞에 .. 망할 c##을 붙여줘야 함 ㅠㅠ
		String pw = "1234";
		
		String sql = "SELECT * FROM NOTICE";
		
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			
			Connection con = DriverManager.getConnection(url, id, pw);
			System.out.println(con.isClosed()? "접속 종료" : "접속 중");
			
			Statement st = con.createStatement();
			ResultSet rs = st.executeQuery(sql);
			
			rs.next();
			String title = rs.getString("TITLE");
			System.out.println(title);
			
			rs.close();
			st.close();
			con.close();
			
		} catch (Exception e) {
			e.printStackTrace();
		}
	}