mybatis传入多参数 

 1 public void insertPsasDevice(@Param("psas") Psas psas,@Param("citys") String[] citys);
 2 
 3 
 4 <insert id="insertPsasDevice">
 5          insert into t_adv_psas_device (
 6             psas_id ,            
 7             device_id ,
 8             device_sn,
 9             create_by,
10             create_time,
11             version,
12             valid
13         ) select #{psas.id},id,device_sn,#{psas.createBy},#{psas.createTime},#{psas.version},#{psas.valid} from t_base_device where area in
14             <foreach collection="citys" item="cityId" index="index"  
15             open="(" close=")" separator=",">  
16             #{cityId}  
17             </foreach>            
18     </insert>

 

posted @ 2017-11-01 16:55  妮妮ing  Views(124)  Comments(0)    收藏  举报