自动化测试示例TestDemo全部测试案例无错版

package testng.javaforever.testdemo.servicetest; import java.math.BigDecimal; import java.sql.Connection; import java.sql.Timestamp; import java.util.List; import junit.framework.Assert; import org.testng.annotations.Test; import testng.javaforever.testdemo.database.DataSafeTestCase2; import com.javaforever.testdemo.bo.AttendanceStatus; import com.javaforever.testdemo.database.DBConf; import com.javaforever.testdemo.domain.User; import com.javaforever.testdemo.service.ClockRecordService; import com.javaforever.testdemo.serviceimpl.ClockRecordServiceImpl; public class ClockRecordServiceTest{ private ClockRecordService clockRecordService = new ClockRecordServiceImpl(); public ClockRecordService getClockRecordService() { return clockRecordService; } public void setClockRecordService(ClockRecordService clockRecordService) { this.clockRecordService = clockRecordService; } @Test(groups = {"tests.service"}) public void testGetLastMonthSummary() throws Exception{ Connection con = DBConf.initTestDB(); Timestamp stamp = new Timestamp(111,7,2,0,0,0,0); con.prepareStatement("delete from clockrecord;").executeUpdate(); con.prepareStatement("insert into clockRecord values ('1','4','160208','2011-07-01 9:00:00','My description.');").executeUpdate(); con.prepareStatement("insert into clockRecord values ('2','4','160208','2011-07-01 16:00:00','My description.');").executeUpdate(); // Test User user = new User(); user.setId(4L); user.setEmpid(160208L); List<BigDecimal> worktimeList2 = getClockRecordService().getLastMonthSummary(stamp, user); Assert.assertEquals(31,worktimeList2.size()); Assert.assertEquals(7.00D,worktimeList2.get(0).doubleValue(),0.01D); for (BigDecimal workTime : worktimeList2){ System.out.println("=============JerryDebug:"+ workTime); } //Assert.fail(); // Clean con.prepareStatement("delete from clockrecord;").executeUpdate(); } @Test(groups = {"tests.service"}) public void testGetThisMonthSummary() throws Exception{ // prepare data Connection con = DBConf.initTestDB(); Timestamp stamp = new Timestamp(111,7,5,0,0,0,0); con.prepareStatement("delete from clockrecord;").executeUpdate(); con.prepareStatement("insert into clockRecord values ('1','4','160208','2011-08-01 9:00:00','My description.');").executeUpdate(); con.prepareStatement("insert into clockRecord values ('2','4','160208','2011-08-01 16:00:00','My description.');").executeUpdate(); // Test User user = new User(); user.setId(4L); user.setEmpid(160208L); List<BigDecimal> worktimeList2 = getClockRecordService().getThisMonthSummary(stamp, user); Assert.assertEquals(5,worktimeList2.size()); Assert.assertEquals(7.00D,worktimeList2.get(0).doubleValue(),0.01D); for (BigDecimal workTime : worktimeList2){ System.out.println("=============JerryDebug:"+ workTime); } // Clean con.prepareStatement("delete from clockrecord;").executeUpdate(); } @Test(groups = {"tests.service"}) public void testGetWholeLastYearSummary() throws Exception{ // prepare data Connection con = DBConf.initTestDB(); Timestamp stamp = new Timestamp(111,7,5,0,0,0,0); con.prepareStatement("delete from clockrecord;").executeUpdate(); con.prepareStatement("insert into clockRecord values ('1','4','160208','2010-08-01 9:00:00','My description.');").executeUpdate(); con.prepareStatement("insert into clockRecord values ('2','4','160208','2010-08-01 16:00:00','My description.');").executeUpdate(); // Test User user = new User(); user.setId(4L); user.setEmpid(160208L); List<BigDecimal> worktimeList2 = getClockRecordService().getWholeLastYearSummary(stamp, user); Assert.assertEquals(365,worktimeList2.size()); int augCount = 31+28+31+30+31+30+31; Assert.assertEquals(7.00D,worktimeList2.get(augCount).doubleValue(),0.01D); for (BigDecimal workTime : worktimeList2){ System.out.println("=============JerryDebug:"+ workTime); } // Clean con.prepareStatement("delete from clockrecord;").executeUpdate(); } @Test(groups = {"tests.service"}) public void testGetWholeThisYearSummary() throws Exception{ // prepare data Connection con = DBConf.initTestDB(); Timestamp stamp = new Timestamp(111,7,5,0,0,0,0); con.prepareStatement("delete from clockrecord;").executeUpdate(); con.prepareStatement("insert into clockRecord values ('1','4','160208','2011-08-01 9:00:00','My description.');").executeUpdate(); con.prepareStatement("insert into clockRecord values ('2','4','160208','2011-08-01 16:00:00','My description.');").executeUpdate(); // Test User user = new User(); user.setId(4L); user.setEmpid(160208L); List<BigDecimal> worktimeList2 = getClockRecordService().getWholeThisYearSummary(stamp, user); int augCount = 31+28+31+30+31+30+31; Assert.assertEquals(augCount+5,worktimeList2.size()); Assert.assertEquals(7.00D,worktimeList2.get(augCount).doubleValue(),0.01D); for (BigDecimal workTime : worktimeList2){ System.out.println("=============JerryDebug:"+ workTime); } // Clean con.prepareStatement("delete from clockrecord;").executeUpdate(); } @Test(groups = {"tests.service"}) public void testGetWholeLastYearWorkStatusSummary() throws Exception{ Connection con = DBConf.initTestDB(); Timestamp stamp = new Timestamp(111,7,5,0,0,0,0); con.prepareStatement("delete from clockrecord;").executeUpdate(); con.prepareStatement("delete from users;").executeUpdate(); con.prepareStatement("insert into clockRecord values ('1','4','160208','2010-08-01 9:00:00','My description.');").executeUpdate(); con.prepareStatement("insert into clockRecord values ('2','4','160208','2010-08-01 16:00:00','My description.');").executeUpdate(); con.prepareStatement("insert into users (id,empid,username,firstname,lastname,sex,password,pin, isadmin,isactive, name_c, name_j, " + " address, address1,phone, mobile,login_failure) values ('4','160208','jerry','Jerry','Shen','male', " + " sha1('jerry19847327'),'19847327','Y','Y','sjf','sjf','li jin road','li jin road','888888','7777777','0');").executeUpdate(); User user = new User(); user.setId(4L); user.setEmpid(160208L); int augCount = 31+28+31+30+31+30+31; List<AttendanceStatus> list2 = getClockRecordService().getWholeLastYearWorkStatusSummary(stamp, user); Assert.assertEquals(365,list2.size()); Assert.assertEquals(7.00D,list2.get(augCount).getDuration().doubleValue(),0.01D); for (AttendanceStatus status : list2){ System.out.println("=============JerryDebug:"+ status.getUsername()); System.out.println("=============JerryDebug:"+ status.getDuration()); System.out.println("=============JerryDebug:"+ status.getAttendanceStatus()); } // Clean con.prepareStatement("delete from clockrecord;").executeUpdate(); con.prepareStatement("delete from users;").executeUpdate(); } @Test(groups = {"tests.service"}) public void testGetWholeThisYearWorkStatusSummary() throws Exception{ Connection con = DBConf.initTestDB(); Timestamp stamp = new Timestamp(111,7,5,0,0,0,0); con.prepareStatement("delete from clockrecord;").executeUpdate(); con.prepareStatement("delete from users;").executeUpdate(); con.prepareStatement("insert into clockRecord values ('1','4','160208','2011-08-01 9:00:00','My description.');").executeUpdate(); con.prepareStatement("insert into clockRecord values ('2','4','160208','2011-08-01 16:00:00','My description.');").executeUpdate(); con.prepareStatement("insert into users (id,empid,username,firstname,lastname,sex,password,pin, isadmin,isactive, name_c, name_j, " + " address, address1,phone, mobile,login_failure) values ('4','160208','jerry','Jerry','Shen','male', " + " sha1('jerry19847327'),'19