Mega Code Archive
Update, Delete Statements With Jdbc Template
<![CDATA[
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();
}
]]>