|  |  | 
 |  |  |             "ssrc_check," + | 
 |  |  |             "as_message_channel," + | 
 |  |  |             "geo_coord_sys," + | 
 |  |  |             "tree_type," + | 
 |  |  |             "on_line," + | 
 |  |  |             "media_server_id," + | 
 |  |  |             "switch_primary_sub_stream," + | 
 |  |  | 
 |  |  |                 "ssrc_check,"+ | 
 |  |  |                 "as_message_channel,"+ | 
 |  |  |                 "geo_coord_sys,"+ | 
 |  |  |                 "tree_type,"+ | 
 |  |  |                 "on_line"+ | 
 |  |  |             ") VALUES (" + | 
 |  |  |                 "#{deviceId}," + | 
 |  |  | 
 |  |  |                 "#{ssrcCheck}," + | 
 |  |  |                 "#{asMessageChannel}," + | 
 |  |  |                 "#{geoCoordSys}," + | 
 |  |  |                 "#{treeType}," + | 
 |  |  |                 "#{onLine}" + | 
 |  |  |             ")") | 
 |  |  |     int add(Device device); | 
 |  |  | 
 |  |  |             "ssrc_check,"+ | 
 |  |  |             "as_message_channel,"+ | 
 |  |  |             "geo_coord_sys,"+ | 
 |  |  |             "tree_type,"+ | 
 |  |  |             "on_line,"+ | 
 |  |  |             "media_server_id,"+ | 
 |  |  |             "switch_primary_sub_stream switchPrimarySubStream,"+ | 
 |  |  | 
 |  |  |             "ssrc_check,"+ | 
 |  |  |             "as_message_channel,"+ | 
 |  |  |             "geo_coord_sys,"+ | 
 |  |  |             "tree_type,"+ | 
 |  |  |             "on_line"+ | 
 |  |  |             " FROM wvp_device WHERE on_line = true") | 
 |  |  |     List<Device> getOnlineDevices(); | 
 |  |  | 
 |  |  |             "ssrc_check,"+ | 
 |  |  |             "as_message_channel,"+ | 
 |  |  |             "geo_coord_sys,"+ | 
 |  |  |             "tree_type,"+ | 
 |  |  |             "on_line"+ | 
 |  |  |             " FROM wvp_device WHERE ip = #{host} AND port=#{port}") | 
 |  |  |     Device getDeviceByHostAndPort(String host, int port); | 
 |  |  | 
 |  |  |             "<if test=\"ssrcCheck != null\">, ssrc_check=#{ssrcCheck}</if>" + | 
 |  |  |             "<if test=\"asMessageChannel != null\">, as_message_channel=#{asMessageChannel}</if>" + | 
 |  |  |             "<if test=\"geoCoordSys != null\">, geo_coord_sys=#{geoCoordSys}</if>" + | 
 |  |  |             "<if test=\"treeType != null\">, tree_type=#{treeType}</if>" + | 
 |  |  |             "<if test=\"switchPrimarySubStream != null\">, switch_primary_sub_stream=#{switchPrimarySubStream}</if>" + | 
 |  |  |             "<if test=\"mediaServerId != null\">, media_server_id=#{mediaServerId}</if>" + | 
 |  |  |             "WHERE device_id=#{deviceId}"+ | 
 |  |  | 
 |  |  |             "ssrc_check,"+ | 
 |  |  |             "as_message_channel,"+ | 
 |  |  |             "geo_coord_sys,"+ | 
 |  |  |             "tree_type,"+ | 
 |  |  |             "on_line,"+ | 
 |  |  |             "media_server_id,"+ | 
 |  |  |             "switch_primary_sub_stream"+ | 
 |  |  | 
 |  |  |             "#{ssrcCheck}," + | 
 |  |  |             "#{asMessageChannel}," + | 
 |  |  |             "#{geoCoordSys}," + | 
 |  |  |             "#{treeType}," + | 
 |  |  |             "#{onLine}," + | 
 |  |  |             "#{mediaServerId}," + | 
 |  |  |             "#{switchPrimarySubStream}" + |