How do I retrieve values from ResultSet?-优快云博客

本文链接：https://blog.youkuaiyun.com/iteye_6401/article/details/82512168

本文介绍了一个Java示例程序，演示了如何通过执行SQL查询来从数据库中读取数据，并展示了如何使用ResultSet处理查询结果。具体包括连接数据库、执行SQL语句、解析结果集等步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Only for reference.

This example shows how to read data from a ResultSet returned by a executing an SQL query to a table in database.

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class ResultSetExample {
	public static void main(String[] args) throws Exception
	{
		Connection connection = getConnection();
		try {
			String query = "select id, title, publisher, year, price from books";
			PreparedStatement ps = connection.prepareStatement(query);
			ResultSet rs = ps.executeQuery();
			while (rs.next()) {
				// Read values using column name
				String id = rs.getString("id");
				String title = rs.getString("title");
				String publisher = rs.getString("publisher");
				
				// Read values using column index
				int year = rs.getInt(4);
				float price = rs.getFloat(5);
				
				System.out.printf("%s. %s, %s, %d, %f\n", id, title, publisher, year, price);
			}
		} finally {
			closeConnection(connection);
		}
	}
	
	private static Connection getConnection() throws Exception {
		Connection connection = null;
		Class.forName("com.mysql.jdbc.Driver");
		connection = DriverManager.getConnection("jdbc:mysql://localhost/bookstore", "root", "");
		return connection;
	}
	
	private static void closeConnection(Connection connection) throws SQLException {
		if (connection != null && !connection.isClosed()) {			
			connection.close();
		}
	}
}