Examples of org.springframework.jdbc.core.JdbcTemplate$SimpleCallableStatementCreator

org.springframework.jdbc.core.JdbcTemplate
Simple adapter for CallableStatementCreator, allowing to use a plain SQL statement.


        userTO = createUser(userTO);
        assertNotNull(userTO);
        assertEquals(1, userTO.getResources().size());


        JdbcTemplate jdbcTemplate = new JdbcTemplate(testDataSource);


        String username = jdbcTemplate.queryForObject("SELECT id FROM test WHERE id=?", String.class,
                userTO.getUsername());


        assertEquals(userTO.getUsername(), username);


        UserMod userMod = new UserMod();


        userMod.setId(userTO.getId());
        userMod.addResourceToBeRemoved(RESOURCE_NAME_TESTDB);


        userTO = userService.update(userMod.getId(), userMod);


        assertTrue(userTO.getResources().isEmpty());


        jdbcTemplate.queryForObject("SELECT id FROM test WHERE id=?", String.class, userTO.getUsername());
    }

View Full Code Here

        actual = userService.read(actual.getId());
        assertEquals("virattrcache", actual.getVirtualAttributeMap().get("virtualdata").getValues().get(0));


        Exception exception = null;
        try {
            final JdbcTemplate jdbcTemplate = new JdbcTemplate(testDataSource);


            String value = jdbcTemplate.queryForObject(
                    "SELECT USERNAME FROM testsync WHERE ID=?", String.class, actual.getId());
            assertEquals("virattrcache", value);


            jdbcTemplate.update("UPDATE testsync set USERNAME='virattrcache2' WHERE ID=?", userTO.getId());


            value = jdbcTemplate.queryForObject(
                    "SELECT USERNAME FROM testsync WHERE ID=?", String.class, userTO.getId());
            assertEquals("virattrcache2", value);


        } catch (EmptyResultDataAccessException e) {
            exception = e;

View Full Code Here

        if (bundleContext != null) {
            applicationContext.setBundleContext(bundleContext);
            applicationContext.refresh();
        }
        ds = applicationContext.getBean("dataSource", DataSource.class);
        jdbcTemplate = new JdbcTemplate(ds);
        return SpringCamelContext.springCamelContext(applicationContext);
    }

View Full Code Here

        this.dataSource = dataSource;
        this.rootElement = rootElement;
    }


    private Object[] getParameters(final String tableName, final Attributes attrs) {
        JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);


        Map<String, Integer> colTypes = jdbcTemplate.query("SELECT * FROM " + tableName,
                new ResultSetExtractor<Map<String, Integer>>() {


            @Override
            public Map<String, Integer> extractData(final ResultSet rs) throws SQLException, DataAccessException {
                Map<String, Integer> colTypes = new HashMap<String, Integer>();

View Full Code Here

                values.append(',');
            }
        }
        query.append(") VALUES (").append(values).append(')');


        JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);


        try {
            jdbcTemplate.update(query.toString(), getParameters(qName, atts));
        } catch (DataAccessException e) {
            LOG.error("While trying to perform {}", query, e);
        }
    }

View Full Code Here

        
        ModelAndView result = new ModelAndView("index");
        
        ArrayList<String> tables = new ArrayList<String>();
        
        JdbcTemplate tplate = new JdbcTemplate(hsqlInMemory);
        
        SqlRowSet retr = tplate.queryForRowSet(
            "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES");
        
        while (retr.next()) {
            tables.add(retr.getString(1));
        }

View Full Code Here

  private final String sql;


  public JdbcSlimRunner(final String driverClassname, final String url, final String username, final String password, final String sql)
          throws ClassNotFoundException {
    Class.forName(driverClassname);
    this.template = new JdbcTemplate(new SingleConnectionDataSource(url, username, password, false));
    this.sql = sql;
  }

View Full Code Here

    }


    public void afterPropertiesSet() throws Exception {
        //because we're using an in-memory hsqldb for the sample app, a new one will be created each time the
        //app starts, so insert the sample admin user at startup:
        JdbcTemplate jdbcTemplate = new JdbcTemplate(this.dataSource);


        jdbcTemplate.execute("insert into roles values (1, 'user', 'The default role given to all users.')");
        jdbcTemplate.execute("insert into roles values (2, 'admin', 'The administrator role only given to site admins')");
        jdbcTemplate.execute("insert into roles_permissions values (2, 'user:*')");
        jdbcTemplate.execute("insert into users(id,username,email,password) values (1, 'admin', 'sample@shiro.apache.org', '" + new Sha256Hash("admin").toHex() + "')");
        jdbcTemplate.execute("insert into users_roles values (1, 2)");




    }

View Full Code Here

        super.resetRestTemplate();
    }


    @Test
    public void createWithApproval() {
        JdbcTemplate jdbcTemplate = new JdbcTemplate(testDataSource);


        UserTO userTO = getSampleTO("createWithApproval@syncope.apache.org");
        userTO.addResource("resource-testdb");


        // User with role 9 are defined in workflow as subject to approval
        MembershipTO membershipTO = new MembershipTO();
        membershipTO.setRoleId(9L);
        userTO.addMembership(membershipTO);


        // 1. create user with role 9 (and verify that no propagation occurred)
        userTO = restTemplate.postForObject(BASE_URL + "user/create", userTO, UserTO.class);
        assertNotNull(userTO);
        assertEquals(1, userTO.getMemberships().size());
        assertEquals(9, userTO.getMemberships().get(0).getRoleId());
        assertEquals("createApproval", userTO.getStatus());
        assertEquals(Collections.singleton("resource-testdb"), userTO.getResources());


        assertTrue(userTO.getPropagationTOs().isEmpty());


        Exception exception = null;
        try {
            jdbcTemplate.queryForInt("SELECT id FROM test WHERE id=?", userTO.getUsername());
        } catch (EmptyResultDataAccessException e) {
            exception = e;
        }
        assertNotNull(exception);


        // 2. request if there is any pending task for user just created
        WorkflowFormTO form = restTemplate.getForObject(BASE_URL + "user/workflow/form/{userId}", WorkflowFormTO.class,
                userTO.getId());
        assertNotNull(form);
        assertNotNull(form.getTaskId());
        assertNull(form.getOwner());


        // 4. claim task (from admin)
        form = restTemplate.getForObject(BASE_URL + "user/workflow/form/claim/{taskId}", WorkflowFormTO.class, form.
                getTaskId());
        assertNotNull(form);
        assertNotNull(form.getTaskId());
        assertNotNull(form.getOwner());


        // 5. approve user (and verify that propagation occurred)
        Map<String, WorkflowFormPropertyTO> props = form.getPropertyMap();
        props.get("approve").setValue(Boolean.TRUE.toString());
        form.setProperties(props.values());
        userTO = restTemplate.postForObject(BASE_URL + "user/workflow/form/submit", form, UserTO.class);
        assertNotNull(userTO);
        assertEquals("active", userTO.getStatus());
        assertEquals(Collections.singleton("resource-testdb"), userTO.getResources());


        exception = null;
        try {
            final String username = jdbcTemplate.queryForObject("SELECT id FROM test WHERE id=?", String.class, userTO.
                    getUsername());
            assertEquals(userTO.getUsername(), username);
        } catch (EmptyResultDataAccessException e) {
            exception = e;
        }

View Full Code Here


        userTO = restTemplate.postForObject(BASE_URL + "user/create", userTO, UserTO.class);
        assertNotNull(userTO);
        assertEquals(1, userTO.getResources().size());


        JdbcTemplate jdbcTemplate = new JdbcTemplate(testDataSource);


        String username =
                jdbcTemplate.queryForObject("SELECT id FROM test WHERE id=?", String.class, userTO.getUsername());


        assertEquals(userTO.getUsername(), username);


        UserMod userMod = new UserMod();


        userMod.setId(userTO.getId());
        userMod.addResourceToBeRemoved("resource-testdb");


        userTO = restTemplate.postForObject(BASE_URL + "user/update", userMod, UserTO.class);


        assertTrue(userTO.getResources().isEmpty());


        jdbcTemplate.queryForObject("SELECT id FROM test WHERE id=?", String.class, userTO.getUsername());
    }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.springframework.jdbc.core.JdbcTemplate$SimpleCallableStatementCreator

ch.inftec.ju.db.DbSpecificHandlerDefault

ch.inftec.ju.db.DbSpecificHandlerMySql

ch.inftec.ju.db.DbSpecificHandlerOracle

ch.inftec.ju.db.JuConnUtils

com.alibaba.otter.node.etl.common.db.DbDialectTest

com.alibaba.otter.node.etl.load.loader.db.DbLoadAction$DbLoadWorker

com.bank.repository.internal.JdbcAccountRepository

com.bank.service.TransferServiceTests

com.github.hakko.musiccabinet.dao.jdbc.JdbcDatabaseAdministrationDao

com.github.hakko.musiccabinet.dao.util.PostgreSQLUtil

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.