package?com.lion.dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;

import?com.lion.model.PageBean;

public?class?SalesfactDao?{


	public?ResultSet?salesfactList（Connection?conPageBean?pageBean）throws?Exception{
		String?sql=“select?*?from?Fact_Sales?where?DateKey=‘2016-01-01‘?limit????“;
		PreparedStatement?pstmt=con.prepareStatement（sql）;
		pstmt.setInt（1?pageBean.getStart（））;
		pstmt.setInt（2?pageBean.getRows（））;
		return?pstmt.executeQuery（）;
	}
	
	public?ResultSet?salesfactListA（Connection?con）throws?Exception{
		String?sql=“select?*?from?Fact_Sales?where?DateKey=‘2016-01-01‘?“;
		PreparedStatement?pstmt=con.prepareStatement（sql）;
	
		return?pstmt.executeQuery（）;
	}
	
	public?int?salesfactCount（Connection?con）throws?Exception{
		String?sql=“select?count（*）?as?total?from?Fact_Sales?where?DateKey=‘2016-01-01‘“;
		PreparedStatement?pstmt=con.prepareStatement（sql）;
		ResultSet?rs=pstmt.executeQuery（）;
		if（rs.next（））{
			return?rs.getInt（“total“）;
		}else{
			return?0;
		}
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2016-07-29?09:47??echarteasyuiV1\
?????文件????????1093??2016-07-29?09:47??echarteasyuiV1\.classpath
?????文件????????1339??2016-07-29?10:03??echarteasyuiV1\.project
?????目錄???????????0??2016-07-29?09:47??echarteasyuiV1\.settings\
?????文件?????????522??2016-07-29?09:47??echarteasyuiV1\.settings\.jsdtscope
?????文件?????????364??2016-07-29?09:47??echarteasyuiV1\.settings\org.eclipse.jdt.core.prefs
?????文件?????????501??2016-07-29?09:47??echarteasyuiV1\.settings\org.eclipse.wst.common.component
?????文件?????????414??2016-07-29?09:47??echarteasyuiV1\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2016-07-29?09:47??echarteasyuiV1\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2016-07-29?09:47??echarteasyuiV1\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2016-07-29?09:58??echarteasyuiV1\src\
?????目錄???????????0??2016-07-29?09:58??echarteasyuiV1\src\com\
?????目錄???????????0??2016-07-29?09:58??echarteasyuiV1\src\com\lion\
?????目錄???????????0??2016-07-29?09:58??echarteasyuiV1\src\com\lion\dao\
?????文件????????1082??2016-07-28?10:11??echarteasyuiV1\src\com\lion\dao\SalesfactDao.java
?????目錄???????????0??2016-07-29?09:59??echarteasyuiV1\src\com\lion\model\
?????文件?????????530??2016-07-27?08:50??echarteasyuiV1\src\com\lion\model\PageBean.java
?????目錄???????????0??2016-07-29?09:58??echarteasyuiV1\src\com\lion\servlet\
?????文件????????1795??2016-07-29?10:03??echarteasyuiV1\src\com\lion\servlet\SalesListServlet.java
?????目錄???????????0??2016-07-29?09:58??echarteasyuiV1\src\com\lion\util\
?????文件????????1100??2016-07-27?14:51??echarteasyuiV1\src\com\lion\util\DbUtil.java
?????文件?????????701??2016-07-27?08:49??echarteasyuiV1\src\com\lion\util\JsonUtil.java
?????文件?????????384??2016-07-27?08:50??echarteasyuiV1\src\com\lion\util\ResponseUtil.java
?????目錄???????????0??2016-07-29?09:51??echarteasyuiV1\WebRoot\
?????文件?????????834??2016-07-29?09:47??echarteasyuiV1\WebRoot\index.jsp
?????目錄???????????0??2016-07-29?09:51??echarteasyuiV1\WebRoot\jquery-easyui-1.4.5\
?????文件???????30176??2016-07-28?17:11??echarteasyuiV1\WebRoot\jquery-easyui-1.4.5\changelog.txt
?????目錄???????????0??2016-07-29?09:51??echarteasyuiV1\WebRoot\jquery-easyui-1.4.5\demo\
?????目錄???????????0??2016-07-29?09:51??echarteasyuiV1\WebRoot\jquery-easyui-1.4.5\demo-mobile\
?????目錄???????????0??2016-07-29?09:51??echarteasyuiV1\WebRoot\jquery-easyui-1.4.5\demo-mobile\accordion\
?????文件????????1149??2016-07-28?17:11??echarteasyuiV1\WebRoot\jquery-easyui-1.4.5\demo-mobile\accordion\basic.html
............此處省略849個文件信息