Java 获取并删除数据库数据示例：cmd_online 表

String[] cmdonlineArr = new String[2]; ' +'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 i = 0; ' +' while (rs.next()) { ' +' cmdonlineArr[i] = rs.getString('cmdonline'); ' +' i++; ' +' if (i > 1) { ' +' break; ' +' } ' +' } ' +' // 删除数据 ' +' String deleteSql = 'DELETE FROM cmd_online WHERE entity_imei = ' + entity_imei + ''; ' +' PreparedStatement deleteStmt = conn.prepareStatement(deleteSql); ' +' deleteStmt.executeUpdate(); ' +'} catch (SQLException e) { ' +' e.printStackTrace(); ' +'}