获取之后删除这两条数据: String cmdonlineArr = new String2; try Connection conn = DriverManagergetConnectionurl username password String sql = SELECT FROM cmd_online WHERE entity_imei = + en
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();
原文地址: https://www.cveoy.top/t/topic/hfYP 著作权归作者所有。请勿转载和采集!