testFindByName():
testFindAll():
testFindRowsBySex():
public class TestStudentDaoImpl {
@Before
public void beforeTest() {
System.out.println(“单元测试开始了!”);
}
@After
public void afterTest() {
System.out.println("单元测试结束了!");
}
@Test
public void testInsert() {
Student student = new Student();
student.setId("18205071");
student.setName("王亮琴");
student.setSex("女");
student.setAge(19);
student.setDepartment("信息工程系");
student.setTelephone("1878798984");
StudentDao dao = new StudentDaoImpl();
int count = dao.insert(student);
if (count > 0) {
System.out.println("恭喜,学生记录插入成功!");
}else {
System.out.println("遗憾,学生记录插入失败!");
}
}
@Test
public void testDeleteById() {
StudentDao dao = new StudentDaoImpl();
String id = "18205113";
int count = dao.deleteById(id);
if (count > 0) {
System.out.println("恭喜,学生记录删除成功!");
}else {
System.out.println("遗憾,学生记录删除失败!");
}
}
@Test
public void testDeleteByClass() {
StudentDao dao = new StudentDaoImpl();
String clazz = "15英教1班";
int count = dao.deleteByClass(clazz);
if (count > 0) {
System.out.println("恭喜,["+ clazz +"]学生记录删除成功");
}else {
System.out.println("遗憾,[" + clazz +"]学生记录删除失败");
}
}
@Test
public void testDeleteByDepartment() {
StudentDao dao = new StudentDaoImpl();
String department = "建筑系";
int count = dao.deleteByDepartment(department);
if (count > 0) {
System.out.println("恭喜,[" + department +"]记录删除成功");
}else {
System.out.println("遗憾,[" + department +"]记录删除失败");
}
}
@Test
public void testUpdate() {
Student student = new Student();
student.setName("王狗屎");
student.setId("15012456");
StudentDao dao = new StudentDaoImpl();
int count = dao.update(student);
if (count > 0) {
System.out.println("恭喜,记录更新成功");
}else {
System.out.println("遗憾,记录更新失败");
}
}
@Test
public void testFindById() {
StudentDao dao = new StudentDaoImpl();
String id = "16080305";
Student student = dao.findById(id);
System.out.println(student);
}
@Test
public void testFindByClass() {
StudentDao dao = new StudentDaoImpl();
String clazz = "16英教1班";
List<Student> students = dao.findByClass(clazz);