?? newssorthibernatedao.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.NewsSortDAO;
import com.pure.domain.NewsSort;
import com.pure.page.Page;
/**
* 新聞類別DAO接口實現類
*
* @author pure
*
*/
public class NewsSortHibernateDAO extends BaseDao implements NewsSortDAO {
protected final Log logger = LogFactory.getLog(getClass());
public void insertNewsSort(NewsSort newsSort) throws DataAccessException {
this.getHibernateTemplate().save(newsSort);
}
public void updateNewsSort(NewsSort newsSort) throws DataAccessException {
this.getHibernateTemplate().update(newsSort);
}
public List getNewsSortList(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 getNewsSortList() {
return getHibernateTemplate().executeFind(new HibernateCallback() {
public Object doInHibernate(Session s) throws HibernateException,
SQLException {
Query query = s
.createQuery("from NewsSort newsSort order by newsSort.seq asc,newsSort.id desc");
List list = query.list();
return list;
}
});
}
public NewsSort getNewsSort(final int id) {
List dataList = this.getHibernateTemplate().find(
"from NewsSort newsSort where newsSort.id = ?", new Long(id));
if (dataList.size() == 0) {
return null;
} else {
return (NewsSort) dataList.get(0);
}
}
public void delNewsSort(final int id) {
getHibernateTemplate().executeFind(new HibernateCallback() {
public Object doInHibernate(Session s) throws HibernateException,
SQLException {
Query query = s.createQuery("delete NewsSort 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 NewsSort set seq=:seq where id=:id");
query.setInteger("seq", seq);
query.setInteger("id", id);
query.executeUpdate();
return null;
}
});
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -