oracle数据库的连接代码

package exam;

import java.sql.DriverManager;//驱动器的管理用以选择驱动器创建连接

import java.sql.Connection;//代表与某一数据库的链接，支持sql声明的创建

import java.sql.Statement;//在链接中执行静态的sql声明，并取得执行结果  

import java.sql.ResultSet;//代表执行sql声明后产生的数据结果

import java.sql.SQLException;

public class TestDB {

public static void main(String[] args) {

   try{

    Class.forName("oracle.jdbc.driver.OracleDriver");//java驱动程序

    String url = "jdbc:oracle:thin:@127.0.0.1:1521:WORKDB";//url串

   Connection conn = DriverManager.getConnection(url,"dbtest","123456");//连接数据库的url串,用户密码,用户名;

    Statement stmt = conn.createStatement();//创建数//据库通道

   // ResultSet rs = stmt.executeQuery("select * from song");//创建数据库结果集
   // ResultSet rs = stmt.executeQuery("insert into BJXXB(bh,bjmc,bzxh) values('6','song','qiang')");
   // ResultSet rs = stmt.executeQuery("select * from BjXXB");
    //ResultSet rs= stmt.executeQuery("delete from BJXXB where BH=2");
    //ResultSet rs = stmt.executeQuery("select * from BjXXB");
  //  ResultSet rs = stmt.executeQuery("update bjxxb set bjmc='luo' where bh=1");
    ResultSet rs = stmt.executeQuery("SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT * FROM BJXXB) A WHERE ROWNUM <= 5)WHERE RN >= 1");
    while(rs.next()){
      System.out.println("bjmc:"+rs.getString(3));
      System.out.println("bh:"+rs.getString(1));
    // System.out.println("name:"+rs.getString(1));
     //System.out.println("name:"+rs.getString(2));
    //System.out.println("id:"+res.getInt(1));
    //System.out.println("id:"+rs.getInt(2));
   
    }

    rs.close();//关闭结果集

    stmt.close();//关闭结果集通道

    conn.close();//关闭数据库连接

   }catch(ClassNotFoundException e){

    e.printStackTrace();

    System.out.println("找不到服务!");

   }catch(SQLException e){

    e.printStackTrace();

   }

}

}