java鐨別xecutequery鏂规硶鎬庝箞浣跨敤
鍦↗ava涓紝鍙互閫氳繃浠ヤ笅姝ラ浣跨敤`executeQuery`鏂规硶锛?br/>1. 瀵煎叆`java.sql`鍖呬腑鐨勭浉鍏崇被锛屽`Connection`銆乣Statement`鍜宍ResultSet`銆?br/>2. 寤虹珛涓庢暟鎹簱鐨勮繛鎺ワ紝鍒涘缓涓€涓猔Connection`瀵硅薄銆傚彲浠ヤ娇鐢╜DriverManager.getConnection`鏂规硶鏉ヨ幏鍙栬繛鎺ャ€?br/>3. 鍒涘缓涓€涓猔Statement`瀵硅薄锛屽彲浠ヤ娇鐢╜Connection.createStatement`鏂规硶鏉ュ垱寤恒€?br/>4. 浣跨敤`Statement.executeQuery`鏂规硶鎵цSQL鏌ヨ璇彞锛屽苟灏嗙粨鏋滃瓨鍌ㄥ湪涓€涓猔ResultSet`瀵硅薄涓€?br/>5. 浣跨敤`ResultSet`瀵硅薄鐨勬柟娉曪紝濡俙next`銆乣getString`銆乣getInt`绛夋潵鑾峰彇鏌ヨ缁撴灉銆?br/>涓嬮潰鏄竴涓畝鍗曠殑绀轰緥浠g爜锛屽睍绀轰簡濡備綍浣跨敤`executeQuery`鏂规硶鎵цSQL鏌ヨ璇彞骞惰幏鍙栫粨鏋滐細
```java
import java.sql.*;
public class Example {
public static void main(String[] args) {
try {
// 寤虹珛涓庢暟鎹簱鐨勮繛鎺?br/>
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "username", "password");
// 鍒涘缓Statement瀵硅薄
Statement statement = connection.createStatement();
// 鎵цSQL鏌ヨ璇彞
String sql = "SELECT * FROM mytable";
ResultSet resultSet = statement.executeQuery(sql);
// 澶勭悊鏌ヨ缁撴灉
while (resultSet.next()) {
int id = resultSet.getInt("id");
String name = resultSet.getString("name");
System.out.println("ID: " + id + ", Name: " + name);
}
// 鍏抽棴杩炴帴鍜岀浉鍏宠祫婧?br/>
resultSet.close();
statement.close();
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
```
璇锋敞鎰忥紝涓婅堪浠g爜涓殑鏁版嵁搴撹繛鎺ヤ俊鎭簲鏍规嵁瀹為檯鎯呭喌杩涜淇敼锛屽寘鎷琔RL銆佺敤鎴峰悕鍜屽瘑鐮併€傚彟澶栵紝杩橀渶瑕佺‘淇濆凡缁忓鍏ヤ簡鐩稿簲鐨凧DBC椹卞姩绋嬪簭銆?/p>