?? categorydao.java
字號:
package com.david.dao;
import java.sql.SQLException;
import java.util.List;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.type.Type;
import org.springframework.dao.DataAccessException;
import org.springframework.dao.DataAccessResourceFailureException;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import com.david.bo.Category;
import com.david.bo.Userinfo;
import com.david.util.IPageBeanSH;
public class CategoryDao extends HibernateDaoSupport implements ICategoryDao {
private IPageBeanSH pageBeanSH;
public boolean addCategory(Category category) {
// TODO Auto-generated method stub
try{
this.getHibernateTemplate().save(category);
return true;
}catch(DataAccessException e){
e.printStackTrace();
return false;
}
}
public boolean deleteCategory(Category category) {
// TODO Auto-generated method stub
try{
this.getHibernateTemplate().delete(category);
return true;
}catch(DataAccessException e){
e.printStackTrace();
return false;
}
}
public List<Category> getCategories(int start, Userinfo userinfo) {
// TODO Auto-generated method stub
String hql="from Category as category where category.userinfo=? Order by category.id desc";// as c where c.userinfo=?";
pageBeanSH.setHql(hql);
pageBeanSH.setStart(start);
Userinfo[] arrValues={userinfo};
pageBeanSH.setArrValues(arrValues);
try {
return (List<Category>) pageBeanSH.doInHibernate(this.getSession());
} catch (DataAccessResourceFailureException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
} catch (HibernateException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
} catch (IllegalStateException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}
}
public boolean updateCategory(Category category) {
// TODO Auto-generated method stub
try{
this.getHibernateTemplate().saveOrUpdate(category);
return true;
}catch(DataAccessException e){
e.printStackTrace();
return false;
}
}
public void setPageBeanSH(IPageBeanSH pageBeanSH) {
// TODO Auto-generated method stub
this.pageBeanSH=pageBeanSH;
}
public int getCategoriesNum(Userinfo userinfo) {
// TODO Auto-generated method stub
return this.getHibernateTemplate().find("from Category as category where category.userinfo=? Order by category.id desc", userinfo).size();
}
public Category getCategoryById(int id) {
// TODO Auto-generated method stub
try{
List<Category> list=this.getHibernateTemplate().find("from Category as category where category.id=? Order by category.id desc", id);
if(list.size()!=1){
return null;
}else{
return list.get(0);
}
//return (Category)this.getHibernateTemplate().load(Category.class, id);
}catch(DataAccessException e){
//e.printStackTrace();
//System.out.print(e.toString());
return null;
}
}
public List<Category> getCategories(Userinfo userinfo) {
// TODO Auto-generated method stub
return this.getHibernateTemplate().find("from Category as category where category.userinfo=? Order by category.id desc", userinfo);
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -