完整版新闻管理系统无bug含数据库表

满足大家的需求 贡献此代码 以供参考 1

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个文件信息