import net.sourceforge.jtds.jdbc.*; String connectionString = "jdbc:jtds:sqlserver://localhost:1433/DatabaseName;user=sa;password=yourpassword"; Connection connection = DriverManager.getConnection(connectionString); Statement statement = connection.createStatement(); ResultSet resultSet = statement.executeQuery("SELECT * FROM TableName"); while (resultSet.next()) { String value = resultSet.getString("ColumnName"); } statement.executeUpdate("UPDATE TableName SET ColumnName='NewValue' WHERE Condition"); resultSet.close(); statement.close(); connection.close();