FlexMenuDAO

package com.foxconn.nwe.flex.ejb.dao;

import java.util.List;

import com.foxconn.nwe.flex.ejb.model.FlexMenu;

/**
* @author f1410198
*
*/
public interface FlexMenuDAO {
public FlexMenu find(int id);

public FlexMenu find(String link);

public long sum();

public List<FlexMenu> list(int start, int limit);

public List<FlexMenu> list();

public boolean insert(FlexMenu flexMenu);

public boolean update(FlexMenu flexMenu);

public boolean delete(int id);

public boolean delete();
}

package com.foxconn.nwe.flex.ejb.dao.jpa;

import java.util.List;

import javax.ejb.Remote;
import javax.ejb.Stateless;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.Query;

import com.foxconn.nwe.flex.ejb.dao.FlexMenuDAO;
import com.foxconn.nwe.flex.ejb.model.FlexMenu;

@Stateless
@Remote({FlexMenuDAO.class})
public class FlexMenuDAOBean implements FlexMenuDAO {

@PersistenceContext(unitName = "Oracle104PU")
private EntityManager em;

/**
* 根據屬性id刪除對象
*
* @author f1410198
* @param id
* @return boolean
*/
public boolean delete(int id) {
FlexMenu flexMenu = this.find(id);

/* 斷開與上級菜單關係 */
if (flexMenu.getFlexMenu() != null
&& flexMenu.getFlexMenu().getFlexMenus() != null) {
flexMenu.getFlexMenu().getFlexMenus().remove(flexMenu);
}

if (flexMenu == null) {
return false;
} else {
try {
em.remove(flexMenu);
} catch (Exception e) {
e.printStackTrace();
return false;
}
}

return true;
}

/**
* 刪除全部對象
*
* @author f1410198
* @return boolean
*/
public boolean delete() {
Query query = em.createQuery("delete from FlexMenu");

int result = query.executeUpdate();

return (result > 0);
}

/**
* 根據主鍵id獲得對象
*
* @author f1410198
* @param id
* @return FlexMenu
*/
public FlexMenu find(int id) {
return em.find(FlexMenu.class, id);
}

/**
* 按源文件鏈結屬性查找對象
*
* @author f1410198
* @param link
* @return FlexMenu
*/
@SuppressWarnings("unchecked")
public FlexMenu find(String link) {
FlexMenu flexMenu = null;

String jpql = "select m from FlexMenu m where m.link=?1 order by m.id asc";

List<FlexMenu> list = em.createQuery(jpql).setParameter(1, link)
.getResultList();

if (list.size() > 0) {
flexMenu = list.get(0);
}

return flexMenu;
}

/**
* 按頁大小獲得對象列表
*
* @author f1410198
* @param start
* @param limit
* @return List<FlexMenu>
*/
@SuppressWarnings("unchecked")
public List<FlexMenu> list(int start, int limit) {

/* 按id升序排列 */
String jpql = "select m from FlexMenu m order by m.id asc";

Query query = em.createQuery(jpql);

/* 設置起始行和每頁顯示最大記錄數 */
query.setFirstResult(start);
query.setMaxResults(limit);

return query.getResultList();
}

public long sum() {

/* 查詢全部的記錄數 */
String jpql = "select count(m) from FlexMenu m";

Query query = em.createQuery(jpql);

/* 返回結果的整型值 */
return (Long) query.getSingleResult();
}

public boolean insert(FlexMenu flexMenu) {
try {
em.persist(flexMenu);
} catch (Exception e) {
e.printStackTrace();
return false;
}

return true;
}

public boolean update(FlexMenu flexMenu) {
if (flexMenu == null) {
return false;
} else {
try {
em.merge(flexMenu);
} catch (Exception e) {
e.printStackTrace();
return false;
}
}

return true;
}

/**
* 獲得所有的對象列表
*
* @author f1410198
* @return List<FlexMenu>
*/
@SuppressWarnings("unchecked")
public List<FlexMenu> list() {
String jpql = "select m from FlexMenu m where m.flexMenu is null order by m.id asc";

Query query = em.createQuery(jpql);

return query.getResultList();
}

}