【编程】java jdbc/ojdbc 链接oracle的三种方式

二 源代码

import java.sql.Connection;
 
import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class testDB {

 public static final String DBDRIVER = "oracle.jdbc.driver.OracleDriver"; 

# public static final String DBURL = "jdbc:oracle:thin:@127.0.0.1:1521/testdb1"; //sid 格式 testdb1是sid

# public static final String DBURL = "jdbc:oracle:thin:@//127.0.0.1:1521/TDB";   //servicename TDB是service_name

 public static final String DBUSER = "test\"; 

 public static final String DBPASSWORD = \"xxx\"; 

 

 public static final String DBURL = \"jdbc:oracle:thin:@TESTDB\"; //tnsname 格式

 public static void main(String[] args) throws Exception

 {

   Connection con = null;

   PreparedStatement ps = null;

   ResultSet rs = null;

  String strSQL = \"select count(*) from tsa_dim_deal\";

# System.setProperty(\"oracle.net.tns_admin\", \"/home/admin/oracle\");//使用tnsname 方法的时候 需要制定tnsname.ora所在的文件夹绝对路径

  Class.forName(DBDRIVER).newInstance(); 

  con = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD); 

  ps = con.prepareStatement(strSQL);

  rs = ps.executeQuery();

  while(rs.next())

  {

   System.out.println(\"num:\"+rs.getString(1));

  }

  rs.close();

  ps.close(); 

  con.close(); 

 }

}