<?xml version="1.0" encoding="UTF-8"?>



  
    
      
      
    
    
    
    
    

    
    
      
    

    
    
      
      
      
      
    
    
    
      
      
    
    
    
      
      
    
    
    
    
    

    
  

public class ItemsMapperTest {
  private ApplicationContext applicationContext;
  private ItemsMapper itemsMapper;

  @Before
  public void setUp() throws Exception {
    applicationContext = new ClassPathXmlApplicationContext("classpath:applicationContext.xml");
    itemsMapper = (ItemsMapper) applicationContext.getBean("itemsMapper");
  }

  //根本主键删除
  @Test
  public void deleteByPrimaryKey() {
    itemsMapper.deleteByPrimaryKey(4);
  }

  @Test
  public void insert() {
  }

  @Test
  public void selectByExample() {
    ItemsExample itemsExample = new ItemsExample();
    ItemsExample.Criteria criteria = itemsExample.createCriteria();
    //使用criteria自定义查询条件
    criteria.andNameEqualTo("水杯");
    criteria.andIdEqualTo(1);

    List list = itemsMapper.selectByExample(itemsExample);
    System.out.println(list);
  }

  @Test
  public void selectByPrimaryKey() {
    Items items = itemsMapper.selectByPrimaryKey(1);
    System.out.println(items);
  }

  @Test
  public void updateByPrimaryKey() {
  }
}