package org.langsin.news.logic;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import org.langsin.news.comm.DataSource;
import org.langsin.news.data.NewsDataBean;
public class NewsLogicBean {
private int allRows;
private int curPage=1;
private int rowPerPage=5;
private int allPages;
public int getCurPage() {
return curPage;
}
public void setCurPage(int curPage) {
this.curPage = curPage;
}
public int getAllPages() {
return allPages;
}
public int getAllRows() {
return allRows;
}
public int getRowPerPage() {
return rowPerPage;
}
@SuppressWarnings("unchecked")
public List findAll(){
List list=new ArrayList();
Statement st=null;
ResultSet rs=null;
try {
st=DataSource.getConnection().createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=st.executeQuery("select newsid,newstitle,newscontent,newscount,newsdate from news order by newsdate desc");
rs.last();
this.allRows=rs.getRow();
if(this.allRows%this.rowPerPage==0){
this.allPages=this.allRows/this.rowPerPage;
}else{
this.allPages=this.allRows/this.rowPerPage+1;
}
if(this.curPage==1){
rs.beforeFirst();
}else{
rs.absolute((this.curPage-1)*this.rowPerPage);
}
int i=0;
while(rs.next()&&i<this.rowPerPage){
NewsDataBean bean=new NewsDataBean();
bean.setNewsid(rs.getString(1));
bean.setNewstitle(rs.getString(2));
bean.setNewscontent(rs.getString(3));
bean.setNewscount(rs.getString(4));
bean.setNewsdate(rs.getString(5));
list.add(bean);
i++;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}
public int insertNews(String newsTitle,String newsContent){
return modify("insert into news(newstitle,newscontent,newscount,newsdate) values('"+newsTitle+"','"+newsContent+"',0,now())");
}
public int modify(String sql){
int result=0;
Statement st=null;
try {
st=DataSource.getConnection().createStatement();
result=st.executeUpdate(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
st.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return result;
}
public int deleteId(String newsid){
return modify("delete from news where newsid="+newsid);
}
public int updateNews(String newsid,String newsTitle,String newsContent){
return modify("update news set newstitle='"+newsTitle+"',newscontent='"+newsContent+"' where newsid="+newsid);
}
public NewsDataBean findById(String newsid){
NewsDataBean bean=new NewsDataBean();
Statement st=null;
ResultSet rs=null;
try {
st=DataSource.getConnection().createStatement();
rs=st.executeQuery("select newsid,newstitle,newscontent,newscount,newsdate from news where newsid="+newsid);
if(rs.next()){
bean.setNewsid(rs.getString(1));
bean.setNewstitle(rs.getString(2));
bean.setNewscontent(rs.getString(3));
bean.setNewscount(rs.getString(4));
bean.setNewsdate(rs.getString(5));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return bean;
}
public NewsDataBean detail(String newsid){
NewsDataBean bean=new NewsDataBean();
Statement st=null;
ResultSet rs=null;
try {
st=DataSource.getConnection().createStatement();
st.executeUpdate("update news set newscount=newscount+1 where newsid="+newsid);
rs=st.executeQuery("select newsid,newstitle,newscontent,newscount,newsdate from news where newsid="+newsid);
if(rs.next()){
bean.setNewsid(rs.getString(1));
bean.setNewstitle(rs.getString(2));
bean.setNewscontent(rs.getString(3));
bean.setNewscount(rs.getString(4));
bean.setNewsdate(rs.getString(5));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return bean;
}
public static void main(String[] args) {
// TODO Auto-generated method stub
List list=new NewsLogicBean().findAll();
System.out.println(list.size());
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
news.rar (34个子文件)
news
.project 1KB
.mymetadata 285B
src
org
langsin
news
logic
LoginLogicBean.java 1KB
NewsLogicBean.java 4KB
comm
SecurityFilter.java 1KB
DataSource.java 728B
data
NewsDataBean.java 892B
control
UpdateServlet.java 2KB
DeleteServlet.java 1KB
LoginServlet.java 2KB
DetailServlet.java 2KB
FindByIdServlet.java 2KB
InsertServlet.java 2KB
WebRoot
WEB-INF
classes
org
langsin
news
logic
LoginLogicBean.class 2KB
NewsLogicBean.class 5KB
comm
DataSource.class 1014B
SecurityFilter.class 2KB
data
NewsDataBean.class 1KB
control
LoginServlet.class 2KB
DeleteServlet.class 1KB
FindByIdServlet.class 2KB
DetailServlet.class 2KB
InsertServlet.class 1KB
UpdateServlet.class 2KB
lib
mysql-connector-java-5.0.3-bin.jar 482KB
web.xml 3KB
index.jsp 767B
META-INF
MANIFEST.MF 39B
main
error.jsp 192B
update.jsp 791B
list.jsp 3KB
insert.jsp 537B
detail.jsp 508B
.myeclipse
.classpath 433B
共 34 条
- 1
资源评论
- 古市轩2014-06-27虽然对我帮助不大,还是谢谢
scalgavin
- 粉丝: 0
- 资源: 6
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功