this.jdbcTemplate.query("select * from ******",new RowMapper());
RowMapper rowMapper = new RowMapper( data ); CellValue<? extends Comparable<?>> cv = data.get( 1 ).get( 0 ); results = rowMapper.mapToAllAbsoluteRows( 0 ); assertEquals( 1, results.size() ); assertTrue( results.contains( 0 ) ); results = rowMapper.mapToAllAbsoluteRows( 1 ); assertEquals( 3, results.size() ); results = rowMapper.mapToAllAbsoluteRows( 2 ); assertEquals( 1, results.size() ); assertTrue( results.contains( 4 ) ); results = rowMapper.mapToAllAbsoluteRows( 3 ); assertEquals( 1, results.size() ); assertTrue( results.contains( 5 ) ); results = rowMapper.mapToAllAbsoluteRows( 4 ); assertEquals( 1, results.size() ); assertTrue( results.contains( 6 ) ); results = rowMapper.mapToAllAbsoluteRows( 5 ); assertEquals( 1,
RowMapper rowMapper = new RowMapper( data ); CellValue<? extends Comparable<?>> cv = data.get( 1 ).get( 0 ); rowMapper.mapToMergedRow( 0 ) ); assertEquals( 1, rowMapper.mapToMergedRow( 1 ) ); assertEquals( 1, rowMapper.mapToMergedRow( 2 ) ); assertEquals( 1, rowMapper.mapToMergedRow( 3 ) ); assertEquals( 2, rowMapper.mapToMergedRow( 4 ) ); assertEquals( 3, rowMapper.mapToMergedRow( 5 ) ); assertEquals( 4, rowMapper.mapToMergedRow( 6 ) ); assertEquals( 5, rowMapper.mapToMergedRow( 7 ) );
@Test public void testMapToAbsoluteRow() { //0=[-][-][-] --> 0=[-][-][-] //1=[1][1][1] --> 1=[1][1][1] //2=[1][1][1] --> 2=[2][2][2] //3=[1][1][1] --> 3=[2][2][2] //4=[2][2][2] --> 4=[2][2][2] //5=[2][2][2] --> 5=[-][-][-] //6=[2][2][2] //7=[-][-][-] RowMapper rowMapper = new RowMapper( data ); CellValue<? extends Comparable<?>> cv = data.get( 1 ).get( 0 ); data.setMerged( true ); data.applyModelGrouping( cv ); assertEquals( 0, rowMapper.mapToAbsoluteRow( 0 ) ); assertEquals( 1, rowMapper.mapToAbsoluteRow( 1 ) ); assertEquals( 4, rowMapper.mapToAbsoluteRow( 2 ) ); assertEquals( 5, rowMapper.mapToAbsoluteRow( 3 ) ); assertEquals( 6, rowMapper.mapToAbsoluteRow( 4 ) ); assertEquals( 7, rowMapper.mapToAbsoluteRow( 5 ) ); }
@Override public void showContextMenu( int index, int clientX, int clientY ) { contextMenu.setContextRows( rowMapper.mapToAllAbsoluteRows( index ) ); contextMenu.setPopupPosition( clientX, clientY ); contextMenu.show(); }
private final JdbcTemplate jdbcTemplate; @Autowired public YourRepository(DataSource ds) { this.jdbcTemplate=new JdbcTemplate(ds); } public List<User> getAllUsers() { List<User> list = new ArrayList<>(); return this.jdbcTemplate("select * from V_USERS t", new RowMapper() { public User mapRow(ResultSet rs, int row) throws SQLException { return RowFetcher.fetchUser(rs); } }); }
String SQL = "select i_out, str_out from test_function1(:id)"; SqlParameterSource namedParameters = new MapSqlParameterSource("id", request.getIntTestVar()); List<TRPerson> result = namedTemplate.query(SQL, namedParameters, new RowMapper() { @Override public TRPerson mapRow(ResultSet rs, int i) throws SQLException { TRPerson result = new TRPerson(); result.setIntVar(rs.getInt("i_out")); result.setStrVar(rs.getString("str_out")); return result; } });
JdbcTemplate template = new JdbcTemplate(dataSource); List data = template.query(sql, new RowMapper() { ... });
String sql = "SELECT * FROM Employee WHERE EMP_ID = ?"; Employee emp = (Employee)getJdbcTemplate().queryForObject( sql, new Object[] { empId }, new RowMapper() { @Override public Object mapRow(ResultSet rs, int rowNum) throws SQLException { Employee emp = new Employee(); emp.setEmpId(rs.getInt("EMP_ID")); } });
@SuppressWarnings("unchecked") protected List<GrantedAuthority> loadGroupAuthorities(String username) { return getJdbcTemplate().query(groupAuthoritiesByUsernameQuery, new String[] {username}, new RowMapper() { @SuppressWarnings("deprecation") public Object mapRow(ResultSet rs, int rowNum) throws SQLException { String roleName = rs.getString("permissionname"); GrantedAuthorityImpl authority = new GrantedAuthorityImpl(roleName); return authority; } }); }
public static Hashtable<Long, Dogs> getSomeDogs(String colName, String colValue) { StringBuffer sql = new StringBuffer(); sql.append("SELECT * FROM ").append("dogs_table"); sql.append(" WHERE ").append(colName).append("='"); sql.append(colValue).append("'"); Hashtable<Long, Dogs> result = new Hashtable<Long, Dogs>(); RowMapper mapper = new RowMapper() { public Object mapRow(ResultSet rs, int rowNum) throws SQLException { Dogs dog = new Dogs(); //...initialize the dog from the current resultSet row result.put(new Long(dog.getId()), dog); } }; (Hashtable<Long, Dogs>) jdbcTemplate.queryForObject(sql, mapper); }
public class EmpDao { private JdbcTemplate jt; public List<EmpDto> listEmpoyees(){ String sql = "select * FROM emp"; List<EmpDto> emplist = jt.query(sql, new RowMapper() { public EmpDto mapRow(ResultSet rs, int rowNum) throws SQLException { EmpDto emp = new EmpDto(); emp.setId(rs.getInt("id")); emp.setName(rs.getString("name")); emp.setAge(rs.getInt("age")); emp.setSalary(rs.getInt("salary")); emp.setAddress(rs.getString("address")); System.out.println("***"); return emp; } }); return emplist; }}
public static List Authenticate(String userName, String password) { List names = template.query("select clinicId from doc_user where userName='"+userName+"' and passwd='"+password+"'", new RowMapper() { public Object mapRow(ResultSet resultSet, int i) throws SQLException { Login loginBean = new Login(); loginBean.setClinicId(String.valueOf(resultSet.getInt(1))); return loginBean ; } }); return names; }
NamedParameterJdbcTemplate namedJdbcTemplate = new NamedParameterJdbcTemplate( jdbcTemplate.getDataSource() ); Set<String> maps = new HashSet<String>(); maps.add("long") maps.add("red") maps.add("wire") MapSqlParameterSource params = new MapSqlParameterSource(); params.addValue("tags", maps ); namedJdbcTemplate.query( "SELECT ... tags in (:tags)" , params , new RowMapper() { @Override public Object mapRow(ResultSet rs, int arg1) throws SQLException { .... } });
LobHandler lobHandler = new DefaultLobHandler(); List<FrontendData> frontEndDataList = jdbcTemplate.query(getResponseQuery(sessionId), new RowMapper() { @Override public Object mapRow(ResultSet rs, int rowNum) throws SQLException { // TODO Auto-generated method stub FrontendData frontEndData = new FrontendData(); String operationName = rs.getString("OPERATION_NAME"); frontEndData.setApiName(operationName); byte[] requestData = lobHandler.getBlobAsBytes(rs,"RESPONSE_MESSAGE"); frontEndData.setResponse(new String(requestData)); return frontEndData; }});
public void onSetInternalModel( SetInternalModelEvent<TemplateModel, TemplateDataColumn> event ) { this.data = event.getData(); this.rowMapper = new RowMapper( this.data ); this.redraw(); }
StoredProcedure storedProcedure = new StoredProcedure( DataSourceFactory.getSomeDatasource(), "_SomeStoredProc" ) {}; storedProcedure.declareParameter( new SqlReturnResultSet( "foo", new RowMapper() { public Object mapRow( final ResultSet rs, final int rowNum ) throws SQLException { return rs.getObject( 1 ); } } ) ); storedProcedure.declareParameter( new SqlParameter( "inParamName", Types.VARCHAR ) ); HashMap< Object, Object > inParams = new HashMap< Object, Object >(); inParams.put( "inParamName", "myparam" ); Map execute = storedProcedure.execute( inParams ); System.out.println( execute.get( "foo" ) );