|  |  |  | 
|---|
|  |  |  | "createTime," + | 
|---|
|  |  |  | "updateTime," + | 
|---|
|  |  |  | "charset," + | 
|---|
|  |  |  | "subscribeCycleForCatalog," + | 
|---|
|  |  |  | "online" + | 
|---|
|  |  |  | ") VALUES (" + | 
|---|
|  |  |  | "#{deviceId}," + | 
|---|
|  |  |  | 
|---|
|  |  |  | "#{createTime}," + | 
|---|
|  |  |  | "#{updateTime}," + | 
|---|
|  |  |  | "#{charset}," + | 
|---|
|  |  |  | "#{subscribeCycleForCatalog}," + | 
|---|
|  |  |  | "#{online}" + | 
|---|
|  |  |  | ")") | 
|---|
|  |  |  | int add(Device device); | 
|---|
|  |  |  | 
|---|
|  |  |  | "<if test=\"keepaliveTime != null\">, keepaliveTime='${keepaliveTime}'</if>" + | 
|---|
|  |  |  | "<if test=\"expires != null\">, expires=${expires}</if>" + | 
|---|
|  |  |  | "<if test=\"charset != null\">, charset='${charset}'</if>" + | 
|---|
|  |  |  | "<if test=\"subscribeCycleForCatalog != null\">, subscribeCycleForCatalog=#{subscribeCycleForCatalog}</if>" + | 
|---|
|  |  |  | "WHERE deviceId='${deviceId}'"+ | 
|---|
|  |  |  | " </script>"}) | 
|---|
|  |  |  | int update(Device device); | 
|---|