java jdbc 测试连接oracle数据库

首相导入oracle jdbc jar ，如果安装了oracle，jar包就在oracle的安装目录app\Administrator\product\11.2.0\dbhome_1\jdbc\lib，如果没有的话从我这里下载。

package test;
import java.sql.*;

public class TestJDBC {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub

		Connection conn = null;
		Statement stmt = null;
		String sql = null;
		ResultSet rs = null;

		try{
			Class.forName("oracle.jdbc.driver.OracleDriver");
			conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl","scott","tiger");
			stmt = conn.createStatement();
			sql = "select * from emp";
			rs = stmt.executeQuery(sql);
			while(rs.next()) {
				System.out.println("empno is : " + rs.getString(1) + " , ename is : " + rs.getString(2));
			}
		} catch(Exception e) {
			e.printStackTrace();
		} finally{
			try {
				if(rs != null) rs.close();
				if(stmt != null) stmt.close();
				if(conn != null) conn.close();
			} catch(Exception e) {
				e.printStackTrace();
			}

		}

	}

}