java resultset封装_java常用知识:jdbc的常用对象ResultSet封装查询结果

package jdbc;

import java.sql.*;

public class Demo06jdbc {

public static void main(String[] args) {

Connection conn = null;

Statement stmt = null;

ResultSet rs = null;

try {

Class.forName("com.mysql.jdbc.Driver");

String sql = "select * from stu_account";

conn = DriverManager.getConnection("jdbc:mysql://服务器:端口/数据库名字", "账号", "密码");

stmt = conn.createStatement();

rs = stmt.executeQuery(sql);

rs.next();

int id = rs.getInt(1);

String name = rs.getString("name");

double balance = rs.getDouble(3);

System.out.println(id+"--"+name+"---"+balance);

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

} finally {

if (rs != null) {

try {

rs.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

if (stmt != null) {

try {

stmt.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

if (conn != null) {

try {

conn.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

}

}