根据http://www.cnblogs.com/friends-wf/p/3799315.html搭建的环境

User.xml加入的 if where判断的

1 
                                 
      2      3         select  from   user_c   4          5              6                 and name like "%" #{name}"%" 7              8              9                 and age=#{age}10             11         12     13 
     14     
     
      15         update user_c 16         
      
       17             
       
        18                  name=#{name},19             
       20             
       
        21                  age=#{age},22             
       23             
       
        24                  address=#{address},25             
       26         
      27         where id=#{id}    28     
     29

 

测试

1     @Test 2     public void testConditionOne() 3     { 4         User u=new User(); 5         u.setName("wf"); 6         SqlSession session=sqlSessionFactory.openSession(); 7         User user=session.selectOne("cn.itcast.mybatis.conditionOne", u); 8         System.out.println(user); 9     }10 11 12     @Test13     public void testUpdateConditionOne()14     {15         SqlSession session=sqlSessionFactory.openSession();16         User u=new User();17         u.setId("1");18         u.setAddress("USAaaaaa");19         int count=session.update("cn.itcast.mybatis.updateConditionOne", u);20         session.commit();21         System.out.println(count);22     }