81,092
社区成员
发帖
与我相关
我的任务
分享
public class IndexAction extends ActionSupport {
private BaseDAO<IndexRecommend> IndexRecommend = new BaseDAO<IndexRecommend>();
private BaseDAO<DownloadList> DownloadList = new BaseDAO<DownloadList>();
private BaseDAO<WebNotice> WebNotice = new BaseDAO<WebNotice>();
private List<IndexRecommend> index_recommend = new ArrayList<IndexRecommend>();
private List<WebNotice> web_notice = new ArrayList<WebNotice>();
private List<DownloadList> download_list = new ArrayList<DownloadList>();
public String recommend() throws Exception {
index_recommend = IndexRecommend.list(" from IndexRecommend order by hot desc ");
return "recommend";
}
public String notice() {
web_notice = WebNotice.list(" from WebNotice where type='1' order by date desc ");
return "notice";
}
public String download() {
download_list = DownloadList.list(" from DownloadList order by total desc ");
return "download";
}
}
applicationContext-beans.xml
<bean name="indexAction" class="com.it8.action.IndexAction" scope="prototype">
</bean>
<bean name="articleAction" class="com.it8.action.ArticleAction" scope="prototype">
</bean>
<bean name="indexDao" class="com.it8.dao.IndexDaoImp">
<property name="sessionFactory" ref="sessionFactory" />
</bean>
<bean name="articleDao" class="com.it8.dao.ArticleDaoImp">
<property name="sessionFactory" ref="sessionFactory" />
</bean>
public class ArticleAction extends ActionSupport {
private static final long serialVersionUID = -5722778083187717369L;
private int aid = 0;
private BaseDAO<Article> baseDAO = new BaseDAO<Article>();
private List<Article> article = new ArrayList<Article>();
private TreeMap<String,Integer> tags_map;
private String key = "";
private int page = 0;
private IArticleManage articleManage;
.......................getset方法省略...............
public String main(){
article = baseDAO.list(" from Article where del_flag = '0' order by cre_date desc ");
return "main";
}
public String hot(){
article = baseDAO.list(" from Article where del_flag = '0' order by pvs desc ");
return "hot";
}
public String recommend(){
article = baseDAO.list(" from Article where recommend ='1' and del_flag = '0' order by cre_date desc ");
return "recommend";
}
public String details(){
article = baseDAO.list(" from Article where id='"+aid+"' and del_flag = '0' ");
return "details";
}
public String list(){
article = baseDAO.list(" from Article where tags like'%"+key+"%' and del_flag = '0' ");
return "list";
}
}
public class BaseDAO<T> {
//插入数据
public void create(T object){
Session session = HibernateUtil.getSessionFactory().openSession();
try {
session.beginTransaction();
session.persist(object);
session.getTransaction().commit();
} catch (Exception e) {
e.printStackTrace();
session.getTransaction().rollback();
} finally {
session.close();
}
}
//更新数据
public void update(T object){
Session session = HibernateUtil.getSessionFactory().openSession();
try {
session.beginTransaction();
session.update(object);
session.getTransaction().commit();
} catch (Exception e) {
e.printStackTrace();
session.getTransaction().rollback();
} finally {
session.close();
}
}
//删除数据
public void delete(T object){
Session session = HibernateUtil.getSessionFactory().openSession();
try {
session.beginTransaction();
session.delete(object);
session.getTransaction().commit();
} catch (Exception e) {
e.printStackTrace();
session.getTransaction().rollback();
} finally {
session.close();
}
}
//根据id查找数据
@SuppressWarnings("unchecked")
public T find(Class<? extends T> clazz, Serializable id){
Session session = HibernateUtil.getSessionFactory().openSession();
try {
session.beginTransaction();
return (T)session.get(clazz, id);
} catch (Exception e) {
e.printStackTrace();
session.getTransaction().rollback();
return null;
} finally {
session.getTransaction().commit();
session.clear();
}
}
@SuppressWarnings("unchecked")
public List<T> list(String hql){
Session session = HibernateUtil.getSessionFactory().openSession();
try {
session.beginTransaction();
return session.createQuery(hql).list();
} catch (Exception e) {
e.printStackTrace();
session.getTransaction().rollback();
return null;
} finally {
session.getTransaction().commit();
session.clear();
}
}
@SuppressWarnings("unchecked")
public List<T> list(String hql,int end){
Session session = HibernateUtil.getSessionFactory().openSession();
try {
session.beginTransaction();
Query query = session.createQuery(hql);
query.setFirstResult(0);
query.setMaxResults(end);
return query.list();
} catch (Exception e) {
e.printStackTrace();
session.getTransaction().rollback();
return null;
} finally {
session.getTransaction().commit();
session.clear();
}
}
@SuppressWarnings("unchecked")
public List<T> list(String hql,int begin,int end){
Session session = HibernateUtil.getSessionFactory().openSession();
try {
session.beginTransaction();
Query query = session.createQuery(hql);
query.setFirstResult(begin);
query.setMaxResults(end);
return query.list();
} catch (Exception e) {
e.printStackTrace();
session.getTransaction().rollback();
return null;
} finally {
session.getTransaction().commit();
session.clear();
}
}
}