在ResultSet接口定义了如下的方法:
·向下移动指针判断是否有数据行:public boolean next()throws SQLException;
·取出数据内容:getInt(), getDouble(), getString() ,getDate()
范例:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Date;
public class OracleDemo {
private static final String DBDRIVER = "oracle.jdbc.driver.OracleDriver";
private static final String DBURL = "jdbc:oracle:thin:@localhost:1521:acehzh";
private static final String USER = "scott";
private static final String PASSWORD = "tiger";
public static void main(String[] args) throws Exception {
// 1.加载驱动
Class.forName(DBDRIVER);
// 2.连接数据库
Connection conn = DriverManager.getConnection(DBURL, USER, PASSWORD);
// 3.操作数据库
Statement sta = conn.createStatement();
String sql = "SELECT mid,name,birthday,age,note " + " FROM member";
ResultSet rs = sta.executeQuery(sql);
while (rs.next()) {
int mid = rs.getInt(1);
String name = rs.getString(2);
Date birthday = rs.getDate(3);
int age = rs.getInt(4);
String note = rs.getString(5);
System.out.println(mid + "," + name + "," + birthday + "," + age + "," + note);
}
rs.close();
conn.close();
}
}
![](https://i-blog.csdnimg.cn/blog_migrate/91795b30a3f22995321d1ba5abc9fa99.png)