Package org.springframework.jdbc.core

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

72
73
74
75
76
77
78
79
80
81
82
  @Before
  public void init() {
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    maxId = jdbcTemplate.queryForObject("SELECT MAX(ID) from T_FOOS", Integer.class);
    for (int i = maxId + 1; i <= ITEM_COUNT; i++) {
      jdbcTemplate.update("INSERT into T_FOOS (ID,NAME,VALUE) values (?, ?, ?)", i, "foo" + i, i);
    }
    assertEquals(ITEM_COUNT, JdbcTestUtils.countRowsInTable(jdbcTemplate, "T_FOOS"));
  }

  @After
View Full Code Here
80
81
82
83
84
85
86
87
88
89
90
  }

  @After
  public void destroy() {
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    jdbcTemplate.update("DELETE from T_FOOS where ID>?", maxId);
  }

  @Test
  public void testAsyncReader() throws Throwable {
    List<Throwable> throwables = new ArrayList<Throwable>();
View Full Code Here
74
75
76
77
78
79
80
81
82
83
84
  @Before
  public void init() {
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    maxId = jdbcTemplate.queryForObject("SELECT MAX(ID) from T_FOOS", Integer.class);
    for (int i = ITEM_COUNT; i > maxId; i--) {
      jdbcTemplate.update("INSERT into T_FOOS (ID,NAME,VALUE) values (?, ?, ?)", i, "foo" + i, i);
    }
    assertEquals(ITEM_COUNT, JdbcTestUtils.countRowsInTable(jdbcTemplate, "T_FOOS"));
  }

  @After
View Full Code Here
82
83
84
85
86
87
88
89
90
91
92
  }

  @After
  public void destroy() {
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    jdbcTemplate.update("DELETE from T_FOOS where ID>?", maxId);
  }

  @Test
  public void testAsyncReader() throws Throwable {
    List<Throwable> throwables = new ArrayList<Throwable>();
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
  @Before
  public void init() {
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    maxId = jdbcTemplate.queryForObject("SELECT MAX(ID) from T_FOOS", Integer.class);
    for (int i = maxId + 1; i <= ITEM_COUNT; i++) {
      jdbcTemplate.update("INSERT into T_FOOS (ID,NAME,VALUE) values (?, ?, ?)", i, "foo" + i, i);
    }
    assertEquals(ITEM_COUNT, JdbcTestUtils.countRowsInTable(jdbcTemplate, "T_FOOS"));
  }

  @After
View Full Code Here
87
88
89
90
91
92
93
94
95
96
97
  }

  @After
  public void destroy() {
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    jdbcTemplate.update("DELETE from T_FOOS where ID>?", maxId);
  }

  @Test
  public void testAsyncReader() throws Throwable {
    List<Throwable> throwables = new ArrayList<Throwable>();
View Full Code Here
72
73
74
75
76
77
78
79
80
81
82
  @Before
  public void init() {
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    maxId = jdbcTemplate.queryForObject("SELECT MAX(ID) from T_FOOS", Integer.class);
    for (int i = maxId + 1; i <= ITEM_COUNT; i++) {
      jdbcTemplate.update("INSERT into T_FOOS (ID,NAME,VALUE) values (?, ?, ?)", i, "foo" + i, i);
    }
    assertEquals(ITEM_COUNT, JdbcTestUtils.countRowsInTable(jdbcTemplate, "T_FOOS"));
  }

  @After
View Full Code Here
80
81
82
83
84
85
86
87
88
89
90
  }

  @After
  public void destroy() {
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    jdbcTemplate.update("DELETE from T_FOOS where ID>?", maxId);
  }

  @Test
  public void testAsyncReader() throws Throwable {
    List<Throwable> throwables = new ArrayList<Throwable>();
View Full Code Here
53
54
55
56
57
58
59
60
61
62
63
    @Transactional
    public void completeTask(String taskId) {

        // First insert a record in the MY_TABLE table
        JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
        int nrOfRows = jdbcTemplate.update("insert into MY_TABLE values ('test');");
        if (nrOfRows != 1) {
            throw new RuntimeException("Insert into MY_TABLE failed");
        }

        taskService.complete(taskId);
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
    JdbcTemplate j = getJdbcTemplate();
    PreparedStatementCreatorFactory creatorFactory = new PreparedStatementCreatorFactory(
        "INSERT INTO resource_metadata (name,dimension_id,db_type,is_partitioning_resource) VALUES (?,?,?,?)",
        new int[] {Types.VARCHAR,Types.INTEGER,Types.VARCHAR,Types.BIT});
    creatorFactory.setReturnGeneratedKeys(true);
    int rows = j.update(creatorFactory
        .newPreparedStatementCreator(parameters), generatedKey);
    if (rows != 1)
      throw new HiveRuntimeException("Unable to create Resource: "
          + parameters);
    if (generatedKey.getKeyList().size() == 0)
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.