逆向工程的Example类用法

package com.imooc.entity;

public class Student {
    /**  */
    private Integer id;

    /**  */
    private String name;

    /**  */
    private Integer age;

    /**  */
    private Integer score;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name == null ? null : name.trim();
    }

    public Integer getAge() {
        return age;
    }

    public void setAge(Integer age) {
        this.age = age;
    }

    public Integer getScore() {
        return score;
    }

    public void setScore(Integer score) {
        this.score = score;
    }
}

And

Or

package com.imooc.test;

import java.util.List;

import org.apache.ibatis.session.SqlSession;

import com.imooc.dao.StudentMapper;
import com.imooc.entity.Student;
import com.imooc.entity.StudentExample;
import com.imooc.entity.StudentExample.Criteria;
import com.imooc.untils.MyBatisUntil;

public class Main {

	public static void main(String[] args) {
		//获得SqlSession对象
		SqlSession sqlSession=MyBatisUntil.getSqlSession();
		
		//获得StudentMapper
		StudentMapper dao=(StudentMapper)sqlSession.getMapper(StudentMapper.class);
		
		
		StudentExample example=new StudentExample();
		Criteria c1=example.createCriteria();
		//select * from student where age between 11 and 22
		c1.andAgeBetween(11, 22);
		
		
		Criteria c2=example.createCriteria();
		//select * from student where age < 11
		c2.andAgeLessThan(11);
		
		//（select * from student where age between 11 and 22） or  ( select * from student where age < 11 )
		//如果不写这一句select * from student where age between 11 and 22
		example.or(c2);//  等价于 C1  or  C2
		//example.or(c3);//  等价于 C1  or  C2 or  C3
	
		List<Student>  students=dao.selectByExample(example);
		for (Student student : students) {
			System.out.println(student);
		}
		

	}

}