PreparedStatement Setter Methods for Different Data Types

Direct Answer

PreparedStatement setter methods bind Java values to one-based parameter positions. Use a setter that matches the intended SQL/JDBC type, such as setString, setInt, setLong, setBigDecimal, setDate, setTimestamp, setObject, or setNull. Binding keeps values separate from SQL syntax; it does not require every driver/database to literally compile the statement before values arrive.

Code Example

String sql = "INSERT INTO orders (id, amount, note, created_at, coupon) " +
             "VALUES (?, ?, ?, ?, ?)";
try (PreparedStatement ps = con.prepareStatement(sql)) {
    ps.setLong(1, 1001L);
    ps.setBigDecimal(2, new java.math.BigDecimal("199.99")); // money
    ps.setString(3, "gift wrap");
    ps.setTimestamp(4, new java.sql.Timestamp(System.currentTimeMillis()));
    ps.setNull(5, java.sql.Types.VARCHAR);                   // explicit NULL
    ps.executeUpdate();
}

Common Mistakes & Pitfalls

• setString for numbers/dates: causes type mismatches or string-stored values.
• double for money: use setBigDecimal to avoid rounding errors.
• Bare Java null: prefer setNull(idx, Types.X) so the driver knows the type.
• setDate when you need time: use setTimestamp to keep the time component.