Setup DriverManagerDataSource as XML bean : DriverManagerDataSource « Spring « Java






Setup DriverManagerDataSource as XML bean

File: context.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN"
"http://www.springframework.org/dtd/spring-beans.dtd">

<beans>
   <bean id="dataSource"
         class="org.springframework.jdbc.datasource.DriverManagerDataSource">

   <property name="driverClassName">
       <value>sun.jdbc.odbc.JdbcOdbcDriver</value>
   </property>

   <property name="url">
       <value>jdbc:odbc:test</value>
   </property>

   <property name="username">
       <value>root</value>
   </property>

   <property name="password">
       <value>sql</value>
   </property>

   </bean>

   <bean id="datacon" class="Dataconimpl">
      <property name="dataSource"><ref local="dataSource"/></property>
   </bean>
</beans>


File: Main.java

import javax.sql.DataSource;

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

public class Main {

  public static void main(String[] args) throws Exception {
    BeanFactory factory = new XmlBeanFactory(new ClassPathResource("context.xml"));
    Dataconimpl bean1 = (Dataconimpl) factory.getBean("datacon");
    JdbcTemplate jt = new JdbcTemplate(bean1.dbcon());
 
    jt.execute("delete from table1  ");
    jt.execute("update table1 set table1.place='' ");

  }
}

class Dataconimpl implements Datacon {
  private DataSource dataSource;

  public void setDataSource(DataSource ds) {
    dataSource = ds;
  }

  public DataSource dbcon() {
    return dataSource;
  }
}

interface Datacon {
  public DataSource dbcon();
}



       

           
       








Spring-UpdateDeleteStatementsWithJdbcTemplate.zip( 2,894 k)

Related examples in the same category