maven配置文件引入架包：

 
     
    
          
     
      org.springframework
          
     
      spring-orm
          
     
      3.2.5.RELEASE
      
     
     
    
          
     
      org.apache.ibatis
          
     
      ibatis-sqlmap
          
     
      2.3.0
      
     
     
    
          
     
      c3p0
          
     
      c3p0
          
     
      0.9.1.2
      
     
     
    
          
     
      mysql
          
     
      mysql-connector-java
          
     
      5.1.9
      
    

 Spring配置文件：

 
     
     
     
    
          
          
          
          
          
          
          
          
       
      
     
           
           
      
                
       
                     
        
         classpath:context/sql_map.xml
                 
             
      
     
    

 Dao父类：

 /**  * Dao父类  *   * @author 张成轩  */ @SuppressWarnings("deprecation") @Repository public abstract class SQLMapDao extends SqlMapClientDaoSupport {     @Resource     public void init(SqlMapClient sqlMapClient) {         this.setSqlMapClient(sqlMapClient);     } }

 例子：

     sql_map.xml文件：

    User.xml：

 
      
    
          
          
     
               
               
                
      
                INSERT INTO LB_USER (             USER, PASSWORD         ) VALUES (             #user#, #password#         )        
       
                UPDATE LB_USER        SET            PASSWORD =  #password#        WHERE            USER = #user#        
        
                 SELECT            USER,            PASSWORD        FROM            LB_USER        
         
                  SELECT            USER,            PASSWORD        FROM            LB_USER        WHERE            1 = 1        
          
                       
           
                            AND USER = #user#                         
           
          
         
        
       
      
     
    

 UserSchema类：

 public class UserSchema {     private String user;     private String password;     public String getUser() {         return user;     }     public void setUser(String user) {         this.user = user;     }     public String getPassword() {         return password;     }     public void setPassword(String password) {         this.password = password;     } }

UserDao类：

 @Repository public class UserDao extends SQLMapDao {     /**      * 插入      */     @SuppressWarnings("deprecation")     public void insert(UserSchema schema) {         getSqlMapClientTemplate().insert("insertUser", schema);     }     /**      * 更新      */     @SuppressWarnings("deprecation")     public void update(UserSchema schema) {         getSqlMapClientTemplate().update("updateUser", schema);     }     /**      * 获取全部数据      */     @SuppressWarnings({ "unchecked", "deprecation" })     public List
    
      getAll() {         return getSqlMapClientTemplate().queryForList("getAllUsers");     }     /**      * 获取数据      */     @SuppressWarnings({ "deprecation" })     public UserSchema getByUser(UserSchema schema) {         return (UserSchema) getSqlMapClientTemplate().queryForObject("getUser", schema);     } }