//测试类
package test;
import java.util.List;
import org.junit.Test;
import sini.dal.rights.GeneralDao;
import sini.dal.rights.MenuDao;
import sini.dal.rights.impl.GeneralDaoImpl;
import sini.dal.rights.impl.ImplFactory;
import sini.dal.rights.impl.MenuDaoImpl;
import sini.model.rights.MenuBean;
public class MenuDaoImplTest {
@Test
public void testadd()throws Exception{
MenuBean menu=new MenuBean((long)0,(long)-1,"权限管理",(short)1,"http://www.0755build.com","http://www.hao123.com");
Dao().add(menu);
}
@Test
public void testupdate()throws Exception{
MenuBean menu=Dao().findById("rights_menu_data",22);
if(menu!=null){
menu.setName("权限管理1");
menu.setRelease((short)1);
}
Dao().update(menu);
}
@Test
public void testdelre()throws Exception{
GeneralDao general=new GeneralDaoImpl();
general.delre("rights_menu_data", 22, 0);
}
@Test
public void testfindByid()throws Exception{
MenuBean menu=Dao().findById("rights_menu_data", 2);
if(menu!=null)
System.out.println(menu.getMid()+","+menu.getPid()+","+menu.getName()+","+menu.getSrc()+","+menu.getMgrsrc());
}
@Test
public void testmenupage()throws Exception{
String sqlselect="select * from rights_menu_data order by id";
String sqlCount="select count(*) from rights_menu_data";
List<MenuBean> list=Dao().menupage(2, 1, sqlselect, sqlCount);
if(list.size()>0){
for(int i=0;i<list.size();i++)
System.out.println(list.get(i).getName()+","+list.get(i).getMgrsrc());
}
}
public static MenuDao Dao()throws Exception{
return (MenuDao)ImplFactory.getInstance(MenuDaoImpl.class.getName());
}
}