鍦↗ava涓紝ResultSet鏄竴涓帴鍙ｏ紝鐢ㄤ簬鑾峰彇鍜屽鐞嗘暟鎹簱鏌ヨ鐨勭粨鏋溿€備互涓嬫槸涓€浜涗娇鐢≧esultSet鐨勫父瑙佹楠わ細

1. 鍒涘缓涓€涓猄tatement瀵硅薄锛屽苟浣跨敤璇ュ璞℃墽琛屾煡璇㈣鍙ャ€備緥濡傦細

Statement statement = connection.createStatement();
String query = "SELECT * FROM table_name";
ResultSet resultSet = statement.executeQuery(query);

2. 浣跨敤ResultSet鐨刵ext()鏂规硶鏉ラ亶鍘嗘煡璇㈢粨鏋滅殑姣忎竴琛屾暟鎹€傝鏂规硶杩斿洖涓€涓竷灏斿€硷紝琛ㄧず鏄惁杩樻湁涓嬩竴琛屾暟鎹€備緥濡傦細

while (resultSet.next()) {
// 澶勭悊褰撳墠琛屾暟鎹?/span>
}

3. 浣跨敤ResultSet鐨刧etXXX()鏂规硶鏉ヨ幏鍙栨瘡涓€鍒楃殑鏁版嵁锛屽叾涓璛XX鏄暟鎹被鍨嬬殑鍚嶇О銆傛牴鎹垪鐨勭储寮曟垨鍚嶇О鑾峰彇鏁版嵁銆備緥濡傦細

int intValue = resultSet.getInt(1); // 鏍规嵁鍒楃殑绱㈠紩鑾峰彇鏁存暟绫诲瀷鏁版嵁
String stringValue = resultSet.getString("column_name"); // 鏍规嵁鍒楃殑鍚嶇О鑾峰彇瀛楃涓茬被鍨嬫暟鎹?/span>

4. 鏍规嵁闇€瑕侊紝鍙互浣跨敤ResultSet鐨勫叾浠栨柟娉曟潵鑾峰彇涓嶅悓绫诲瀷鐨勬暟鎹紝姣斿getLong()銆乬etDouble()銆乬etDate()绛夈€?/p>

5. 鍦ㄥ畬鎴愬ResultSet鐨勪娇鐢ㄥ悗锛岄渶瑕佸叧闂璕esultSet銆丼tatement鍜孋onnection瀵硅薄锛屼互閲婃斁璧勬簮銆備緥濡傦細

resultSet.close();
statement.close();
connection.close();

闇€瑕佹敞鎰忕殑鏄紝鍦ㄤ娇鐢≧esultSet鏃讹紝闇€瑕佷繚璇佹暟鎹簱杩炴帴鏄墦寮€鐨勶紝骞朵笖鏌ヨ璇彞鏄悎娉曠殑銆傚彟澶栵紝杩橀渶瑕佹敞鎰忓鐞嗗彲鑳藉嚭鐜扮殑SQLException寮傚父銆?/p>