String connectionUrl = "jdbc:sqlserver://localhost:1433;databaseName=myDB;user=myUser;password=myPassword"; Connection connection = DriverManager.getConnection(connectionUrl); Statement statement = connection.createStatement(); String updateQuery = "UPDATE employees SET salary = 5000 WHERE id = 1"; int rowsAffected = statement.executeUpdate(updateQuery); System.out.println("Rows affected: " + rowsAffected); String deleteQuery = "DELETE FROM employees WHERE id = 1"; int rowsAffected = statement.executeUpdate(deleteQuery); System.out.println("Rows affected: " + rowsAffected); statement.close(); connection.close();


上一篇:
下一篇:
切换中文