智能标签

 

//修改
public int updateProvider( SmbmsProvider provider);
//查询范围
public List getProInData(String [] proCodes);
//查询范围
public List< SmbmsProvider> getProList(List list);
//查询范围
public List< SmbmsProvider> getProbject (@Param( " proCodeList") List< SmbmsProvider> proCodeList , @Param(" proNameList") L ist< SmbmsProvider> proNameList) ;

 




proCode=#{proCode},


proName=#{proName},



where id=#{id}




' mapper>

 

SmbmsProvider provider=new SmbmsProvider();
provider . setId(18);
provider . setProCode("BJ_ GYS002" );
provider . setProName(”北京市海淀区五道口");
int count = mapper. updateProvider(provider);
sqlSession. commit( );
System. out . println(count);
}
@Test
public void getINPro( ){
ISmbmsProviderDao mapper = sq1Session . getMapper ( ISmbmsProviderDao.class);
String [] strs-new String[]{};
L ist< SmbmsProvider> porviderData = mapper . getProInData(strs);
for ( SmbmsProvider pro: porviderData){
System. out . print1n(pro . getProName());
}
@Test
public void getProList(){
ISmbmsProviderDao mapper = sqlSession. getMapper( ISmbmsProviderDao. class);
List list=new ArrayList<>();
list . add("BJ_ GYS002");
list . add("BJ_ GYS001");
List porviderData = mapper . getProList(list);
for ( SmbmsProvider pro: porviderData)
System. out . println(pro . getProName());
}
@Test
public void getPro0bject(){
ISmbmsProviderDao mapper = sqlSession. getMapper ( ISmbmsProviderDao . class);
List list=new ArrayList();
SmbmsProvider provider=new SmbmsProvider( );
provider. setProCode("BJ_ GYS082" );
list. add(provider);
List< SmbmsProvider> list2=new ArrayList<~>();
SmbmsProvider provider2=new SmbmsProvider();
provider2. setProName( "北京纳福尔食用油有限公司”);
list2. add(provider2);
List< SmbmsProvider> porviderData = mapper . getPro0bject(list,list2);
for (SmbmsProvider pro:porviderData){
System. out . println(pro . getProName());
}

你可能感兴趣的