Intelligent label

1. ProviderDao layer

　　 //Smart label case

 //Smart label multi-condition query

 public List providerTest(@Param("proCode") String proCode, @Param("proName") String proName);

 //Smart label to modify

 public int updatePro(Provider provider);

 //Query range (array)

 public List getProInData(String [] proCodes);

 //Query range (collection)

 public List getProList(List list);

 //Query range (multiple collections)

 public List getProObject(@Param("proCodeList") List proCodeList,@Param("proNameList") List proNameList);

< p>Two, ProviderDao.xml small configuration file

 

 

 select * from smbms.smbms_provider

 

 

 and proCode like concat (‘%‘,#{proCode},‘%‘)

 

 

 and proName like concat (‘%‘,#{proName},‘%‘)

 

 

 

 

 

 update smbms_provider

 

 

 

 proCode=#{proCode},

 

 

 proName=#{proName},

 

 

 

 where id=#{id}

 

 

 

 

 select * from smbms.smbms_provider where proCode in

 

 

 #{proCode}

 

 

 

 

 select * from smbms.smbms_provider

 

 where proCode in

 

 

 #{proCode}

 

 

 

 

 

 select * from smbms.smbms_provider where proCode in

 

 

 #{proCode.proCode}

 

 and proName in

 

 #{proName.proName}

 

 

Three, test class

public class providerTest {

 SqlSession sqlSession=MybatisUtil.getSqlSession();

 ProviderDao mapper = sqlSession.getMapper(ProviderDao.class);

 //Smart label multi-condition query

 @Test

 public void getAllPro(){

 List providers = mapper.providerTest("GZ", "Shenzhen");

 for (Provider pro:providers) {

 System.out.println(pro.getProName());

}

}

 //Smart label to modify

 @Test

 public void updatePro(){

 Provider provider=new Provider();

 provider.setId(10);

 provider.setProCode("JS_GYS012");

 provider.setProName("Little Nanjing Fire Head Army Information Technology Co., Ltd.");

 int count=mapper.updatePro(provider);

 sqlSession.commit();

 System.out.println(count);

}

 //Query range (array)

 @Test

 public void getInPro(){

 List providers = mapper.getProInData(new String[]{"BJ_GYS001","BJ_GYS002"});

 for (Provider pro:providers) {

 System.out.println(pro.getProName());

}

}

 //Query range (collection)

 @Test

 public void getProList(){

 List list=new ArrayList<>();

 list.add("BJ_GYS002");

 list.add("BJ_GYS001");

 List providerData=mapper.getProList(list);

 for (Provider pro:providerData) {

 System.out.println(pro.getProName());

}

}

 //Query range (multiple collections)

 @Test

 public void getProObject(){

 List list =new ArrayList();

 Provider provider=new Provider();

 provider.setProCode("BJ_GYS002");

 list.add(provider);



 List list2 =new ArrayList();

 Provider provider2=new Provider();

 provider2.setProName("Beijing Nafore Edible Oil Co., Ltd.");

 list2.add(provider2);

 List providerData=mapper.getProObject(list,list2);

 for (Provider pro:providerData) {

 System.out.println(pro.getProName());

}

}

}

　　 //Smart label case

 //Smart label multi-condition query

 public List providerTest(@Param("proCode") String proCode, @Param("proName") String proName);

 //Smart label to modify

 public int updatePro(Provider provider);

 //Query range (array)

 public List getProInData(String [] proCodes);

 //Query range (collection)

 public List getProList(List list);

 //Query range (multiple collections)

 public List getProObject(@Param("proCodeList") List proCodeList,@Param("proNameList") List proNameList);

< p>

 

 

 select * from smbms.smbms_provider

 

 

 and proCode like concat (‘%‘,#{proCode},‘%‘)

 

 

 and proName like concat (‘%‘,#{proName},‘%‘)

 

 

 

 

 

 update smbms_provider

 

 

 

 proCode=#{proCode},

 

 

 proName=#{proName},

 

 

 

 where id=#{id}

 

 

 

 

 select * from smbms.smbms_provider where proCode in

 

 

 #{proCode}

 

 

 

 

 select * from smbms.smbms_provider

 

 where proCode in

 

 

 #{proCode}

 

 

 

 

 

 select * from smbms.smbms_provider where proCode in

 

 

 #{proCode.proCode}

 

 and proName in

 

 #{proName.proName}

 

 

public class providerTest {

 SqlSession sqlSession=MybatisUtil.getSqlSession();

 ProviderDao mapper = sqlSession.getMapper(ProviderDao.class);

 //Smart label multi-condition query

 @Test

 public void getAllPro(){

 List providers = mapper.providerTest("GZ", "Shenzhen");

 for (Provider pro:providers) {

 System.out.println(pro.getProName());

}

}

 //Smart label to modify

 @Test

 public void updatePro(){

 Provider provider=new Provider();

 provider.setId(10);

 provider.setProCode("JS_GYS012");

 provider.setProName("Little Nanjing Fire Head Army Information Technology Co., Ltd.");

 int count=mapper.updatePro(provider);

 sqlSession.commit();

 System.out.println(count);

}

 //Query range (array)

 @Test

 public void getInPro(){

 List providers = mapper.getProInData(new String[]{"BJ_GYS001","BJ_GYS002"});

 for (Provider pro:providers) {

 System.out.println(pro.getProName());

}

}

 //Query range (collection)

 @Test

 public void getProList(){

 List list=new ArrayList<>();

 list.add("BJ_GYS002");

 list.add("BJ_GYS001");

 List providerData=mapper.getProList(list);

 for (Provider pro:providerData) {

 System.out.println(pro.getProName());

}

}

 //Query range (multiple collections)

 @Test

 public void getProObject(){

 List list =new ArrayList();

 Provider provider=new Provider();

 provider.setProCode("BJ_GYS002");

 list.add(provider);



 List list2 =new ArrayList();

 Provider provider2=new Provider();

 provider2.setProName("Beijing Nafore Edible Oil Co., Ltd.");

 list2.add(provider2);

 List providerData=mapper.getProObject(list,list2);

 for (Provider pro:providerData) {

 System.out.println(pro.getProName());

}

}

}