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 WebRoot WEB-INF web.xml 3KB lib 
mysql-connector-java-5.0.3-bin.jar 482KB classes org langsin news control LoginServlet.class 2KB InsertServlet.class 1KB DetailServlet.class 2KB FindByIdServlet.class 2KB UpdateServlet.class 2KB DeleteServlet.class 1KB logic NewsLogicBean.class 5KB LoginLogicBean.class 2KB data NewsDataBean.class 1KB comm SecurityFilter.class 2KB DataSource.class 1014B index.jsp 767B main insert.jsp 537B list.jsp 3KB error.jsp 192B update.jsp 791B detail.jsp 508B META-INF MANIFEST.MF 39B .myeclipse src org langsin news control FindByIdServlet.java 2KB DeleteServlet.java 1KB UpdateServlet.java 2KB LoginServlet.java 2KB DetailServlet.java 2KB InsertServlet.java 2KB logic LoginLogicBean.java 1KB NewsLogicBean.java 4KB data NewsDataBean.java 892B comm SecurityFilter.java 1KB DataSource.java 728B .classpath 433B资源评论
