Data Access 之 MyBatis（八）- MyBatis 通用 Mapper（Part D）（上）

@Test
public void testCache(){
    // 第一次执行selectAll
    List<Porsche> porscheList = porscheMapper.selectAll();
    for (int i = 0; i < 3; i++) {
        System.out.println("第一次查询到的前三条：" + porscheList.get(i).getPorName());
    }
    // 第二次执行selectAll
    List<Porsche> porsches = porscheMapper.selectAll();
    for (int i = 0; i < 3; i++) {
        System.out.println("第二次查询到的前三条：" + porsches.get(i).getPorName());
    }
}
复制代码

<settings>
    <setting name="cacheEnabled" value="true"/>
</settings>
复制代码

DROP TABLE IF EXISTS `table_user`;
CREATE TABLE `table_user` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(100) DEFAULT NULL,
  `address` varchar(100) DEFAULT NULL,
  `season` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of table_user
-- ----------------------------
BEGIN;
INSERT INTO `table_user` VALUES (1, 'stark', 'State of New York,New York City,Marbury Street', 'SPRING');
COMMIT;
SET FOREIGN_KEY_CHECKS = 1;
复制代码

@Data
@Table(name = "table_user")
public class User {
    @Id
    private Integer userId;
    private String userName;
    private Address address;
    private SeasonEnum season;
}
复制代码

@Data
public class Address {
    private String province;
    private String city;
    private String street;
}
复制代码

public enum SeasonEnum {
    SPRING("spring"),SUMMER("summer"),AUTUMN("autumn"),WINTER("winter");
    private String seasonName;
    private SeasonEnum(String seasonName){
        this.seasonName = seasonName;
    }
    public String getSeasonName(){
        return this.seasonName;
    }
    public String toString(){
        return this.seasonName;
    }
}
复制代码

public interface UserMapper extends Mapper<User> {
}
复制代码

public interface UserService {
    User getUserById(Integer id);
}
复制代码

@Service
public class UserServiceImpl implements UserService {
    @Autowired
    private UserMapper userMapper;
    @Override
    public User getUserById(Integer id) {
        return userMapper.selectByPrimaryKey(id);
    }
}
复制代码

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("classpath:application.xml")
public class UserServiceTest {
    @Autowired
    private UserService userService;
    @Test
    public void getUserById() {
        User user = userService.getUserById(1);
        System.out.println("查询到的内容为：" + user);
    }
}
复制代码

@Test
public void saveUser(){
    User use = new User();
    use.setUserName("banner");
    Address address = new Address();
    address.setProvince("State of New York");
    address.setCity("New York City");
    address.setStreet("Unkown");
    use.setAddress(address);
    use.setSeason(SeasonEnum.SPRING);
    userService.saveUser(use);
}
复制代码