ResultSet的使用方法:
ResultSet rs = st.executeQuery(sql);
rs.next():移动光标,如果有下一条记录则返回true,否则返回false;
rs.get(int): 填入列号获得当前记录的一个字段的值,并将值转换成类型,
rs.get(String):填入列名查询出当前记录的字段值,并转换成类型
rs.close():关闭资源;
JdbcUtil类:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class JdbcUtil {
private static String url = "jdbc:mysql://localhost:3306/books";
private static String userName = "root";
private static String password = "tiger";
static {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static Connection getConnection() {
Connection conn = null;
try {
conn = DriverManager.getConnection(url, userName, password);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
}
ResultSet的一个使用案例
import java.sql.*;
public class TestResultset {
public static void main(String[] args) throws SQLException {
// 查询
Connection conn = JdbcUtil.getConnection();
String sql = "select * from account";
try (Statement st = conn.createStatement();
ResultSet rs = st.executeQuery(sql)) {
while (rs.next()) {
int i = rs.getInt(1);
System.out.print(i + "\t");
System.out.print(rs.getString("name") + "\t");
System.out.print(rs.getInt(3) + "\n");
}
}
}
}