SuperMarketSys超市管理系统(model2版本）

实体类

package com.yccz.entity;import java.util.Date;import java.util.List;/** * 订单表 * @author Administrator * */public class Bill {    private int id;    private String billCode;    private String productName;    private String productDesc;    private String productUnit;    private double productCount;    private double totalPrice;    private int isPayment;    private int createdBy;    private Date creationDate;    private int modifyBy;    private Date modifyDate;    private int providerId;    private String providerName;    public String getProviderName() {        return providerName;    }    public void setProviderName(String providerName) {        this.providerName = providerName;    }    //供应商集合    private Provider provider;    public int getId() {        return id;    }    public void setId(int id) {        this.id = id;    }    public String getBillCode() {        return billCode;    }    public void setBillCode(String billCode) {        this.billCode = billCode;    }    public String getProductName() {        return productName;    }    public void setProductName(String productName) {        this.productName = productName;    }    public String getProductDesc() {        return productDesc;    }    public void setProductDesc(String productDesc) {        this.productDesc = productDesc;    }    public String getProductUnit() {        return productUnit;    }    public void setProductUnit(String productUnit) {        this.productUnit = productUnit;    }    public double getProductCount() {        return productCount;    }    public void setProductCount(double productCount) {        this.productCount = productCount;    }    public double getTotalPrice() {        return totalPrice;    }    public void setTotalPrice(double totalPrice) {        this.totalPrice = totalPrice;    }    public int getIsPayment() {        return isPayment;    }    public void setIsPayment(int isPayment) {        this.isPayment = isPayment;    }    public int getCreatedBy() {        return createdBy;    }    public void setCreatedBy(int createdBy) {        this.createdBy = createdBy;    }    public Date getCreationDate() {        return creationDate;    }    public void setCreationDate(Date creationDate) {        this.creationDate = creationDate;    }    public int getModifyBy() {        return modifyBy;    }    public void setModifyBy(int modifyBy) {        this.modifyBy = modifyBy;    }    public Date getModifyDate() {        return modifyDate;    }    public void setModifyDate(Date modifyDate) {        this.modifyDate = modifyDate;    }    public int getProviderId() {        return providerId;    }    public void setProviderId(int providerId) {        this.providerId = providerId;    }    public Provider getProvider() {        return provider;    }    public void setProvider(Provider provider) {        this.provider = provider;    }    @Override    public String toString() {        return "Bill [id=" + id + ", billCode=" + billCode + ", productName="                + productName + ", productDesc=" + productDesc                + ", productUnit=" + productUnit + ", productCount="                + productCount + ", totalPrice=" + totalPrice + ", isPayment="                + isPayment + ", createdBy=" + createdBy + ", creationDate="                + creationDate + ", modifyBy=" + modifyBy + ", modifyDate="                + modifyDate + ", providerId=" + providerId + ", provider="                + provider + "]";    }}

package com.yccz.entity;

import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;

/**
* 用户表
* @author Administrator
*
*/
public class User {

  private int id;  private String userCode;  private String userName;  private String userPassword;  private int gender;  private Date birthday;  private String phone;  private String address;  private int userRole;  private int createdBy;  private Date creationDate;  private int modifyBy;  private Date modifyDate;    private int age;    private String  userRoleName;        //由出生日期获得年龄          public  int getMyAge(Date birthDay) throws Exception {              Calendar cal = Calendar.getInstance();              if (cal.before(birthDay)) {                  throw new IllegalArgumentException(                          "The birthDay is before Now.It's unbelievable!");              }              int yearNow = cal.get(Calendar.YEAR);              int monthNow = cal.get(Calendar.MONTH);              int dayOfMonthNow = cal.get(Calendar.DAY_OF_MONTH);              cal.setTime(birthDay);              int yearBirth = cal.get(Calendar.YEAR);              int monthBirth = cal.get(Calendar.MONTH);              int dayOfMonthBirth = cal.get(Calendar.DAY_OF_MONTH);              int age = yearNow - yearBirth;              if (monthNow <= monthBirth) {                  if (monthNow == monthBirth) {                      if (dayOfMonthNow < dayOfMonthBirth) age--;                  }else{                      age--;                  }              }              return age;          }    public int getAge() {    return age;}public void setAge(int age) {    this.age = age;}public String getUserRoleName() {    return userRoleName;}public void setUserRoleName(String userRoleName) {    this.userRoleName = userRoleName;}public int getId() {    return id;}public void setId(int id) {    this.id = id;}public String getUserCode() {    return userCode;}public void setUserCode(String userCode) {    this.userCode = userCode;}public String getUserName() {    return userName;}public void setUserName(String userName) {    this.userName = userName;}public String getUserPassword() {    return userPassword;}public void setUserPassword(String userPassword) {    this.userPassword = userPassword;}public int getGender() {    return gender;}public void setGender(int gender) {    this.gender = gender;}public Date getBirthday() {    return birthday;}public void setBirthday(Date birthday) {    this.birthday = birthday;    try {        age = getMyAge(birthday);    } catch (Exception e) {        e.printStackTrace();    }}public String getPhone() {    return phone;}public void setPhone(String phone) {    this.phone = phone;}public String getAddress() {    return address;}public void setAddress(String address) {    this.address = address;}public int getUserRole() {    return userRole;}public void setUserRole(int userRole) {    this.userRole = userRole;}public int getCreatedBy() {    return createdBy;}public void setCreatedBy(int createdBy) {    this.createdBy = createdBy;}public Date getCreationDate() {    return creationDate;}public void setCreationDate(Date creationDate) {    this.creationDate = creationDate;}public int getModifyBy() {    return modifyBy;}public void setModifyBy(int modifyBy) {    this.modifyBy = modifyBy;}public Date getModifyDate() {    return modifyDate;}public void setModifyDate(Date modifyDate) {    this.modifyDate = modifyDate;}

}

package com.yccz.entity;

import java.util.Date;
//供应商
public class Provider {
private int id;
private String proCode;
private String proName;
private String proDesc;
private String proContact;
private String proPhone;
private String proAddress;
private String proFax;
private int createdBy;
private Date creationDate;
private int modifyBy;
private Date modifyDate;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getProCode() {
return proCode;
}
public void setProCode(String proCode) {
this.proCode = proCode;
}
public String getProName() {
return proName;
}
public void setProName(String proName) {
this.proName = proName;
}
public String getProDesc() {
return proDesc;
}
public void setProDesc(String proDesc) {
this.proDesc = proDesc;
}
public String getProContact() {
return proContact;
}
public void setProContact(String proContact) {
this.proContact = proContact;
}
public String getProPhone() {
return proPhone;
}
public void setProPhone(String proPhone) {
this.proPhone = proPhone;
}
public String getProAddress() {
return proAddress;
}
public void setProAddress(String proAddress) {
this.proAddress = proAddress;
}
public String getProFax() {
return proFax;
}
public void setProFax(String proFax) {
this.proFax = proFax;
}
public int getCreatedBy() {
return createdBy;
}
public void setCreatedBy(int createdBy) {
this.createdBy = createdBy;
}
public Date getCreationDate() {
return creationDate;
}
public void setCreationDate(Date creationDate) {
this.creationDate = creationDate;
}
public int getModifyBy() {
return modifyBy;
}
public void setModifyBy(int modifyBy) {
this.modifyBy = modifyBy;
}
public Date getModifyDate() {
return modifyDate;
}
public void setModifyDate(Date modifyDate) {
this.modifyDate = modifyDate;
}

}

**dao层**

package com.yccz.dao;

import java.util.List;

import com.yccz.entity.Bill;

public interface BillDao {
public List selectAllList(int start,int size);
public int selectAllCount();

public List<Bill> selectByNameList( String productName,String providerId,String isPayment,int start,int size);public int selectByNameCount( String productName,String providerId,String isPayment);public int addBill(Bill bill);public Bill selectById(int id);public int update(Bill bill);public int delete(int id);public String getProviderNameByProId(int proId);

}

package com.yccz.dao.impl;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import com.yccz.dao.BillDao;
import com.yccz.entity.Bill;
import com.yccz.entity.Provider;
import com.yccz.util.BaseDao;

public class BillDaoImpl extends BaseDao implements BillDao {

@Overridepublic List<Bill> selectAllList(int start, int size) {    List<Bill> list = new ArrayList<Bill>();    String sql="select b.billCode,b.productName,b.providerId,b.totalPrice,b.isPayment,b.creationDate,p.proName,b.id from smbms_bill b,smbms_provider p where b.providerId = p.id order by b.id limit ?,?";    ResultSet rs = executeQuery(sql, (start-1)*size,size);    try {        while(rs.next()){            Bill bill = new Bill();            bill.setBillCode(rs.getString(1));            bill.setProductName(rs.getString(2));            bill.setProviderId(rs.getInt(3));            bill.setTotalPrice(rs.getDouble(4));            bill.setIsPayment(rs.getInt(5));            bill.setCreationDate(rs.getTimestamp(6));            bill.setId(rs.getInt(8));            Provider pro = new Provider();            pro.setProName(rs.getString(7));            bill.setProvider(pro);            list.add(bill);        }    } catch (SQLException e) {        e.printStackTrace();    }finally{        closeAll(null, null, rs);    }    return list;}@Overridepublic int selectAllCount() {    int rows = 0;    String sql="select count(b.id) from smbms_bill b,smbms_provider p where b.providerId = p.id order by b.id";    ResultSet rs = executeQuery(sql);    try {        while(rs.next()){            rows = rs.getInt(1);        }    } catch (SQLException e) {        e.printStackTrace();    }finally{        closeAll(null, null, rs);    }    return rows;}@Overridepublic List<Bill> selectByNameList( String productName,String providerId,String isPayment,int start, int size) {        List<Bill> list = new ArrayList<Bill>();        String sql="select b.billCode,b.productName,b.providerId,b.totalPrice,b.isPayment,b.creationDate,p.proName,b.id from smbms_bill b,smbms_provider p where b.providerId = p.id ";        List<Object> obj = new ArrayList<Object>();        //商品名称productName        //供应商id providerId         //是否付款 isPayment        String str = "";        if(productName!=null&&productName.trim().length()>0){            str+=" and productName like ?";            obj.add("%"+productName+"%");        }        if(providerId!=null&&providerId.trim().length()>0&&Integer.parseInt(providerId)>0){            str+=" and providerId=?";            obj.add(providerId);        }if(isPayment!=null&&isPayment.trim().length()>0&&Integer.parseInt(isPayment)>0){            str+=" and isPayment=?";            obj.add(isPayment);        }        obj.add((start-1)*size);        obj.add(size);        sql=sql+str+" limit ?,?";        ResultSet rs = executeQuery(sql, obj.toArray());        try {            while(rs.next()){                Bill bill = new Bill();                bill.setBillCode(rs.getString(1));                bill.setProductName(rs.getString(2));                bill.setProviderId(rs.getInt(3));                bill.setTotalPrice(rs.getDouble(4));                bill.setIsPayment(rs.getInt(5));                bill.setCreationDate(rs.getTimestamp(6));                bill.setId(rs.getInt(8));                Provider pro = new Provider();                pro.setProName(rs.getString(7));                bill.setProvider(pro);                list.add(bill);            }        } catch (SQLException e) {            e.printStackTrace();        }finally{            closeAll(null, null, rs);        }        return list;}@Overridepublic int selectByNameCount(String productName,String providerId,String isPayment) {    int rows=0;    String sql="select count(b.id) from smbms_bill b,smbms_provider p where b.providerId = p.id ";    List<Object> obj = new ArrayList<Object>();    //商品名称productName    //供应商id providerId     //是否付款 isPayment    String str = "";    if(productName!=null&&productName.trim().length()>0){        str+=" and productName like ?";        obj.add("%"+productName+"%");    }    if(providerId!=null&&providerId.trim().length()>0&&Integer.parseInt(providerId)>0){        str+=" and providerId=?";        obj.add(providerId);    }if(isPayment!=null&&isPayment.trim().length()>0&&Integer.parseInt(isPayment)>0){        str+=" and isPayment=?";        obj.add(isPayment);    }    sql=sql+str;    ResultSet rs = executeQuery(sql, obj.toArray());    try {        while(rs.next()){            rows = rs.getInt(1);        }    } catch (SQLException e) {        e.printStackTrace();    }finally{        closeAll(null, null, rs);    }    return rows;}@Overridepublic int addBill(Bill bill) {    String sql = "insert into smbms_bill( billCode,productName,providerId,productCount,totalPrice,isPayment,createdBy,creationDate)  values(?,?,?,?,?,?,?,?)";    int rows = executeUpdate(sql, bill.getBillCode(),bill.getProductName(),bill.getProviderId(),bill.getProductCount(),            bill.getTotalPrice(),bill.getIsPayment(),bill.getCreatedBy(),bill.getCreationDate());    return rows;}@Overridepublic Bill selectById(int id) {    Bill bill = new Bill();    String sql="select b.billCode,b.productName,b.providerId,b.totalPrice,b.isPayment,b.creationDate,p.proName,b.id,b.productUnit,b.productcount from smbms_bill b,smbms_provider p where b.providerId = p.id order by b.id and b.id=?";    ResultSet rs = executeQuery(sql, id);    try {        while(rs.next()){            bill.setBillCode(rs.getString(1));            bill.setProductName(rs.getString(2));            bill.setProviderId(rs.getInt(3));            bill.setTotalPrice(rs.getDouble(4));            bill.setIsPayment(rs.getInt(5));            bill.setCreationDate(rs.getTimestamp(6));            bill.setId(rs.getInt(8));            Provider pro = new Provider();            pro.setProName(rs.getString(7));            bill.setProvider(pro);            bill.setProductUnit(rs.getString(9));            bill.setProductCount(rs.getInt(10));        }    } catch (SQLException e) {        e.printStackTrace();    }finally{        closeAll(null, null, rs);    }    return bill;}@Overridepublic int update(Bill bill) {    String sql = "update smbms_bill set billCode=?,productName=?,providerId=?,productCount=?,totalPrice=?,isPayment=?,modifyBy=?,modifyDate=? where id=?";    int rows = executeUpdate(sql, bill.getBillCode(),bill.getProductName(),bill.getProviderId(),bill.getProductCount(),            bill.getTotalPrice(),bill.getIsPayment(),bill.getModifyBy(),bill.getModifyDate(),bill.getId());    return rows;}@Overridepublic int delete(int id) {    String sql = "delete from smbms_bill where id=?";    int rows = executeUpdate(sql, id);    return rows;}//通过供应商id来查供应商名称@Overridepublic String getProviderNameByProId(int proId) {    String sql = "select proName from smbms_provider where id = ?";    ResultSet rs = executeQuery(sql, proId);    try {        while(rs.next()){            String proName = rs.getString(1);            return proName;        }    } catch (SQLException e) {        e.printStackTrace();    }    return null;}

}

service层，只写出了订单的实现层

package com.yccz.service.impl;

import java.util.List;

import com.yccz.dao.BillDao;
import com.yccz.dao.impl.BillDaoImpl;
import com.yccz.entity.Bill;
import com.yccz.service.BillService;

public class BillServiceImpl implements BillService {
BillDao bd = new BillDaoImpl();
@Override
public List selectAllList(int start, int size) {

    return bd.selectAllList(start, size);}@Overridepublic int selectAllCount() {    return bd.selectAllCount();}@Overridepublic List<Bill> selectByNameList(String productName, String providerId,        String isPayment, int start, int size) {    return bd.selectByNameList(productName, providerId, isPayment, start, size);}@Overridepublic int selectByNameCount(String productName, String providerId,        String isPayment) {    return bd.selectByNameCount(productName, providerId, isPayment);}@Overridepublic int addBill(Bill bill) {    return bd.addBill(bill);}@Overridepublic Bill selectById(int id) {    return bd.selectById(id);}@Overridepublic int update(Bill bill) {    return bd.update(bill);}@Overridepublic int delete(int id) {    return bd.delete(id);}@Overridepublic String getProviderNameByProId(int proId) {    return new BillDaoImpl().getProviderNameByProId(proId);}

}

**Servlet，只列出订单的servlet**

package com.yccz.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.yccz.entity.Bill;
import com.yccz.entity.Provider;
import com.yccz.entity.User;
import com.yccz.service.BillService;
import com.yccz.service.ProviderService;
import com.yccz.service.impl.BillServiceImpl;
import com.yccz.service.impl.ProviderServiceImpl;
import com.yccz.util.BillPage;

public class BillServlet extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)        throws ServletException, IOException {    doPost(request, response);}public void doPost(HttpServletRequest request, HttpServletResponse response)        throws ServletException, IOException {    request.setCharacterEncoding("utf-8");    response.setContentType("text/html;charset=utf-8");    PrintWriter out = response.getWriter();    BillService bs = new BillServiceImpl();    ProviderService ps = new ProviderServiceImpl();    String opr = request.getParameter("opr");    if(opr==null||opr.length()<0){        opr="list";    }    //获取当前页    String currPageNo = request.getParameter("currPageNo");    if(currPageNo==null||currPageNo.length()<0){        currPageNo = "1";    }    if("list".equals(opr)){//查询全部        int totalCount = bs.selectAllCount();        BillPage bp = new BillPage();        bp.setCurrPageNo(Integer.parseInt(currPageNo));        bp.setTotalCount(totalCount);        ProviderService providerService = new ProviderServiceImpl();        List<Provider> prolist = providerService.selectAll();        List<Bill> list = bs.selectAllList(bp.getCurrPageNo(), bp.getPageSize());        request.setAttribute("list", list);        request.setAttribute("prolist", prolist);        request.setAttribute("currPageNo", currPageNo);        request.setAttribute("totalPageCount", bp.getTotalPageCount());        request.getRequestDispatcher("jsp/billlist.jsp").forward(request, response);    }else if("query".equals(opr)){//条件查询        ProviderService providerService = new ProviderServiceImpl();        List<Provider> prolist = providerService.selectAll();        String queryProductName = request.getParameter("queryProductName");        String queryProviderId = request.getParameter("queryProviderId");        String queryIsPayment = request.getParameter("queryIsPayment");        int totalCount = bs.selectByNameCount(queryProductName, queryProviderId, queryIsPayment);        BillPage bp = new BillPage();        bp.setCurrPageNo(Integer.parseInt(currPageNo));        bp.setTotalCount(totalCount);        List<Bill> list = bs.selectByNameList(queryProductName, queryProviderId, queryIsPayment,bp.getCurrPageNo(), bp.getPageSize());        request.setAttribute("prolist", prolist);        request.setAttribute("list", list);        request.setAttribute("currPageNo", currPageNo);        request.setAttribute("totalPageCount", bp.getTotalPageCount());        request.setAttribute("queryProductName", queryProductName);        request.setAttribute("queryProviderId", queryProviderId);        request.setAttribute("queryIsPayment", queryIsPayment);        request.getRequestDispatcher("jsp/billlist.jsp").forward(request, response);    }else if("queryPro".equals(opr)){        List<Provider > list =  ps.selectAll();        request.setAttribute("list", list);        request.getRequestDispatcher("jsp/billadd.jsp").forward(request, response);    }else if("add".equals(opr)){        String billcode = request.getParameter("billcode");        String productname = request.getParameter("productname");        String productunit = request.getParameter("productunit");        String productcount = request.getParameter("productcount");        int productCount = 0;        if(productcount!=null&&productcount.length()>0){            productCount = Integer.parseInt(productcount);        }        String totalprice = request.getParameter("totalprice");        double totalPrice=0;        int providerId=0;        int isPayment = 0;        if(totalprice!=null&&totalprice.length()>0){            totalPrice=Double.parseDouble(totalprice);        }        String providerid = request.getParameter("providerid");        if(providerid!=null&&providerid.length()>0){            providerId = Integer.parseInt(providerid);        }        String ispayment  = request.getParameter("ispayment");        if(ispayment!=null&&ispayment.length()>0){            isPayment = Integer.parseInt(ispayment);        }        Bill bill = new Bill();        bill.setBillCode(billcode);        bill.setProductName(productname);        bill.setProductUnit(productunit);        bill.setProductCount(productCount);        bill.setTotalPrice(totalPrice);        bill.setProviderId(providerId);        bill.setIsPayment(isPayment);        User user = (User)request.getSession().getAttribute("user");        bill.setCreatedBy(user.getId());        bill.setCreationDate(new Date());        int rows = bs.addBill(bill);        if(rows>0){        out.print("<script>alert('订单添加成功')"                + ";location.href='jsp/billlist.jsp'"                + "</script>");        }        else{            out.print("<script>alert('订单添加失败')"                    + ";history.back()"                    + "</script>");        }    }else if("queryById".equals(opr)){        String id=request.getParameter("id");        String method = request.getParameter("method");        Bill bill = bs.selectById(Integer.parseInt(id));        String proName = bs.getProviderNameByProId(bill.getId());        bill.setProviderName(proName);        request.setAttribute("bill", bill);        if(method.equals("update")){            ProviderService providerService = new ProviderServiceImpl();            List<Provider> prolist = providerService.selectAll();            request.setAttribute("prolist", prolist);            request.getRequestDispatcher("jsp/billmodify.jsp").forward(request, response);        }else if(method.equals("query")){            request.getRequestDispatcher("jsp/billview.jsp").forward(request, response);            }    }else if("update".equals(opr)){        String id=request.getParameter("id");        String billcode = request.getParameter("billcode");        String productname = request.getParameter("productname");        String productunit = request.getParameter("productunit");        String productcount = request.getParameter("productcount");        int productCount = 0;        if(productcount!=null&&productcount.length()>0){            productCount = Integer.parseInt(productcount);        }        String totalprice = request.getParameter("totalprice");        double totalPrice=0;        int providerId=0;        int isPayment = 0;        if(totalprice!=null&&totalprice.length()>0){            totalPrice=Double.parseDouble(totalprice);        }        String providerid = request.getParameter("providerid");        if(providerid!=null&&providerid.length()>0){            providerId = Integer.parseInt(providerid);        }        String ispayment  = request.getParameter("ispayment");        if(ispayment!=null&&ispayment.length()>0){            isPayment = Integer.parseInt(ispayment);        }        Bill bill = new Bill();        bill.setId(Integer.parseInt(id));        bill.setBillCode(billcode);        bill.setProductName(productname);        bill.setProductUnit(productunit);        bill.setProductCount(productCount);        bill.setTotalPrice(totalPrice);        bill.setProviderId(providerId);        bill.setIsPayment(isPayment);        User user = (User)request.getSession().getAttribute("user");        bill.setModifyBy(user.getId());        bill.setModifyDate(new Date());        int rows = bs.update(bill);        if(rows>0){        out.print("<script>alert('订单修改成功')"                + ";location.href='BillServlet'"                + "</script>");        }        else{            out.print("<script>alert('订单修改失败')"                    + ";history.back()"                    + "</script>");        }    }else if("delete".equals(opr)){        String id = request.getParameter("id");        int rows = bs.delete(Integer.parseInt(id.trim()));        System.out.println("受影响行数"+rows);        if(rows>0){        out.print("<script>alert('订单删除成功')"                + ";location.href='BillServlet'"                + "</script>");        }        else{            out.print("<script>alert('订单删除失败')"                    + ";history.back()"                    + "</script>");        }    }else{    }    out.flush();    out.close();}

}

**util包（工具类）**

package com.yccz.util;

import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

import javax.annotation.Resource;
/**
*
* @ClassName: BaseDao
* @Description: 数据库工具类
* @author 志辉
* @date 2017年10月11日
*/
public class BaseDao {
private Connection conn = null;
private static Properties props=null;
private static String driver;
private static String url;
private static String user;
private static String password;
static{
InputStream is = BaseDao.class.getClassLoader().getResourceAsStream(“database.properties”);
if(is==null)
throw new RuntimeException(“找不到数据库参数配置文件”);

        props = new Properties();        try{            props.load(is);            driver = props.getProperty("driver");            url = props.getProperty("url");            user = props.getProperty("user");            password = props.getProperty("password");        }catch (IOException e) {            throw new RuntimeException("数据库配置参数加载错误！", e);        } finally {            try {                is.close();            } catch (IOException e) {                e.printStackTrace();            }        }}public Connection getConnection(){    try {        Class.forName(driver);//加载驱动        conn = DriverManager.getConnection(url, user, password);    } catch (ClassNotFoundException e) {        e.printStackTrace();    } catch (SQLException e) {        e.printStackTrace();    }    return conn;}/** * 关闭数据库连接。 *  * @param conn *            数据库连接 * @param stmt *            Statement对象 * @param rs *            结果集 */public void closeAll(Connection conn, Statement stmt, ResultSet rs) {    // 若结果集对象不为空，则关闭    try {        if (rs != null && !rs.isClosed()){              rs.close();        }    } catch (Exception e) {        e.printStackTrace();    }    // 若Statement对象不为空，则关闭    try {        if (stmt != null && !stmt.isClosed())            stmt.close();    } catch (Exception e) {        e.printStackTrace();    }    // 若数据库连接对象不为空，则关闭    try {        if (conn != null && !conn.isClosed())            conn.close();    } catch (Exception e) {        e.printStackTrace();    }}/** * 增、删、改操作 *  * @param sql *            sql语句 * @param prams *            参数数组 * @return 执行结果 */protected int executeUpdate(String sql, Object... params) {    int result = 0;    conn = this.getConnection();    PreparedStatement pstmt = null;    try {        pstmt = conn.prepareStatement(sql);        for (int i = 0; i < params.length; i++) {            pstmt.setObject(i + 1, params[i]);        }        result = pstmt.executeUpdate();    } catch (SQLException e) {        e.printStackTrace();    } finally {        closeAll(null, pstmt, null);    }    return result;}/** * 查询操作 *  * @param sql *            sql语句 * @param params *            参数数组 * @return 查询结果集 */protected ResultSet executeQuery(String sql, Object... params) {    conn = this.getConnection();    PreparedStatement pstmt = null;    ResultSet rs = null;    System.out.println(sql);    try {        pstmt = conn.prepareStatement(sql);        for (int i = 0; i < params.length; i++) {            pstmt.setObject(i + 1, params[i]);            System.out.println(params[i]);        }        rs = pstmt.executeQuery();    } catch (SQLException e) {        e.printStackTrace();    }    return rs;}

}

package com.yccz.util;

import java.util.List;

import com.yccz.entity.Bill;

/**
*
* @ClassName: BillPage
* @Description: 分页的工具类
* @author 志辉
* @date 2017年10月11日
*/
public class BillPage {
// 总页数
private int totalPageCount = 0;
// 页面大小，即每页显示记录数
private int pageSize = 5;
// 记录总数
private int totalCount;
// 当前页码
private int currPageNo = 1;
// 每页新闻集合
private List billList;

public int getCurrPageNo() {    return currPageNo;}public void setCurrPageNo(int currPageNo) {    if (currPageNo > 0)        this.currPageNo = currPageNo; }public int getPageSize() {    return pageSize;}public void setPageSize(int pageSize) {    if (pageSize > 0)        this.pageSize = pageSize;}public int getTotalCount() {    return totalCount;}public void setTotalCount(int totalCount) {//总记录60条数据  页面大小 5条    if (totalCount > 0) {        this.totalCount = totalCount;        // 计算总页数        this.totalPageCount = this.totalCount % pageSize == 0 ? (this.totalCount / pageSize)                : (this.totalCount / pageSize + 1);        if(currPageNo>totalPageCount)            this.currPageNo = totalPageCount;    }}public int getTotalPageCount() {    return totalPageCount;}public void setTotalPageCount(int totalPageCount) {    this.totalPageCount = totalPageCount;}public List<Bill> getBillList() {    return billList;}public void setBillList(List<Bill> billList) {    this.billList = billList;}

}

**jsp**

billlist.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"    pageEncoding="UTF-8"%><%@include file="./common/head.jsp"%><%@taglib uri="http://java.sun.com/jsp/jstl/core"  prefix="c"%><div class="right">       <div class="location">           <strong>你现在所在的位置是:</strong>           <span>订单管理页面</span>       </div>       <div class="search">       <form method="get" action="BillServlet">            <input name="opr" value="query" class="input-text" type="hidden">            <span>商品名称：</span>            <input name="queryProductName" type="text" value="">            <span>供应商：</span>            <select name="queryProviderId">                   <option value="0">--请选择--</option>                   <c:forEach items="${prolist }" var="pro">                   <option value=${pro.id}>${pro.proName}</option>                   </c:forEach>            </select>            <span>是否付款：</span>            <select name="queryIsPayment">                <option value="0">--请选择--</option>                <option value="1">未付款</option>                <option value="2" >已付款</option>            </select>             <input type="hidden" name="pageIndex" value="1"/>             <input value="查 询" type="submit" id="searchbutton">             <a href="BillServlet?opr=queryPro">添加订单</a>        </form>       </div>       <!--账单表格 样式和供应商公用-->      <table class="providerTable" cellpadding="0" cellspacing="0">          <tr class="firstTr">              <th width="10%">订单编码</th>              <th width="20%">商品名称</th>              <th width="10%">供应商</th>              <th width="10%">订单金额</th>              <th width="10%">是否付款</th>              <th width="10%">创建时间</th>              <th width="30%">操作</th>          </tr>          <c:forEach items="${list }" var="bill">                <tr>                    <td>                        <span>${bill.billCode }</span>                    </td>                    <td>                        <span>${bill.productName }</span>                    </td>                    <td>                        <span>${bill.provider.proName }</span>                    </td>                    <td>                        <span>${bill.totalPrice }</span>                    </td>                    <!-- 显示是否付款 -->                    <td>                        <span>                            <c:choose>                                <c:when test="${bill.isPayment eq 2}">                                    已付款                                </c:when>                                <c:otherwise>                                    未付款                                </c:otherwise>                            </c:choose>                        </span>                    </td>                    <!-- 创建时间 -->                    <td>                        <span>                            ${bill.creationDate }                        </span>                    </td>                    <td>                        <span><a class="viewBill" href="BillServlet?opr=queryById&id=${bill.id }&method=query" ><img src="/SupermarketSys/statics/images/read.png" alt="查看" title="查看"/></a></span>                        <span><a class="modifyBill" href="BillServlet?opr=queryById&id=${bill.id }&method=update"><img src="/SupermarketSys/statics/images/xiugai.png" alt="修改" title="修改"/></a></span>                        <%-- <span><a class="deleteBill" href="javascript:confirm('确认删除?')?BillServlet?opr=delete&id=${bill.id }:history.back()"><img src="/SupermarketSys/statics/images/schu.png" alt="删除" title="删除"/></a></span> --%>                        <span><a class="deleteBill" href="BillServlet?opr=delete&id=${bill.id }"><img src="/SupermarketSys/statics/images/schu.png" alt="删除" title="删除"/></a></span>                    </td>                </tr>            </c:forEach>      </table>        <p align="center">               当前页数:[${currPageNo }/${totalPageCount }]&nbsp;                <c:choose>                <c:when test="${empty queryProductName and empty queryProviderId and empty queryIsPayment }">                      <c:if test="${currPageNo >1}">                        <a href="BillServlet?opr=list&currPageNo=1">首页</a>                        <a href="BillServlet?opr=list&currPageNo=${currPageNo-1}">上一页</a>                      </c:if>                      <c:if test="${currPageNo ne totalPageCount }">                           <a href="BillServlet?opr=list&currPageNo=${currPageNo+1}">下一页</a>                        <a href="BillServlet?opr=list&currPageNo=${totalPageCount}">末页</a>                    </c:if>                </c:when>                <c:otherwise>                     <c:if test="${currPageNo >1}">                        <a href="BillServlet?opr=query&queryProductName=${queryProductName }&queryProviderId=${queryProviderId }&queryIsPayment=${queryIsPayment }&currPageNo=1">首页</a>                        <a href="BillServlet?opr=query&queryProductName=${queryProductName }&queryProviderId=${queryProviderId }&queryIsPayment=${queryIsPayment }&currPageNo=${currPageNo-1}">上一页</a>                      </c:if>                      <c:if test="${currPageNo ne totalPageCount }">                           <a href="BillServlet?opr=query&queryProductName=${queryProductName }&queryProviderId=${queryProviderId }&queryIsPayment=${queryIsPayment }&currPageNo=${currPageNo+1}">下一页</a>                        <a href="BillServlet?opr=query&queryProductName=${queryProductName }&queryProviderId=${queryProviderId }&queryIsPayment=${queryIsPayment }&currPageNo=${totalPageCount}">末页</a>                      </c:if>                </c:otherwise>              </c:choose>             <%--  <c:if test="${currPageNo >1}">                <a href="BillServlet?opr=list&currPageNo=1">首页</a>                <a href="BillServlet?opr=list&currPageNo=${currPageNo-1}">上一页</a>              </c:if>              <c:if test="${currPageNo ne totalPageCount }">                   <a href="BillServlet?opr=list&currPageNo=${currPageNo+1}">下一页</a>                <a href="BillServlet?opr=list&currPageNo=${totalPageCount}">末页</a>              </c:if> --%>          </p>   </div></section><!--点击删除按钮后弹出的页面--><div class="zhezhao"></div><div class="remove" id="removeBi">    <div class="removerChid">        <h2>提示</h2>        <div class="removeMain">            <p>你确定要删除该订单吗？</p>            <a href="#" id="yes">确定</a>            <a href="#" id="no">取消</a>        </div>    </div></div><%@include file="./common/foot.jsp" %><script type="text/javascript" src="statics/js/billlist.js"></script>

billadd.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"    pageEncoding="UTF-8"%><%@include file="./common/head.jsp"%><%@taglib uri="http://java.sun.com/jsp/jstl/core"  prefix="c"%><div class="right">     <div class="location">         <strong>你现在所在的位置是:</strong>         <span>订单管理页面 >> 订单添加页面</span>     </div>\     <script type="text/javascript">     </script>     <div class="providerAdd">         <form id="billForm" name="billForm" method="post" action="BillServlet">             <!--div的class 为error是验证错误，ok是验证成功-->             <input type="hidden" name="opr" value="add">             <div class="">                 <label for="billCode" >订单编码：</label>                 <input type="text" name="billcode" class="text" id="billCode" value="">                  <!-- 放置提示信息 -->                 <font color="red"></font>             </div>             <div>                 <label for="productName">商品名称：</label>                 <input type="text" name="productname" id="productName" value="">                  <font color="red"></font>             </div>             <div>                 <label for="productUnit">商品单位：</label>                 <input type="text" name="productunit" id="productUnit" value="">                  <font color="red"></font>             </div>             <div>                 <label for="productCount">商品数量：</label>                 <input type="text" name="productcount" id="productCount" value="">                  <font color="red"></font>             </div>             <div>                 <label for="totalPrice">总金额：</label>                 <input type="text" name="totalprice" id="totalPrice" value="">                  <font color="red"></font>             </div>             <div>                 <label >供应商：</label>                 <select name="providerid" id="providerId">                    <c:forEach items="${list }" var="pro">                        <option value="${pro.id }">${pro.proName }</option>                   </c:forEach>                 </select>                 <font color="red"></font>             </div>             <div>                 <label >是否付款：</label>                 <input type="radio" name="ispayment" value="1" checked="checked">未付款                 <input type="radio" name="ispayment" value="2" >已付款             </div>             <div class="providerAddBtn">                  <input type="button" name="add" id="add" value="保存">                  <input type="button" id="back" name="back" value="返回" >             </div>         </form>     </div> </div></section><%@include file="./common/foot.jsp" %><script type="text/javascript" src="statics/js/billadd.js"></script>

billmodify.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"    pageEncoding="UTF-8"%><%@include file="./common/head.jsp"%><%@taglib uri="http://java.sun.com/jsp/jstl/core"  prefix="c"%><div class="right">        <div class="location">            <strong>你现在所在的位置是:</strong>            <span>订单管理页面 >> 订单添加页面</span>        </div>        <div class="providerAdd">          <form id="billForm" name="billForm" method="post" action="BillServlet">                <input type="hidden" name="opr" value="update">                <input type="hidden" name="id" value="${bill.id }">                <!--div的class 为error是验证错误，ok是验证成功-->                <div class="">                    <label for="billCode">订单编码：</label>                    <input type="text" name="billcode" id="billCode" value="${bill.billCode }" readonly="readonly">                 </div>                <div>                    <label for="productName">商品名称：</label>                    <input type="text" name="productname" id="productName" value="${bill.productName }">                     <font color="red"></font>                </div>                <div>                    <label for="productUnit">商品单位：</label>                    <input type="text" name="productunit" id="productUnit" value="${bill.productUnit }">                     <font color="red"></font>                </div>                <div>                    <label for="productCount">商品数量：</label>                    <input type="text" name="productcount" id="productCount" value="${bill.productCount }">                     <font color="red"></font>                </div>                <div>                    <label for="totalPrice">总金额：</label>                    <input type="text" name="totalprice" id="totalPrice" value="${bill.totalPrice }">                     <font color="red"></font>                </div>                <div>                    <label for="providerId">供应商：</label>                    <input type="hidden" value="" id="pid" />                    <select name="providerid" id="providerId">                        <option value="${bill.providerId }">${bill.provider.proName }</option>                        <c:forEach items="${prolist }" var="pro">                            <option value=${pro.id}>${pro.proName}</option>                        </c:forEach>                    </select>                    <font color="red"></font>                </div>                <div>                    <label >是否付款：</label>                     <c:if test="${bill.isPayment == 1 }">                        <input type="radio" name="ispayment" value="1" checked="checked">未付款                        <input type="radio" name="ispayment" value="2" >已付款                    </c:if>                    <c:if test="${bill.isPayment == 2 }">                        <input type="radio" name="ispayment" value="1">未付款                        <input type="radio" name="ispayment" value="2" checked="checked">已付款                    </c:if>                 </div>                <div class="providerAddBtn">                  <input type="button" name="save" id="save" value="保存">                  <input type="button" id="back" name="back" value="返回" >                </div>            </form>        </div>    </div></section><%@include file="./common/foot.jsp" %><script type="text/javascript" src="statics/js/billmodify.js"></script>

billview.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"    pageEncoding="UTF-8"%><%@include file="./common/head.jsp"%><%@taglib uri="http://java.sun.com/jsp/jstl/core"  prefix="c"%><div class="right">     <div class="location">         <strong>你现在所在的位置是:</strong>         <span>订单管理页面 >> 信息查看</span>     </div>     <div class="providerView">         <p><strong>订单编号：</strong><span>${bill.billCode }</span></p>         <p><strong>商品名称：</strong><span>${bill.productName}</span></p>         <p><strong>商品单位：</strong><span>${bill.productUnit }</span></p>         <p><strong>商品数量：</strong><span>${bill.productCount }</span></p>         <p><strong>总金额：</strong><span>${bill.totalPrice }</span></p>         <p><strong>供应商：</strong><span>${bill.providerName }</span></p>         <p><strong>是否付款：</strong>            <span>                <c:if test="${bill.isPayment == 1}">未付款</c:if>                <c:if test="${bill.isPayment == 2}">已付款</c:if>            </span>        </p>        <div class="providerAddBtn">            <input type="button" id="back" name="back" value="返回" >        </div>     </div> </div></section><%@include file="./common/foot.jsp" %><script type="text/javascript" src="statics/js/billview.js"></script>

web.xml配置

<?xml version="1.0" encoding="UTF-8"?><web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0">  <display-name>SuperMarketSys</display-name>  <servlet>    <description>This is the description of my J2EE component</description>    <display-name>This is the display name of my J2EE component</display-name>    <servlet-name>LoginServlet</servlet-name>    <servlet-class>com.yccz.servlet.LoginServlet</servlet-class>  </servlet>  <servlet>    <description>This is the description of my J2EE component</description>    <display-name>This is the display name of my J2EE component</display-name>    <servlet-name>BillServlet</servlet-name>    <servlet-class>com.yccz.servlet.BillServlet</servlet-class>  </servlet>  <servlet-mapping>    <servlet-name>LoginServlet</servlet-name>    <url-pattern>/LoginServlet</url-pattern>  </servlet-mapping>  <servlet-mapping>    <servlet-name>BillServlet</servlet-name>    <url-pattern>/BillServlet</url-pattern>  </servlet-mapping>    <servlet-mapping>    <servlet-name>UserServlet</servlet-name>    <url-pattern>/UserServlet</url-pattern>  </servlet-mapping>  <welcome-file-list>    <welcome-file>index.html</welcome-file>    <welcome-file>index.htm</welcome-file>    <welcome-file>index.jsp</welcome-file>    <welcome-file>default.html</welcome-file>    <welcome-file>default.htm</welcome-file>    <welcome-file>default.jsp</welcome-file>  </welcome-file-list></web-app>