[java] 오라클 연결 예제

오라클 디비 연결 예제

 

 

 

 

import java.sql.*;
import java.util.Scanner;

class OracleConnectSample
{
	public static void main( String[] args )
	{
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;

		try
		{
			Class.forName( "oracle.jdbc.driver.OracleDriver" );
			conn = DriverManager.getConnection( "jdbc:oracle:thin:@localhost:1521:orcl", "id", "pw" );
			stmt = conn.createStatement();
			rs = stmt.executeQuery( "SELECT * from CUST_PROD" );

			while( rs.next() )
			{
				String custId = rs.getString( "CUST_ID" );
				String prodCd = rs.getString( "PROD_CD" );
				int principal = rs.getInt( "PRINCIPAL" );
				String purchaseDay = rs.getString( "PURCHASE_DAY" );
				int term = rs.getInt( "TERM" );
			}
		}
		catch( SQLException sqle )
		{
			System.out.println( sqle.getMessage() );
		}
		catch( ClassNotFoundException cnfe )
		{
			System.out.println( cnfe.getMessage() );
		}

		finally
		{
			try
			{
				rs.close();
				stmt.close();
				conn.close();
			}
			catch( Exception ignoled )
			{
			}
		}
	}
}