PreparedStatement ps =
connection.prepareStatement("Update Foo SET name=?, value=?");
ps.setString(1, "penny");
ps.setBigDecimal(2, new BigDecimal(0.01));
ps.executeUpdate();
connection.prepareStatement("Update Foo SET name=?, value=?");
ps.setString(1, "penny");
ps.setBigDecimal(2, new BigDecimal(0.01));
ps.executeUpdate();
connection.prepareStatement("INSERT INTO Foo ('name','value')VALUES(?,?)");