package xxgl.dao.news;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import xxgl.conn.DataConn;
public class NewsDaoImpl implements NewsDao {
/**
* 添加新闻
*
* @param news
* @return
*/
public int addnews(News news) {
// TODO Auto-generated method stub
int flag = 0;
Connection conn = DataConn.getConn();
PreparedStatement ps = null;
String sql = "insert into t_news(newstitle,classid,newskey,newsourse,newscontent,userid) values (?,?,?,?,?,?)";
try {
ps = conn.prepareStatement(sql);
ps.setString(1, news.getNewstitle());
ps.setInt(2, news.getClassid());
ps.setString(3, news.getNewskey());
ps.setString(4, news.getNewsourse());
ps.setString(5, news.getNewscontent());
ps.setInt(6, news.getUserid());
flag = ps.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
try {
ps.close();
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return flag;
}
/**
* 通过栏目得到新闻列表
*
* @param itemid
* @return
*/
public ArrayList<News> getNewsByItemId(int itemid) {
ArrayList<News> listnews = new ArrayList<News>();
Connection conn = DataConn.getConn();
String sql = "select top 2 * from t_news where classid in "
+ "(select classid from t_class where itemid='" + itemid + "')";
try {
PreparedStatement ps = conn.prepareStatement(sql);
// ps.setInt(1,itemid);
ResultSet rs = ps.executeQuery();
while (rs.next()) {
News news = new News();
news.setClassid(rs.getInt("classid"));
news.setNewsid(rs.getInt("newsid"));
news.setNewstitle(rs.getString("newstitle"));
news.setUserid(rs.getInt("userid"));
news.setNewskey(rs.getString("newskey"));
listnews.add(news);
}
rs.close();
ps.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
return listnews;
}
/**
* 通过类别得到新闻列表
* @param classid
* @return
*/
public ArrayList<News> getNewsByClasses(int classid) {
ArrayList<News> listnews = new ArrayList<News>();
Connection conn = DataConn.getConn();
String sql = "select top 2 * from t_news where classid =? order by newsdate desc";
try {
PreparedStatement ps = conn.prepareStatement(sql);
ps.setInt(1, classid);
ResultSet rs = ps.executeQuery();
while (rs.next()) {
News news = new News();
news.setClassid(rs.getInt("classid"));
news.setNewsid(rs.getInt("newsid"));
news.setNewstitle(rs.getString("newstitle"));
news.setUserid(rs.getInt("userid"));
news.setNewskey(rs.getString("newskey"));
listnews.add(news);
}
rs.close();
ps.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
return listnews;
}
/**
* 通过新闻id获取新闻信息
* @param newsid
* @return
*/
public News getNews(int newsid) {
News news = new News();
Connection conn = DataConn.getConn();
String sql = "select * from t_news where newsid=?";
try {
PreparedStatement ps = conn.prepareStatement(sql);
ps.setInt(1, newsid);
ResultSet rs = ps.executeQuery();
while (rs.next()) {
news.setNewsid(rs.getInt("newsid"));
news.setNewstitle(rs.getString("newstitle"));
news.setNewskey(rs.getString("newskey"));
news.setNewscontent(rs.getString("newscontent"));
news.setNewsdate(rs.getDate("newsdate") + " "
+ rs.getTime("newsdate"));
news.setNewsourse(rs.getString("newsourse"));
news.setNewsauding(rs.getInt("newsauding"));
news.setNewscomment(rs.getInt("newscomment"));
news.setClassid(rs.getInt("classid"));
}
rs.close();
ps.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
return news;
}
/**
* 使用分页得到新闻列表
* @param currentPage
* @param pageSize
* @return
*/
public List<News> getNewsByPage(int currentPage, int pageSize) {
// TODO Auto-generated method stub
ArrayList<News> list = new ArrayList<News>();
Connection conn = DataConn.getConn();
PreparedStatement ps = null;
ResultSet rs = null;
String sql = "select top "
+ pageSize
+ " * from t_news where (newsid not in (select top "
+ (pageSize * (currentPage - 1))
+ " newsid from t_news order by newsid asc)) order by newsid asc";
try {
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
while (rs.next()) {
News news = new News();
news.setUserid(rs.getInt("userid"));
news.setNewsid(rs.getInt("newsid"));
news.setNewstitle(rs.getString("newstitle"));
news.setClassid(rs.getInt("classid"));
news.setNewskey(rs.getString("newskey"));
news.setNewsdate(rs.getDate("newsdate") + " "
+ rs.getTime("newsdate"));
news.setNewsauding(rs.getInt("newsauding"));
news.setNewscontent(rs.getString("newscontent"));
news.setNewscomment(rs.getInt("newscomment"));
news.setNewsourse(rs.getString("newsourse"));
list.add(news);
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
rs.close();
ps.close();
conn.close();
} catch (SQLException e1) {
e1.printStackTrace();
}
}
return list;
}
/**
* 通过新闻内容获取新闻列表
* @param pageSize
* @param currentPage
* @param title
* @return
*/
public List<News> getNewsByContent(int pageSize, int currentPage,
String content) {
// TODO Auto-generated method stub
ArrayList<News> list = new ArrayList<News>();
Connection conn = DataConn.getConn();
String sql = "select top "
+ pageSize
+ " * from t_news where(newsid not in(select top "
+ (pageSize * (currentPage - 1))
+ " newsid from t_news where newscontent like ? order by newsdate desc)) and (newscontent like ? )order by newsdate desc ";
try {
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1, "%" + content + "%");
ps.setString(2, "%" + content + "%");
ResultSet rs = ps.executeQuery();
while (rs != null && rs.next()) {
News news = new News();
news.setNewsid(rs.getInt("newsid"));
news.setNewstitle(rs.getString("newstitle"));
news.setClassid(rs.getInt("classid"));
news.setNewskey(rs.getString("newskey"));
news.setNewsdate(rs.getDate("newsdate") + " "
+ rs.getTime("newsdate"));
news.setNewsourse(rs.getString("newsourse"));
list.add(news);
}
ps.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
return list;
}
/**
* 通过新闻关键字获取新闻列表
* @param pageSize
* @param currentPage
* @param content
* @return
*/
public List<News> getNewsByKeyword(int pageSize, int currentPage,
String keyword) {
// TODO Auto-generated method stub
ArrayList<News> list = new ArrayList<News>();
Connection conn = DataConn.getConn();
String sql = "select top "
+ pageSize
+ " * from t_news where(newsid not in(select top "
+ (pageSize * (currentPage - 1))
+ " newsid from t_news where newskey like ? order by newsdate desc)) and (newskey like ? )order by newsdate desc ";
try {
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1, "%" + keyword + "%");
ps.setString(2, "%" + keyword + "%");
ResultSet rs = ps.executeQuery();
while (rs != null && rs.next()) {
News news = new News();
news.setNewsid(rs.getInt("newsid"));
news.setNewstitle(rs.getString("newstitle"));
news.setClassid(rs.getInt("classid"));
news.setNewskey(rs.getString("newskey"));
news.setNewsdate(rs.getDate("newsdate") + " "
+
新闻发布系统 JSP+servlet +sql2000
5星 · 超过95%的资源 需积分: 10 168 浏览量
2009-11-06
14:40:23
上传
评论 4
收藏 2.43MB RAR 举报 
新闻发布系统 JSP+servlet +sql2000 （696个子文件） 
spellchecker.cfm 5KB NewsDaoImpl.class 14KB UserDaoImpl.class 8KB ClassesDaoImpl.class 7KB PageDaoImpl.class 6KB CommentDaoImpl.class 5KB ItemsDaoImpl.class 4KB AddNew.class 3KB News.class 3KB FixNews.class 3KB PopedomidDaoImpl.class 3KB FindNewsByContent.class 3KB FindNewsByKeyword.class 3KB FindNewsByTitle.class 3KB FixClasses.class 3KB GetComment.class 2KB GetClassesServlet.class 2KB MoveNews.class 2KB FixItems.class 2KB User.class 2KB StatisDaoImpl.class 2KB GetNews.class 2KB SetLogin.class 2KB GetNewsByNewsid.class 2KB FindUsersByPage.class 2KB FindNewsByPage.class 2KB AddClasses.class 2KB UserFix.class 2KB LimitServlet.class 2KB AddUserServlet.class 2KB AdminFilter.class 2KB FrontFilter.class 2KB GetNewsByClasses.class 2KB GetNewsByClassId.class 2KB CommentServlet.class 2KB DelComment.class 2KB AddItems.class 2KB DelClasses.class 2KB GetNewsByItems.class 2KB DelItems.class 2KB AudingNews.class 2KB GetItemByClasses.class 2KB GetCommentByNewsId.class 2KB GetNewsByItemId.class 2KB NowLockingUser.class 2KB IsComment.class 2KB NoComment.class 2KB DelNews.class 2KB AdminAddUser.class 2KB GetClassName.class 2KB GetUserNameById.class 2KB GetLimit.class 2KB AudingUser.class 2KB JieSuoUser.class 2KB DelUser.class 2KB Page.class 2KB SetHits.class 2KB GetItemClass.class 2KB GetItemServlet.class 2KB GetUsers.class 2KB FindNews.class 2KB FindHits.class 1KB FindNewsByMonth.class 1KB FindNewsByYear.class 1KB FindNewsByHits.class 1KB FindNewsByDay.class 1KB DataConn.class 1KB Statis.class 1KB Comment.class 1KB EncodingFilter.class 1KB Classes.class 1KB Popedomid.class 1KB ItemClass.class 1KB Items.class 1KB NewsDao.class 1KB ClassesDao.class 817B UserDao.class 667B PageDao.class 500B PopedomidDaoFactory.class 476B StatisDaoFactory.class 458B CommentDaoFactory.class 456B ClassesDaoFactory.class 456B ItemsDaoFactory.class 436B ItemsDao.class 432B NewsDaoFactory.class 426B UserDaoFactory.class 426B PageDaoFactory.class 426B CommentDao.class 423B PopedomidDao.class 242B StatisDao.class 223B .classpath 1KB fck_editor.css 8KB fck_editor.css 8KB fck_editor.css 8KB fck_dialog.css 6KB fck_dialog.css 6KB fck_dialog.css 6KB fck_internal.css 4KB fck_editorarea.css 3KB fck_dialog_common.css 2KB共 696 条
- 1
- 2
- 3
- 4
- 5
- 6
- 7
资源评论
微微信2014-03-05这个程序可以运行！！！就是稍微有点乱，。。认真看就能看懂
