public static void Val_by_obj(Db_stmt stmt, String key, Object val) {
int tid = Type_adp_.To_tid_obj(val);
switch (tid) {
case Type_adp_.Tid__bool:
stmt.Val_bool_as_byte(key, Bool_.cast(val));
break;
case Type_adp_.Tid__byte:
stmt.Val_byte(key, Byte_.cast(val));
break;
case Type_adp_.Tid__int:
stmt.Val_int(key, Int_.cast(val));
break;
case Type_adp_.Tid__long:
stmt.Val_long(key, Long_.cast(val));
break;
case Type_adp_.Tid__float:
stmt.Val_float(key, Float_.cast(val));
break;
case Type_adp_.Tid__double:
stmt.Val_double(key, Double_.cast(val));
break;
case Type_adp_.Tid__str:
stmt.Val_str(key, String_.cast(val));
break;
case Type_adp_.Tid__bry:
stmt.Val_bry(key, Bry_.cast(val));
break;
default:
throw Err_.new_unhandled_default(tid);
}
}
public void Update(
int site_id, int priority, String domain, String name, String path, String xtn) {
Db_stmt stmt = conn.Stmt_update_exclude(tbl_name, flds, fld_site_id);
stmt.Val_int(fld_site_priority, priority)
.Val_str(fld_site_domain, domain)
.Val_str(fld_site_name, name)
.Val_str(fld_site_path, path)
.Val_str(fld_site_xtn, xtn)
.Crt_int(fld_site_id, site_id)
.Exec_update();
}
public void Insert(
int site_id, int priority, String domain, String name, String path, String xtn) {
Db_stmt stmt = conn.Stmt_insert(tbl_name, flds);
stmt.Val_int(fld_site_id, site_id)
.Val_int(fld_site_priority, priority)
.Val_str(fld_site_domain, domain)
.Val_str(fld_site_name, name)
.Val_str(fld_site_path, path)
.Val_str(fld_site_xtn, xtn)
.Exec_insert();
}
