public class StudentDaoImpl implements StudentDao{\n\t@Override\n\tpublic boolean add(Student stu) {\n\t String insert = "insert Student values(?,?,?,?)";\n\t boolean jg = DBUtil.updateTable(insert, stu.getSid(), stu.getSname(), stu.getPwd(), stu.getSex());\n\t return jg;\n\t}\n\t@Override\n\tpublic boolean update(Student stu) {\n\t String insert = "update Student set sname=?,pwd=?,sex=? where sid=?";\n\t boolean jg = DBUtil.updateTable(insert, stu.getSname(), stu.getPwd(), stu.getSex(), stu.getSid());\n\t return jg;\n\t}\n\t@Override\n\tpublic boolean del(int sid) {\n\t String insert = "delete from Student where sid=?";\n\t boolean jg = DBUtil.updateTable(insert, sid);\n\t return jg;\n\t}\n\t@Override\n\tpublic List list() {\n\t List stuList = DBUtil.queryTable("select * from Student", Student.class, null);\n\t return stuList;\n\t}\n\t@Override\n\tpublic List list(String sname) {\n\t List stuList = DBUtil.queryTable("select * from Student where sname=?", Student.class, sname);\n\t return stuList;\n\t}\n\t@Override\n\tpublic Student listById(int sid) {\n\t Student stu = null;\n\t List stulist = DBUtil.queryTable("select * from Student where sid=?", Student.class,sid);\n\t if (stulist.size()!=0){\n\t stu = stulist.get(0);\n\t }\n\t return stu;\n\t}\n\t@Override\n\tpublic boolean login(Student stu) {\n\t List stulist = DBUtil.queryTable("select * from Student where sid=? ang pwd=?", Student.class);\n\t if (stulist.size()==0){\n\t return false;\n\t }\n\t return true;\n\t}\n}\npublic class StudentDaoImplTest {\n\t@Test\n\tpublic void testAdd() {\n\t StudentDaoImpl studentDao = new StudentDaoImpl();\n\t Student student = new Student();\n\t // set student properties\n\t boolean result = studentDao.add(student);\n\t assertTrue(result);\n\t}\n\t@Test\n\tpublic void testUpdate() {\n\t StudentDaoImpl studentDao = new StudentDaoImpl();\n\t Student student = new Student();\n\t // set student properties\n\t boolean result = studentDao.update(student);\n\t assertTrue(result);\n\t}\n\t@Test\n\tpublic void testDel() {\n\t StudentDaoImpl studentDao = new StudentDaoImpl();\n\t int sid = 1; // specify the student ID to delete\n\t boolean result = studentDao.del(sid);\n\t assertTrue(result);\n\t}\n\t@Test\n\tpublic void testList() {\n\t StudentDaoImpl studentDao = new StudentDaoImpl();\n\t List stuList = studentDao.list();\n\t assertNotNull(stuList);\n\t}\n\t@Test\n\tpublic void testListByName() {\n\t StudentDaoImpl studentDao = new StudentDaoImpl();\n\t String sname = "John"; // specify the student name to search\n\t List stuList = studentDao.list(sname);\n\t assertNotNull(stuList);\n\t}\n\t@Test\n\tpublic void testListById() {\n\t StudentDaoImpl studentDao = new StudentDaoImpl();\n\t int sid = 1; // specify the student ID to search\n\t Student student = studentDao.listById(sid);\n\t assertNotNull(student);\n\t}\n\t@Test\n\tpublic void testLogin() {\n\t StudentDaoImpl studentDao = new StudentDaoImpl();\n\t Student student = new Student();\n\t // set student properties\n\t boolean result = studentDao.login(student);\n\t assertTrue(result);\n\t}\n
