package y2javaee.xmal2.operation;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
import y2javaee.xmal2.common.DBAccessException;
import y2javaee.xmal2.common.ExpertConnection;
import y2javaee.xmal2.entity.Article;
/**
* 文章业务类
* @author nj
*
*/
public class AritcleBo extends ExpertConnection{
private Connection conn = null; //保存数据库连接
private PreparedStatement pstmt = null; //执行SQL语句
private ResultSet rs = null; //保存查询结果集
/**
* 根据文章类型查询相关的文章信息
*/
public List selectArticleByType(int type){
List list = new ArrayList();
String sql = "select * from aritcle where type=? ";
try {
conn=this.getConn();
pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, type);
rs = pstmt.executeQuery();
while(rs.next()){
Article aritcle= new Article();
aritcle.setArticleid(rs.getInt("articleId"));
aritcle.setContent(rs.getString("content"));
aritcle.setTitle(rs.getString("title"));
aritcle.setType(rs.getInt("type"));
aritcle.setWriteDate(rs.getString("writeDate"));
aritcle.setWriter(rs.getString("writer"));
list.add(aritcle);
}
} catch (Exception e) {
System.out.println("根据文章类型查询相关的文章信息失败");
e.printStackTrace();
}finally{
this.closeAll(conn, pstmt, rs);
}
return list;
}
/**
* 根据文章类型和用户名查询相关的文章信息
*/
public List selectArticleByType(int type,String userName){
String sql = "select top(5) * from aritcle where type = ? and writer = ? order by writeDate";
List list = new ArrayList();
try {
conn=this.getConn();
pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, type);
pstmt.setString(2, userName);
rs = pstmt.executeQuery();
while(rs.next()){
Article aritcle= new Article();
aritcle.setArticleid(rs.getInt("articleId"));
aritcle.setTitle(rs.getString("title"));
aritcle.setType(rs.getInt("type"));
aritcle.setContent(rs.getString("content"));
aritcle.setWriteDate(rs.getString("writeDate"));
aritcle.setWriter(rs.getString("writer"));
list.add(aritcle);
}
} catch (SQLException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
} finally{
this.closeAll(conn, pstmt, rs);
}
return list;
}
/**
* 根据文章类型 作者 标题 模糊查询相关的文章信息
*/
public List selectArticleByType(int type,String writer,String title){
String sql = "select top 10 * from aritcle where 1=1 ";
if(type != 0){
sql += "and type = "+type+" ";
}
if(writer != null && !writer.equals("")){
sql += "and writer like '%"+writer+"%' ";
}
if(title != null && !title.equals("")){
sql += "and title like '%"+title+"%' ";
}
sql += "order by writeDate";
List list = new ArrayList();
try {
conn = this.getConn();
pstmt = conn.prepareStatement(sql);
rs = pstmt.executeQuery();
while(rs.next()){
Article aritcle = new Article();
aritcle.setArticleid(rs.getInt("articleId"));
aritcle.setTitle(rs.getString("title"));
aritcle.setType(rs.getInt("type"));
aritcle.setContent(rs.getString("content"));
aritcle.setWriteDate(rs.getString("writeDate"));
aritcle.setWriter(rs.getString("writer"));
list.add(aritcle);
}
} catch (Exception e) {
e.printStackTrace();
} finally{
this.closeAll(conn, pstmt, rs);
}
return list;
}
/**
* 根据文章ID查询文章对象
*/
public Article findArticleByID(int articleId){
String sql = "select * from aritcle where articleId=?";
Article article=null;
try {
conn=this.getConn();
pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, articleId);
rs = pstmt.executeQuery();
while(rs.next())
{
article = new Article();
article.setArticleid(rs.getInt("articleId"));
article.setContent(rs.getString("content"));
article.setTitle(rs.getString("title"));
article.setType(rs.getShort("type"));
article.setWriteDate(rs.getString("writeDate"));
article.setWriter(rs.getString("writer"));
}
} catch (Exception e) {
System.out.println("根据文章ID查询文章对象失败!");
e.printStackTrace();
}
return article;
}
/**
* 删除文章信息
*/
public int deleteArticle(int articleID){
String sql = "delete from aritcle where articleId = ?";
int result = 0;
try {
conn = this.getConn();
pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, articleID);
result = pstmt.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
} finally{
this.closeAll(conn, pstmt, rs);
}
return result;
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
jsp+server2005 E-家园个人网站的实现
共138个文件
gif:40个
jpg:20个
java:16个
5星 · 超过95%的资源 需积分: 10 44 下载量 61 浏览量
2010-09-28
12:53:10
上传
评论
收藏 1.78MB RAR 举报
温馨提示
jsp+server2005 E-家园个人网站的实现jsp+server2005 E-家园个人网站的实现jsp+server2005 E-家园个人网站的实现jsp+server2005 E-家园个人网站的实现jsp+server2005 E-家园个人网站的实现jsp+server2005 E-家园个人网站的实现jsp+server2005 E-家园个人网站的实现jsp+server2005 E-家园个人网站的实现
资源推荐
资源详情
资源评论
收起资源包目录
jsp+server2005 E-家园个人网站的实现 (138个子文件)
AritcleBo.class 5KB
AddBookServlet.class 4KB
ExpertConnection.class 3KB
SearchServlet.class 3KB
DeleteArticleServlet.class 3KB
UsersBo.class 3KB
LoginServlet.class 3KB
SelectArticleServlet.class 2KB
DetailArticleServlet.class 2KB
RegisterServlet.class 2KB
Article.class 2KB
InvalidateServlet.class 1KB
Users.class 1KB
testaritcle.class 1KB
Env.class 1KB
DBAccessException.class 679B
.classpath 820B
org.eclipse.wst.jsdt.ui.superType.container 49B
css.css 2KB
banner.gif 30KB
index_11.gif 8KB
index_1.gif 8KB
logo.gif 4KB
left02.gif 4KB
left04.gif 4KB
left03.gif 4KB
bg06.gif 4KB
index_4.gif 3KB
index_10.gif 3KB
cen06.gif 3KB
cen05.gif 2KB
bg05.gif 810B
button02.gif 664B
button03.gif 660B
button01.gif 652B
line02.gif 393B
bg09.gif 283B
bg03.gif 275B
index_6.gif 169B
isms.gif 162B
bg10.gif 155B
dot02.gif 153B
index_5.gif 138B
index_9.gif 130B
bg01.gif 128B
iboy.gif 125B
igirl.gif 124B
cen02.gif 121B
cen04.gif 121B
line01.gif 114B
bg13.gif 109B
index_3.gif 107B
bg02.gif 96B
bg08.gif 81B
bg07.gif 79B
bg04.gif 78B
dot01.gif 76B
bg11.gif 66B
bg12.gif 66B
sqljdbc.jar 570KB
standard.jar 343KB
jstl.jar 17KB
book.jar 302B
AritcleBo.java 5KB
SearchServlet.java 3KB
AddBookServlet.java 3KB
ExpertConnection.java 2KB
SelectArticleServlet.java 2KB
LoginServlet.java 2KB
DeleteArticleServlet.java 2KB
UsersBo.java 2KB
RegisterServlet.java 1KB
DetailArticleServlet.java 1KB
Article.java 1KB
InvalidateServlet.java 980B
Users.java 936B
Env.java 868B
testaritcle.java 750B
DBAccessException.java 585B
logo.jpg 6KB
cen02~.jpg 4KB
cen01~.jpg 4KB
cen01.jpg 3KB
cen04~.jpg 3KB
cen02.jpg 3KB
cen03~.jpg 3KB
cen04.jpg 3KB
cen03.jpg 3KB
daohan_5.jpg 2KB
daohan_4.jpg 2KB
left01.jpg 1KB
daohan_6.jpg 1KB
button05.jpg 1KB
daohan_7.jpg 1KB
daohan_1.jpg 1KB
daohan_3.jpg 1KB
button07.jpg 1KB
button06.jpg 1KB
daohan_2.jpg 983B
htmlmoban.js 217B
共 138 条
- 1
- 2
资源评论
- yflanyi2012-04-23功能挺多的,就是有些图片缺失
- lanyiyiss2012-10-27为什么数据库又导入不了
lcz383546469
- 粉丝: 16
- 资源: 34
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功