Ibatis,Spring注解方式注入sqlMapClien

pom.xml

1 2 3 4 5

< dependency >      < groupId >org.apache.ibatis</ groupId >      < artifactId >ibatis-sqlmap</ artifactId >      < version >2.3.4.726</ version > </ dependency >

Spring-config.xml

1 2 3 4 5 6 7 8 9 10 11 12 13

<!-- sqlMapCLient --> < bean  id = "sqlMapClient"  class = "org.springframework.orm.ibatis.SqlMapClientFactoryBean" >      < property  name = "configLocation"  value = "classpath:sqlmap-config.xml" />      < property  name = "dataSource"  ref = "dataSource"  /> </ bean > <!-- Spring bean configuration. Tell Spring to bounce off BoneCP --> < bean  id = "dataSource"  class = "org.springframework.jdbc.datasource.DriverManagerDataSource" >     <!-- BoneCP type -->      < property  name = "driverClassName"  value = "${jdbc.driverClass}"  />      < property  name = "url"  value = "${jdbc.jdbcUrl}"  />      < property  name = "username"  value = "${jdbc.username}"  />      < property  name = "password"  value = "${jdbc.password}"  /> </ bean >

BaseDao.java

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

package  com.tq365.samples.ibatis.dao; import  javax.annotation.PostConstruct; import  javax.annotation.Resource; import  org.springframework.orm.ibatis.support.SqlMapClientDaoSupport; import  com.ibatis.sqlmap.client.SqlMapClient; /**   * BaseDao,Dao需继承此Dao   * @author archie2010   * since 2011-3-3 下午02:52:36   */ public  class  BaseDao  extends  SqlMapClientDaoSupport{      @Resource (name =  "sqlMapClient" )      private  SqlMapClient sqlMapClient;      @PostConstruct          public  void  initSqlMapClient(){           super .setSqlMapClient(sqlMapClient);      } }

@PostConstruct注解
   在方法上加上注解@PostConstruct，这个方法就会在Bean初始化之后被Spring容器执行（注：Bean初始化包括，实例化Bean，并装配Bean的属性（依赖注入））。它的一个典型的应用场景是，当你需要往Bean里注入一个其父类中定义的属性，而你又无法复写父类的属性或属性的setter方法时

UserDAOimpl.java

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74

import  org.springframework.stereotype.Component; import  com.tq365.samples.ibatis.model.User; import  com.tq365.sqmples.util.Pages; /**   * UserDAO接口实现类   * @author archie2010   * since 2011-3-3 下午02:54:57   */ @Component ( "userDAO" ) public  class  UserDAOimpl  extends  BaseDao  implements  UserDAO{      public  User findUserById( int  id){          return  (User) getSqlMapClientTemplate().queryForObject( "findUserById" , id);      }      /**       * 添加User       */      public  void  addUser(User user) {          getSqlMapClientTemplate().insert( "addUser" , user);      }      /**       * 删除User       */      public  void  deleteUserById( int  id) {          getSqlMapClientTemplate().delete( "deleteUserById" , id);      }      /**       * 查找User       */      public  User findUser(User user) {          return  (User) getSqlMapClientTemplate().queryForObject( "findUser" , user);      }      public  int  getTotalCountByUsername(String username){          return  (Integer) getSqlMapClientTemplate().queryForObject( "getTotalCountByUsername" , username);      }      /**       * User分页       */      @SuppressWarnings ( "unchecked" )      public  Pages<User> findUsersByUsername(String username, int  pageNo) {          Pages<User> pages= new  Pages<User>(getTotalCountByUsername(username));          pages.setPageSize( 5 );                                                                                          List<User> userList= new  ArrayList<User>();                                                                                          Map<String, Object> map= new  HashMap<String, Object>();          map.put( "username" , username);          map.put( "start" , pages.getStart(pageNo));                                                                                          userList=(List<User>) getSqlMapClientTemplate().queryForObject( "findUsersByUsername" , map);          pages.setPageList(userList);                                                                                          return  pages;      }      /**       * 查询所有记录       * @return       */      public  int  getTotalCount(){          return  (Integer) getSqlMapClientTemplate().queryForObject( "getTotalCount" );      }      @SuppressWarnings ( "unchecked" )      public  Pages<User> findAllPageUser( int  pageNo){          Pages<User> pages= new  Pages<User>(getTotalCount());          pages.setPageSize( 5 );                                                                                          List<User> userList= new  ArrayList<User>();                                                                                          userList=(List<User>) getSqlMapClientTemplate().queryForList( "findAllPageUser" , pages.getStart(pageNo));          pages.setPageList(userList);                                                                                          return  pages;      }                                                                             }

本文转自 LinkedKeeper 51CTO博客，原文链接：http://blog.51cto.com/sauron/1271834，如需转载请自行联系原作者