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

Introduction

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

Prototype

public JdbcTemplate(DataSource dataSource)

Source Link

Document

Construct a new JdbcTemplate, given a DataSource to obtain connections from.

Usage

From source file:org.cloudfoundry.identity.uaa.scim.job.ClearNamesJobIntegrationTests.java

@Test
public void testJobRuns() throws Exception {
    TestUtils.deleteFrom(cloudControllerDataSource, "users");
    TestUtils.deleteFrom(uaaDataSource, "users");
    JdbcTemplate uaaTemplate = new JdbcTemplate(uaaDataSource);
    uaaTemplate.update(//from   w  ww . ja v a2s.c  om
            "insert into users "
                    + "(id, active, userName, email, password, familyName, givenName, created, lastModified) "
                    + "values (?, ?, ?, ?, ?, ?, ?, ?, ?)",
            "FOO", true, "uniqua", "uniqua@test.org", "ENCRYPT_ME", "Una", "Uniqua", new Date(), new Date());
    uaaTemplate.update(
            "insert into users "
                    + "(id, active, userName, email, password, familyName, givenName, created, lastModified) "
                    + "values (?, ?, ?, ?, ?, ?, ?, ?, ?)",
            "BAR", true, "username", "uniqua@test.org", "ENCRYPT_ME", "uniqua", "test.org", new Date(),
            new Date());
    uaaTemplate.update(
            "insert into users "
                    + "(id, active, userName, email, password, familyName, givenName, created, lastModified) "
                    + "values (?, ?, ?, ?, ?, ?, ?, ?, ?)",
            "SPAM", true, "another", "uniqua@test.org", "ENCRYPT_ME", "another", "another", new Date(),
            new Date());
    JobExecution execution = jobLauncher.run(job,
            new JobParametersBuilder().addDate("start.date", new Date(0L)).toJobParameters());
    assertEquals(BatchStatus.COMPLETED, execution.getStatus());
    Iterator<StepExecution> iterator = execution.getStepExecutions().iterator();
    StepExecution step = iterator.next();
    assertEquals(3, step.getReadCount());
    assertEquals(2, step.getWriteCount());
    assertEquals(2, uaaTemplate.queryForInt("select count(*) from users where givenName is null"));
}

From source file:com.dai.dao.SelecaoTreinoDaoImpl.java

public List<SelecaoTreino> listaST(int idTreino) {

    List<SelecaoTreino> stList = new ArrayList();

    String sql = "select * from selecaoTreino where treino_idtreino=" + idTreino;

    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    stList = jdbcTemplate.query(sql, new SelecaoTreinoRowMapper());
    return stList;
}

From source file:com.github.ebnew.ki4so.core.authentication.handlers.jdbc.AbstractJdbcUsernamePasswordAuthenticationHandler.java

/**
 * Method to set the datasource and generate a JdbcTemplate.
 * /*  w w w  .j av a 2  s .  c o  m*/
 * @param dataSource the datasource to use.
 */
public final void setDataSource(final DataSource dataSource) {
    this.jdbcTemplate = new JdbcTemplate(dataSource);
    this.dataSource = dataSource;
}

From source file:com.rplt.studioMusik.studioMusik.StudioMusikDAO.java

@Override
public void updateData(StudioMusik pStudioMusik) {

    String sql = "UPDATE studio_musik SET " + "nama_studio = ?, " + "tarif_per_jam = ?, " + "jam_buka = ?, "
            + "jam_tutup = ?" + "WHERE kode_studio = ?";
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

    jdbcTemplate.update(sql, new Object[] { pStudioMusik.getmNamaStudio(), pStudioMusik.getmTarifPerJam(),
            pStudioMusik.getmKodeStudio(), pStudioMusik.getmJamBuka(), pStudioMusik.getmJamTutup() });
}

From source file:me.hengwei.t.javaee.spring.springjndidemo.controller.EmployeeController.java

@RequestMapping(value = "/rest/emps", method = RequestMethod.GET)
public @ResponseBody List<Employee> getAllEmployees() {
    logger.info("Start getAllEmployees.");
    List<Employee> empList = new ArrayList<Employee>();
    //JDBC Code - Start
    String query = "select id, name, role from Employee";
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

    List<Map<String, Object>> empRows = jdbcTemplate.queryForList(query);

    for (Map<String, Object> empRow : empRows) {
        Employee emp = new Employee();
        emp.setId(Integer.parseInt(String.valueOf(empRow.get("id"))));
        emp.setName(String.valueOf(empRow.get("name")));
        emp.setRole(String.valueOf(empRow.get("role")));
        empList.add(emp);//from  ww  w  . ja v  a 2s  .co m
    }

    return empList;
}

From source file:com.arcane.dao.Impl.UserDaoImpl.java

@Override
public List<User> list() {
    //return all users
    LOG.info("Returning all the users");
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    String sql = "SELECT * from user";
    List<User> listUser = jdbcTemplate.query(sql, new RowMapper<User>() {

        @Override//from   w w  w. j a va2  s  .  c  om
        public User mapRow(ResultSet rs, int rowNumber) throws SQLException {
            User user = new User();
            user.setUserid(rs.getInt("userid"));
            user.setUsername(rs.getString("username"));
            user.setPassword(rs.getString("password"));
            return user;
        }

    });
    return listUser;
}

From source file:com.google.api.ads.adwords.awalerting.util.JdbcUtil.java

/**
 * Create a JdbcTemplate according to the parameters.
 *
 * @param dbConfig the Json configuration for database connection
 * @param driverKey the key for JDBC driver class name
 * @param urlKey the key for JDBC url/*from w w  w .jav  a2s .c o  m*/
 * @param usernameKey the key for JDBC username
 * @param passwordKey the key JDBC password
 * @return a JdbcTemplate with the given parameters
 */
public static JdbcTemplate createJdbcTemplate(JsonObject dbConfig, String driverKey, String urlKey,
        String usernameKey, String passwordKey) {
    // Read the config values.
    String driver = DEFAULT_DB_DRIVER;
    if (dbConfig.has(driverKey)) {
        driver = dbConfig.get(driverKey).getAsString();
    }

    Preconditions.checkArgument(dbConfig.has(urlKey), "Missing compulsory property: %s", urlKey);
    String url = dbConfig.get(urlKey).getAsString();

    String username = null;
    if (dbConfig.has(usernameKey)) {
        username = dbConfig.get(usernameKey).getAsString();
    }

    String password = null;
    if (dbConfig.has(passwordKey)) {
        password = dbConfig.get(passwordKey).getAsString();
    }

    // Create the data source.
    DriverManagerDataSource dataSource = new DriverManagerDataSource();
    dataSource.setDriverClassName(driver);
    dataSource.setUrl(url);
    dataSource.setUsername(username);
    dataSource.setPassword(password);

    // Create the JdbcTemplate with the data srouce.
    return new JdbcTemplate(dataSource);
}

From source file:com.exploringspatial.dao.text.ConflictDaoTest.java

@PostConstruct
public void postConstruct() {
    jdbcTemplate = new JdbcTemplate(dataSource);
    eventsCsvFile = this.getClass().getResource("/ACLEDtestFile.csv").getFile();
}

From source file:com.dai.dao.JogadorEquipaAdversariaDaoImpl.java

@Override
public List<JogadorEquipaAdversaria> listaJEA(int idEA) {
    List<JogadorEquipaAdversaria> jeaList = new ArrayList();

    String sql = "select * from jogadorEquipaAdversaria where equipaAdversaria_idEquipaAdversaria= " + idEA;

    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    jeaList = jdbcTemplate.query(sql, new JogadorEquipaAdversariaRowMapper());
    return jeaList;
}

From source file:sample.RiderAutoPartsPartnerTest.java

@Before
public void setupDatabase() throws Exception {
    DataSource ds = context.getRegistry().lookup("myDataSource", DataSource.class);
    jdbc = new JdbcTemplate(ds);

    java.util.List rs;//w ww .  ja  v a  2s. c om
    rs = jdbc.queryForList("show tables like 'partner_metric'");

    Iterator it = rs.iterator();
    if (!it.hasNext()) {
        jdbc.execute("create table partner_metric "
                + "( partner_id varchar(10), time_occurred varchar(20), status_code varchar(3), perf_time varchar(10) )");
    }
}