Package com.jpoweredcart.common.entity.user.jdbc

Examples of com.jpoweredcart.common.entity.user.jdbc.UserRowMapper


public class UserServiceImpl extends BaseModel implements UserService {
 
  @Override
  public User getSystemUserByUsername(String username) {
    String sql = "SELECT * FROM " +quoteTable("user")+ " WHERE username = ?";
    return getJdbcOperations().queryForObject(sql, new Object[]{username}, new UserRowMapper());
  }
View Full Code Here


  @Override
  public User get(Integer userId, Class<? extends User> clazz) {
    String sql = "SELECT * FROM " +quoteTable("user")+ " WHERE user_id = ?";
    return getJdbcOperations().queryForObject(sql, new Object[]{userId},
        new UserRowMapper().setTargetClass(clazz));
  }
View Full Code Here

  }
 
  @Override
  public User getOneByUsername(String username) {
    String sql = "SELECT * FROM " +quoteTable("user")+ " WHERE username = ?";
    return getJdbcOperations().queryForObject(sql, new Object[]{username}, new UserRowMapper());
  }
View Full Code Here

  }
 
  @Override
  public User getUserByCode(String code) {
    String sql = "SELECT * FROM " +quoteTable("user")+ " WHERE code = ?";
    return getJdbcOperations().queryForObject(sql, new Object[]{code}, new UserRowMapper());
  }
View Full Code Here

   
    //sortedKeys={"username", "status", "date_added"}
    String sql = "SELECT * FROM "+quoteTable("user");
    QueryBean query = createPaginationQuery(sql, pageParam);
    List<User> userList = getJdbcOperations().query(query.getSql(),
        query.getParameters(), new UserRowMapper());
    return userList;
  }
View Full Code Here

TOP

Related Classes of com.jpoweredcart.common.entity.user.jdbc.UserRowMapper

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.