package?dao;

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

import?entity.Bill;
import?entity.PageBean;
import?entity.Supplier;

public?class?BillDao?{
	public?List?getBillByPage（PageBean?pb?Bill?condition）?{
		String?conditionSql?=““;
		String?sql?=?“select?t2.*t3.name?from（select?t1.*rownum?rn?from?bill?t1?where?rownum<=?“;
		if（condition!=null）{
			if（condition.getPro_name（）?!=null?&&?!““.equals（condition.getPro_name（）））{
				conditionSql?+=?“and?pro_name?like?‘%“+condition.getPro_name（）?+“%‘?“;
			}
			if（condition.getPay（）>0?）{??
				conditionSql?+=?“and?pay?like?‘%“?+?condition.getPay（）?+?“%‘?“;
			}
		}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????779??2014-04-22?13:19??supermaket\bill.txt

?????文件????????978??2014-04-10?15:14??supermaket\javaxm2\.classpath

?????文件???????1040??2014-04-09?19:45??supermaket\javaxm2\.project

?????文件????????503??2014-04-09?18:29??supermaket\javaxm2\.settings\.jsdtscope

?????文件?????????57??2014-04-10?10:49??supermaket\javaxm2\.settings\org.eclipse.core.resources.prefs

?????文件????????364??2014-04-09?18:29??supermaket\javaxm2\.settings\org.eclipse.jdt.core.prefs

?????文件????????473??2014-04-09?19:45??supermaket\javaxm2\.settings\org.eclipse.wst.common.component

?????文件????????345??2014-04-09?18:29??supermaket\javaxm2\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2014-04-09?18:29??supermaket\javaxm2\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2014-04-09?18:29??supermaket\javaxm2\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????7314??2014-04-22?12:49??supermaket\javaxm2\build\classes\dao\BillDao.class

?????文件???????7385??2014-04-22?11:46??supermaket\javaxm2\build\classes\dao\SupplierDao.class

?????文件???????9739??2014-04-18?20:14??supermaket\javaxm2\build\classes\dao\UsersDao.class

?????文件???????2099??2014-04-20?21:58??supermaket\javaxm2\build\classes\entity\Bill.class

?????文件???????1172??2014-04-12?16:52??supermaket\javaxm2\build\classes\entity\PageBean.class

?????文件???????2789??2014-04-15?10:46??supermaket\javaxm2\build\classes\entity\Supplier.class

?????文件???????2491??2014-04-15?11:17??supermaket\javaxm2\build\classes\entity\Users.class

?????文件???????1582??2014-04-12?14:30??supermaket\javaxm2\build\classes\util\DBUtil.class

?????文件???????2361??2014-04-22?11:47??supermaket\javaxm2\build\classes\web\AddSupplierServlet.class

?????文件???????2309??2014-04-15?11:46??supermaket\javaxm2\build\classes\web\AddUsersServlet.class

?????文件???????1699??2014-04-12?16:07??supermaket\javaxm2\build\classes\web\DeleteSupplierServlet.class

?????文件???????1677??2014-04-18?09:56??supermaket\javaxm2\build\classes\web\DeleteUserServlet.class

?????文件???????2412??2014-04-20?21:31??supermaket\javaxm2\build\classes\web\DoAddBillServlet.class

?????文件???????2026??2014-04-22?12:54??supermaket\javaxm2\build\classes\web\DoDeleteBillServlet.class

?????文件???????2888??2014-04-22?12:49??supermaket\javaxm2\build\classes\web\DoUpdateBillServlet.class

?????文件???????1570??2014-04-12?14:29??supermaket\javaxm2\build\classes\web\FindSupplierServlet.class

?????文件???????1652??2014-04-12?14:29??supermaket\javaxm2\build\classes\web\FindUserServlet.class

?????文件???????2915??2014-04-18?21:55??supermaket\javaxm2\build\classes\web\GetBillServlet.class

?????文件???????2797??2014-04-13?17:31??supermaket\javaxm2\build\classes\web\GetSupplierServlet.class

?????文件???????2623??2014-04-18?11:39??supermaket\javaxm2\build\classes\web\GetUserServlet.class

............此處省略102個文件信息