this.jdbcTemplate.query("select * from ******",new RowMapper());
private List<org.drools.workbench.services.verifier.plugin.client.Coordinate> convert(final List<Coordinate> updates) { final ArrayList<org.drools.workbench.services.verifier.plugin.client.Coordinate> result = new ArrayList<>(); for (final Coordinate coordinate : updates) { result.add(new org.drools.workbench.services.verifier.plugin.client.Coordinate(coordinate.getRow(), coordinate.getCol())); } return result; }
protected DynamicDataRow makeRow() { DynamicDataRow row = new DynamicDataRow(); for ( CellValue<?> cell : makeCellValueList() ) { row.add( cell ); } return row; }
@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 setup() { super.setup(); //Setup date to merge //[1][-][3] //[1][2][*] //[-][2][3] data.get( 0 ).get( 0 ).setValue( "1" ); data.get( 0 ).get( 1 ).setValue( "-" ); data.get( 0 ).get( 2 ).setValue( "3" ); data.get( 1 ).get( 0 ).setValue( "1" ); data.get( 1 ).get( 1 ).setValue( "2" ); data.get( 1 ).get( 2 ).addState( CellState.OTHERWISE ); data.get( 2 ).get( 0 ).setValue( "-" ); data.get( 2 ).get( 1 ).setValue( "2" ); data.get( 2 ).get( 2 ).setValue( "3" ); }
@Override public void showContextMenu( int index, int clientX, int clientY ) { contextMenu.setContextRows( rowMapper.mapToAllAbsoluteRows( index ) ); contextMenu.setPopupPosition( clientX, clientY ); contextMenu.show(); }
@Before public void setup() { super.setup(); //Setup date to merge //[1][-][3] //[1][2][3] //[-][2][3] data.get( 0 ).get( 0 ).setValue( "1" ); data.get( 0 ).get( 1 ).setValue( "-" ); data.get( 0 ).get( 2 ).setValue( "3" ); data.get( 1 ).get( 0 ).setValue( "1" ); data.get( 1 ).get( 1 ).setValue( "2" ); data.get( 1 ).get( 2 ).setValue( "3" ); data.get( 2 ).get( 0 ).setValue( "-" ); data.get( 2 ).get( 1 ).setValue( "2" ); data.get( 2 ).get( 2 ).setValue( "3" ); }
protected DynamicDataRow makeRow() { DynamicDataRow row = new DynamicDataRow(); for ( CellValue<?> cell : makeCellValueList() ) { row.add( cell ); } return row; }
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; } });
@Before public void setup() { super.setup(); //Setup date to merge //[1][-][3] //[1][2][3] //[-][2][3] data.get( 0 ).get( 0 ).setValue( "1" ); data.get( 0 ).get( 1 ).setValue( "-" ); data.get( 0 ).get( 2 ).setValue( "3" ); data.get( 1 ).get( 0 ).setValue( "1" ); data.get( 1 ).get( 1 ).setValue( "2" ); data.get( 1 ).get( 2 ).setValue( "3" ); data.get( 2 ).get( 0 ).setValue( "-" ); data.get( 2 ).get( 1 ).setValue( "2" ); data.get( 2 ).get( 2 ).setValue( "3" ); }
protected DynamicDataRow makeRow() { DynamicDataRow row = new DynamicDataRow(); for ( CellValue<?> cell : makeCellValueList() ) { row.add( cell ); } return row; }
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")); } });
@Before public void setup() { super.setup(); //Setup date to merge //[1][-][3] //[1][2][3] //[-][2][3] data.get( 0 ).get( 0 ).setValue( "1" ); data.get( 0 ).get( 1 ).setValue( "-" ); data.get( 0 ).get( 2 ).setValue( "3" ); data.get( 1 ).get( 0 ).setValue( "1" ); data.get( 1 ).get( 1 ).setValue( "2" ); data.get( 1 ).get( 2 ).setValue( "3" ); data.get( 2 ).get( 0 ).setValue( "-" ); data.get( 2 ).get( 1 ).setValue( "2" ); data.get( 2 ).get( 2 ).setValue( "3" ); }
protected DynamicDataRow makeRow() { DynamicDataRow row = new DynamicDataRow(); for ( CellValue<?> cell : makeCellValueList() ) { row.add( cell ); } return row; }
@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; } }); }
@Before public void setup() { super.setup(); //Setup date to merge //[1][-][3] //[1][2][3] //[-][2][3] data.get( 0 ).get( 0 ).setValue( "1" ); data.get( 0 ).get( 1 ).setValue( "-" ); data.get( 0 ).get( 2 ).setValue( "3" ); data.get( 1 ).get( 0 ).setValue( "1" ); data.get( 1 ).get( 1 ).setValue( "2" ); data.get( 1 ).get( 2 ).setValue( "3" ); data.get( 2 ).get( 0 ).setValue( "-" ); data.get( 2 ).get( 1 ).setValue( "2" ); data.get( 2 ).get( 2 ).setValue( "3" ); }
public void onSetInternalModel( SetInternalModelEvent<TemplateModel, TemplateDataColumn> event ) { this.data = event.getData(); this.rowMapper = new RowMapper( this.data ); this.redraw(); }
@Before public void setup() { super.setup(); //Setup date to merge //[1][-][3] //[1][2][3] //[-][2][3] data.get( 0 ).get( 0 ).setValue( "1" ); data.get( 0 ).get( 1 ).setValue( "-" ); data.get( 0 ).get( 2 ).setValue( "3" ); data.get( 1 ).get( 0 ).setValue( "1" ); data.get( 1 ).get( 1 ).setValue( "2" ); data.get( 1 ).get( 2 ).setValue( "3" ); data.get( 2 ).get( 0 ).setValue( "-" ); data.get( 2 ).get( 1 ).setValue( "2" ); data.get( 2 ).get( 2 ).setValue( "3" ); }
@Before public void setup() { super.setup(); //Setup date to merge //[1][-][3] //[1][2][3] //[-][2][3] data.get( 0 ).get( 0 ).setValue( "1" ); data.get( 0 ).get( 1 ).setValue( "-" ); data.get( 0 ).get( 2 ).setValue( "3" ); data.get( 1 ).get( 0 ).setValue( "1" ); data.get( 1 ).get( 1 ).setValue( "2" ); data.get( 1 ).get( 2 ).setValue( "3" ); data.get( 2 ).get( 0 ).setValue( "-" ); data.get( 2 ).get( 1 ).setValue( "2" ); data.get( 2 ).get( 2 ).setValue( "3" ); }
@Before public void setup() { super.setup(); //Setup date to merge //[1][-][3] //[1][2][3] //[-][2][3] data.get( 0 ).get( 0 ).setValue( "1" ); data.get( 0 ).get( 1 ).setValue( "-" ); data.get( 0 ).get( 2 ).setValue( "3" ); data.get( 1 ).get( 0 ).setValue( "1" ); data.get( 1 ).get( 1 ).setValue( "2" ); data.get( 1 ).get( 2 ).setValue( "3" ); data.get( 2 ).get( 0 ).setValue( "-" ); data.get( 2 ).get( 1 ).setValue( "2" ); data.get( 2 ).get( 2 ).setValue( "3" ); }