?? filedao.java
字號:
package com.david.dao;
import java.sql.SQLException;
import java.util.List;
import org.hibernate.HibernateException;
import org.springframework.dao.DataAccessException;
import org.springframework.dao.DataAccessResourceFailureException;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import com.david.bo.Category;
import com.david.bo.File;
import com.david.bo.Userinfo;
import com.david.util.IPageBean;
import com.david.util.IPageBeanSH;
public class FileDao extends HibernateDaoSupport implements IFileDao {
private IPageBeanSH pageBeanSH;
public boolean save(File file) {
// TODO Auto-generated method stub
try{
this.getHibernateTemplate().save(file);
return true;
}catch(DataAccessException e){
e.printStackTrace();
return false;
}
}
public List<File> getFileList(int start, Category category) {
// TODO Auto-generated method stub
String hql="from File as file";// where file.category=?";
try{
if(category==null){
return (List<File>) pageBeanSH.doInHibernate(this.getSession());
}else{
hql+=" where file.category=? Order by file.id desc";
Category[] categories={category};
pageBeanSH.setHql(hql);
pageBeanSH.setStart(start);
pageBeanSH.setArrValues(categories);
return (List<File>) 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 void setPageBeanSH(IPageBeanSH pageBeanSH) {
// TODO Auto-generated method stub
this.pageBeanSH=pageBeanSH;
}
public List<File> getAllMyFileList(Category category) {
// TODO Auto-generated method stub
if(category==null){
return this.getHibernateTemplate().find("from File as file Order by file.id desc");
}else{
return this.getHibernateTemplate().find("from File as file where file.category=? Order by file.id desc", category);
}
}
public boolean deleteFileById(File file) {
// TODO Auto-generated method stub
try{
this.getHibernateTemplate().delete(file);
return true;
}catch(DataAccessException e){
return false;
}
}
public File getFileById(int id) {
// TODO Auto-generated method stub
List<File> list=this.getHibernateTemplate().find("from File as file where file.id=?", id);
if(list.size()!=1){
return null;
}else{
return list.get(0);
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -