SqlConst

• Stores the SQL string and bind field definitions (field names and types).
• Primarily intended for use in batch processing; declare as a class variable (constant).
• Using this class enables caching of prepared statements, so its use for performance improvement in web service processing is also assumed.
• When executing SQL, pass parameters with bind values together with this SQL.
• The same field name can be bound multiple times with the same type.
• If there are no bind fields, use as-is.
• To execute using the prepared statement cache, use SqlUtil.executeOneCache or SqlUtil.executeCache.

[SQL declaration example - with bind fields]
SqlConst SQL_INS_PET = SqlConst.begin()
    .addQuery("INSERT INTO t_pet ( ")
    .addQuery("  pet_no ")
    .addQuery(", pet_nm ")
    .addQuery(", birth_dt ")
    .addQuery(", ins_ts ")
    .addQuery(", upd_ts ")
    .addQuery(" ) VALUES ( ")
    .addQuery("  ? ", "pet_no", BindType.BigDecimal)
    .addQuery(", ? ", "pet_nm", BindType.String)
    .addQuery(", ? ", "birth_dt", BindType.Date)
    .addQuery(", ? ", "now_ts", BindType.Timestamp)
    .addQuery(", ? ", "now_ts", BindType.Timestamp)
    .addQuery(" ) ")
    .end();
[SQL execution example - with bind fields]
SqlUtil.executeOne(conn, SQL_INS_PET.bind(io));
[SQL declaration example - without bind fields]
SqlConst SQL_SEL_USER = SqlConst.begin()
    .addQuery("SELECT ")
    .addQuery("  u.user_id ")
    .addQuery(", u.user_nm ")
    .addQuery(", u.email ")
    .addQuery(", u.birth_dt ")
    .addQuery(" FROM t_user AS u ")
    .addQuery(" ORDER BY u.user_id ")
    .end();
[SQL execution example - without bind fields]
SqlResultSet rSet = SqlUtil.select(getDbConn(), SQL_SEL_USER);
[SQL execution example - prepared statement cache execution]
SqlUtil.executeOneCache(conn, SQL_INS_PET.bind(io));