使用java连接oracle

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

public class ConnUtil {

 /**
  * @param args
  * @throws ClassNotFoundException
  * @throws SQLException
  */
 public static void main(String[] args) throws ClassNotFoundException,
   SQLException {
  // 1.准备参数
  String ip = "localhost";
  String sid = "test";
  String port = "1521";
  String dbUser = "SYS";
  String dbPassword = "liuyuxin";
  String driver = "oracle.jdbc.driver.OracleDriver";
  String url = "jdbc:oracle:thin:@" + ip + ":" + port + ":" + sid;
  // 2.构造驱动实例
  Class.forName(driver);
 /**
  * 下面方式是sys 以sysdba登陆的方法
  */
  Properties conProps = new Properties();
  conProps.put("user", dbUser);
  conProps.put("password", dbPassword);
  conProps.put("defaultRowPrefetch", "15");
  conProps.put("internal_logon", "sysdba");
  // 连接字符串是固定的形式,oracle的形式:
  Connection conn = DriverManager.getConnection(url, conProps);
 // Connection conn = DriverManager.getConnection(url, dbUser,dbPassword);//普通用户连接oracle
   String sql = "select id,username from TANCHUANG.user2 ";
   Statement stmt = conn.createStatement();
   String sql1 = "insert into TANCHUANG.user2(id,username) values('3','name12') ";//访问不在该用户下的表，需要加上方案名
   stmt.execute(sql1);
   ResultSet rs = stmt.executeQuery(sql);//执行sql语句
   while(rs.next()){
   int id = rs.getInt(1);
   String name = rs.getString(2);
   System.out.println("welcome," + name);
   }
   rs.close();
   stmt.close();
   conn.close();
  System.out.println("connection:" + conn);

 }

}