/**
*
*/
package y2javaee.xmal2.common;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import y2javaee.xmal2.entity.Article;
/**
* 与文章相关的数据库操作
*
* @author Administrator
*
*/
public class ArticleDAO {
/**
* 非用户登录,按照文章类型查询所有文章信息
*
* @param typeId
* @return
*/
public List<Article> selectArticleByTypeID(int typeId) {
List<Article> articles = new ArrayList<Article>();
Connection con = DBConnection.getConnection();
PreparedStatement pstmt = null;
String sql = "select * from article where typeId=?";
try {
pstmt = con.prepareStatement(sql);
pstmt.setInt(1, typeId);
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
Article article = new Article();
article.setArticleId(rs.getInt(1));
article.setTitle(rs.getString(2));
article.setTypeId(rs.getInt(3));
article.setContent(rs.getString(4));
article.setWriter(rs.getString(5));
article.setWriterDate(rs.getString(6));
articles.add(article);
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBConnection.closeStatement(pstmt);
DBConnection.closeConnection(con);
}
return articles;
}
/**
*
* @param typeId
* @param title
* @param writer
* @return
*/
public List<Article> selectArticle(int typeId, String title, String writer) {
List<Article> articles = new ArrayList<Article>();
Connection con = DBConnection.getConnection();
Statement stmt = null;
String sql = "select * from article where";
if (typeId != 0) {
sql = sql + " typeId=" + typeId + "";
}
if (title != "") {
if (sql.charAt(sql.length() - 1) == 'e')
sql = sql + " title like '%" + title + "%'";
else {
sql = sql + " and title like '%" + title + "%'";
}
}
if (writer != "") {
//System.out.println("222222222222");
if (sql.charAt(sql.length() - 1) != 'e') {
sql = sql + " and writer like '%" + writer + "%'";
} else {
sql = sql + " writer like '%" + writer + "%'";
}
}
if (typeId == 0 && title == "" && writer == "") {
//System.out.println("aaaaaaaaaaa");
sql = "select * from article";
}
//System.out.println(sql);
try {
stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
Article article = new Article();
article.setArticleId(rs.getInt(1));
article.setTitle(rs.getString(2));
article.setTypeId(rs.getInt(3));
article.setContent(rs.getString(4));
article.setWriter(rs.getString(5));
article.setWriterDate(rs.getString(6));
articles.add(article);
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBConnection.closeStatement(stmt);
DBConnection.closeConnection(con);
}
return articles;
}
/**
* 根据文章ID查询所有的文章
*
* @param articleId
* @return
*/
public Article selectArticleByArticleID(int articleId) {
Article article = null;
Connection con = DBConnection.getConnection();
PreparedStatement pstmt = null;
String sql = "select * from article where articleId=?";
try {
pstmt = con.prepareStatement(sql);
pstmt.setInt(1, articleId);
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
article = new Article();
article.setArticleId(rs.getInt(1));
article.setTitle(rs.getString(2));
article.setArticleId(rs.getInt(3));
article.setContent(rs.getString(4));
article.setWriter(rs.getString(5));
article.setWriterDate(rs.getString(6));
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBConnection.closeStatement(pstmt);
DBConnection.closeConnection(con);
}
return article;
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
ACCP S2阶段的项目实战—“E家园”个人网站
共113个文件
gif:40个
jpg:20个
class:14个
2星 需积分: 9 19 下载量 163 浏览量
2009-10-12
21:15:22
上传
评论
收藏 1.92MB RAR 举报
温馨提示
ACCP S2阶段的项目实战—“E家园”个人网站 ACCP S2阶段的项目实战—“E家园”个人网站 ACCP S2阶段的项目实战—“E家园”个人网站
资源推荐
资源详情
资源评论
收起资源包目录
ACCP S2阶段的项目实战—“E家园”个人网站 (113个子文件)
ArticleDAO.class 4KB
UserDAO.class 3KB
LoginAction.class 2KB
SearchServlet.class 2KB
RegisterAction.class 2KB
ShowArticles.class 2KB
DetailArticleServlet.class 2KB
DBConnection.class 2KB
Article.class 1KB
LeaveAction.class 1KB
User.class 1KB
ArticleBiz.class 1KB
UserBiz.class 765B
Test.class 710B
.classpath 631B
css.css 2KB
styles.css 941B
Thumbs.db 83KB
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
cen04.gif 121B
cen02.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
standard.jar 385KB
jtds-1.2.jar 279KB
naming-factory-dbcp.jar 150KB
jstl.jar 21KB
ArticleDAO.java 4KB
UserDAO.java 2KB
Article.java 2KB
SearchServlet.java 2KB
ShowArticles.java 1KB
LoginAction.java 1KB
RegisterAction.java 1KB
DBConnection.java 1KB
DetailArticleServlet.java 1KB
User.java 986B
LeaveAction.java 882B
ArticleBiz.java 631B
UserBiz.java 377B
Test.java 330B
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
addBook.jsp 8KB
register.jsp 6KB
left.jsp 6KB
共 113 条
- 1
- 2
资源评论
- f5742540482013-04-11登录不行呀 注册也有问题 求帮助
MABOXIA8898
- 粉丝: 1
- 资源: 4
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功