List of usage examples for org.springframework.jdbc.core JdbcTemplate execute
@Override
public void execute(final String sql) throws DataAccessException
From source file:org.jasig.cas.ticket.registry.support.JdbcLockingStrategyTests.java
/** * @throws Exception on test setup./*from w w w .j av a2 s . c o m*/ */ public void setUp() throws Exception { super.setUp(); this.testDataSource = new SimpleDriverDataSource(new org.hsqldb.jdbcDriver(), "jdbc:hsqldb:mem:locktest", "sa", ""); final JdbcTemplate tmpl = new JdbcTemplate(this.testDataSource); tmpl.execute(CREATE_TABLE_SQL); tmpl.execute(CREATE_PRI_KEY_SQL); }
From source file:test.dao.BankDaoTest.java
@Before public void init() { JdbcTemplate jdbc = new JdbcTemplate(dataSource); jdbc.execute("delete from banktable"); banks = creatListOfBanks();/* w ww . j av a 2 s . co m*/ }
From source file:org.beast.project.template.config.MyBatisConfig.java
@Override public DataSource dataSource() { EmbeddedDatabaseBuilder builder = new EmbeddedDatabaseBuilder(); //DataSource ds = builder.setType(EmbeddedDatabaseType.HSQL).addScript("schema.sql").build(); BasicDataSource basicDataSource = new BasicDataSource(); basicDataSource.setDriverClassName(org.hsqldb.jdbcDriver.class.getName()); basicDataSource.setUsername("sa"); basicDataSource.setPassword(""); basicDataSource.setUrl("jdbc:hsqldb:mem:mydb"); JdbcTemplate jdbcTemplate = new JdbcTemplate(basicDataSource); System.out.println("Creating tables"); jdbcTemplate.execute("drop table person if exists"); jdbcTemplate.execute("create table person(id serial, firstName varchar(50), lastName varchar(50))"); jdbcTemplate.update("INSERT INTO users(firstName, lastName) values (?,?)", "Mike", "Lanyon"); return basicDataSource; }
From source file:db.postgres.V2_0_1__InitializeIdentityZones.java
private void dropConstraintsAndColumns(final JdbcTemplate jdbcTemplate) { jdbcTemplate.execute("ALTER TABLE resource DROP CONSTRAINT unique_issuer_client_resource_identifier;"); jdbcTemplate.execute("ALTER TABLE resource DROP COLUMN issuer_id;"); jdbcTemplate.execute("ALTER TABLE resource DROP COLUMN client_id;"); jdbcTemplate.execute("ALTER TABLE subject DROP CONSTRAINT unique_issuer_client_subject_identifier;"); jdbcTemplate.execute("ALTER TABLE subject DROP COLUMN issuer_id;"); jdbcTemplate.execute("ALTER TABLE subject DROP COLUMN client_id;"); jdbcTemplate.execute("ALTER TABLE policy_set DROP CONSTRAINT unique_issuer_client_pset;"); jdbcTemplate.execute("ALTER TABLE policy_set DROP COLUMN issuer_id;"); jdbcTemplate.execute("ALTER TABLE policy_set DROP COLUMN client_id;"); }
From source file:com.sg.capstone.dao.tests.UserDaoTest.java
@Before public void setup() { ApplicationContext ctx = new ClassPathXmlApplicationContext("test-applicationContext.xml"); userDao = (UserDao) ctx.getBean("userDao"); JdbcTemplate cleaner = (JdbcTemplate) ctx.getBean("jdbcTemplate"); cleaner.execute("delete from authorities"); cleaner.execute("delete from user"); ArrayList<String> testAuthoritiesList = new ArrayList<>(); testAuthoritiesList.add("ADMIN"); testAuthoritiesList.add("MODERATOR"); User user1 = new User(); user1.setUsername("TestName1"); user1.setPassword("Password1"); user1.setAuthorities(testAuthoritiesList); User user2 = new User(); user2.setUsername("TestName2"); user2.setPassword("Password2"); user2.setAuthorities(testAuthoritiesList); User user3 = new User(); user3.setUsername("TestName3"); user3.setPassword("Password3"); user3.setAuthorities(testAuthoritiesList); TestUsers[0] = user1;/*from ww w . j a v a 2s . co m*/ TestUsers[1] = user2; TestUsers[2] = user3; }
From source file:com.swcguild.flooringmasteryweb.Dao.OrderDAOTest.java
@Before public void setUp() { //initialize the beans ApplicationContext ctx = new ClassPathXmlApplicationContext("test-applicationContext.xml"); this.ordDao = (OrderDAO) ctx.getBean("OrderDAO"); JdbcTemplate cleaner = (JdbcTemplate) ctx.getBean("jdbcTemplate"); cleaner.execute("DELETE FROM orders"); }
From source file:com.swcguild.capstoneproject.dao.BlogDaoInMemImplTest.java
@Before public void setUp() { ApplicationContext ctx = new ClassPathXmlApplicationContext("test-applicationContext.xml"); dao = (BlogDao) ctx.getBean("BlogDao"); JdbcTemplate cleaner = (JdbcTemplate) ctx.getBean("jdbcTemplate"); cleaner.execute("delete from posts"); }
From source file:com.xpanxion.userprojecthibernate.UserDaoTest.java
@Before public void setUp() { ApplicationContext ctx = new ClassPathXmlApplicationContext("test-applicationContext.xml"); JdbcTemplate cleaner = ctx.getBean("jdbcTemplate", JdbcTemplate.class); cleaner.execute("delete from users"); cleaner.execute("delete from authorities"); dao = (UserDao) ctx.getBean("userDao"); u1 = new UserEntity(); u1.setUsername("user1"); u1.setPassword("user1Password"); u2 = new UserEntity(); u2.setUsername("user2"); u2.setPassword("user2Password"); }
From source file:org.thlim.castle.dao.BootstrapDataPopulator.java
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(dataSource); jdbcTemplate.execute( "insert into role(id,name,description) values (1, 'platform admin', 'Overall admin for all levels')"); jdbcTemplate.execute(/*from w w w . j a v a 2s . co m*/ "insert into role(id,name,description) values (2, 'agency admin', 'Overall admin for an agency')"); jdbcTemplate.execute("insert into role(id,name,description) values (3, 'agency owner', 'Owns an agency.')"); jdbcTemplate .execute("insert into role(id,name,description) values (4, 'project admin', 'Admin for project.')"); jdbcTemplate .execute("insert into role(id,name,description) values (5, 'project owner', 'Owns a project.')"); jdbcTemplate .execute("insert into role(id,name,description) values (6, 'operator', 'Operators for project.')"); jdbcTemplate.execute("insert into permission values (1, '*')"); jdbcTemplate.execute("insert into permission values (2, 'agency:*')"); jdbcTemplate.execute("insert into permission values (3, 'agency:view')"); jdbcTemplate.execute("insert into permission values (4, 'agency:edit')"); jdbcTemplate.execute("insert into permission values (5, 'agency:create')"); jdbcTemplate.execute("insert into permission values (6, 'agency:delete')"); jdbcTemplate.execute("insert into permission values (7, 'user:create')"); jdbcTemplate.execute("insert into permission values (8, 'role:create')"); // project permissions created on the fly jdbcTemplate.execute("insert into permission values (9, 'project:*')"); jdbcTemplate.execute("insert into permission values (10, 'project:create')"); jdbcTemplate.execute("insert into permission values (11, 'project:view')"); jdbcTemplate.execute("insert into permission values (12, 'project:edit')"); jdbcTemplate.execute("insert into permission values (13, 'project:assign')"); jdbcTemplate.execute("insert into permission values (14, 'project:delete')"); jdbcTemplate.execute("insert into permission values (15, 'vm:delete')"); jdbcTemplate.execute("insert into permission values (16, 'vm:stop')"); jdbcTemplate.execute("insert into permission values (17, 'vm:start')"); jdbcTemplate.execute("insert into role_permission values (1, 1)"); jdbcTemplate.execute("insert into role_permission values (2, 2)"); jdbcTemplate.execute( "insert into user(id,username,email,password) values (1, 'alice', 'sample@shiro.apache.org', '" + new Sha256Hash("alice").toHex() + "')"); jdbcTemplate.execute( "insert into user(id,username,email,password) values (2, 'bob', 'sample@shiro.apache.org', '" + new Sha256Hash("bob").toHex() + "')"); jdbcTemplate.execute("insert into user_role values (1, 2)"); jdbcTemplate.execute("insert into user_role values (2, 1)"); }
From source file:com.swcguild.addressbookwebapp.AddressBookDAOTest.java
@Before public void setUp() { //Ask Spring for my DAO ApplicationContext ctx = new ClassPathXmlApplicationContext("test-applicationContext.xml"); DAO = (AddressBookDAO) ctx.getBean("addressBookDAO"); JdbcTemplate cleaner = (JdbcTemplate) ctx.getBean("jdbcTemplate"); cleaner.execute("delete from addresses"); }