spring+JDBC

 首先建立实体。然后写dao和service。dao要继承JdbcDaoSupport。如下列代码。

 

import java.util.List;

import org.springframework.jdbc.core.support.JdbcDaoSupport;
import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;

import com.spring.entity.Emp;

public class EmpDAOImpl extends JdbcDaoSupport implements IEmpDAO{

 public boolean deleteEmp() {
  // TODO Auto-generated method stub
  getJdbcTemplate().execute("delete * from dept where deptno=5");
  System.out.println("delete success!");
  return true;
 }

 public List<Emp> getEmps() {
  // TODO Auto-generated method stub
  return getJdbcTemplate().queryForList("select * from emp");
 }

 public void updateEmp() {
  getJdbcTemplate().update("update emp set empname='zj' where empname='ldh'");
  System.out.println("updete:");
  
 }

 public void insertEmp(Emp emp) {
  getJdbcTemplate().execute("insert into emp where empno='"+emp.getEmpno()+"',empname='"+emp.getEname()+"',deptno='"+emp.getDept().getDeptno());
  System.out.println("insert:");
  
 }

 
}
然后在service里面利用AOP注入DAO,在spring配置文件中配置如下的代码即可调用。

 <?xml version="1.0" encoding="UTF-8"?>
<beans
 xmlns="http://www.springframework.org/schema/beans"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">
 
 <!-- 数据源 -->
    <bean id="dataSource"  class="org.springframework.jdbc.datasource.DriverManagerDataSource">
       <property name="driverClassName" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"></property>
       <property name="url" value="jdbc:sqlserver://127.0.0.1:1433;databaseName=mydb"></property>
       <property name="username" value="sa"></property>
       <property name="password" value=""></property>
    </bean>

 <bean id="DeptDAOImpl" class="com.spring.dao.DeptDAOImpl">
  <property name="dataSource" ref="dataSource"></property>
 </bean>
 <bean id="DeptServiceImpl" class="com.spring.biz.DeptServiceImpl">
  <property name="deptDao" ref="DeptDAOImpl"></property>
 </bean>
 
 <!-- 事务管理器 -->
 <bean id="transManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
   <property name="dataSource" ref="dataSource"></property>
 </bean>
 <!-- 事务拦截器 -->
 <bean id="trInterceptor" class="org.springframework.transaction.interceptor.TransactionInterceptor">
  <property name="transactionManager" ref="transManager"></property>
  <property name="transactionAttributes">
   <props>
   <prop key="*">PROPAGATION_REQUIRED</prop>
   </props>
  </property>
 </bean>
 <!-- 自动代理 -->
 <bean id="autoProxy" class="org.springframework.aop.framework.autoproxy.BeanNameAutoProxyCreator">
     <property name="beanNames">
      <list>
       <value>*DAOImpl</value>
      </list>
     </property>
     <property name="interceptorNames">
         <list>
            <value>trInterceptor</value>
         </list>
     </property>
    </bean>
</beans>