JDBC 简单的Oracle连接

/*主要是为了看清连接逻辑，所以把异常Exception*/
import java.sql.*;
public class TestJDBC {
    public static void main(String[] args) throws Exception {
        ResultSet rs = null;
        Statement stmt = null;
        Connection conn = null;
       
            Class.forName("oracle.jdbc.driver.OracleDriver");//要引入Oracle的class12.jar
            //new oracle.jdbc.driver.OracleDriver();
            conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.1:1521:demo", "scott", "tiger");
            stmt = conn.createStatement();
            rs = stmt.executeQuery("select * from dept");
            while(rs.next()) {
                System.out.println(rs.getString("deptno"));
                System.out.println(rs.getInt("deptno"));
            }
        rs.close();
        stmt.close();
        conn.close();
        }
}