Package org.springframework.jdbc.core

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

100
101
102
103
104
105
106
107
108
109
110
    definition.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED);
    TransactionStatus status=null;
    try {
      status=transactionManager.getTransaction(definition);
      JdbcTemplate template=new JdbcTemplate(getDataSource());
      template.update(UPDATE_FIELD_REQUEST,
          new Object[] {TEST_FIELD_VALUE,new Integer(FIELD_ID)},
          new int[] {Types.VARCHAR,Types.INTEGER});
      transactionManager.rollback(status);
    } catch(Exception ex) {
      ex.printStackTrace();
View Full Code Here
71
72
73
74
75
76
77
78
79
80
81
    this.connectionFactory = connectionFactory;
  }

  private void updateDatabase(String ddlRequest) {
    JdbcTemplate template=new JdbcTemplate(getDataSource());
    template.update(ddlRequest);
  }
 
  protected String[] getConfigLocations() {
    return new String[] { "org/jencks/samples/outbound/jencks-multiple.xml" };
  }
View Full Code Here
122
123
124
125
126
127
128
129
130
131
132
    try {
      status=transactionManager.getTransaction(definition);

      //JDBC
      JdbcTemplate jdbcTemplate=new JdbcTemplate(getDataSource());
      jdbcTemplate.update(UPDATE_FIELD_REQUEST,
          new Object[] {TEST_FIELD_VALUE,new Integer(FIELD_ID)},
          new int[] {Types.VARCHAR,Types.INTEGER});
      //JMS
      JmsTemplate jmsTemplate=new JmsTemplate(getConnectionFactory());
      jmsTemplate.convertAndSend(queue,TEST_MESSAGE);
View Full Code Here
152
153
154
155
156
157
158
159
160
161
162
    try {
      status=transactionManager.getTransaction(definition);

      //JDBC
      JdbcTemplate jdbcTemplate=new JdbcTemplate(getDataSource());
      jdbcTemplate.update(UPDATE_FIELD_REQUEST,
          new Object[] {TEST_FIELD_VALUE,new Integer(FIELD_ID)},
          new int[] {Types.VARCHAR,Types.INTEGER});
      //JMS
      JmsTemplate jmsTemplate=new JmsTemplate(getConnectionFactory());
      jmsTemplate.convertAndSend(queue,TEST_MESSAGE);
View Full Code Here
2259
2260
2261
2262
2263
2264
2265
2266
2267
2268
2269
            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);
View Full Code Here
226
227
228
229
230
231
232
233
234
235
236
        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=?", actual.getId());

        value = jdbcTemplate.queryForObject(
                "SELECT USERNAME FROM testsync WHERE ID=?", String.class, actual.getId());
        assertEquals("virattrcache2", value);
        // ----------------------------------------
View Full Code Here
385
386
387
388
389
390
391
392
393
394
395
        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=?", actual.getId());

        value = jdbcTemplate.queryForObject(
                "SELECT USERNAME FROM testsync WHERE ID=?", String.class, actual.getId());
        assertEquals("virattrcache2", value);
        // ----------------------------------------
View Full Code Here
97
98
99
100
101
102
103
104
105
106
107
                    replaceAll("org\\.apache\\.syncope\\.types\\.",
                    "org.apache.syncope.common.types").
                    replaceAll("org/apache/syncope/types/",
                    "org/apache/syncope/common/types/").
                    getBytes();
            jdbcTemplate.update("UPDATE ACT_GE_BYTEARRAY SET BYTES_=? WHERE ID_=?",
                    new Object[] {updated, row.get("ID_")});
        }
    }

    private String upgradeSyncopeConf() {
View Full Code Here
232
233
234
235
236
237
238
239
240
241
242
                jdbcTemplate.queryForList("SELECT id, serializedInstance FROM ReportletConfInstance");
        for (Map<String, Object> row : rcInstances) {
            String updated = ((String) row.get("serializedInstance")).
                    replaceAll("org\\.apache\\.syncope\\.client\\.report\\.",
                    "org.apache.syncope.common.report.");
            jdbcTemplate.update("UPDATE ReportletConfInstance SET serializedInstance=? WHERE id=?",
                    new Object[] {updated, row.get("id")});
        }
    }

    private void upgradeUserRequest() {
View Full Code Here
120
121
122
123
124
125
126
127
128
129
130
        JdbcTemplate template = new JdbcTemplate( dataSource );

        // if this is a new node, insert it
        if( id == null ) {
            JdbcSettings parent = (JdbcSettings) getParent();
            template.update( "INSERT INTO SETTINGS (KEY, PARENT, USER) VALUES (?, ?, ?)", new Object[] { getName(),
                    parent == null ? null : parent.getId(), user } );
            id = Integer.valueOf( template.queryForInt( "SELECT MAX(ID) FROM SETTINGS" ) );
        } else {
            for( Iterator iter = remove.iterator(); iter.hasNext(); ) {
                String key = (String) iter.next();
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.