package cn.com.blogonline;
import java.util.List;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;
public class DbOperate {
/**
* 根据用户名得到Blog对象
*/
public Blog getBlog(String userId) throws HibernateException {
Session session = HibernateUtil.currentSession();
Blog blog = null;
Transaction tx = null;
try {
tx = session.beginTransaction();
// 创建查询对象
Query query = session.createQuery("from Blog where username=:userId");
query.setParameter("userId", userId);
List list = query.list();
if (!list.isEmpty())
blog = (Blog) list.get(0);
tx.commit();
} catch (HibernateException e) {
if (tx != null)
tx.rollback();
throw e;
}
session.close();
return blog;
}
/**
* 根据ID得到Blog对象
*/
public Blog getBlog(int Id) throws HibernateException {
Session session = HibernateUtil.currentSession();
Blog blog = null;
Transaction tx = null;
try {
tx = session.beginTransaction();
// 创建查询对象
Query query = session.createQuery("from Blog where id=" + Id);
List list = query.list();
if (!list.isEmpty())
blog = (Blog) list.get(0);
tx.commit();
} catch (HibernateException e) {
if (tx != null)
tx.rollback();
throw e;
}
session.close();
return blog;
}
/**
* 得到热点Blog对象集
*/
public List getBlogs(int showCount) throws HibernateException {
Session session = HibernateUtil.currentSession();
List list=null;
Transaction tx = null;
try {
tx = session.beginTransaction();
// 创建查询对象
Query query = session.createQuery("from Blog order by visitcount desc");
if (showCount>0){
query.setMaxResults(showCount); //记录集最大个数
}
list = query.list(); //从数据库取出数据，并自动封装到List集合中
tx.commit();
} catch (HibernateException e) {
if (tx != null)
tx.rollback();
throw e;
}
HibernateUtil.closeSession();
return list;
}
/**
* 得到匹配Blog对象集
*/
public List getMatchBlogs(String key) throws HibernateException {
Session session = HibernateUtil.currentSession();
List list=null;
Transaction tx = null;
try {
tx = session.beginTransaction();
// 创建查询对象
Query query = session.createQuery("from Blog where subject like '%" + key + "%'");
list = query.list(); //从数据库取出数据，并自动封装到List集合中
tx.commit();
} catch (HibernateException e) {
if (tx != null)
tx.rollback();
throw e;
}
HibernateUtil.closeSession();
return list;
}
/**
* 根据ID得到Sort对象
*/
public Sort getSort(int Id) throws HibernateException {
Session session = HibernateUtil.currentSession();
Sort sort = null;
Transaction tx = null;
try {
tx = session.beginTransaction();
// 创建查询对象
Query query = session.createQuery("from Sort where id=" + Id);
List list = query.list();
if (!list.isEmpty())
sort = (Sort) list.get(0);
tx.commit();
} catch (HibernateException e) {
if (tx != null)
tx.rollback();
throw e;
}
session.close();
return sort;
}
/**
* 根据ID得到Links对象
*/
public Links getLink(int Id) throws HibernateException {
Session session = HibernateUtil.currentSession();
Links link = null;
Transaction tx = null;
try {
tx = session.beginTransaction();
// 创建查询对象
Query query = session.createQuery("from Links where id=" + Id);
List list = query.list();
if (!list.isEmpty())
link = (Links) list.get(0);
tx.commit();
} catch (HibernateException e) {
if (tx != null)
tx.rollback();
throw e;
}
session.close();
return link;
}
/**
* 得到指定文章对象
*/
public Article getArticle(int articleid) throws HibernateException {
Session session = HibernateUtil.currentSession();
Article article = null;
Transaction tx = null;
try {
tx = session.beginTransaction();
// 创建查询对象
Query query = session.createQuery("from Article where id=" + articleid);
List list = query.list();
if (!list.isEmpty())
article = (Article) list.get(0);
tx.commit();
} catch (HibernateException e) {
if (tx != null)
tx.rollback();
throw e;
}
session.close();
return article;
}
/**
* 得到匹配Article对象集
*/
public List getMatchArticles(String key) throws HibernateException {
Session session = HibernateUtil.currentSession();
List list=null;
Transaction tx = null;
try {
tx = session.beginTransaction();
// 创建查询对象
Query query = session.createQuery("from Article where title like '%" + key + "%'");
list = query.list(); //从数据库取出数据，并自动封装到List集合中
tx.commit();
} catch (HibernateException e) {
if (tx != null)
tx.rollback();
throw e;
}
HibernateUtil.closeSession();
return list;
}
/**
* 得到最新文章对象集
*/
public List getArticles(int showCount) throws HibernateException {
Session session = HibernateUtil.currentSession();
List list=null;
Transaction tx = null;
try {
tx = session.beginTransaction();
// 创建查询对象
Query query = session.createQuery("from Article order by pubtime desc");
if (showCount>0){
query.setMaxResults(showCount); //记录集最大个数
}
list = query.list(); //从数据库取出数据，并自动封装到List集合中
tx.commit();
} catch (HibernateException e) {
if (tx != null)
tx.rollback();
throw e;
}
HibernateUtil.closeSession();
return list;
}
/**
* 得到指定博客最新文章对象集
*/
public List getBlogArticles(int blogid,int sortid) throws HibernateException {
Session session = HibernateUtil.currentSession();
List list=null;
Transaction tx = null;
try {
tx = session.beginTransaction();
// 创建查询对象
String strSql = "from Article where blogid=" + blogid;//创建一个查询语句,查询指定类别产品;
if (sortid>0){
strSql = strSql + " and sortid=" + sortid ; //记录集最大个数
}
strSql = strSql + " order by pubtime desc" ; //记录集最大个数
Query query = session.createQuery(strSql);
list = query.list(); //从数据库取出数据，并自动封装到List集合中
tx.commit();
} catch (HibernateException e) {
if (tx != null)
tx.rollback();
throw e;
}
HibernateUtil.closeSession();
return list;
}
/**
* 得到指定博客文章分类对象集
*/
public List getBlogSorts(int blogid) throws HibernateException {
Session session = HibernateUtil.currentSession();
List list=null;
Transaction tx = null;
try {
tx = session.beginTransaction();
// 创建查询对象
String strSql = "from Sort where blogid=" + blogid;//创建一个查询语句,查询指定类别产品;
Query query = session.createQuery(strSql);
list = query.list(); //从数据库取出数据，并自动封装到List集合中
tx.commit();
} catch (HibernateException e) {
if (tx != null)
tx.rollback();
throw e;
}
HibernateUtil.closeSession();
return list;
}
/**
* 得到指定博客超级链接对象集
*/
public List getBlogLinks(int blogid) throws HibernateException {
Session session = HibernateUtil.currentSession();
List list=null;
Transaction tx = null;
try {
tx = session.beginTransaction();
// 创建查询对象
String strSql = "from Links where blogid=" + blogid;//创建一个查询语句,查询指定类别产品;
Query query = session.createQuery(strSql);
list = query.list(); //从数据库取出数据，并自动封
[博客空间]JSP博客在线_bonlin.rar （113个子文件） 
DbOperate.class 7KB AdminArticleAction.class 4KB AdminLinksAction.class 4KB AdminSortAction.class 3KB BlogOperateAction.class 3KB ArticleSaveAction.class 3KB OpenArticleAction.class 3KB ShowFeedbackAction.class 3KB LoginAction.class 3KB FirstAction.class 3KB SaveLogoAction.class 3KB WriteFeedbackAction.class 3KB OpenBlogAction.class 3KB ArticleSortAction.class 2KB SaveSelfInfoAction.class 2KB ImageTool.class 2KB HibernateUtil.class 2KB RegistAction.class 2KB SearchAction.class 2KB CheckUnameAction.class 2KB Blog.class 2KB Article.class 1KB FeedBack.class 1KB Links.class 1KB Constants.class 1KB Sort.class 904B .classpath 4KB mystyle.css 2KB Thumbs.db 15KB
logo.gif 2KB bk_button01.gif 448B jsp-blogonlie-demo.htm 907B
hibernate3.jar 1.88MB mysql-connector-java-5.0.0-beta-bin.jar 464KB antlr-2.7.6rc1.jar 434KB log4j-1.2.11.jar 342KB dom4j-1.6.1.jar 307KB cglib-2.1.3.jar 276KB commons-collections-2.1.1.jar 171KB oscache-2.1.jar 112KB ehcache-1.1.jar 46KB commons-logging-1.0.4.jar 37KB asm.jar 26KB jta.jar 9KB DbOperate.java 10KB AdminArticleAction.java 3KB BlogOperateAction.java 3KB AdminLinksAction.java 3KB AdminSortAction.java 3KB ShowFeedbackAction.java 3KB OpenArticleAction.java 2KB FirstAction.java 2KB ArticleSaveAction.java 2KB OpenBlogAction.java 2KB LoginAction.java 2KB WriteFeedbackAction.java 2KB SaveLogoAction.java 2KB RegistAction.java 2KB ArticleSortAction.java 2KB SaveSelfInfoAction.java 2KB ImageTool.java 1KB SearchAction.java 1KB CheckUnameAction.java 1KB HibernateUtil.java 1KB Blog.java 1KB Constants.java 1KB Article.java 905B FeedBack.java 787B Links.java 564B Sort.java 437B
default_icon.jpg 6KB bk_11.jpg 350B index.js 5KB adminArticle.js 5KB adminLink.js 5KB adminSort.js 4KB newArticle.js 3KB regist.js 3KB index.jsp 4KB regist.jsp 4KB left.jsp 4KB feedback.jsp 3KB newArticle.jsp 2KB adminSelf.jsp 2KB searchResult.jsp 2KB registOK.jsp 2KB adminLink.jsp 2KB main.jsp 2KB adminLeft.jsp 2KB adminSort.jsp 2KB adminLogo.jsp 1KB adminArticle.jsp 1KB top.jsp 1KB blogAdminMain.jsp 1009B adminTop.jsp 837B otherBlogMain.jsp 720B blogMain.jsp 716B adminMain.jsp 566B image.jsp 455B .struts-config.mex 48B共 113 条
- 1
- 2
资源评论
