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:com.dai.dao.PerfilDaoImpl.java

@Override
public List<Perfil> listarPerfil() {
    List<Perfil> lp = new ArrayList();
    JdbcTemplate template = new JdbcTemplate(dataSource);
    lp = template.query("SELECT * FROM perfil", new PerfilRowMapper());
    return lp;// w w w .  j  a v  a2  s  .  c om
}

From source file:org.smigo.user.JdbcUserDao.java

@Autowired
public void setDataSource(DataSource dataSource) {
    this.jdbcTemplate = new JdbcTemplate(dataSource);
    this.insert = new SimpleJdbcInsert(dataSource).withTableName("users").usingGeneratedKeyColumns("id")
            .usingColumns("username", "locale", "termsofservice", "email", "displayname", "decidetime", "about",
                    "password");
    this.insertOpenId = new SimpleJdbcInsert(dataSource).withTableName("openid").usingGeneratedKeyColumns("id");
}

From source file:com.nebhale.cyclinglibrary.repository.JdbcTypeRepository.java

@Autowired
JdbcTypeRepository(DataSource dataSource) {
    this.jdbcTemplate = new JdbcTemplate(dataSource);
    this.createStatement = new SimpleJdbcInsert(dataSource).withTableName("types")
            .usingGeneratedKeyColumns("id");
}

From source file:com.springsource.greenhouse.invite.mail.MailInviteServiceTest.java

@Before
public void setUp() {
    db = new GreenhouseTestDatabaseBuilder().member().activity().invite().testData(getClass()).getDatabase();
    jdbcTemplate = new JdbcTemplate(db);
    InviteRepository inviteRepository = new JdbcInviteRepository(jdbcTemplate, null);
    mailSender = mock(MailSender.class);
    inviteService = new AsyncMailInviteService(mailSender, inviteRepository,
            "http://localhost:8443/invite/accept?token={token}");
}

From source file:com.nebhale.cyclinglibrary.repository.JdbcItemRepository.java

@Autowired
JdbcItemRepository(DataSource dataSource) {
    this.jdbcTemplate = new JdbcTemplate(dataSource);
    this.createStatement = new SimpleJdbcInsert(dataSource).withTableName("items")
            .usingGeneratedKeyColumns("id");
}

From source file:com.github.fedorchuck.webstore.dao.impl.postgresql.JdbcUserRepositoryTest.java

@Before
@Ignore/*from   w w  w. j  a va  2  s  .  c  o  m*/
public void setUp() {
    try {
        //TODO: should be rewritten.

        DriverManagerDataSource dataSource = new DriverManagerDataSource();
        dataSource.setDriverClassName(Config.DRIVERCLASSNAME);
        dataSource.setUrl(Config.URL);
        dataSource.setUsername(Config.USERNAME);
        dataSource.setPassword(Config.PASSWORD);
        jdbc = new JdbcUserRepository(new JdbcTemplate(dataSource));
        //TODO: run creating scripts.
        Assert.assertTrue(true);
    } catch (Throwable throwable) {
        Assert.fail(throwable.getMessage());
    }
}

From source file:org.jasig.cas.web.support.InspektrThrottledSubmissionByIpAddressAndUsernameHandlerInterceptorAdapter.java

public InspektrThrottledSubmissionByIpAddressAndUsernameHandlerInterceptorAdapter(
        final AuditTrailManager auditTrailManager, final DataSource dataSource) {
    this.auditTrailManager = auditTrailManager;
    this.jdbcTemplate = new JdbcTemplate(dataSource);
}

From source file:com.seajas.search.utilities.logging.dao.LoggingDAO.java

/**
 * Initialize the database table.//from   www.j  av a2s  .c  om
 * 
 * @param dataSource
 */
@Autowired
public LoggingDAO(final DataSource dataSource) {
    this.jdbc = new JdbcTemplate(dataSource);

    try {
        jdbc.execute(
                "CREATE CACHED TABLE logging (id INT IDENTITY, level VARCHAR(255) NOT NULL, message VARCHAR(8196) NOT NULL, "
                        + "creation_date DATETIME NOT NULL)");
    } catch (DataAccessException e) {
        if (logger.isDebugEnabled())
            logger.debug("Table 'logging' likely already exists as it could not be created");
    }
}

From source file:net.paoding.rose.jade.dataaccess.DataAccessFactoryAdapter.java

@Override
public DataAccess getDataAccess(StatementMetaData metaData, Map<String, Object> runtime) {
    DataSourceHolder holder = dataSourceFactory.getHolder(metaData, runtime);
    while (holder != null && holder.isFactory()) {
        holder = holder.getFactory().getHolder(metaData, runtime);
    }//from   w w w .j av  a2s . c  o  m
    if (holder == null || holder.getDataSource() == null) {
        throw new NullPointerException("cannot found a dataSource for: " + metaData);
    }
    JdbcTemplate jdbcTemplate = new JdbcTemplate(holder.getDataSource());
    return new DataAccessImpl(jdbcTemplate);
}

From source file:com.emc.ecs.sync.service.SqliteDbService.java

protected JdbcTemplate createJdbcTemplate() {
    SingleConnectionDataSource ds = new SingleConnectionDataSource();
    ds.setUrl(JDBC_URL_BASE + getDbFile());
    ds.setSuppressClose(true);//from  w  ww . ja  v a  2  s .c  om
    return new JdbcTemplate(ds);
}