学步园

1、注册驱动

Class.forName("oracle.jdbc.driver.OracleDriver"):

2、建立连接

Connection con = DriverManager.getConnection("jdbc:oracle:thin:@120.0.0.1:1521:mydatabase","admin","admin");

3、创建Statement

Statement st = con.createStatement();

4、执行SQL语句

ResultSet rs = st.executeQuery(sql);

5、处理结果集

while(rs.next){

rs.getString("name");

rs.getInt("age");

}

6、关闭连接

con.close();