e65f5d2556a63e8df987a45e73b14eec956a8567.svn-base 1018 B

123456789101112131415161718192021222324252627282930
  1. package com.yihu.platform.service.impl;
  2. import com.coreframework.db.DB;
  3. import com.coreframework.db.Sql;
  4. import com.yihu.platform.enums.MyDatabaseEnum;
  5. import com.yihu.platform.enums.UserMappingSqlNameEnum;
  6. import com.yihu.platform.service.IUserMappingService;
  7. /**
  8. *
  9. * ClassName: UserMappingServiceImpl
  10. * @Description: TODO
  11. * @author houzq
  12. * @Company www.yihu.com
  13. * @date 2017-8-31 下午06:58:12
  14. */
  15. public class UserMappingServiceImpl implements IUserMappingService {
  16. public String getUserAgent(String userId) throws Exception {
  17. Sql sql = DB.me().createSql(UserMappingSqlNameEnum.getUserAgent);
  18. sql.addParamValue(userId);
  19. return DB.me().queryForString(MyDatabaseEnum.BasicServiceDB, sql);
  20. }
  21. public Integer getUserType4UserMapping(String userId) throws Exception {
  22. Sql sql = DB.me().createSql(UserMappingSqlNameEnum.getUserType4UserMapping);
  23. sql.addParamValue(userId);
  24. return DB.me().queryForInteger(MyDatabaseEnum.BasicServiceDB, sql);
  25. }
  26. }