汽车销售系统毕业论文 - 图文

华北水利水电学院毕业论文

5.4.3 界面风格

员工表输入员工编号和密码判断失败error.jsp成功index.jsp员工表输入员工编号和密码判断失败error.jsp成功index.jsp

5.4.4 代码实现（部分）

DAO实现方法:

package com.csms.sale.dao.impl;

import java.sql.SQLException; import java.util.HashMap;

- 41 -

华北水利水电学院毕业论文

import java.util.List; import java.util.Map;

import com.csms.power.bean.StaffDTO; import com.csms.sale.bean.ClientDTO; import com.csms.sale.bean.OrderListDTO; import com.csms.sale.dao.OrderListDAO; import com.csms.stock.bean.CarDTO;

import com.softstone.mvc.dao.DAOFactory; import com.softstone.mvc.dao.DaoSupport; import com.softstone.mvc.dao.DefaultParams; import com.softstone.mvc.model.Paging;

public class OrderListDaoImpl extends DaoSupport implements OrderListDAO {

private static final String SQL_insert=\into orderList_table(cliCard,staId,carType,carPrice,carSum,orderTime,orderEst) values(?,?,?,?,?,?,?)\

private static final String SQL_select=\ private static final String SQL_selectById=\orderId,engineId,cliCard,staId,carType,carPrice,carSum,orderTime,orderEst from orderList_table where orderId=?\

private static final String SQL_update=\orderList_table set cliCard=?,carType=?,carPrice=?,carSum=?,orderTime=?,orderEst=? where orderId=?\

private static final String SQL_selStaId=\ private static final String SQL_selCarType=\car_table\

private static final String SQL_selectEST=\where orderEst=?\

private static final String SQL_selectSum=\where orderEst='0' and carType=?\ private String SQL_FINDPRICE = \carType,carPrice from car_table where carType='\

public static final String SQL=\orderEst='0'\

public List SQL(Paging Paging){

try {

return this.queryForList(SQL, OrderListDTO.class,paging); } catch (SQLException e) { e.printStackTrace();

- 42 -

华北水利水电学院毕业论文

}

return null; }

public int insert(OrderListDTO orderList){ int ret = 0; try {

DefaultParams params=new DefaultParams();

params.addParam(orderList.getCliCard()); params.addParam(orderList.getStaId()); params.addParam(orderList.getCarType()); params.addParam(orderList.getCarPrice()); params.addParam(orderList.getCarSum()); params.addParam(orderList.getOrderTime()); params.addParam(orderList.getOrderEst());

ret=this.execute(SQL_insert, params); } catch (SQLException e) { e.printStackTrace(); }

return ret; }

//不分页显示所有订单信息

public List list() { try {

return this.queryForList(SQL_select, OrderListDTO.class); } catch (SQLException e) { e.printStackTrace(); }

return null; }

//分页显示所有订单信息

public List listByPaging(Paging paging) { try {

return this.queryForList(SQL_select, OrderListDTO.class,paging); } catch (SQLException e) { e.printStackTrace(); }

return null; }

- 43 -

华北水利水电学院毕业论文

public List listPaging(Paging paging,OrderListDTO dto) { try {

DefaultParams params=new DefaultParams(); params.addParam(dto.getOrderEst()); return

this.queryForList(SQL_selectEST,params,OrderListDTO.class,paging); } catch (SQLException e) { e.printStackTrace(); }

return null; }

public int update(OrderListDTO orderList) { int ret = 0; try {

DefaultParams params=new DefaultParams();

params.addParam(orderList.getCliCard()); params.addParam(orderList.getCarType()); params.addParam(orderList.getCarPrice()); params.addParam(orderList.getCarSum()); params.addParam(orderList.getOrderTime()); params.addParam(orderList.getOrderEst()); params.addParam(orderList.getOrderId());

ret=this.execute(SQL_update, params); System.out.println(\ } catch (SQLException e) { e.printStackTrace(); }

return ret; }

//根据订单的Id查询所有订单

public OrderListDTO queryById(OrderListDTO dto) { try {

dto=this.get(SQL_selectById, dto.getOrderId(), dto.getClass()); } catch (SQLException e) { e.printStackTrace(); }

return dto; }

- 44 -