Package org.springframework.jdbc.core

Examples of org.springframework.jdbc.core.JdbcTemplate.queryForList()

24
25
26
27
28
29
30
31
  @Test
  public void queryJdbcData() {
    System.out.println("开始查询数据");
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    System.out.println("通过jdbc查询数据条数："
        + jdbcTemplate.queryForList("select * from user_info").size());
  }
}
View Full Code Here
20
21
22
23
24
25
26
27
  private DataSource dbcp;

  @Test
  public void sett() {
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dbcp);
        System.out.println(jdbcTemplate.queryForList("select * from usertab").size());
  }
}
View Full Code Here
29
30
31
32
33
34
35
36
  @Test
  public void sett() {
     System.out.println("开始初始化12");
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
        System.out.println(jdbcTemplate.queryForList("select * from user_info").size());
  }
}
View Full Code Here
29
30
31
32
33
34
35
36
37
38
39
      @Override
      public void execute(Connection conn) {
        JdbcTemplate jt = JuConnUtils.asJdbcTemplate(conn);
       
        // Reset autoincrement values
        List<Map<String, Object>> res = jt.queryForList("select t.TABLENAME, c.COLUMNNAME " +
            "from sys.SYSCOLUMNS c " +
            "  inner join sys.SYSTABLES t on t.TABLEID = c.REFERENCEID " +
            "where c.AUTOINCREMENTVALUE is not null");
         
        for (Map<String, Object> row : res) {
View Full Code Here
29
30
31
32
33
34
35
36
37
38
39
   
    this.connUtil.doWork(new DbWork() {
      @Override
      public void execute(Connection conn) {
        JdbcTemplate jt = JuConnUtils.asJdbcTemplate(conn);
        res.setValue(jt.queryForList(sql, listType));
      }
    });
   
    return res.getValue();
  }
View Full Code Here
33
34
35
36
37
38
39
40
41
42
43
      @Override
      public void execute(Connection conn) {
        JdbcTemplate jt = JuConnUtils.asJdbcTemplate(conn);
       
        // Reset autoincrement values
        List<Map<String, Object>> res = jt.queryForList("select c.TABLE_NAME, c.COLUMN_NAME " +
          "from information_schema.columns c " +
          "where c.EXTRA='auto_increment'"); //c.TABLE_NAME='Player'"
               
        for (Map<String, Object> row : res) {
          String tableName = row.get("TABLE_NAME").toString();
View Full Code Here
389
390
391
392
393
394
395
396
397
398
399
    DummyJob.param = 0;
    DummyJob.count = 0;

    ClassPathXmlApplicationContext ctx = context("databasePersistence.xml");
    JdbcTemplate jdbcTemplate = new JdbcTemplate(ctx.getBean(DataSource.class));
    assertTrue("No triggers were persisted", jdbcTemplate.queryForList("SELECT * FROM qrtz_triggers").size()>0);
    Thread.sleep(3000);
    try {
      assertTrue(DummyJob.count > 0);
    }
    finally {
View Full Code Here
196
197
198
199
200
201
202
203
204
205
206
    Connection connection = DataSourceUtils.getConnection(csds);
    csds.startCloseSuppression(connection);
    tt.execute(new TransactionCallback<Void>() {
      @Override
      public Void doInTransaction(TransactionStatus status) {
        template.queryForList("select baz from bar");
        template.queryForList("select foo from bar");
        return null;
      }
    });
    tt.execute(new TransactionCallback<Void>() {
View Full Code Here
197
198
199
200
201
202
203
204
205
206
207
    csds.startCloseSuppression(connection);
    tt.execute(new TransactionCallback<Void>() {
      @Override
      public Void doInTransaction(TransactionStatus status) {
        template.queryForList("select baz from bar");
        template.queryForList("select foo from bar");
        return null;
      }
    });
    tt.execute(new TransactionCallback<Void>() {
      @Override
View Full Code Here
204
205
206
207
208
209
210
211
212
213
214
      }
    });
    tt.execute(new TransactionCallback<Void>() {
      @Override
      public Void doInTransaction(TransactionStatus status) {
        template.queryForList("select ham from foo");
        tt2.execute(new TransactionCallback<Void>() {
          @Override
          public Void doInTransaction(TransactionStatus status) {
            template.queryForList("select 1 from eggs");
            return null;
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.