istudentdaoimpltest.java

ibatis + sqlserver 学生成绩管理

package dao;

import java.util.List;

import junit.framework.TestCase;
import bean.Student;

public class IStudentDAOImplTest extends TestCase {
	private IStudentDAO studentDAO = new IStudentDAOImpl();

	public void testAddStudent() {
		Student student = new Student();
		student.setSid("2007082046");
		student.setSname("唐辉");
		student.setSex("男");
		student.setAge(21);
		student.setComment("统招");
		studentDAO.addStudent(student);
	}

	public void testAddStudentBySequence() {
		Student student = new Student();
		student.setSid("2007082068");
		student.setSname("李尚洺");
		student.setSex("女");
		student.setAge(21);
		student.setComment("女同学");
		studentDAO.addStudentBySequence(student);
	}

	public void testDeleteStudentById() {
		studentDAO.deleteStudentById("2007082046");
	}

	public void testQueryAllStudent() {
		List<Student> list = studentDAO.queryAllStudent();

		for (Student o : list) {
			System.out.println(o);
		}
	}

	public void testQueryAllStudentById() {
		Student student = studentDAO.queryAllStudentById("2007082046");
		System.out.println(student);
	}

	public void testQueryAllStudentByName() {
		List<Student> list = studentDAO.queryAllStudentByName("霞");

		for (Student o : list) {
			System.out.println(o);
		}
	}

	public void testUpdateStudentById() {
		Student student = new Student();
		student.setSid("2007082037");
		student.setSname("杨霞");
		student.setSex("女");
		student.setAge(21);
		student.setComment("统招");
		studentDAO.updateStudentById(student);
	}
}