Spring JDBC Hello World Example, Create Table In Database

Let us see how to create a table in database using spring JDBC.

Files Required

• SpringJdbcCreateTable.java
• OurLogic.java
• spconfig.xml

Directory Structure

SpringJdbcCreateTable.java

package java4s;

import org.springframework.jdbc.core.JdbcTemplate;

public class SpringJdbcCreateTable
{
	JdbcTemplate jt;

	public void setJt(JdbcTemplate jt)
	{
		this.jt = jt;
	}

	public void createTable()
	{
		jt.execute("create table sptest(sno number(3), sname varchar(10))");
		// execute() returns void
		System.out.println("table created");
	}
}

OurLogic.java

package java4s;

import org.springframework.beans.factory.BeanFactory;
import org.springframework.beans.factory.xml.XmlBeanFactory;
import org.springframework.core.io.ClassPathResource;
import org.springframework.core.io.Resource;

public class OurLogic
{
	public static void main(String args[])
	{
		Resource res = new ClassPathResource("spconfig.xml");
		BeanFactory factory = new XmlBeanFactory(res);
		SpringJdbcCreateTable st =(SpringJdbcCreateTable)factory.getBean("id3");
		st.createTable();
	}
}

spconfig.xml

<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN 2.0//EN"
"http://www.springframework.org/dtd/spring-beans-2.0.dtd">

<beans>

<bean id="id1" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
  <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
  <property name="url" value="jdbc:oracle:thin:@localhost:1521:XE"/>
  <property name="username" value="system"/>
  <property name="password" value="admin"/>
</bean>

<bean id="id2" class="org.springframework.jdbc.core.JdbcTemplate">
  <constructor-arg>
      <ref bean="id1"/>
  </constructor-arg>
</bean>

<bean id="id3" class="java4s.SpringJdbcCreateTable">
  <property name="jt">
     <ref bean="id2"/>
  </property>
</bean>

</beans>

Output:

table created

Note:  See in SpringJdbcCreateTable.java  i have used execute() method which will returns void, in fact we can use update() too but this will returns some int value.  So better execute() for creating these type of jobs.

You Might Also Like

• How to Configure Cache in Spring Boot Applications
• Spring Boot JDBC + MySQL – How to Configure Multiple DataSource
• Spring Boot JDBC + MySQL – How to Create/Configure a DataSource
• Spring MVC Execution Flow Diagram, Spring MVC 3.2 Flow
• NameMatchMethodPointcut Class In Spring AOP

::. About the Author .::
		Sivateja Kandula - Java/J2EE Full Stack Developer Founder of Java4s - Get It Yourself, A popular Java/J2EE Programming Blog, Love Java and UI frameworks. You can sign-up for the Email Newsletter for your daily dose of Java tutorials.