connectoracledemo.java

来自「java课件 java课件 java课件 java课件」· Java 代码 · 共 34 行

import java.sql.*;
public class ConnectOracleDemo{
  public static void main(String args[]){
    try{
     Class.forName("oracle.jdbc.driver.OracleDriver"); 
    //DriverManager.registerDriver(
    //new oracle.jdbc.driver.OracleDriver());
     String url="jdbc:oracle:thin:@localhost:1521:oracle";
     String user = "scott";
     String password = "tiger";
     Connection conn =
        DriverManager.getConnection(url,user,password);
     String sql = "select * from student";
     Statement stmt = conn.createStatement();
     ResultSet rst = stmt.executeQuery(sql);
     while(rst.next()){
       System.out.println(rst.getString(1)+"  "+rst.getString(2)+
                         "  "+rst.getString(3)+
                         "  "+rst.getInt(4)+
                         "  "+rst.getString(5));
     }
     System.out.println("Correct");
     try{
       rst.close();
       stmt.close();
       conn.close();
     }catch(Exception e){}
    }catch(Exception e){
      System.out.println(e);
    }
  }
}