Package org.springframework.jdbc.core

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

71
72
73
74
75
76
77
78
79
80
81
        for (String idx : indexes.stringPropertyNames()) {
            LOG.debug("Creating index {}", indexes.get(idx).toString());

            try {
                jdbcTemplate.execute(indexes.get(idx).toString());
            } catch (DataAccessException e) {
                LOG.error("Could not create index ", e);
            }
        }
View Full Code Here
89
90
91
92
93
94
95
96
97
98
99
        for (String idx : views.stringPropertyNames()) {
            LOG.debug("Creating view {}", views.get(idx).toString());

            try {
                jdbcTemplate.execute(views.get(idx).toString().replaceAll("\\n", " "));
            } catch (DataAccessException e) {
                LOG.error("Could not create view ", e);
            }
        }
View Full Code Here
34
35
36
37
38
39
40
41
42
43
44
   */
  public static void loadFunction(JdbcTemplateDao dao, PostgreSQLFunction dbFunction) throws ApplicationException {
    JdbcTemplate jdbcTemplate = dao.getJdbcTemplate();

    // initialize drop procedure, if database has been dropped
    jdbcTemplate.execute(new ResourceUtil(DROP_FUNCTION.getURI()).getContent());

    // drop previous function version, if necessary
    jdbcTemplate.queryForInt("select util.drop_function( ?,? )",
        dbFunction.getSchema(), dbFunction.getFunctionName());

View Full Code Here
41
42
43
44
45
46
47
48
49
50
51
    // drop previous function version, if necessary
    jdbcTemplate.queryForInt("select util.drop_function( ?,? )",
        dbFunction.getSchema(), dbFunction.getFunctionName());

    // load new function body
    jdbcTemplate.execute(new ResourceUtil(dbFunction.getURI()).getContent());
  }

  public static void loadAllFunctions(JdbcTemplateDao dao) throws ApplicationException {
    for (PostgreSQLFunction dbFunction : PostgreSQLFunction.values()) {
      loadFunction(dao, dbFunction);
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
    }
  }
 
  public static void truncateTables(JdbcTemplateDao dao) throws ApplicationException {
    JdbcTemplate jdbcTemplate = dao.getJdbcTemplate();
    jdbcTemplate.execute("truncate music.artist cascade");
    jdbcTemplate.execute("truncate library.directory cascade");
    jdbcTemplate.execute("truncate music.tag cascade");
    jdbcTemplate.execute("truncate music.lastfmuser cascade");
   
    /*
 
View Full Code Here
53
54
55
56
57
58
59
60
61
62
63
  }
 
  public static void truncateTables(JdbcTemplateDao dao) throws ApplicationException {
    JdbcTemplate jdbcTemplate = dao.getJdbcTemplate();
    jdbcTemplate.execute("truncate music.artist cascade");
    jdbcTemplate.execute("truncate library.directory cascade");
    jdbcTemplate.execute("truncate music.tag cascade");
    jdbcTemplate.execute("truncate music.lastfmuser cascade");
   
    /*
     * If we really wanted to truncate all tables, we could do:
View Full Code Here
54
55
56
57
58
59
60
61
62
63
64
 
  public static void truncateTables(JdbcTemplateDao dao) throws ApplicationException {
    JdbcTemplate jdbcTemplate = dao.getJdbcTemplate();
    jdbcTemplate.execute("truncate music.artist cascade");
    jdbcTemplate.execute("truncate library.directory cascade");
    jdbcTemplate.execute("truncate music.tag cascade");
    jdbcTemplate.execute("truncate music.lastfmuser cascade");
   
    /*
     * If we really wanted to truncate all tables, we could do:
     * loadFunction(dao, PostgreSQLFunction.TRUNCATE_ALL_TABLES);
View Full Code Here
55
56
57
58
59
60
61
62
63
64
65
  public static void truncateTables(JdbcTemplateDao dao) throws ApplicationException {
    JdbcTemplate jdbcTemplate = dao.getJdbcTemplate();
    jdbcTemplate.execute("truncate music.artist cascade");
    jdbcTemplate.execute("truncate library.directory cascade");
    jdbcTemplate.execute("truncate music.tag cascade");
    jdbcTemplate.execute("truncate music.lastfmuser cascade");
   
    /*
     * If we really wanted to truncate all tables, we could do:
     * loadFunction(dao, PostgreSQLFunction.TRUNCATE_ALL_TABLES);
     * jdbcTemplate.execute("select util.truncate_all_tables()");
View Full Code Here
230
231
232
233
234
235
236
237
238
239
                    createTableSql.append(")");
                } else {
                    createTableSql.append(", ");
                }
            }
            jdbcTemplate.execute(createTableSql.toString());
        }
    }

}
View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
    public void afterPropertiesSet() throws Exception {
        //because we're using an in-memory hsqldb for the sample app, a new one will be created each time the
        //app starts, so insert the sample admin user at startup:
        JdbcTemplate jdbcTemplate = new JdbcTemplate(this.dataSource);

        jdbcTemplate.execute("insert into roles values (1, 'user', 'The default role given to all users.')");
        jdbcTemplate.execute("insert into roles values (2, 'admin', 'The administrator role only given to site admins')");
        jdbcTemplate.execute("insert into roles_permissions values (2, 'user:*')");
        jdbcTemplate.execute("insert into users(id,username,email,password) values (1, 'admin', 'sample@shiro.apache.org', '" + new Sha256Hash("admin").toHex() + "')");
        jdbcTemplate.execute("insert into users_roles values (1, 2)");

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.