?? dishsorthibernatedao.java.svn-base
字號:
package com.pure.dao.hibernate;
import java.sql.SQLException;
import java.util.List;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.dao.DataAccessException;
import org.springframework.orm.hibernate3.HibernateCallback;
import com.pure.dao.DishSortDAO;
import com.pure.domain.DishSort;
import com.pure.page.Page;
/**
* 菜品分類DAO接口實現(xiàn)類
*
* @author pure
*
*/
public class DishSortHibernateDAO extends BaseDao implements DishSortDAO {
protected final Log logger = LogFactory.getLog(getClass());
public void insertDishSort(DishSort dishSort) throws DataAccessException {
this.getHibernateTemplate().save(dishSort);
}
public void updateDishSort(DishSort dishSort) throws DataAccessException {
this.getHibernateTemplate().update(dishSort);
}
public List getDishSortList(final Page page) {
return getHibernateTemplate().executeFind(new HibernateCallback() {
public Object doInHibernate(Session s) throws HibernateException,
SQLException {
Query query = s.createQuery(page.getHql());
query.setFirstResult(page.getStartRs());
query.setMaxResults(page.getPerPage());
List list = query.list();
return list;
}
});
}
public List getDishSortList() {
return getHibernateTemplate().executeFind(new HibernateCallback() {
public Object doInHibernate(Session s) throws HibernateException,
SQLException {
Query query = s
.createQuery("from DishSort dishSort order by dishSort.seq asc,dishSort.id desc");
List list = query.list();
return list;
}
});
}
public DishSort getDishSort(final int id) {
List dataList = this.getHibernateTemplate().find(
"from DishSort dishSort where dishSort.id = ?", new Long(id));
if (dataList.size() == 0) {
return null;
} else {
return (DishSort) dataList.get(0);
}
}
public void delDishSort(final int id) {
getHibernateTemplate().executeFind(new HibernateCallback() {
public Object doInHibernate(Session s) throws HibernateException,
SQLException {
Query query = s.createQuery("delete DishSort where id=:id");
query.setInteger("id", id);
query.executeUpdate();
return null;
}
});
}
public void seq(final int id, final int seq) {
getHibernateTemplate().executeFind(new HibernateCallback() {
public Object doInHibernate(Session s) throws HibernateException,
SQLException {
Query query = s
.createQuery("update DishSort set seq=:seq where id=:id");
query.setInteger("seq", seq);
query.setInteger("id", id);
query.executeUpdate();
return null;
}
});
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -