SpringMVC-StudentManage3.rar

package cn.edu.xaut.test; import java.sql.Date; import java.sql.Timestamp; import java.util.List; import org.junit.Test; import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; import cn.edu.xaut.bean.Student; import cn.edu.xaut.bean.User; import cn.edu.xaut.dao.IStudentDao; import cn.edu.xaut.dao.IUserDao; import cn.edu.xaut.service.IStudentService; import cn.edu.xaut.service.IUserService; import cn.edu.xaut.service.StudentServiceImpl; public class DaoTest { @Test public void userDaoTest() { ApplicationContext ac = new ClassPathXmlApplicationContext("applicationContext.xml"); IUserService userService = (IUserService) ac.getBean("userService"); boolean u = userService.loginCheck("xiong", "123"); System.out.println(u); } @Test public void studentDaoTest() { ApplicationContext ac = new ClassPathXmlApplicationContext("applicationContext.xml"); IStudentService studentService = (IStudentService) ac.getBean("studentService"); List<Student> ss = studentService.findAllStudents(); for(Student s : ss) System.out.println(s); } // 查询ID成功 @Test public void studentDaoTest01() { ApplicationContext ac = new ClassPathXmlApplicationContext("applicationContext.xml"); IStudentService studentService = (IStudentService) ac.getBean("studentService"); Student s=studentService.selectStudentById(1); System.out.println(s); } // 删除成功 @Test public void studentDaoTest02() { ApplicationContext ac = new ClassPathXmlApplicationContext("applicationContext.xml"); IStudentService studentService = (IStudentService) ac.getBean("studentService"); studentService.deleteStudent(17); } // 插入成功 @Test public void studentDaoTest03() { ApplicationContext ac = new ClassPathXmlApplicationContext("applicationContext.xml"); IStudentService studentService = (IStudentService) ac.getBean("studentService"); Student s= new Student(); s.setStuId(55); s.setStuName("小熊"); s.setBirthday(Date.valueOf("1999-03-03")); s.setAffiliation("计173"); s.setLastLoginTime(new Timestamp(System.currentTimeMillis())); studentService.insertStudent(s); } // 修改成功 @Test public void studentDaoTest04() { ApplicationContext ac = new ClassPathXmlApplicationContext("applicationContext.xml"); IStudentService studentService = (IStudentService) ac.getBean("studentService"); Student s= new Student(); s.setStuName("小熊"); s.setBirthday(Date.valueOf("1999-03-03")); s.setAffiliation("计ke173"); s.setLastLoginTime(new Timestamp(System.currentTimeMillis())); studentService.updateStudent(s); } // 模糊查询 @Test public void studentDaoTest05() { ApplicationContext ac = new ClassPathXmlApplicationContext("applicationContext.xml"); IStudentService studentService = (IStudentService) ac.getBean("studentService"); List<Student> s=studentService.FuzzyQueryUser("雷"); System.out.println(s); } }