用JDBCTemplate实现的单表通用DAO,实现增删改查和统计 - JAVA

tends TestCase{

public void testInsert() {
ContainerDao containerDao = AppDefine.getAppContext().getBean(ContainerDao.class);
for (int i = 0; i < 1; i++) {
Container c = new Container();
c.setContainerID("APLX"+RandomStringUtils.randomNumeric(7));
c.setService("APL");
c.setType("45");
Assert.assertNotNull(containerDao.insert(c));
}
}

public void testInsert2() {
ContainerDao containerDao = AppDefine.getAppContext().getBean(ContainerDao.class);
for (int i = 0; i < 1; i++) {
Container c = new Container();
c.setContainerID("APLX"+RandomStringUtils.randomNumeric(7));
c.setService("APL");
c.setType("45");
Assert.assertNotNull(containerDao.insert(c));
}
}

public void testUpdate() {
ContainerDao containerDao = AppDefine.getAppContext().getBean(ContainerDao.class);
for (int i = 0; i < 1; i++) {
Container c = new Container();
c.setContainerID("APLX"+RandomStringUtils.randomNumeric(7));
c.setService("APL");
c.setType("45");
Assert.assertNotNull(containerDao.insert(c));
c.setType("22");
Assert.assertEquals(1,containerDao.update(c));
}
}

public void testDelete() {
ContainerDao containerDao = AppDefine.getAppContext().getBean(ContainerDao.class);
for (int i = 0; i < 1; i++) {
Container c = new Container();
c.setContainerID("APLX"+RandomStringUtils.randomNumeric(7));

c.setService("APL");
c.setType("45");
Assert.assertNotNull(containerDao.insert(c));
c.setType("22");
Assert.assertEquals(1,containerDao.deleteItem(c));
}
}

public void testSearchByID() {
ContainerDao containerDao = AppDefine.getAppContext().getBean(ContainerDao.class);
for (int i = 0; i < 1; i++) {
Container c = new Container();
c.setContainerID("APLX"+RandomStringUtils.randomNumeric(7));
c.setService("APL");
c.setType("45");
Assert.assertNotNull(containerDao.insert(c));
c.setType("22");
Assert.assertEquals(c.getId(),containerDao.searchByID(c.getId()).getId());
}
}

public void testSearchByCondition() {
ContainerDao containerDao = AppDefine.getAppContext().getBean(ContainerDao.class);
for (int i = 0; i < 10; i++) {
Container c = new Container();
c.setContainerID("APLX"+RandomStringUtils.randomNumeric(7));
c.setService("APL");
c.setType("45");
Assert.assertNotNull(containerDao.insert(c));
}
List list = containerDao.search("containerid like 'APLX%'");
Assert.assertTrue(list.size()>0);
}

public void testCount() {
ContainerDao containerDao = AppDefine.getAppContext().getBean(ContainerDao.class);
for (int i = 0; i < 10; i++) {
Container c = new Container();
c.setContainerID("APLX"+RandomStringUtils.randomNumeric(7));
c.setService("APL");
c.setType("

用JDBCTemplate实现的单表通用DAO,实现增删改查和统计(七)