Java/Spring/DriverManagerDataSource

Материал из Java эксперт
Перейти к: навигация, поиск

Setup DriverManagerDataSource as XML bean

   <source lang="java">

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();

}


      </source>