Create Table 

Spring JDBC Framework simplifies the use of JDBC and helps to avoid common errors. The following example shows creating a table using JdbcTemplate class.

File Name  :   /SpringJDBC001/conf/basic/applicationContext.xml

view sourceprint? 01 <?xml version="1.0" encoding="UTF-8"?> 02 <beans xmlns="http://www.springframework.org/schema/beans" 03        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 04        xsi:schemaLocation="http://www.springframework.org/schema/beans 05            http://www.springframework.org/schema/beans/spring-beans-3.0.xsd"> 06   07     <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> 08         <property name="driverClassName" value="org.h2.Driver" /> 09         <property name="url" value="jdbc:h2:tcp://localhost/~/test" /> 10         <property name="username" value="sa" /> 11         <property name="password" value="" /> 12     </bean> 13   14 </beans>

File Name  :   com/bethecoder/tutorials/spring3/tests/CreateTableTest.java  Author  :   Sudhakar KV Email  :   kvenkatasudhakar@gmail.com

package com.bethecoder.tutorials.spring3.tests; import javax.sql.DataSource; import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; import org.springframework.jdbc.core.JdbcTemplate; public class CreateTableTest {   /**    * @param args    */   public static void main(String[] args) {          /**      * Initialize context and get the JdbcTemplate      */     ApplicationContext appContext = new ClassPathXmlApplicationContext("applicationContext.xml");     DataSource dataSource = (DataSource) appContext.getBean("dataSource");     JdbcTemplate template = new JdbcTemplate(dataSource);     /**      * Create table.      */     template.execute("create table USERS (" +         "id integer PRIMARY KEY, name varchar(60), " +         "age integer, salary decimal )");          System.out.println("Table created successfully");   } }

Table created successfully