@Test public void testQuery() throws Exception { groupOperationDao.insertOrUpdate(newGroupOperation()); groupOperationDao.insertOrUpdate(newGroupOperation()); Assert.assertTrue(groupOperationDao.query().size() >= 2); }
public List<GroupOperationModel> query() { return DataConfig.jdbcTemplate().query("select group_id, operation from service_group_operation", new RowMapper<GroupOperationModel>() { @Override public GroupOperationModel mapRow(ResultSet rs, int i) throws SQLException { GroupOperationModel groupOperation = new GroupOperationModel(); groupOperation.setGroupId(rs.getLong(1)); groupOperation.setOperation(rs.getString(2)); return groupOperation; } }); }
GroupOperationDao { public List<GroupOperationModel> query() { return DataConfig.jdbcTemplate().query("select group_id, operation from service_group_operation", new RowMapper<GroupOperationModel>() { @Override public GroupOperationModel mapRow(ResultSet rs, int i) throws SQLException { GroupOperationModel groupOperation = new GroupOperationModel(); groupOperation.setGroupId(rs.getLong(1)); groupOperation.setOperation(rs.getString(2)); return groupOperation; } }); } }
GroupOperationDao { public List<GroupOperationModel> query() { return DataConfig.jdbcTemplate().query("select group_id, operation from service_group_operation", new RowMapper<GroupOperationModel>() { @Override public GroupOperationModel mapRow(ResultSet rs, int i) throws SQLException { GroupOperationModel groupOperation = new GroupOperationModel(); groupOperation.setGroupId(rs.getLong(1)); groupOperation.setOperation(rs.getString(2)); return groupOperation; } }); } private  GroupOperationDao(); }
GroupOperationDao { public List<GroupOperationModel> query() { return DataConfig.jdbcTemplate().query("select group_id, operation from service_group_operation", new RowMapper<GroupOperationModel>() { @Override public GroupOperationModel mapRow(ResultSet rs, int i) throws SQLException { GroupOperationModel groupOperation = new GroupOperationModel(); groupOperation.setGroupId(rs.getLong(1)); groupOperation.setOperation(rs.getString(2)); return groupOperation; } }); } private  GroupOperationDao(); List<GroupOperationModel> query(); }
GroupOperationDao { public List<GroupOperationModel> query() { return DataConfig.jdbcTemplate().query("select group_id, operation from service_group_operation", new RowMapper<GroupOperationModel>() { @Override public GroupOperationModel mapRow(ResultSet rs, int i) throws SQLException { GroupOperationModel groupOperation = new GroupOperationModel(); groupOperation.setGroupId(rs.getLong(1)); groupOperation.setOperation(rs.getString(2)); return groupOperation; } }); } private  GroupOperationDao(); List<GroupOperationModel> query(); static final GroupOperationDao INSTANCE; }