67,516
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE `customer` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(80) DEFAULT NULL,
`age` smallint(6) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
)
public static void main(String[] args)throws Exception{
String driver="com.mysql.jdbc.Driver";
String url="jdbc:mysql://localhost:3306/TEST?useUnicode=true&characterEncoding=UTF-8";
String user="root";
String password="root";
Class.forName(driver);
Connection conn= DriverManager.getConnection(url,user,password);
DatabaseMetaData dbmd=conn.getMetaData();
//下面判断是否支持可滚动结果集
if(dbmd.supportsResultSetType(ResultSet.TYPE_SCROLL_INSENSITIVE)){
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
ResultSet rs=stmt.executeQuery("select * from customer");
//一下是传统的遍历方法
while(rs.next()){
int id=rs.getInt("id");
int age=rs.getInt("age");
String name=rs.getString("name");
System.out.println("id="+id+",age="+age+",name="+name);
}
//传统遍历方法结束
// rs.first();
rs.absolute(5); //直接跳转到第五行
//以下取出第五行的数据,只有三列分别取数据
int id=rs.getInt("id");
int age=rs.getInt("age");
String name=rs.getString("name");
System.out.println("第五行输出:id="+id+",age="+age+",name="+name);
//关闭数据库连接,释放资源
rs.close();
stmt.close();
conn.close();
}else{
System.out.println("数据库不支持可滚动结果集");
}
}