连接oracle数据库代码,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();

}

}

}