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(); //从数据库取出数据,并自动封
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
ajax jsp Hibernate的Blog源码ajax jsp Hibernate的Blog源码ajax jsp Hibernate的Blog源码ajax jsp Hibernate的Blog源码ajax jsp Hibernate的Blog源码ajax jsp Hibernate的Blog源码
资源推荐
资源详情
资源评论
收起资源包目录
ajax jsp Hibernate的博客网站 源码 (111个子文件)
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
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
MANIFEST.MF 39B
共 111 条
- 1
- 2
资源评论
- yunmengran2012-08-13代码完好,是初学hibernate的好实例
- shangyanlianghao2012-09-06调试了半天,可运行
huiyengma
- 粉丝: 1
- 资源: 12
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功