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.zip （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
资源评论
芝麻粒儿
- 粉丝: 6w+
- 资源: 2万+
最新资源
- 6吨级轻型载货汽车驱动桥的设计及虚拟装配 (1)
- Springboot 学生管理系统更删改查
- 九缸星形发动机点火器3D
- 毕业设计-宿舍管理系统设计与实现
- 全面详解Ruby编程语言，从入门到高级实战
- CC2530无线zigbee裸机代码实现红外遥控器接收IRDecod、串口打印UART、12864液晶屏显示例程.zip
- 跨平台的云端爬虫系统项目全套技术资料.zip
- CC2530无线zigbee裸机代码实现红外遥控发送、串口打印、LCD12864液晶屏、按键程序.zip
- Delphi编程语言从基础知识到高级应用全面指南
- Scratch图形化编程语言入门与进阶指南
- 酒店后台管理系统项目全套技术资料.zip
- CC2530无线zigbee裸机代码实现RS485串口通讯.zip
- Day-03 Vue222222222222222222222
- Visual Basic语言入门与进阶教程
- 数据安全治理白皮书6.0-2024年最新版
- 基于pygame的圣诞小游戏
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
