System.out.println(writer.toString());
}
public void test() {
try {
JpaConnection connection = JpaConnection.getInstance();
connection.init();
EntityManager em = connection.getCurrentEntityManager();
em.getTransaction().begin();
SiteDomain siteDomain = SiteDomainDAO.load(Long.valueOf(5));
Menu parent = MenuDAO.load("Electronics", Long.valueOf(11));
for (Menu menu : parent.getMenuChildren()) {
System.out.println(menu.getMenuId() + " " + menu.getMenuLanguage().getMenuName());
}
Menu menu = new Menu();
menu.setSiteDomain(siteDomain);
menu.setMenuParent(parent);
menu.setSeqNum(10);
menu.setMenuSetName("MAIN");
menu.setMenuType(Constants.MENU_HOME);
menu.setMenuUrl("");
menu.setMenuWindowTarget("");
menu.setMenuWindowMode("");
menu.setPublished(Constants.PUBLISHED_YES);
menu.setRecUpdateBy("admin");
menu.setRecCreateBy("admin");
menu.setRecUpdateDatetime(new Date(System.currentTimeMillis()));
menu.setRecCreateDatetime(new Date(System.currentTimeMillis()));
MenuLanguage menuLanguage = new MenuLanguage();
menuLanguage.setMenuName("New Menu 6");
menuLanguage.setMenu(menu);
menuLanguage.setRecUpdateBy("admin");
menuLanguage.setRecCreateBy("admin");
menuLanguage.setRecUpdateDatetime(new Date(System.currentTimeMillis()));
menuLanguage.setRecCreateDatetime(new Date(System.currentTimeMillis()));
SiteProfileClass siteProfileClass = SiteProfileClassDAO.load(Long.valueOf(6));
menuLanguage.setSiteProfileClass(siteProfileClass);
em.persist(menuLanguage);
menu.getMenuLanguages().add(menuLanguage);
menu.setMenuLanguage(menuLanguage);
em.persist(menu);
em = connection.getCurrentEntityManager();
String sql = "from Menu menu where menu.menuParent.menuId = 11";
Query query = em.createQuery(sql);
Iterator<?> iterator = query.getResultList().iterator();
while (iterator.hasNext()) {