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(); //从数据库取出数据,并自动封
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
BlogOnline.rar (98个子文件)
BlogOnline
.project 1KB
.myumldata 66B
.settings
org.eclipse.core.resources.prefs 826B
.mymetadata 303B
WebRoot
otherBlogMain.jsp 720B
adminArticle.jsp 1KB
adminMain.jsp 566B
searchResult.jsp 2KB
WEB-INF
.struts-config.mex 48B
web.xml 5KB
lib
classes
cn
com
blogonline
ImageTool.class 2KB
OpenBlogAction.class 3KB
Blog.class 2KB
FirstAction.class 3KB
CheckUnameAction.class 2KB
OpenArticleAction.class 3KB
BlogOperateAction.class 3KB
ArticleSortAction.class 2KB
LoginAction.class 3KB
Article.class 1KB
DbOperate.class 7KB
ShowFeedbackAction.class 3KB
Constants.class 1KB
WriteFeedbackAction.class 3KB
HibernateUtil.class 2KB
ArticleSaveAction.class 3KB
SaveLogoAction.class 3KB
SaveSelfInfoAction.class 2KB
AdminLinksAction.class 4KB
AdminSortAction.class 3KB
Links.class 1KB
AdminArticleAction.class 4KB
FeedBack.class 1KB
RegistAction.class 2KB
Sort.class 904B
SearchAction.class 2KB
model.hbm.xml 2KB
hibernate.cfg.xml 946B
adminTop.jsp 837B
adminSelf.jsp 2KB
index.jsp 4KB
regist.jsp 4KB
META-INF
MANIFEST.MF 39B
blogAdminMain.jsp 1009B
newArticle.jsp 2KB
image.jsp 455B
top.jsp 1KB
left.jsp 4KB
adminLink.jsp 2KB
main.jsp 2KB
blogMain.jsp 716B
adminLeft.jsp 2KB
images
bk_button01.gif 448B
regist.js 3KB
mystyle.css 2KB
adminArticle.js 5KB
bk_11.jpg 350B
logo.gif 2KB
default_icon.jpg 6KB
index.js 5KB
Thumbs.db 15KB
adminSort.js 4KB
checkwd_image.png 406B
newArticle.js 3KB
adminLink.js 5KB
registOK.jsp 2KB
adminSort.jsp 2KB
feedback.jsp 3KB
adminLogo.jsp 1KB
.myeclipse
src
cn
com
blogonline
FeedBack.java 787B
HibernateUtil.java 1KB
LoginAction.java 2KB
Article.java 905B
Sort.java 437B
BlogOperateAction.java 3KB
FirstAction.java 2KB
WriteFeedbackAction.java 2KB
Constants.java 1KB
CheckUnameAction.java 1KB
RegistAction.java 2KB
SearchAction.java 1KB
ArticleSortAction.java 2KB
DbOperate.java 10KB
ShowFeedbackAction.java 3KB
OpenBlogAction.java 2KB
SaveLogoAction.java 2KB
Blog.java 1KB
AdminLinksAction.java 3KB
ArticleSaveAction.java 2KB
Links.java 564B
AdminArticleAction.java 3KB
ImageTool.java 1KB
OpenArticleAction.java 2KB
SaveSelfInfoAction.java 2KB
AdminSortAction.java 3KB
model.hbm.xml 2KB
hibernate.cfg.xml 946B
.classpath 4KB
共 98 条
- 1
资源评论
liqianghunnueducn
- 粉丝: 3
- 资源: 35
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功