mysql批量查询、添加和修改

1、批量查询

    SELECT  from risk_user where user_id in (select user_id from risk_project_user where 
　　　　　　project_id=#{projectId})
  

 
  
    select  u.user_id, u.user_name, u.company_id, u.user_pwd,u.deal_user,u.email,u.contact_phone,u.uuid
    from risk_user u inner join risk_user_role ur on ur.user_id=u.user_id and u.company_id=#{companyId} and ur.role_id not in (1)
  

2、批量添加

list为传入的数据类型

RiskProjectRisk为list集合里的对象

  
    INSERT INTO risk_project_risk(property_id, property_name, project_id)
    VALUES
    
      (#{RiskProjectRisk.propertyId}, #{RiskProjectRisk.propertyName},#{RiskProjectRisk.projectId})
    
  

3、批量修改

  
    update t_temp_ctl_model set m_name=
    
      when #{tTempCtlModel.mId}  then #{tTempCtlModel.mName}
    ,
    update_time=
    
      when #{tTempCtlModel.mId}  then #{tTempCtlModel.updateTime}
    
    where m_id in
    
      #{tTempCtlModel.mId}