Example usage for org.springframework.jdbc.core JdbcTemplate query

List of usage examples for org.springframework.jdbc.core JdbcTemplate query

  1. HOME
  2. Java
  3. org.springframework
  4. org.springframework.jdbc.core.*
  5. JdbcTemplate
  6. query

Introduction

In this page you can find the example usage for org.springframework.jdbc.core JdbcTemplate query.

Prototype

@Override
    public <T> List<T> query(String sql, RowMapper<T> rowMapper, @Nullable Object... args)
            throws DataAccessException

Source Link

Usage

From source file:org.bisen.blog.service.BlogService.java

@Transactional(readOnly = true)
public BlogUser findUser(String email) throws DataAccessException {
    String sql = create.select().from(DSL.tableByName("user")).where(DSL.fieldByName("email").eq(email))
            .getSQL();//  w w w .j  ava 2 s.c  o m
    JdbcTemplate template = new JdbcTemplate(dataSource);
    BlogUser user = template.query(sql, new Object[] { email }, new ResultSetExtractor<BlogUser>() {
        @Override
        public BlogUser extractData(ResultSet rs) throws SQLException, DataAccessException {
            return rs.next() ? new BlogUser(rs.getString("email"), rs.getString("full_name")) : null;
        }
    });
    return user;
}

From source file:com.rplt.studioMusik.pegawai.PegawaiDAO.java

@Override
public int validateLogin(String pUsername, String pPassword) {
    List<Pegawai> pegawaiList = new ArrayList<Pegawai>();

    String sql = "SELECT * FROM pegawai_studio_musik WHERE username_pegawai = ?";

    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    pegawaiList = jdbcTemplate.query(sql, new Object[] { pUsername.toUpperCase() }, new PegawaiRowMapper());

    if (!pegawaiList.isEmpty()) {
        String username = pegawaiList.get(0).getmUsernamePegawai();
        String password = pegawaiList.get(0).getmPaswordPegawai();
        String role = pegawaiList.get(0).getmRolePegawai();
        if (pUsername.equalsIgnoreCase(username) && pPassword.equals(password)) {
            System.out.println("ROLE : " + role);
            if (role.equalsIgnoreCase(ROLE.OPERATOR)) {
                return 2;
            } else if (role.equalsIgnoreCase(ROLE.OWNER)) {
                return 3;
            }/*w ww.j  a v  a  2 s .  c  o  m*/
        } else {
            System.out.println("WRONG USERNAME/PASSWORD/ROLE");
            return 1;
        }
    } else {
        System.out.println("UNREGISTERED USERNAME");
        return 0;
    }

    return -1;
}

From source file:org.bisen.chatamari.service.BlogService.java

@Transactional(readOnly = true)
public BlogUser findUser(String email) throws DataAccessException {
    String sql = create.select().from(DSL.tableByName("user")).where(DSL.fieldByName("email").eq(email))
            .getSQL();/*from   w w  w . j a va 2  s.co m*/
    JdbcTemplate template = new JdbcTemplate(dataSource);
    BlogUser user = template.query(sql, new Object[] { email },
            (ResultSet rs) -> rs.next() ? new BlogUser(rs.getString("email"), rs.getString("full_name"))
                    : null);
    return user;
}

From source file:com.rplt.studioMusik.member.MemberDAO.java

@Override
public List<Member> getDataListbyUser(String pUsername) {
    List<Member> memberList = new ArrayList<Member>();

    String sql = "SELECT kode_member, username_member, password_member, nama_member, to_char(ttl_member, 'dd-MON-yyyy'), alamat_member, email_member, no_telp_member, saldo_member, tempat_lahir_member FROM member_studio_musik WHERE username_member = ?";

    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    memberList = jdbcTemplate.query(sql, new Object[] { pUsername.toUpperCase() }, new MemberRowMapper());
    return memberList;
}

From source file:com.rplt.studioMusik.member.MemberDAO.java

@Override
public int validateLogin(String pUsername, String pPassword) {
    List<Member> memberList = new ArrayList<Member>();

    String sql = "SELECT * FROM member_studio_musik WHERE username_member = ?";

    sql = "SELECT * FROM `studiomusik`.`member_studio_musik` WHERE `USERNAME_MEMBER` = ?";

    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    memberList = jdbcTemplate.query(sql, new Object[] { pUsername.toUpperCase() }, new MemberRowMapper());

    if (!memberList.isEmpty()) {
        String username = memberList.get(0).getmUsernameMember();
        String password = memberList.get(0).getmPaswordMember();
        if (pUsername.equalsIgnoreCase(username) && pPassword.equals(password)) {
            return 2;
        } else {/*  w  ww .  j  a v  a 2 s.  c  om*/
            System.out.println("WRONG USERNAME/PASSWORD/ROLE");
            return 1;
        }
    } else {
        System.out.println("UNREGISTERED USERNAME");
        return 0;
    }

}

From source file:com.jaxio.celerio.configuration.database.h2.H2Extension.java

@Override
public void apply(Connection connection, Metadata metadata) {
    JdbcTemplate jdbcTemplate = getJdbcTemplate(connection);
    String schemaName = getSchemaName(metadata);

    List<Constraint> constraints = jdbcTemplate.query(
            "SELECT table_name, column_name, check_constraint FROM information_schema.columns WHERE table_schema = ? AND LENGTH(check_constraint) > 0",
            new Object[] { schemaName }, new RowMapper<Constraint>() {
                @Override//from  w w  w.  j  a  v  a  2  s .com
                public Constraint mapRow(ResultSet rs, int rowNum) throws SQLException {
                    Constraint constraint = new Constraint();
                    constraint.setTableName(rs.getString("table_name"));
                    constraint.setColumnName(rs.getString("column_name"));
                    constraint.setConstraint(rs.getString("check_constraint"));
                    return constraint;
                }

            });
    for (Constraint constraint : constraints) {
        addEnumValue(metadata, constraint.getTableName(), constraint.getColumnName(),
                constraint.getConstraint());
    }
}

From source file:com.plexobject.testplayer.dao.hibernate.GenericDaoHibernate.java

@SuppressWarnings("unchecked")
public List<T> findAll() {
    //if (true) return findByCriteria();

    JdbcTemplate jdbc = new JdbcTemplate(getDataSource());
    return jdbc.query(allQuery, new Object[0], mapper);

    /*/* w ww. ja va  2 s  . c o  m*/
            Transaction tx = getSession().beginTransaction();
            try {
    //Criteria criteria = getSession().createCriteria(getPersistentClass());
    Criteria criteria = getSession().createCriteria(MethodEntry.class);
    tx.commit();
    return criteria.list();
            } catch (RuntimeException e) {
    try {
      tx.rollback();
    } catch (RuntimeException ex) {}
    throw e;
            }
    */
}

From source file:com.rplt.studioMusik.dataPersewaan.PersewaanStudioMusikDAO.java

@Override
public List<PersewaanStudioMusik> getDataListByMonth(String pDate) {

    String sql = "select KODE_SEWA, KODE_STUDIO, NAMA_PENYEWA, NOMOR_TELEPON, to_char(MULAI_SEWA, 'dd-MON-yyyy HH24:MI'), to_char(SELESAI_SEWA, 'dd-MON-yyyy HH24:MI'), BIAYA_PELUNASAN "
            + "from PERSEWAAN_STUDIO_MUSIK "
            + "WHERE to_char(mulai_sewa, 'dd-MON-yyyy') = ? ORDER BY mulai_sewa ASC";

    sql = "select `KODE_SEWA`, `KODE_STUDIO`, `NAMA_PENYEWA`, `NOMOR_TELEPON`, "
            + "date_format(`MULAI_SEWA`, '%d-%b-%Y %k:%S'), date_format(`SELESAI_SEWA`, '%d-%b-%Y %k:%S'), `BIAYA_PELUNASAN` "
            + "from `studiomusik`.`persewaan_studio_musik` WHERE date_format(mulai_sewa, '%d-%b-%Y') = ? ORDER BY mulai_sewa ASC";

    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    return jdbcTemplate.query(sql, new Object[] { pDate }, new PersewaanStudioMusikRowMapper());
}

From source file:org.perconsys.dao.implement.UserJdbcTpl.java

@Override
public List<User> list(Long from, Long count) {
    JdbcTemplate dbtpl = this.getJdbcTemplate();
    String sql = String.format("select * from `%s` LIMIT ?, ? ;", table);
    return dbtpl.query(sql, new Object[] { from, count }, new UserMapper());
}

From source file:com.plexobject.testplayer.dao.hibernate.GenericDaoHibernate.java

@SuppressWarnings("unchecked")
public T findById(ID id) {
    JdbcTemplate jdbc = new JdbcTemplate(getDataSource());
    List<T> list = (List<T>) jdbc.query(finderQuery, new Object[] { id }, mapper);
    if (list.size() == 0)
        throw new DaoException("Failed to find method with id " + id);
    if (list.size() > 1)
        throw new DaoException("Found multiple methods with id " + id + ": " + list);
    return list.get(0);
    /*/*  ww  w .ja va  2s. com*/
            T entity; 
         boolean lock = false;
            Transaction tx = getSession().beginTransaction();
            try {
    if (lock) entity = (T) getSession().load(getPersistentClass(), id, LockMode.UPGRADE);
    else entity = (T) getSession().load(getPersistentClass(), id);
            
    tx.commit();
    return entity;
            } catch (RuntimeException e) {
    try {
      tx.rollback();
    } catch (RuntimeException ex) {}
    throw e;
            }
    */
}