mavne引入:
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>3.1.1.RELEASE</version>
</dependency>
代码实现:
package study.mybatis;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Random;
import org.apache.ibatis.session.RowBounds;
import org.junit.Before;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
import study.mybatis.dao.StudentMapper;
import study.mybatis.domain.Student;
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("file:src/main/resources/spring/appContext.xml")
public class MybatisSpring {
@Autowired
StudentMapper studentMapper;
Student student;
@Before
public void init(){
student=new Student(311,"tanliu"+new Random().nextInt(500),1);
}
public void testSpring() {
System.out.println(studentMapper.getClass());
}
public void addStudent(){
student=new Student(new Random().nextInt(500),"tanliu"+new Random().nextInt(500),1);
System.out.println(studentMapper.insert(student));
}
public void updataStudent(){
studentMapper.updateByPrimaryKey(student);
}
public void delectStudent(){
studentMapper.deleteByPrimaryKey(446);
}
public void selectStudent(){
Student student = studentMapper.selectByPrimaryKey(311);
System.out.println(student);
}
public void selectStudentList(){
Map<String, Object> params=new HashMap<String, Object>();
params.put("cid", 1);
List<Student> students = studentMapper.selectList(params);
System.out.println(students);
}
/**
* 带分页的
*/
@Test
public void selectStudentWithRowBounds(){
Map<String, Object> params=new HashMap<String, Object>();
params.put("cid", 1);
// 分布的设置
int offset=2;
int limit=3;
RowBounds rowBounds=new RowBounds(offset, limit);
List<Student> students = studentMapper.selectList(params,rowBounds);
System.out.println(students.size());
}
}