java main 调用_java main方法里调用mapper

packagecom.runxsoft.test;importcom.runxsoft.iutils.common.utils.UserUtils;importcom.runxsoft.superwe.base.SqlVo;importcom.runxsoft.superwe.base.mapper.ProtogenesisMapper;importcom.runxsoft.superwe.valueCard.Constants;importcom.runxsoft.superwe.valueCard.mapper.CardInfoMapper;importcom.runxsoft.superwe.valueCard.mapper.CardTypeMapper;importcom.runxsoft.superwe.valueCard.mapper.CustomerInfoMapper;importcom.runxsoft.superwe.valueCard.model.Bonus;importcom.runxsoft.superwe.valueCard.model.CardInfo;importcom.runxsoft.superwe.valueCard.model.CardType;importcom.runxsoft.superwe.valueCard.model.CustomerInfo;importcom.runxsoft.superwe.valueCard.model.CustomerInfoExample;importcom.runxsoft.superwe.valueCard.service.CustomerInfoService;importjava.sql.Timestamp;importjava.util.Date;importjava.util.HashMap;importjava.util.List;importjava.util.Map;importorg.apache.commons.lang3.StringUtils;importorg.springframework.beans.factory.BeanFactory;importorg.springframework.context.ApplicationContext;importorg.springframework.context.support.ClassPathXmlApplicationContext;public classImprotMain {public static voidmain(String[] args) {

ApplicationContext context=new ClassPathXmlApplicationContext("spring-config-imp.xml");

BeanFactory factory=(BeanFactory) context;

CustomerInfoMapper customerInfoMapper=factory.getBean(CustomerInfoMapper.class);

ProtogenesisMapper protogenesisMapper= factory.getBean(ProtogenesisMapper.class);

CardTypeMapper cardTypeMapper= factory.getBean(CardTypeMapper.class);

CardInfoMapper cardInfoMapper= factory.getBean(CardInfoMapper.class);try{

//下面就可以使用mapper接口了List> results =protogenesisMapper.selectBySql(new SqlVo("select usAccounts,usNumber,usName,departname,usMoney, " +

"ifnull(ROUND((select sum(crMoney) from old_chargerecord cr where cr.crAccounts = ubi.usAccounts),2),0) as consumedMoney, " +

"ROUND((usMoney + ifnull((select sum(crMoney) from old_chargerecord cr where cr.crAccounts = ubi.usAccounts),0)),0) as totalMoney," +

"usCardNo, usRegisterDate ,ushandtel,usIdentityCardNo,usSex " +

"from old_userbasicinfo ubi " +

"left join old_T_S_Department on DepartID = usDepartmentNo " +

"where ifnull(usNumber,'')<>'' " +

"and ifnull(usCardNo,'0')<>'0' " +

"and usMoney > 0 " +

"order by ubi.usName"));

String userName= "";

CardInfo cardInfo= null;

Long customerId= 0L;System.out.println(results.size());

}catch(Exception e) {

e.printStackTrace();

}

}

}