package com.jdbc;
import java.sql.Connection;import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;import java.sql.Statement;
/* * 加载驱动 */
public class TestConnection {
/** * @param args */
public static void main(String[] args) {
// TODO Auto-generated method stub
Connection conn = null ;
Statement st = null ;
try {
//1.加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver") ;
//2.创建连接（注册）驱动 连接
String url = "jdbc:oracle:thin:@127.0.0.1:1521:student" ;
String user = "scott" ;
String psd = "tiger" ;
conn = DriverManager.getConnection(url, user, psd) ;
System.out.println("hello!");
//3. 会话
st = conn.createStatement() ;
String sql = "select * from dept " ;
//4.SQL的执行
ResultSet rs = st.executeQuery(sql) ;
//5.输出结果集
while(rs.next()){
System.out.println(rs.getLong("deptno") +"\t"+rs.getString("dname") +"\t"+ rs.getString("loc"));}}
catch (ClassNotFoundException e)
{// TODO Auto-generated
catch blocke.printStackTrace();
}
catch (SQLException e) {
// TODO Auto-generated
catch blocke.printStackTrace();
}
finally{
try {
//6. 关闭驱动
st.close() ;
conn.close() ;
}
catch (SQLException e) {
// TODO Auto-generated catch blocke.printStackTrace();}}
}
}