Examples of org.springframework.jdbc.core.BeanPropertyRowMapper

org.springframework.jdbc.core.BeanPropertyRowMapper
{@link RowMapper} implementation that converts a row into a new instanceof the specified mapped target class. The mapped target class must be a top-level class and it must have a default or no-arg constructor.
Column values are mapped based on matching the column name as obtained from result set metadata to public setters for the corresponding properties. The names are matched either directly or by transforming a name separating the parts with underscores to the same name using "camel" case.
Mapping is provided for fields in the target class for many common types, e.g.: String, boolean, Boolean, byte, Byte, short, Short, int, Integer, long, Long, float, Float, double, Double, BigDecimal, java.util.Date, etc.
To facilitate mapping between columns and fields that don't have matching names, try using column aliases in the SQL statement like "select fname as first_name from customer".
Please note that this class is designed to provide convenience rather than high performance. For best performance consider using a custom RowMapper. @author Thomas Risberg @author Juergen Hoeller @since 2.5

    }


    @Override
    public User findOne(Long userId) {
        String sql = "select id, organization_id, username, password, salt, role_ids as roleIdsStr, locked from sys_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

    }


    @Override
    public List<User> findAll() {
        String sql = "select id, organization_id, username, password, salt, role_ids as roleIdsStr, locked from sys_user";
        return jdbcTemplate.query(sql, new BeanPropertyRowMapper(User.class));
    }

View Full Code Here




    @Override
    public User findByUsername(String username) {
        String sql = "select id, organization_id, username, password, salt, role_ids as roleIdsStr, locked from sys_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




    @Override
    public App findOne(Long appId) {
        final String sql = "select id, name, app_key, app_secret, available from sys_app where id=?";
        List<App> appList = jdbcTemplate.query(sql, new BeanPropertyRowMapper(App.class), appId);
        if(appList.size() == 0) {
            return null;
        }
        return appList.get(0);
    }

View Full Code Here

    }


    @Override
    public List<App> findAll() {
        final String sql = "select id, name, app_key, app_secret, available from sys_app";
        return jdbcTemplate.query(sql, new BeanPropertyRowMapper(App.class));
    }

View Full Code Here




    @Override
    public Role findOne(Long roleId) {
        final String sql = "select id, role, description, resource_ids as resourceIdsStr, available from sys_role where id=?";
        List<Role> roleList = jdbcTemplate.query(sql, new BeanPropertyRowMapper(Role.class), roleId);
        if(roleList.size() == 0) {
            return null;
        }
        return roleList.get(0);
    }

View Full Code Here

    }


    @Override
    public List<Role> findAll() {
        final String sql = "select id, role, description, resource_ids as resourceIdsStr, available from sys_role";
        return jdbcTemplate.query(sql, new BeanPropertyRowMapper(Role.class));
    }

View Full Code Here

    }


    @Override
    public List<Resource> findAll() {
        final String sql = "select id, name, type, url, permission, parent_id, parent_ids, available from sys_resource order by concat(parent_ids, id) asc";
        return jdbcTemplate.query(sql, new BeanPropertyRowMapper(Resource.class));
    }

View Full Code Here




    @Override
    public Role findOne(Long roleId) {
        final String sql = "select id, role, description, resource_ids as resourceIdsStr, available from sys_role where id=?";
        List<Role> roleList = jdbcTemplate.query(sql, new BeanPropertyRowMapper(Role.class), roleId);
        if(roleList.size() == 0) {
            return null;
        }
        return roleList.get(0);
    }

View Full Code Here

    }


    @Override
    public List<Role> findAll() {
        final String sql = "select id, role, description, resource_ids as resourceIdsStr, available from sys_role";
        return jdbcTemplate.query(sql, new BeanPropertyRowMapper(Role.class));
    }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

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

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.