java采用jdbc的连接oracle数据库

package com.wsb.javahome; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public class JavaConnectionOracleDemo01 { /** * @param args */ public static void main(String[] args) { Connection conn = null; //Connection数据库连接对象 PreparedStatement pstmt = null; ResultSet rs = null; try { // 注册驱动 Class.forName("oracle.jdbc.driver.OracleDriver"); conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ora9","scott","tiger"); } catch (ClassNotFoundException e) { System.out.println("驱动类没有找到！"); } catch(SQLException e){ System.out.println("得到Connection数据库连接对象出错！！"); } try { pstmt = conn.prepareStatement("SELECT * FROM EMP"); rs = pstmt.executeQuery(); System.out.println("编号 \t 姓名 \t 工资"); while(rs.next()){ System.out.println(rs.getString("EMPNO") + "\t" + rs.getString("ENAME") + "\t" + rs.getString("SAL")); } }catch(SQLException e0){ System.out.println("数据库操作异常！" + e0.getMessage()); } finally{ try{ if(rs!= null){rs.close();} if(pstmt!= null){pstmt.close();} if(conn != null && !conn.isClosed()){conn.close();} }catch(SQLException e){ e.printStackTrace(); } } } }