import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class GetOracleConnection{
/** Oracle数据库连接URL*/
private final static String DB_URL = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
/** Oracle数据库连接驱动*/
private final static String DB_DRIVER = "oracle.jdbc.driver.OracleDriver";
/** 数据库用户名*/
private final static String DB_USERNAME = "global";
/** 数据库密码*/
private final static String DB_PASSWORD = "odps";
/**
* 获取数据库连接
* @return
* @throws SQLException
*/
public void getConnection(){
/** 声明Connection连接对象*/
Connection conn = null;
Statement st=null;
ResultSet rs=null;
try{
/** 使用Class.forName()方法自动创建这个驱动程序的实例且自动调用DriverManager来注册它*/
Class.forName(DB_DRIVER);
/** 通过DriverManager的getConnection()方法获取数据库连接*/
conn = DriverManager.getConnection(DB_URL,DB_USERNAME,DB_PASSWORD);
System.out.println("连接数据库成功!");
/**采用Statement进行查询 */
st = conn.createStatement();
rs = st.executeQuery("select * from tab001");
while(rs.next()) {
/**打印字段信息 */
System.out.println(rs.getString("content"));
}
}catch(Exception ex){
ex.printStackTrace();
}finally{
/**注:一定要记得关闭连接,否则后果很严重的!*/
try {
rs.close();
st.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public static void main(String[] args){
(new GetOracleConnection()).getConnection();
}
}