oraclejdbcthin.java

java多种方式连接Oracle数据库的例子。

/*
 * Created on 2005-2-18
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */

/**
 * @author Administrator
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */

import java.sql.*;
//import oracle.jdbc.driver.OracleDriver;

public class OracleJdbcThin {
	
	private Connection con;
	private Statement stmt;
	private ResultSet rs;
	
	public OracleJdbcThin()
	{
		try {
    	    Class.forName("oracle.jdbc.driver.OracleDriver");
    	    con = DriverManager.getConnection("jdbc:oracle:thin:@fuchong:1521:DBSERVER","scott","tiger");
            stmt = con.createStatement();
		} catch(ClassNotFoundException e) {
		    System.out.println(e.getMessage());
		} catch(SQLException e) { 
		    System.out.println(e.getMessage());
		}    
	}
	
	public ResultSet excuteQuery(String SQL_stmt)
	{
		try {
		    rs = stmt.executeQuery(SQL_stmt);
		} catch(SQLException e) { 
		    System.out.println(e.getMessage());
		}
		return rs;
	}	
    
	public static void main(String[] args)
    {
    	String SQL_stmt = "select empno, ename, hiredate, sal from emp";
        OracleJdbcThin instance = new OracleJdbcThin();
        ResultSet rs = instance.excuteQuery(SQL_stmt);
            
        try { 
        	while(rs.next()) {
           	System.out.print(rs.getInt("empno") + "  ");
           	System.out.print(rs.getString("ename") + "  ");
           	System.out.print(rs.getDate("hiredate") + "  ");
           	System.out.print(rs.getDouble("sal") + "  ");
           	System.out.println(""); }
        } catch(SQLException e) { 
    	    System.out.println(e.getMessage());
    	}
    }    
}