public static List SqlstrCmd(String entity_imei, int times) {
String url = "jdbc:mysql://121.199.69.248:3306/gps_db";
String username = "root";
String password = "YWRtaW42NjY=mysql";
List cmdonlineList = new ArrayList<>();
try (Connection conn = DriverManager.getConnection(url, username, password)) {
String sql = "SELECT * FROM cmd_online WHERE entity_imei = " + entity_imei + "";
PreparedStatement stmt = conn.prepareStatement(sql);
ResultSet rs = stmt.executeQuery();
int count = 0;
while (rs.next() && count < times) {
String cmdonline = rs.getString("cmdonline");
cmdonlineList.add(cmdonline);
System.out.println("cmdonline:" + cmdonline);
count++;
}
} catch (SQLException e) {
e.printStackTrace();
}
return cmdonlineList;
}
这里修改了方法的返回值，返回一个字符串列表，其中包含了查询到的前times次的cmdonline。同时在while循环中增加了一个计数器count，用于限制查询次数
