package?dao;

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?util.DBConn;

import?entity.News;

public?class?GetAllnews?{
	Connection?conn;
	Statement?stmt;
	ResultSet?rs;
	
	public?List?getPageList（String?sqlint?page）{
		int?pageNume?=?10;
		conn?=?DBConn.getConn（）;
		try?{
			stmt?=?conn.createStatement（ResultSet.TYPE_SCROLL_INSENSITIVE
					ResultSet.CONCUR_READ_ONLY）;
			rs?=?stmt.executeQuery（sql）;
			if（page==1）{
				rs.beforeFirst（）;
			}else{
				rs.absolute（（page-1）*pageNume）;
			}
			List?list?=?new?ArrayList（）;
			for（int?i=0;i				News??news=new?News（rs.getInt（1）rs.getString（2）rs.getString（3）rs.getString（4））;
				list.add（news）;
			}
			return?list;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
			return?null;
		}finally{
			
			DBConn.closeConn（conn）;
		}
	}
	
	private?int?num;
	
	public?int?getNum（）?{
		return?num;
	}

	public?void?setNum（int?num）?{
		this.num?=?num;
	}

	public?void?getCount（String?sql）{
		conn?=?DBConn.getConn（）;
		try?{
			stmt?=?conn.createStatement（）;
			rs?=?stmt.executeQuery（sql）;
			if（rs.next（））{
				this.num?=?rs.getInt（1）;
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}finally{
			
			DBConn.closeConn（conn）;
		}
	}
	
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2015-03-23?11:09??company\
?????文件?????????670??2015-03-23?10:52??company\.classpath
?????目錄???????????0??2009-11-03?11:02??company\.myeclipse\
?????文件?????????294??2015-03-23?10:45??company\.mymetadata
?????文件?????????291??2015-03-23?10:45??company\.mymetadata.bak
?????文件????????1750??2015-03-23?09:33??company\.project
?????目錄???????????0??2015-03-23?10:45??company\.settings\
?????文件?????????500??2015-03-23?09:33??company\.settings\.jsdtscope
?????文件????????1009??2015-03-23?10:45??company\.settings\com.genuitec.eclipse.j2eedt.core.prefs
?????文件??????????69??2015-03-23?10:36??company\.settings\org.eclipse.core.resources.prefs
?????文件?????????303??2015-03-23?09:33??company\.settings\org.eclipse.jdt.core.prefs
?????文件?????????458??2015-03-23?09:33??company\.settings\org.eclipse.wst.common.component
?????文件?????????252??2015-03-23?09:33??company\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2015-03-23?09:33??company\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2015-03-23?09:33??company\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件????????7117??2015-03-23?11:07??company\company.sql
?????文件??????425627??2015-03-23?11:09??company\login.png
?????文件?????????211??2015-03-23?11:11??company\readme
?????目錄???????????0??2009-11-03?11:02??company\src\
?????目錄???????????0??2009-11-03?11:02??company\src\dao\
?????文件????????1505??2009-02-27?16:23??company\src\dao\GetAllnews.java
?????文件????????1345??2009-02-27?11:13??company\src\dao\GetnewsDao.java
?????文件???????11527??2009-02-27?16:22??company\src\dao\MessageDAO.java
?????文件????????6263??2009-02-27?16:17??company\src\dao\ProductDAO.java
?????文件????????1066??2009-02-27?11:13??company\src\dao\Userdao.java
?????文件????????2516??2009-02-27?11:13??company\src\dao\UsersDAO.java
?????目錄???????????0??2009-11-03?11:02??company\src\entity\
?????文件?????????457??2009-02-27?11:13??company\src\entity\Liaoinfo.java
?????文件????????1149??2009-02-27?11:13??company\src\entity\Message.java
?????文件?????????983??2009-02-27?11:13??company\src\entity\News.java
?????文件????????1533??2009-02-27?11:13??company\src\entity\Product.java
............此處省略210個文件信息