每天记录学习，每天会有好心情。*^_^*
今天记录的项目是基于web的工艺品销售平台，面对市场日益加剧的竞争环境,我国工艺品企业加快发展电子商务和信息化步伐是必然走势,这将有利于企业增加外贸渠道,降低交易成本,简化商务过程和缩短生产周期。采用当前非常流行的B/S体系结构,以JSP作为开发技术,主要依赖SSM技术框架，mysql数据库建立本系统。
做基于web的工艺品销售平台的时候，我们需要用到SSM(MYECLIPSE)框架，开发工具选用最拿手的MYECLIPSE。
基于web的工艺品销售平台项目是一个 后台项目。
开发系统时，需求分析是必不可少的一个环节。基于web的工艺品销售平台拥有的登录角色包括了管理员。
每个账号设置身份、账号、密码是必不可少的，管理员中都包含这些登录角色该有的字段。
在系统的功能中，订单是一个重要的表。这个表使得产品关联了起来。在订单表中订单的名字与产品的mingzi字段对应、订单的价格与产品的jiage字段对应
，他们拥有关联关系。
总结得出基于web的工艺品销售平台项目所有数据为：管理员(admin)、用户(yonghu)、产品(chanpin)、订单(dingdan)、运输(yunshu)
基于web的工艺品销售平台之管理员表
字段名 | 类型 | 属性 | 描述id | INT(11) | PRIMARY KEY | 管理员idusername | VARCHAR(255) | | 账号password | VARCHAR(255) | | 密码quanxian | VARCHAR(255) | | 权限
基于web的工艺品销售平台之用户表
字段名 | 类型 | 属性 | 描述id | INT(11) | PRIMARY KEY | 用户idxingming | VARCHAR(255) | | 姓名nianling | VARCHAR(255) | | 年龄xingbie | VARCHAR(255) | | 性别username | VARCHAR(255) | | 账号password | VARCHAR(255) | | 密码
基于web的工艺品销售平台之产品表
字段名 | 类型 | 属性 | 描述id | INT(11) | PRIMARY KEY | 产品idzhonglei | VARCHAR(255) | | 种类guige | VARCHAR(255) | | 规格jiage | VARCHAR(255) | | 价格shuliang | VARCHAR(255) | | 数量mingzi | VARCHAR(255) | | 名字jieshao | VARCHAR(255) | | 介绍
基于web的工艺品销售平台之订单表
字段名 | 类型 | 属性 | 描述id | INT(11) | PRIMARY KEY | 订单idmingzi | VARCHAR(255) | | 名字jiage | VARCHAR(255) | | 价格shuliang | VARCHAR(255) | | 数量dizhi | VARCHAR(255) | | 地址xingming | VARCHAR(255) | | 姓名lianxifangshi | VARCHAR(255) | | 联系方式
基于web的工艺品销售平台之运输表
字段名 | 类型 | 属性 | 描述id | INT(11) | PRIMARY KEY | 运输idshifadi | VARCHAR(255) | | 始发地tujing | VARCHAR(255) | | 途径shijian | VARCHAR(255) | | 时间
package org.mypro.front;import java.io.File;import java.io.IOException;import java.math.BigDecimal;import java.text.SimpleDateFormat;import java.util.ArrayList;import java.util.Calendar;import java.util.Collections;import java.util.Date;import java.util.List;import javax.jms.Session;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.servlet.http.HttpSession;import org.apache.commons.lang3.StringUtils;import org.apache.commons.logging.Log;import org.apache.commons.logging.LogFactory;import org.mypro.dao.DingdanMapper;import org.mypro.entity.Dingdan;import org.mypro.entity.DingdanExample;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Controller;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RequestMethod;import org.springframework.web.multipart.MultipartFile;@Controller@RequestMapping(value = "/")public class DingdanController {private static final Log logger = LogFactory.getLog(DingdanController.class);@Autowiredprivate DingdanMapper dingdandao;//定义方法tianjiadingdan,响应页面tianjiadingdan请求@RequestMapping(value = "tianjiadingdan")public String tianjiadingdan(HttpServletRequest request, HttpServletResponse response,HttpSession session,String backurl) {logger.debug("DingdanController.tianjiadingdan ......");if(backurl != null && backurl.indexOf("tianjiadingdan.action") == -1){return "forward:/" + backurl; }return "tianjiadingdan";}@RequestMapping(value = "tianjiadingdanact")public String tianjiadingdanact(HttpServletRequest request,HttpSession session, HttpServletResponse response,Dingdan dingdan,String backurl) throws IOException {logger.debug("DingdanController.tianjiadingdanact ......");dingdandao.insert(dingdan);request.setAttribute("message", "添加订单成功");if(backurl != null && backurl.indexOf("tianjiadingdanact.action") == -1){return "forward:/" + backurl; }//返回tianjiadingdan方法return "forward:/tianjiadingdan.action";}//定义dingdanguanli方法响应页面请求@RequestMapping(value = "dingdanguanli")public String dingdanguanli(HttpServletRequest request,HttpSession session, HttpServletResponse response,String backurl) {logger.debug("DingdanController.dingdanguanli ......");DingdanExample example = new DingdanExample();List dingdanall = dingdandao.selectByExample(example);request.setAttribute("dingdanall", dingdanall);if(backurl != null && backurl.indexOf("dingdanguanli.action") == -1){return "forward:/" + backurl; }return "dingdanguanli";}// 定义 dingdanchakan方法@RequestMapping(value = "dingdanchakan")public String dingdanchakan(HttpServletRequest request,HttpSession session, HttpServletResponse response,String backurl) {logger.debug("DingdanController.dingdanchakan ......");DingdanExample example = new DingdanExample();List dingdanall = dingdandao.selectByExample(example);request.setAttribute("dingdanall", dingdanall);if(backurl != null && backurl.indexOf("dingdanchakan.action") == -1){return "forward:/" + backurl; }return "dingdanchakan";}// 定义 xiugaidingdan方法@RequestMapping(value = "xiugaidingdan")public String xiugaidingdan(HttpServletRequest request, HttpServletResponse response,HttpSession session,int id,String backurl){logger.debug("DingdanController.xiugaidingdan ......");Dingdan dingdan = dingdandao.selectByPrimaryKey(id);request.setAttribute("dingdan", dingdan);if(backurl != null && backurl.indexOf("xiugaidingdan.action") == -1){return "forward:/" + backurl; }return "xiugaidingdan";}// 定义xiugaidingdanact处理订单修改@RequestMapping(value = "xiugaidingdanact")public String xiugaidingdanact(HttpServletRequest request, HttpServletResponse response,Dingdan dingdan,HttpSession session,String backurl) throws IOException {logger.debug("DingdanController.xiugaidingdanact ......");dingdandao.updateByPrimaryKeySelective(dingdan);request.setAttribute("message", "修改订单信息成功");if(backurl != null && backurl.indexOf("xiugaidingdanact.action") == -1){return "forward:/" + backurl; }return "forward:/dingdanguanli.action";}// 定义shanchudingdan,处理删除订单@RequestMapping(value = "shanchudingdan")public String shanchudingdan(HttpServletRequest request, HttpServletResponse response,HttpSession session,int id,String backurl){logger.debug("DingdanController.shanchudingdan ......");dingdandao.deleteByPrimaryKey(id);request.setAttribute("message", "删除订单成功");if(backurl != null && backurl.indexOf("shanchudingdan.action") == -1){return "forward:/" + backurl; }return "forward:/dingdanguanli.action";}// 定义sousuodingdan方法，处理搜索操作@RequestMapping(value = "sousuodingdan")public String sousuodingdan(HttpServletRequest request, HttpServletResponse response,HttpSession session,String search,String backurl) {logger.debug("DingdanController.sousuodingdan ......");DingdanExample example = new DingdanExample();DingdanExample.Criteria criteria = example.createCriteria();if(search != null){criteria.andMingziLike("%" + search + "%");}List dingdanall = dingdandao.selectByExample(example);request.setAttribute("dingdanall", dingdanall);if(backurl != null && backurl.indexOf("sousuodingdan.action") == -1){return "forward:/" + backurl; }return "sousuodingdan";}// 定义DingdanpinglunMapper@RequestMapping(value = "dingdanxiangqing")public String dingdanxiangqing(HttpServletRequest request,HttpSession session, HttpServletResponse response,int id,String backurl) {logger.debug("DingdanController.dingdanxiangqing ......");Dingdan dingdan = dingdandao.selectByPrimaryKey(id);request.setAttribute("dingdan", dingdan);if(backurl != null && backurl.indexOf("dingdanxiangqing.action") == -1){return "forward:/" + backurl; }return "dingdanxiangqing";}// 上传文件图片等public String uploadUtile(MultipartFile file, HttpServletRequest request) throws IOException {// 根据当前时间生成时间字符串SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmmssSS");String res = sdf.format(new Date());// uploads文件夹位置String rootPath = request.getSession().getServletContext().getRealPath("resource/uploads/");// 原始名称String originalFileName = file.getOriginalFilename();// 新文件名String newFileName = "sliver" + res + originalFileName.substring(originalFileName.lastIndexOf("."));// 创建年月文件夹Calendar date = Calendar.getInstance();File dateDirs = new File(date.get(Calendar.YEAR) + File.separator + (date.get(Calendar.MONTH)+1));// 新文件File newFile = new File(rootPath + File.separator + dateDirs + File.separator + newFileName);// 判断目标文件所在目录是否存在if( !newFile.getParentFile().exists()) {// 如果目标文件所在的目录不存在，则创建父目录newFile.getParentFile().mkdirs();}System.out.println(newFile);// 将内存中的数据写入磁盘file.transferTo(newFile);// 完整的urlString fileUrl = date.get(Calendar.YEAR) + "/" + (date.get(Calendar.MONTH)+1) + "/" + newFileName;return fileUrl;}}
