Package org.springframework.jdbc.core

Examples of org.springframework.jdbc.core.BeanPropertyRowMapper

58
59
60
61
62
63
64
65
66
67
68
    }

    @Override
    public User findOne(Long userId) {
        String sql = "select id, username, password, salt from oauth2_user where id=?";
        List<User> userList = jdbcTemplate.query(sql, new BeanPropertyRowMapper(User.class), userId);
        if(userList.size() == 0) {
            return null;
        }
        return userList.get(0);
    }
View Full Code Here
68
69
70
71
72
73
74
    }

    @Override
    public List<User> findAll() {
        String sql = "select id, username, password, salt from oauth2_user";
        return jdbcTemplate.query(sql, new BeanPropertyRowMapper(User.class));
    }
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85

    @Override
    public User findByUsername(String username) {
        String sql = "select id, username, password, salt from oauth2_user where username=?";
        List<User> userList = jdbcTemplate.query(sql, new BeanPropertyRowMapper(User.class), username);
        if(userList.size() == 0) {
            return null;
        }
        return userList.get(0);
    }
View Full Code Here
83
84
85
86
87
88
89
90
91
92
93

    @Override
    public User findOne(Long userId) {
        String sql = "select id, username, password, salt, locked from sys_users where id=?";
        List<User> userList = getJdbcTemplate().query(sql, new BeanPropertyRowMapper(User.class), userId);
        if(userList.size() == 0) {
            return null;
        }
        return userList.get(0);
    }
View Full Code Here
93
94
95
96
97
98
99
100
101
102
103
    }

    @Override
    public User findByUsername(String username) {
        String sql = "select id, username, password, salt, locked from sys_users where username=?";
        List<User> userList = getJdbcTemplate().query(sql, new BeanPropertyRowMapper(User.class), username);
        if(userList.size() == 0) {
            return null;
        }
        return userList.get(0);
    }
View Full Code Here
277
278
279
280
281
282
283
284
285
286
287
                    result = row;
                }
            }
        } else {
            Class<?> outputClzz = getCamelContext().getClassResolver().resolveClass(outputClass);
            RowMapper rowMapper = new BeanPropertyRowMapper(outputClzz);
            RowMapperResultSetExtractor<?> mapper = new RowMapperResultSetExtractor(rowMapper);
            List<?> data = mapper.extractData(rs);
            if (data.size() > 1) {
                throw new SQLDataException("Query result not unique for outputType=SelectOne. Got " + data.size() +  " count instead.");
            } else if (data.size() == 1) {
View Full Code Here
105
106
107
108
109
110
111
  public Page findAll(String tableName,final PageRequest pageRequest) {
    return pageQuery("select * from "+tableName+" /~ order by [sortColumns] ~/",pageRequest);
  }
 
  public Page pageQuery(String query,PageRequest pageRequest) {
    return pageQuery(query,pageRequest,new BeanPropertyRowMapper(getEntityClass()), "select count(*) ");
  }
View Full Code Here
239
240
241
242
243
244
245
246
247
248
249
  }
 
  public E getById(PK id) {
    List list = null;
    if(getSqlGenerator().getTable().getPrimaryKeyCount() > 1) {
      list = getNamedParameterJdbcTemplate().query(getSqlGenerator().getSelectByPkSql(), new BeanPropertySqlParameterSource(id), new BeanPropertyRowMapper(getEntityClass()));
    }else if(getSqlGenerator().getTable().getPrimaryKeyCount() == 1){
      list = getSimpleJdbcTemplate().query(getSqlGenerator().getSelectByPkSql(), ParameterizedBeanPropertyRowMapper.newInstance(getEntityClass()), id);
    }else {
      throw new IllegalStateException("not found primary key on table:"+getSqlGenerator().getTable().getTableName());
    }
View Full Code Here
TOP

Related Classes of org.springframework.jdbc.core.BeanPropertyRowMapper

  • com.github.zhangkaitao.shiro.chapter11.dao.UserDaoImpl
  • com.github.zhangkaitao.shiro.chapter12.dao.UserDaoImpl
  • com.github.zhangkaitao.shiro.chapter13.dao.UserDaoImpl
  • com.github.zhangkaitao.shiro.chapter14.dao.UserDaoImpl
  • com.github.zhangkaitao.shiro.chapter15.dao.UserDaoImpl
  • com.github.zhangkaitao.shiro.chapter16.dao.OrganizationDaoImpl
  • com.github.zhangkaitao.shiro.chapter16.dao.ResourceDaoImpl
  • com.github.zhangkaitao.shiro.chapter16.dao.RoleDaoImpl
  • com.github.zhangkaitao.shiro.chapter16.dao.UserDaoImpl
  • com.github.zhangkaitao.shiro.chapter17.dao.ClientDaoImpl
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.