登录
首页 >  数据库 >  MySQL

ssm搭建拍卖系统

来源:SegmentFault

时间:2023-02-16 15:43:56 102浏览 收藏

怎么入门数据库编程?需要学习哪些知识点?这是新手们刚接触编程时常见的问题;下面golang学习网就来给大家整理分享一些知识点,希望能够给初学者一些帮助。本篇文章就来介绍《ssm搭建拍卖系统》,涉及到MySQL、javascript、ssm、jsp、jquery,有需要的可以收藏一下

项目介绍及流程

拍卖系统采用ssm架构搭建,页面数据渲染采用jsp的初级简易拍卖系统,拍卖流程为 普通用户注册、登录后,进入个人中心发布商品后, 系统管理员进行商品审核, 审核不通过,用户发布列表展示拒绝原因, 审核通过后,首页及分类可查询展示,非发布人员进行商品竞价, 竞价完成,发布者进行商品发货, 拍卖获得者进行付款, 完成最终交易。

开发环境:

  1. jdk 8
  2. intellij idea
  3. tomcat 8
  4. mysql 5.7

所用技术:

项目框架:ssm
前端渲染:jsp
前端技术:js/jquery

项目目录结构

项目目录结构
  • controller,视图控制层,
  • service,业务逻辑层
  • dao,数据库操作层
  • jsp,页面进行数据渲染
  • mapper.xml,此文件定义了操作数据库的sql,每个sql是一个statement,映射文件是mybatis的核心
  • jdbc.properties,数据库帐号密码配置

运行效果

  • 注册

注册
  • 首页

首页
  • 发布商品

发布商品
  • 商品竞价

商品竞价
  • 浏览记录

浏览记录
  • 后端-商品管理

后端-商品管理

核心项目配置:

1.spring-mvc.xml配置:

<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p" xmlns:context="http://www.springframework.org/schema/context" xmlns:mvc="http://www.springframework.org/schema/mvc" xsi:schemalocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd"><annotation-driven></annotation-driven><!-- 自动扫描 @Controller--><component-scan base-package="com.pmxt.controller"></component-scan><resources mapping="/js/**" location="/js/"></resources><resources mapping="/css/**" location="/css/"></resources><resources mapping="/images/**" location="/images/"></resources><resources mapping="/view/**" location="/view/"></resources><resources mapping="/upload/**" location="/upload/"></resources><!--避免IE执行AJAX时,返回JSON出现下载文件 --><bean id="mappingJacksonHttpMessageConverter" class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter"><property name="supportedMediaTypes"><list><value>text/html;charset=UTF-8</value></list></property></bean><!-- 启动SpringMVC的注解功能,完成请求和注解POJO的映射 --><bean class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter"><property name="messageConverters"><list><ref bean="mappingJacksonHttpMessageConverter"></ref><!-- JSON转换器 --></list></property></bean><!-- 定义跳转的文件的前后缀 ,视图模式配置 --><bean class="org.springframework.web.servlet.view.InternalResourceViewResolver"><property name="prefix" value="/WEB-INF/jsp/"></property><property name="suffix" value=".jsp"></property></bean><!-- 文件上传配置 --><bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver"><!-- 默认编码 --><property name="defaultEncoding" value="UTF-8"></property><!-- 上传文件大小限制为31M,31*1024*1024 --><property name="maxUploadSize" value="32505856"></property><!-- 内存中的最大值 --><property name="maxInMemorySize" value="4096"></property></bean><interceptors><interceptor><mapping path="/**"></mapping><exclude-mapping path="/showLogin"></exclude-mapping><exclude-mapping path="/getVerifyCode"></exclude-mapping><exclude-mapping path="/checkLogin"></exclude-mapping><exclude-mapping path="/showReg"></exclude-mapping><exclude-mapping path="/forget"></exclude-mapping><exclude-mapping path="/checkUname"></exclude-mapping><exclude-mapping path="/forgetPassword"></exclude-mapping><exclude-mapping path="/reg"></exclude-mapping><exclude-mapping path="/css/**"></exclude-mapping><exclude-mapping path="/images/**"></exclude-mapping><exclude-mapping path="/js/**"></exclude-mapping><exclude-mapping path="/upload/**"></exclude-mapping><exclude-mapping path="/WEB-INF/jsp/login.jsp"></exclude-mapping><bean class="com.pmxt.interceptor.LoginInterceptor"></bean></interceptor></interceptors><!--500错误和404请求失败--><bean class="org.springframework.web.servlet.handler.SimpleMappingExceptionResolver"><property name="exceptionMappings"><map><entry key="ResourceNotFoundException" value="common/error/resourceNotFoundError"></entry><entry key=".DataAccessException" value="common/error/dataAccessError"></entry></map></property><property name="statusCodes"><map><entry key="common/error/resourceNotFoundError" value="404"></entry><entry key="common/error/dataAccessError" value="500"></entry></map></property></bean></beans>

2.spring-mybatis.xml配置

<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemalocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.1.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.1.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd"><!-- 自动扫描 --><component-scan base-package="com.pmxt"></component-scan><bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"><property name="driverClassName"><value>com.mysql.jdbc.Driver</value></property><property name="url"><value>jdbc:mysql://localhost:3306/pmxt?characterEncoding=UTF-8</value></property><property name="username"><value>root</value></property><property name="password"><value>root123</value></property></bean><!-- mybatis和spring完美整合,不需要mybatis的配置映射文件 --><bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><property name="dataSource" ref="dataSource"></property><!-- 自动扫描mapping.xml文件 --><property name="mapperLocations" value="classpath:mapping/*.xml"></property></bean><!-- DAO接口所在包名,Spring会自动查找其下的类 --><bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"><property name="basePackage" value="com.pmxt.dao"></property><property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property></bean><!-- (事务管理)transaction manager, use JtaTransactionManager for global tx --><bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"><property name="dataSource" ref="dataSource"></property></bean><!-- (事务管理)transaction manager, use JtaTransactionManager for global tx --><annotation-driven transaction-manager="transactionManager"></annotation-driven></beans>

3.登录验证

@RequestMapping("/sysRecommend")
public String sysRecommend(HttpSession session, Model model, String page)
{
 PUsersModel pUsersModel=(PUsersModel)session.getAttribute("pUsersModel"); //先判断当前用户是否已经浏览过商品
 LookshistoryModel lookModel=new LookshistoryModel(); lookModel.setUserid(pUsersModel.getUid()); List<lookshistorymodel> lists=lookshistoryService.selectLookshistory(lookModel);      //查询总记录并做降序处理
 Map<integer> gmap=new HashMap<integer integer>(); if(lists!=null&lists.size()>0){                                           //根据做商品过滤筛选 精准推荐
 int hits=0;                                                          //获取浏览总数
 for(LookshistoryModel m:lists){ gmap.put(m.getPgtype(),m.getHits());                                 //填充商品占比情况
 hits+=m.getHits();                                              //叠加浏览次数
 } Map<integer> gpmap=new HashMap<integer integer>();                               //对象储存转换,类型--->>次数 模式
 for (Map.Entry<integer integer> entry : gmap.entrySet()) { BigDecimal percentage=new BigDecimal(entry.getValue()).divide(new BigDecimal(hits),2,BigDecimal.ROUND_HALF_DOWN);     //当前最高商品的占比
 int result=percentage.multiply(new BigDecimal(12)).intValue();                   //推荐每个商品出现的占比情况
 gpmap.put(entry.getKey(),result); } List<goodsmodel> afterGoodsModels =new ArrayList<goodsmodel>(); int afterPageNums =0; for (Map.Entry<integer integer> entry : gmap.entrySet()) {                         //最终推荐出商品情况
 int afterPageItem = goodsService.countAfterGoodsByKinds(entry.getKey()); final int afterPageSize = entry.getValue(); if (page == null) { page = "1"; } PageUtil afterPageUtil = new PageUtil(afterPageItem, afterPageSize, Integer.parseInt(page)); int afterPageNum = afterPageUtil.getPageNum(); afterPageNums+=afterPageNum; int afterStartRow = afterPageUtil.getStartRow(); List<goodsmodel> goodsModels = goodsService.getAfterCheckGoodsByPageBykinds(afterStartRow, afterPageSize, entry.getKey()); Boolean afterHasNextPage = (Integer.parseInt(page) != afterPageNum) && (afterPageNum != 0); model.addAttribute("afterHasPrePage", Integer.parseInt(page) != 1); model.addAttribute("afterHasNextPage", afterHasNextPage); model.addAttribute("afterGoodsModels", afterGoodsModels); model.addAttribute("afterPageItem", afterPageItem);
 model.addAttribute("nowPage", Integer.parseInt(page)); afterGoodsModels.addAll(goodsModels); } model.addAttribute("afterPrePage", Integer.parseInt(page) - 1); model.addAttribute("afterNextPage", Integer.parseInt(page) + 1); model.addAttribute("afterPageNum", afterPageNums);    //总页面
 model.addAttribute("afterGoodsModels", afterGoodsModels);//总商品
 }else{                                                             //根据大众浏览推荐
 lists=lookshistoryService.selectLookshistory(new LookshistoryModel());          //根据大众浏览次数多的多推荐
 if(lists!=null&lists.size()>0){ int hits=0;                                                          //获取浏览总数
 for(LookshistoryModel m:lists){ gmap.put(m.getPgtype(),m.getHits());                                 //填充商品占比情况
 hits+=m.getHits();                                              //叠加浏览次数
 } Map<integer> gpmap=new HashMap<integer integer>();//商品占比存储对象
 for (Map.Entry<integer integer> entry : gmap.entrySet()) { BigDecimal percentage=new BigDecimal(entry.getValue()).divide(new BigDecimal(hits));      //当前最高商品的占比
 int result=percentage.multiply(new BigDecimal(12)).intValue();                   //推荐每个商品出现的占比情况
 gpmap.put(entry.getKey(),result); } List<goodsmodel> afterGoodsModels =new ArrayList<goodsmodel>(); int afterPageNums =0; for (Map.Entry<integer integer> entry : gmap.entrySet()) {             //最终推荐出商品情况
 int afterPageItem = goodsService.countAfterGoodsByKinds(entry.getKey()); final int afterPageSize = entry.getValue(); if (page == null) { page = "1"; }`` PageUtil afterPageUtil = new PageUtil(afterPageItem, afterPageSize, Integer.parseInt(page)); int afterPageNum = afterPageUtil.getPageNum(); afterPageNums+=afterPageNum; int afterStartRow = afterPageUtil.getStartRow(); List<goodsmodel> goodsModels = goodsService.getAfterCheckGoodsByPageBykinds(afterStartRow, afterPageSize, entry.getKey()); Boolean afterHasNextPage = (Integer.parseInt(page) != afterPageNum) && (afterPageNum != 0); model.addAttribute("afterHasPrePage", Integer.parseInt(page) != 1); model.addAttribute("afterHasNextPage", afterHasNextPage); model.addAttribute("afterGoodsModels", afterGoodsModels); model.addAttribute("afterPageItem", afterPageItem);
 model.addAttribute("nowPage", Integer.parseInt(page)); afterGoodsModels.addAll(goodsModels); } model.addAttribute("afterPrePage", Integer.parseInt(page) - 1); model.addAttribute("afterNextPage", Integer.parseInt(page) + 1); model.addAttribute("afterPageNum", afterPageNums);    //总页面
 model.addAttribute("afterGoodsModels", afterGoodsModels);//总商品
 }else{ int lindid=(int)Math.random()*(1);                         //没有浏览次数系统随机推荐
 int afterPageItem = goodsService.countAfterGoodsByKinds(lindid); final int afterPageSize = 12; if (page == null) { page = "1"; } PageUtil afterPageUtil = new PageUtil(afterPageItem, afterPageSize, Integer.parseInt(page)); int afterPageNum = afterPageUtil.getPageNum(); int afterStartRow = afterPageUtil.getStartRow(); List<goodsmodel> afterGoodsModels = goodsService.getAfterCheckGoodsByPageBykinds(afterStartRow, afterPageSize, 0); Boolean afterHasNextPage = (Integer.parseInt(page) != afterPageNum) && (afterPageNum != 0); model.addAttribute("afterHasPrePage", Integer.parseInt(page) != 1); model.addAttribute("afterHasNextPage", afterHasNextPage); model.addAttribute("afterPrePage", Integer.parseInt(page) - 1); model.addAttribute("afterNextPage", Integer.parseInt(page) + 1); model.addAttribute("afterGoodsModels", afterGoodsModels); model.addAttribute("afterPageItem", afterPageItem); model.addAttribute("afterPageNum", afterPageNum); model.addAttribute("nowPage", Integer.parseInt(page)); } } return "otherkinds";}</goodsmodel></goodsmodel></integer></goodsmodel></goodsmodel></integer></integer></integer></goodsmodel></integer></goodsmodel></goodsmodel></integer></integer></integer></integer></integer></lookshistorymodel>

项目总结

目前此版本为简易拍卖系统,其他拍卖逻辑或者额外功能,后续迭代排期开发,敬请关注!

今天关于《ssm搭建拍卖系统》的内容就介绍到这里了,是不是学起来一目了然!想要了解更多关于mysql的内容请关注golang学习网公众号!

声明:本文转载于:SegmentFault 如有侵犯,请联系study_golang@163.com删除
相关阅读
更多>
最新阅读
更多>
课程推荐
更多>