smbms-SSM(超市订单管理系统)
学了狂神的javaweb和ssm框架想把web的smbms换为ssm版,但找了好久没有合适的,最后在github找了一个思想对我胃口的来记录项目从0-1的实现(菜–勿喷)
项目参考图
数据库内容
/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Type : MySQL
Source Server Version : 80025
Source Host : localhost:3306
Source Schema : smbms
Target Server Type : MySQL
Target Server Version : 80025
File Encoding : 65001
Date: 19/10/2021 17:00:36
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for smbms_bill
-- ----------------------------
DROP TABLE IF EXISTS `smbms_bill`;
CREATE TABLE `smbms_bill` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
`billCode` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '账单编码',
`productName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品名称',
`productDesc` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品描述',
`productUnit` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品数量',
`productCount` decimal(20, 2) NULL DEFAULT NULL COMMENT '总金额',
`totalPrice` decimal(20, 2) NULL DEFAULT NULL COMMENT '是否支付',
`isPayment` int NULL DEFAULT NULL COMMENT '供应商ID',
`createdBy` bigint NULL DEFAULT NULL COMMENT '创建者',
`creationDate` datetime NULL DEFAULT NULL COMMENT '创建时间',
`modifyBy` bigint NULL DEFAULT NULL COMMENT '更新者',
`modifyDate` datetime NULL DEFAULT NULL COMMENT '更新时间',
`providerId` bigint NOT NULL COMMENT '供应商ID',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of smbms_bill
-- ----------------------------
INSERT INTO `smbms_bill` VALUES (5, 'BILL2016_005', '洗洁精', '日用品-厨房清洁', '瓶', 500.00, 7000.00, 2, 1, '2014-12-14 13:02:03', 2, '2021-10-19 15:59:58', 9);
INSERT INTO `smbms_bill` VALUES (6, 'BILL2016_006', '美国大杏仁', '食品-坚果', '袋', 300.00, 5000.00, 2, 1, '2016-04-14 06:08:09', NULL, NULL, 4);
INSERT INTO `smbms_bill` VALUES (7, 'BILL2016_007', '沐浴液、精油', '日用品-沐浴类', '瓶', 500.00, 23000.00, 1, 1, '2016-07-22 10:10:22', NULL, NULL, 14);
INSERT INTO `smbms_bill` VALUES (8, 'BILL2016_008', '不锈钢盘碗', '日用品-厨房用具', '个', 600.00, 6000.00, 2, 1, '2016-04-14 05:12:13', NULL, NULL, 14);
INSERT INTO `smbms_bill` VALUES (9, 'BILL2016_009', '塑料杯', '日用品-杯子', '个', 350.00, 1750.00, 2, 1, '2016-02-04 11:40:20', NULL, NULL, 14);
INSERT INTO `smbms_bill` VALUES (10, 'BILL2016_010', '豆瓣酱', '食品-调料', '瓶', 200.00, 2000.00, 2, 1, '2013-10-29 05:07:03', NULL, NULL, 8);
INSERT INTO `smbms_bill` VALUES (11, 'BILL2016_011', '海之蓝', '饮料-国酒', '瓶', 50.00, 10000.00, 1, 1, '2016-04-14 16:16:00', NULL, NULL, 1);
INSERT INTO `smbms_bill` VALUES (12, 'BILL2016_012', '芝华士', '饮料-洋酒', '瓶', 20.00, 6000.00, 1, 1, '2016-09-09 17:00:00', NULL, NULL, 1);
INSERT INTO `smbms_bill` VALUES (13, 'BILL2016_013', '长城红葡萄酒', '饮料-红酒', '瓶', 60.00, 800.00, 2, 1, '2016-11-14 15:23:00', NULL, NULL, 1);
INSERT INTO `smbms_bill` VALUES (14, 'BILL2016_014', '泰国香米', '食品-大米', '斤', 400.00, 5000.00, 2, 1, '2016-10-09 15:20:00', NULL, NULL, 3);
INSERT INTO `smbms_bill` VALUES (15, 'BILL2016_015', '东北大米', '食品-大米', '斤', 600.00, 4000.00, 2, 1, '2016-11-14 14:00:00', NULL, NULL, 3);
INSERT INTO `smbms_bill` VALUES (16, 'BILL2016_016', '可口可乐', '饮料', '瓶', 2000.00, 6000.00, 2, 1, '2012-03-27 13:03:01', NULL, NULL, 2);
INSERT INTO `smbms_bill` VALUES (17, 'BILL2016_017', '脉动', '饮料', '瓶', 1500.00, 4500.00, 2, 1, '2016-05-10 12:00:00', NULL, NULL, 2);
INSERT INTO `smbms_bill` VALUES (18, 'BILL2016_018', '哇哈哈', '饮料', '瓶', 2000.00, 4000.00, 2, 1, '2015-11-24 15:12:03', NULL, NULL, 2);
-- ----------------------------
-- Table structure for smbms_provider
-- ----------------------------
DROP TABLE IF EXISTS `smbms_provider`;
CREATE TABLE `smbms_provider` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
`proCode` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '供应商编码',
`proName` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '供应商名称',
`proDesc` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '供应商描述',
`proContact` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '供应商联系人',
`proPhone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '供应商电话',
`proAddress` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '供应商地址',
`proFax` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '供应商传真',
`createdBy` bigint NULL DEFAULT NULL COMMENT '创建者',
`creationDate` datetime NULL DEFAULT NULL COMMENT '创建时间',
`modifyDate` datetime NULL DEFAULT NULL COMMENT '更新时间',
`modifyBy` bigint NULL DEFAULT NULL COMMENT '更新者',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of smbms_provider
-- ----------------------------
INSERT INTO `smbms_provider` VALUES (1, 'BJ_GYS001', '北京三木堂商贸有限公司', '长期合作伙伴,主营产品:茅台、五粮液、郎酒、酒鬼酒、泸州老窖、赖茅酒、法国红酒等', '张国强', '13566667777', '北京市丰台区育芳园北路', '010-58858787', 1, '2013-03-21 16:52:07', NULL, NULL);
INSERT INTO `smbms_provider` VALUES (2, 'HB_GYS001', '石家庄帅益食品贸易有限公司', '长期合作伙伴,主营产品:饮料、水饮料、植物蛋白饮料、休闲食品、果汁饮料、功能饮料等', '王军', '13309094212', '河北省石家庄新华区', '0311-67738876', 1, '2016-04-13 04:20:40', NULL, NULL);
INSERT INTO `smbms_provider` VALUES (3, 'GZ_GYS001', '深圳市泰香米业有限公司', '初次合作伙伴,主营产品:良记金轮米,龙轮香米等', '郑程瀚', '13402013312', '广东省深圳市福田区深南大道6006华丰大厦', '0755-67776212', 1, '2014-03-21 16:56:07', NULL, NULL);
INSERT INTO `smbms_provider` VALUES (4, 'GZ_GYS002', '深圳市喜来客商贸有限公司', '长期合作伙伴,主营产品:坚果炒货.果脯蜜饯.天然花茶.营养豆豆.特色美食.进口食品.海味零食.肉脯肉', '林妮', '18599897645', '广东省深圳市福龙工业区B2栋3楼西', '0755-67772341', 1, '2013-03-22 16:52:07', NULL, NULL);
INSERT INTO `smbms_provider` VALUES (6, 'BJ_GYS002', '北京纳福尔食用油有限公司', '长期合作伙伴,主营产品:山茶油、大豆油、花生油、橄榄油等', '马莺', '13422235678', '北京市朝阳区珠江帝景1号楼', '010-588634233', 1, '2012-03-21 17:52:07', '2021-10-10 10:00:39', 2);
INSERT INTO `smbms_provider` VALUES (7, 'BJ_GYS003', '北京国粮食用油有限公司', '初次合作伙伴,主营产品:花生油、大豆油、小磨油等', '王驰', '13344441135', '北京大兴青云店开发区', '010-588134111', 1, '2016-04-13 00:00:00', NULL, NULL);
INSERT INTO `smbms_provider` VALUES (8, 'ZJ_GYS001', '慈溪市广和绿色食品厂', '长期合作伙伴,主营产品:豆瓣酱、黄豆酱、甜面酱,辣椒,大蒜等农产品', '薛圣丹', '18099953223', '浙江省宁波市慈溪周巷小安村', '0574-34449090', 1, '2013-11-21 06:02:07', NULL, NULL);
INSERT INTO `smbms_provider` VALUES (9, 'GX_GYS001', '优百商贸有限公司', '长期合作伙伴,主营产品:日化产品', '李立国', '13323566543', '广西南宁市秀厢大道42-1号', '0771-98861134', 1, '2013-03-21 19:52:07', '2021-10-18 15:52:19', 2);
INSERT INTO `smbms_provider` VALUES (10, 'JS_GYS002', '南京火头军信息技术有限公司', '长期合作伙伴,主营产品:不锈钢厨具等', '陈女士', '13098992113', '江苏省南京市浦口区浦口大道1号新城总部大厦A座903室', '025-86223345', 1, '2013-03-25 16:52:07', NULL, NULL);
INSERT INTO `smbms_provider` VALUES (11, 'GZ_GYS003', '广州市白云区美星五金制品厂', '长期合作伙伴,主营产品:海绵床垫、坐垫、靠垫、海绵枕头、头枕等', '梁天', '13562276775', '广州市白云区钟落潭镇福龙路20号', '020-85542231', 1, '2016-12-21 06:12:17', NULL, NULL);
INSERT INTO `smbms_provider` VALUES (12, 'BJ_GYS004', '北京隆盛日化科技', '长期合作伙伴,主营产品:日化环保清洗剂,家居洗涤专卖、洗涤用品网、墙体除霉剂、墙面霉菌清除剂等', '孙欣', '13689865678', '北京市大兴区旧宫', '010-35576786', 1, '2014-11-21 12:51:11', NULL, NULL);
INSERT INTO `smbms_provider` VALUES (13, 'SD_GYS001', '山东豪克华光联合发展有限公司', '长期合作伙伴,主营产品:洗衣皂、洗衣粉、洗衣液、洗洁精、消杀类、香皂等', '吴洪转', '13245468787', '山东济阳济北工业区仁和街21号', '0531-53362445', 1, '2015-01-28 10:52:07', NULL, NULL);
INSERT INTO `smbms_provider` VALUES (14, 'JS_GYS003', '无锡喜源坤商行', '长期合作伙伴,主营产品:日化品批销', '周一清', '18567674532', '江苏无锡盛岸西路', '0510-32274422', 1, '2016-04-23 11:11:11', NULL, NULL);
INSERT INTO `smbms_provider` VALUES (16, '1', '王军2', '啊实打实', '', '', '', '', 2, NULL, NULL, NULL);
INSERT INTO `smbms_provider` VALUES (17, 'HN_GYS002', '河南222有限公司', '无', '半藏', '12345678912', '河南郑州b路2号', '12345678912', 16, NULL, '2021-10-19 16:48:01', 16);
-- ----------------------------
-- Table structure for smbms_role
-- ----------------------------
DROP TABLE IF EXISTS `smbms_role`;
CREATE TABLE `smbms_role` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
`roleCode` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色编码',
`roleName` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色名称',
`createdBy` bigint NULL DEFAULT NULL COMMENT '创建者',
`creationDate` datetime NULL DEFAULT NULL COMMENT '创建时间',
`modifyBy` bigint NULL DEFAULT NULL COMMENT '更新者',
`modifyDate` datetime NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of smbms_role
-- ----------------------------
INSERT INTO `smbms_role` VALUES (1, 'SMBMS_ADMIN', '系统管理员', 1, '2016-04-13 00:00:00', NULL, NULL);
INSERT INTO `smbms_role` VALUES (2, 'SMBMS_MANAGER', '经理', 1, '2016-04-13 00:00:00', NULL, NULL);
INSERT INTO `smbms_role` VALUES (3, 'SMBMS_EMPLOYEE', '普通员工', 1, '2016-04-13 00:00:00', NULL, NULL);
-- ----------------------------
-- Table structure for smbms_user
-- ----------------------------
DROP TABLE IF EXISTS `smbms_user`;
CREATE TABLE `smbms_user` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
`userCode` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户编码',
`userName` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名字',
`userPassword` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户密码',
`gender` int NULL DEFAULT NULL COMMENT '性别',
`birthday` date NULL DEFAULT NULL COMMENT '出生日期',
`phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话',
`address` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址',
`userRole` bigint NULL DEFAULT NULL COMMENT '用户角色',
`createdBy` bigint NULL DEFAULT NULL COMMENT '创建者',
`creationDate` datetime NULL DEFAULT NULL COMMENT '创建时间',
`modifyBy` bigint NULL DEFAULT NULL COMMENT '更新者',
`modifyDate` datetime NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of smbms_user
-- ----------------------------
INSERT INTO `smbms_user` VALUES (1, 'xiaowei', 'xiaowei', '123123123123', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `smbms_user` VALUES (2, 'xx', 'xx', 'aa123123', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `smbms_user` VALUES (3, 'yy', 'yy', 'yy456123', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `smbms_user` VALUES (5, 'hanlubiao', '韩路彪', '0000000', 2, '1984-06-05', '18567542321', '北京市朝阳区北辰中心12号', 2, 1, '2014-12-31 19:52:09', 2, '2021-10-19 16:05:06');
INSERT INTO `smbms_user` VALUES (7, 'wangyang', '王洋', '0000000', 2, '1982-12-31', '13444561124', '北京市海淀区西二旗辉煌国际16层', 2, 1, '2014-06-11 19:09:07', 2, '2021-10-19 15:52:59');
INSERT INTO `smbms_user` VALUES (8, 'zhaoyan', '赵燕', '0000000', 2, '1986-03-07', '18098764545', '北京市海淀区回龙观小区10号楼', 2, 1, '2016-04-21 13:54:07', 2, '2021-10-19 15:52:45');
INSERT INTO `smbms_user` VALUES (11, 'sunxing', '孙兴', '0000000', 2, '1978-03-12', '13367890900', '北京市朝阳区建国门南大街10号', 3, 1, '2016-11-09 16:51:17', NULL, NULL);
INSERT INTO `smbms_user` VALUES (12, 'zhangchen', '张晨', '0000000', 1, '1986-03-28', '18098765434', '朝阳区管庄路口北柏林爱乐三期13号楼', 3, 1, '2016-08-09 05:52:37', 1, '2016-04-14 14:15:36');
INSERT INTO `smbms_user` VALUES (13, 'dengchao', '邓超', '0000000', 2, '1981-11-04', '13689674534', '北京市海淀区北航家属院10号楼', 3, 1, '2016-07-11 08:02:47', NULL, NULL);
INSERT INTO `smbms_user` VALUES (14, 'yangguo', '杨过', '0000000', 2, '1980-01-01', '13388886623', '北京市朝阳区北苑家园茉莉园20号楼', 3, 1, '2015-02-01 03:52:07', NULL, NULL);
INSERT INTO `smbms_user` VALUES (15, 'zhaomin', '赵敏', '0000000', 1, '1987-12-04', '18099897657', '北京市昌平区天通苑3区12号楼', 2, 1, '2015-09-12 12:02:12', NULL, NULL);
INSERT INTO `smbms_user` VALUES (16, 'admin', 'admin', '123456', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
SET FOREIGN_KEY_CHECKS = 1;
项目创建准备
一、打开idea新建maven项目手动添加Web项目
二、导入静态资源页面
三、创建包
四、导入项目依赖
<!--依赖 junit ,数据库驱动,连接池 servlet,jsp,mybatis,mybatis-spring,spring-mvc-->
<dependencies>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
</dependency>
<!--数据库驱动-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.26</version>
</dependency>
<!-- 数据库连接池 -->
<dependency>
<groupId>com.mchange</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.5.5</version>
</dependency>
<!--Servlet - JSP -->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>servlet-api</artifactId>
<version>2.5</version>
</dependency>
<dependency>
<groupId>javax.servlet.jsp</groupId>
<artifactId>jsp-api</artifactId>
<version>2.2</version>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<!--Mybatis-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.7</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>2.0.6</version>
</dependency>
<!--Spring-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>5.2.12.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>5.2.12.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>5.3.10</version>
</dependency>
<!-- https://mvnrepository.com/artifact/com.fasterxml.jackson.core/jackson-databind -->
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
<version>2.13.0-rc1</version>
</dependency>
<!-- https://mvnrepository.com/artifact/com.alibaba/fastjson -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>fastjson</artifactId>
<version>1.2.78</version>
</dependency>
<!-- https://mvnrepository.com/artifact/log4j/log4j -->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.apache.commons/commons-lang3 -->
<dependency>
<groupId>org.apache.commons</groupId>
<artifactId>commons-lang3</artifactId>
<version>3.12.0</version>
</dependency>
<!-- https://mvnrepository.com/artifact/commons-io/commons-io -->
<dependency>
<groupId>commons-io</groupId>
<artifactId>commons-io</artifactId>
<version>2.11.0</version>
</dependency>
<!-- https://mvnrepository.com/artifact/commons-fileupload/commons-fileupload -->
<dependency>
<groupId>commons-fileupload</groupId>
<artifactId>commons-fileupload</artifactId>
<version>1.4</version>
</dependency>
<!-- 横切的包aspectjweaver -->
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjweaver</artifactId>
<version>1.9.6</version>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.20</version>
</dependency>
</dependencies>
<build>
<!-- Maven 资源过滤:静态资源导出问题 -->
<resources>
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.properties</include>
<include>**/*.xml</include>
</includes>
<filtering>false</filtering>
</resource>
<resource>
<directory>src/main/resources</directory>
<includes>
<include>**/*.properties</include>
<include>**/*.xml</include>
</includes>
<filtering>false</filtering>
</resource>
</resources>
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.8.1</version>
<configuration>
<source>6</source>
<target>6</target>
</configuration>
</plugin>
</plugins>
</build>
</project>
五、idea连接数据库
六、整合SSM配置
database.properties
jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/smbms?userSSL=false&userUnicode=true&characterEncoding=utf-8
jdbc.username=root
jbdc.password=123456
mybatis-config.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org/DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<typeAliases>
<package name="com.wei.pojo"/>
</typeAliases>
</configuration>
mybatis-config.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:mvc="http://www.springframework.org/schema/mvc"
xmlns:p="http://www.springframework.org/schema/p"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-4.2.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-4.2.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-4.2.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-4.2.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-4.2.xsd">
<!--
<bean name="/index.jsp" class="cn.smbms.controller.IndexController"/>
-->
<!-- 基于注解方式 -->
<context:component-scan base-package="com.wei.controller"/>
<mvc:annotation-driven/>
<!-- 视图配置 -->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/jsp/"/>
<property name="suffix" value=".jsp"/>
</bean>
<!-- 全局异常处理 -->
<bean class="org.springframework.web.servlet.handler.SimpleMappingExceptionResolver">
<property name="exceptionMappings">
<props>
<prop key="java.lang.RuntimeException">publicError</prop>
</props>
</property>
</bean>
<!-- 2. 静态资源过滤-->
<mvc:default-servlet-handler/>
<!-- 访问静态资源配置 -->
<!-- <mvc:resources location="/statics/" mapping="/statics/**"></mvc:resources>-->
<!-- <mvc:resources location="/uploads/" mapping="/uploads/**"></mvc:resources>-->
<bean id="multipartResolver"
class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
<property name="maxUploadSize" value="5000000"/>
<property name="defaultEncoding" value="UTF-8"/>
</bean>
</beans>
applicationContext.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"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd">
<!--
使spring扫描包下的所有类,让标注spring注解的类生效
若扫描到有@Component @Controller@Service等这些注解的类,则把这些类注册为bean
-->
<context:component-scan base-package="com.wei.service"/>
<context:component-scan base-package="com.wei.dao"/>
<!-- 1. 关联数据库配置文件-->
<context:property-placeholder location="classpath:database.properties"/>
<!-- 2. 连接池
dbcp:半自动华操作,不能自动连接
c3p0:自动化操作(自动化加载配置文件,并且可以自设置到对象中)
druid:hikari
-->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="${jdbc.driver}"/>
<property name="jdbcUrl" value="${jdbc.url}"/>
<property name="user" value="${jdbc.username}"/>
<property name="password" value="${jbdc.password}"/>
<!-- c3p0 连接池的私有属性 -->
<property name="maxPoolSize" value="30"/>
<property name="minPoolSize" value="10"/>
<!-- 关闭连接后不自动commit -->
<property name="autoCommitOnClose" value="false"/>
<!-- 获取连接超时时间 -->
<property name="checkoutTimeout" value="10000"/>
<!-- 当获取连接失败重试次数 -->
<property name="acquireRetryAttempts" value="2"/>
</bean>
<!-- 配置SqlSessionFactoryBean -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!-- 引入数据源 -->
<property name="dataSource" ref="dataSource"/>
<!-- 引入mybatis配置 -->
<property name="configLocation" value="classpath:mybatis-config.xml"/>
<!-- 配置Sql映射文件 -->
<property name="mapperLocations">
<list>
<value>classpath:com/wei/dao/**/*.xml</value>
</list>
</property>
</bean>
<!-- 使用MapperScannerConfigure配置 自动扫描dao接口,并自动添加bean配置 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
<property name="basePackage" value="com.wei.dao"/>
</bean>
</beans>
log4j.properties
##日志的优先级从高到低FATAL:ERROR:WARN:INFO:DEBUG:##
log4j.rootLogger=debug,con
# deBUG级别,从屏幕输出
log4j.appender.con=org.apache.log4j.ConsoleAppender
log4j.appender.con.layout=org.apache.log4j.PatternLayout
log4j.appender.File.layout.ConversionPattern = %-d{yyyy-MM-dd HH:mm:ss} [ %t:%r ] - [ %p ] %m%n
七、web.xml解读
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
version="4.0">
<!-- 配置监听,初始化spring 容器 -->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!-- 配置本地参数 -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:applicationContext.xml</param-value>
</context-param>
<!-- 配置springMVC的核心控制器 -->
<servlet>
<servlet-name>springMVC</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<!-- 初始参数 -->
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:springmvc-servlet.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<!-- 配置生效的目录 -->
<servlet-mapping>
<servlet-name>springMVC</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>default</servlet-name>
<url-pattern>*.js</url-pattern>
<url-pattern>*.css</url-pattern>
<url-pattern>/assets/*"</url-pattern>
<url-pattern>/images/*</url-pattern>
</servlet-mapping>
<!--字符编码设置-->
<filter>
<filter-name>charsetEncoding</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
<init-param>
<param-name>forceEncoding</param-name>
<param-value>true</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>charsetEncoding</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<display-name>ssm8</display-name>
<!--首页欢迎页面设置-->
<welcome-file-list>
<welcome-file>login.jsp</welcome-file>
<welcome-file>login.html</welcome-file>
<welcome-file>login.htm</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>
项目创建0-1
一、先说思路
二、在pojo下新建实体类
User.java
public class User {
private Integer id;
private String userCode;//用户账号
private String userName;//用户姓名
private String userPassword;//密码
private Integer gender;//性别
@DateTimeFormat(pattern="yyyy-MM-dd")
private Date birthday;//生日
private String phone;//电话
private String address;//电话
private Integer userRole;//角色id
private Integer createdBy;//创建者
private Date creationDate;//创建时间
private Integer modifyBy;//修改者
private Date modifyDate;//修改时间
private String idPicPath;//证件照
private String workPicPath;//工作照
private String roleName;//角色名
private com.wei.pojo.Role role;//角色对象
}
Role.java
public class Role {
private Integer id;//主键ID,
private String roleCode;//角色编码,
private String roleName;//角色名称,
private Integer createdBy;//创建者,
private Date creationDate;//创建时间,
private Integer modifyBy;//修改者,
private Date modifyDate;//修改时间,
}
Provider.java
public class Provider {
//定义类的属性
private Integer id;//主键ID,
private String proCode;//供应商编码,
private String proName;//供应商名称,
private String proDesc;//供应商详细描述,
private String proContact;//供应商联系人,
private String proPhone;//联系电话,
private String proAddress;//地址,
private String proFax;//传真,
private Integer createdBy;//创建者(userId),
private Date creationDate;//创建时间,
private Date modifyDate;// 更新时间,
private Integer modifyBy;//更新者(userId),
private String companyLicPicPath;//营业执照,
private String orgCodePicPath;//组织机构代码证,
}
Order.java
public class Order {
//定义类的属性
private Integer id;//主键ID,
private String billCode;//账单编码,
private String productName;//商品名称,
private String productDesc;//商品描述,
private String productUnit;//商品单位,
private double productCount;//商品数量,
private double totalPrice;//商品总额,
private int isPayment;//是否支付,
private Integer createdBy;//创建者(userId),
private Date creationDate;//创建时间,
private Date modifyDate;// 更新时间,
private Integer modifyBy;//更新者(userId),
private int providerId;//供应商ID,
}
三、提取公共类生成工具包utils
分别为Constants常量类和PageHelper类翻页功能的实现(分页未实现 无效果)
package com.wei.utils;
public class Constants {
public final static String USER_SESSION = "userSession";
public final static String SYS_MESSAGE = "message";
public final static int pageSize = 5;
}
package com.wei.utils;
public class PageHelper {
//当前页码-来自于用户输入
private int currentPageNo = 1;
//总数量(表)
private int totalCount = 0;
//页面容量
private int pageSize = 0;
//总页数-totalCount/pageSize(+1)
private int totalPageCount = 1;
public int getCurrentPageNo() {
return currentPageNo;
}
public void setCurrentPageNo(int currentPageNo) {
if(currentPageNo > 0){
this.currentPageNo = currentPageNo;
}
}
public int getTotalCount() {
return totalCount;
}
public void setTotalCount(int totalCount) {
if(totalCount > 0){
this.totalCount = totalCount;
//设置总页数
this.setTotalPageCountByRs();
}
}
public int getPageSize() {
return pageSize;
}
public void setPageSize(int pageSize) {
if(pageSize > 0){
this.pageSize = pageSize;
}
}
public int getTotalPageCount() {
return totalPageCount;
}
public void setTotalPageCount(int totalPageCount) {
this.totalPageCount = totalPageCount;
}
public void setTotalPageCountByRs(){
if(this.totalCount % this.pageSize == 0){
this.totalPageCount = this.totalCount / this.pageSize;
}else if(this.totalCount % this.pageSize > 0){
this.totalPageCount = this.totalCount / this.pageSize + 1;
}else{
this.totalPageCount = 0;
}
}
}
三、登录退出业务实现
在dao层新建新建UserMapper接口和UserMapper.xml对数据库进行操作
public interface UserMapper {
//用户登录
public User checkLogin(@Param("userCode") String userCode, @Param("userPassword") String userPassword);
}
UserMapper.xml
<!--登录查询 -->
<select id="checkLogin" resultType="User">
select * from smbms.smbms_user where userCode=#{userCode} and userPassword=#{userPassword}
</select>
在service层新建UserService接口和UserServiceImpl实现类
public interface UserService {
public User checkLogin(String userCode, String userPassword);
}
@Service
public class UserServiceImpl implements UserService{
@Autowired
UserMapper userMapper;
@Override
public User checkLogin(String userCode, String userPassword) {
return userMapper.checkLogin(userCode, userPassword);
}
}
在Controller层中的IndexController类和UserController类中实现登录功能
@Controller
public class IndexController {
//用户登录处理界面
@RequestMapping("/userLoginGo")
public ModelAndView userLoginGo(User user, HttpSession session) {
ModelAndView mv =new ModelAndView();
mv.addObject("user",user);
session.setAttribute("userName","ddd");
mv.setViewName("success");
return mv;
}
//用户登录界面
@RequestMapping("/userLogin")
public String userLogin() {
return "userLogin";
}
}
@Controller
public class UserController {
@Autowired
UserService userService;
//请求登录界面
@RequestMapping("/login")
public String login() {
return "/WEB-INF/login.jsp";
}
//退出界面
@RequestMapping("/logout")
public String logout(HttpSession session){
session.removeAttribute(Constants.USER_SESSION);
return "redirect:login.jsp";
}
//请求处理程序
@RequestMapping("/loginGo")
public String loginGo(String userCode,String userPassword,Model md,HttpSession session) {
User user=new User();
user=userService.checkLogin(userCode, userPassword);
if(null!=user) {
md.addAttribute("user",user);
session.setAttribute(Constants.USER_SESSION, user);
return "frame";
}else {
md.addAttribute("msg","用户名或密码错误!");
// session.setAttribute("msg", "用户名或密码错误!");
// throw new RuntimeException("用户名或密码错误!");
return "redirect:login.jsp";
}
}
}
四、修改密码业务实现
在dao层UserMapper接口和UserMapper.xml继续添加业务操作
public interface UserMapper {
//修改密码
public Integer modifyPasswd(@Param("userCode") String userCode,
@Param("userPassword") String userPassword,
@Param("newPassword") String newPassword);
}
UserMapper.xml
<!--修改密码 -->
<select id="modifyPasswd" resultType="User">
update smbms.smbms_user set userPassword=#{newPassword}
where userCode=#{userCode} and userPassword=#{userPassword}
</select>
在UserService接口和UserServiceImpl实现类添加实现操作
public interface UserService {
//修改密码
public boolean modifyPasswd(String userCode, String userPassword, String newPassword);
}
@Service
public class UserServiceImpl implements UserService{
@Override
public boolean modifyPasswd(String userCode, String userPassword, String newPassword) {
boolean flag = false;
String msg= "";
try {
if(!StringUtils.isEmpty(userCode)&& null!=userPassword&&null!=newPassword) {
if(userMapper.modifyPasswd(userCode, userPassword,newPassword)>0) {
flag=true;
}else
{
msg="修改失败";
}
}else
msg="参数为空错误!";
}catch(RuntimeException e) {
throw new RuntimeException(msg+e);
}
return flag;
}
}
在Controller层中的UserController类中实现修改密码
//修改密码实现方法
@RequestMapping("/modifyPasswordGo")
public String modifyPasswordGo(String userCode,String userPassword,String newPassword,Model md) {
String msg="";
if(userService.modifyPasswd(userCode, userPassword, newPassword))
msg="修改密码成功!";
else
msg="修改密码失败!";
md.addAttribute("msg",msg);
return "modifyPasswordFinish";
}
//添加用户打开修改密码的界面
@RequestMapping("/modifyPasswd")
public String modifyPasswd(HttpSession session, Model md) {
User user = (User) session.getAttribute(Constants.USER_SESSION);
String userCode = user.getUserCode();
md.addAttribute("userCode", userCode);
return "modifyPasswd";
}
五、实现订单业务的增删改查
在dao层新建新建OrderMapper接口和OrderMapper.xml对数据库进行操作
package com.wei.dao;
import com.wei.pojo.Order;
import org.apache.ibatis.annotations.Param;
import java.util.List;
public interface OrderMapper {
public List<Order> getOrderList(@Param("productName") String productName,
@Param("pageIndex") Integer pageIndex,
@Param("pageSize") Integer pageSize);
//根据条件获取订单的记录数
public Integer getOrderCount(@Param("productName") String productName);
//添加订单
public Integer orderAdd(Order order);
//删除订单
public Integer deleteOrderById(@Param("id") Integer id);
//修改订单
public Integer modifyOrder(Order order);
//根据订单的id获取订单信息
public Order getOrderById(@Param("id") Integer id);
}
}
OrderMapper.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.wei.dao.OrderMapper">
<!-- 根据订单模糊查询订单列表 -->
<select id="getOrderList" resultType="com.wei.pojo.Order">
select * from smbms.smbms_bill where productName like CONCAT('%',#{productName},'%')
limit #{pageIndex},#{pageSize};
</select>
<!-- 获取订单记录数 -->
<select id="getOrderCount" parameterType="String" resultType="Integer">
select count(*) from smbms.smbms_bill where productName like CONCAT('%',#{productName},'%');
</select>
<!-- 添加订单 -->
<insert id="orderAdd" parameterType="com.wei.pojo.Order">
insert into smbms.smbms_bill(billCode,productName,productDesc,productUnit,productCount,totalPrice,isPayment)
values(#{billCode},#{productName},#{productDesc},#{productUnit},#{productCount},#{totalPrice},#{isPayment})
</insert>
<!--根据订单id删除记录-->
<insert id="deleteOrderById" parameterType="Integer">
delete from smbms.smbms_bill where id=#{id};
</insert>
<!-- 根据订单id获取订单信息 -->
<select id="getOrderById" parameterType="Integer" resultType="com.wei.pojo.Order">
select * from smbms.smbms_bill where id=#{id}
</select>
<!-- 修改订单信息 -->
<update id="modifyOrder" parameterType="com.wei.pojo.Order">
update smbms.smbms_bill set billCode=#{billCode},
productName=#{productName},
productDesc =#{productDesc},
productUnit=#{productUnit},
productCount=#{productCount},
totalPrice=#{totalPrice},
isPayment=#{isPayment},
modifyBy=#{modifyBy},
modifyDate=#{modifyDate}
where id=#{id}
</update>
</mapper>
在service层新建OrderService接口和OrderServiceImpl实现类
package com.wei.service;
import com.wei.pojo.Order;
import java.util.List;
public interface OrderService {
public List<Order> getOrderList(String orderName, Integer pageIndex, Integer pageSize);
//根据条件获取订单的记录数
public Integer getOrderCount(String orderName);
//修改订单信息
public boolean modifyOrder(Order order);
//添加订单
public boolean orderAdd(Order order);
//删除订单
public boolean deleteOrderById(String id);
//根据id获取订单信息
public Order getOrderById(String id);
}
package com.wei.service;
import com.wei.dao.OrderMapper;
import com.wei.pojo.Order;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.ArrayList;
import java.util.List;
@Service
public class OrderServiceImpl implements OrderService{
//引入Dao层
@Autowired
OrderMapper orderMapper;
@Override
public List<Order> getOrderList(String orderName, Integer pageIndex, Integer pageSize) {
List<Order> order = new ArrayList<Order>();
try {
order=orderMapper.getOrderList(orderName, pageIndex, pageSize);
}catch(RuntimeException e) {
e.printStackTrace();
throw new RuntimeException("查询异常"+e.toString());
}
return order;
}
@Override
public Integer getOrderCount(String orderName) {
Integer num = 0;
try {
num = orderMapper.getOrderCount(orderName);
}catch(RuntimeException e) {
e.printStackTrace();
throw new RuntimeException("获取总数异常"+e.toString());
}
return num;
}
@Override
public boolean modifyOrder(Order order) {
String msg="";
boolean flag=false;
try {
if(null!=order) {
if(orderMapper.modifyOrder(order)>0)
flag=true;
}
}catch(RuntimeException e) {
throw new RuntimeException(msg+e);
}
return flag;
}
@Override
public boolean orderAdd(Order order) {
boolean flag = false;
try {
if(orderMapper.orderAdd(order)>=1) {
flag = true;
}
}catch(RuntimeException e) {
e.printStackTrace();
throw new RuntimeException("添加订单错误"+e.getMessage());
}
return flag;
}
@Override
public boolean deleteOrderById(String id) {
boolean flag=false;
Integer nid=null;
String msg="";
try {
if(!StringUtils.isEmpty(id)) {
nid=Integer.parseInt(id);
if(orderMapper.deleteOrderById(nid)>0)
flag=true;
}else msg="参数为空!";
}catch(RuntimeException e) {
throw new RuntimeException(msg+e);
}
return flag;
}
@Override
public Order getOrderById(String id) {
//字符串转换整型数据
String msg="";
Integer nid=null;
Order order=new Order();
try {
if(!StringUtils.isEmpty(id)) {
nid=Integer.parseInt(id);
order=orderMapper.getOrderById(nid);
}else
msg="用户的id为空!";
}catch(RuntimeException e) {
throw new RuntimeException(msg+e);
}
return order;
}
}
在Controller层中的IndexController类和UserController类中实现登录功能
package com.wei.controller;
import com.wei.pojo.Order;
import com.wei.pojo.User;
import com.wei.service.OrderService;
import com.wei.utils.Constants;
import com.wei.utils.PageHelper;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import javax.servlet.http.HttpSession;
import java.util.Date;
import java.util.List;
@Controller
public class OrderController {
@Autowired
OrderService orderService;
//添加订单界面
@RequestMapping("/orderAdd")
public String orderAdd() {
return "orderAdd";
}
//添加订单处理方法
@RequestMapping("/orderAddGo")
public String orderAddGo(Order order, HttpSession session) {
Order ord = new Order();
ord = order;
Integer oid=null;
oid=((User) session.getAttribute(Constants.USER_SESSION)).getId();
if(null!=oid) {
ord.setCreatedBy(oid);
if(orderService.orderAdd(ord))
return "redirect:getOrder";
else
return "redirect:orderAdd";
}
else
return "/WEB-INF/login.jsp";
}
//获取订单列表的处理方法
@RequestMapping("/getOrder")
public String getOrderList(String orderName, Model md, String pageIndex) {
String strName="";
if(!StringUtils.isEmpty(orderName)) {
strName=orderName;
}
Integer currentPageNo=1;
Integer pageSize= Constants.pageSize;
if(!StringUtils.isEmpty(pageIndex)) {
currentPageNo=Integer.parseInt(pageIndex);
}
//根据条件获取总记录数
Integer totalCount=orderService.getOrderCount(strName);
//计算可以分几页
PageHelper pages=new PageHelper();
pages.setCurrentPageNo(currentPageNo);
pages.setPageSize(pageSize);
pages.setTotalCount(totalCount);
int totalPageCount = pages.getTotalPageCount();
List<Order> order=orderService.getOrderList(strName,(currentPageNo-1)*pageSize,pageSize);
md.addAttribute("totalPageCount", totalPageCount);
md.addAttribute("totalCount", totalCount);
md.addAttribute("currentPageNo", currentPageNo);
md.addAttribute("order",order);
return "orderList";
}
//根据id删除订单信息
@RequestMapping("deleteOrderById")
public String deleteOrderById(String id,Model md) {
String msg="";
if(orderService.deleteOrderById(id)) {
msg="删除订单成功!";
}else
msg="删除订单失败!";
md.addAttribute("msg", msg);
return "redirect:getOrder";
}
//添加修改界面
@RequestMapping("/modifyOrder")
public String modifyOrder(String id,Model md) {
Order order=new Order();
order=orderService.getOrderById(id);
md.addAttribute("order", order);
return "modifyOrder";
}
//添加修改用户的执行路由信息
@RequestMapping("/modifyOrderGo")
public String modifyOrderGo(Order order,HttpSession session) {
Integer oid=((User)session.getAttribute(Constants.USER_SESSION)).getId();
if(null!=order) {
order.setModifyBy(oid);
order.setModifyDate(new Date());
orderService.modifyOrder(order);
}
return "redirect:getOrder";
}
//根据ID查看订单
@RequestMapping("/viewOrder")
public String viewOrder(String id,Model md) {
Order order=new Order();
order=orderService.getOrderById(id);
md.addAttribute("order", order);
return "viewOrder";
}
}
六、实现供应商业务的增删改查
在dao层新建新建ProviderMapper接口和ProviderMapper.xml对数据库进行操作
package com.wei.dao;
import com.wei.pojo.Provider;
import org.apache.ibatis.annotations.Param;
import java.util.List;
public interface ProviderMapper {
public List<Provider> getProviderList(@Param("proName") String proName,
@Param("pageIndex") Integer pageIndex,
@Param("pageSize") Integer pageSize);
//根据条件获取供应商的记录数
public Integer getProviderCount(@Param("proName") String proName);
//添加供应商
public Integer providerAdd(Provider provider);
//修改供应商
public Integer modifyProvider(Provider provider);
//从ID获取某一个供应商信息
public Provider getProvider(@Param("id") Integer id);
//删除供应商
public Integer deleteProviderById(@Param("id") Integer id);
}
OrderMapper.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.wei.dao.ProviderMapper">
<!-- 根据供应商名模糊查询供应商列表 -->
<select id="getProviderList" resultType="Provider">
select * from smbms.smbms_provider where proName like CONCAT('%',#{proName},'%')
limit #{pageIndex},#{pageSize};
</select>
<!-- 获取供应商记录数 -->
<select id="getProviderCount" parameterType="String" resultType="Integer">
select count(*) from smbms.smbms_provider where proName like CONCAT('%',#{proName},'%');
</select>
<!-- 添加供应商 -->
<insert id="providerAdd" parameterType="Provider">
insert into smbms.smbms_provider(proCode,proName,proDesc,proContact,proPhone,proAddress,proFax,createdBy)
values(#{proCode},#{proName},#{proDesc},#{proContact},#{proPhone},#{proAddress},#{proFax},#{createdBy})
</insert>
<!-- 根据供应商id删除记录 -->
<delete id="deleteProviderById" parameterType="Integer">
delete from smbms.smbms_provider where id=#{id}
</delete>
<!-- 根据供应商id获取供应商信息 -->
<select id="getProvider" parameterType="Integer" resultType="Provider">
select * from smbms.smbms_provider where id=#{id}
</select>
<!-- 修改供应商信息 -->
<update id="modifyProvider" parameterType="Provider">
update smbms.smbms_provider set proCode=#{proCode},
proName=#{proName},
proDesc =#{proDesc},
proContact=#{proContact},
proPhone=#{proPhone},
proAddress=#{proAddress},
proFax=#{proFax},
modifyBy=#{modifyBy},
modifyDate=#{modifyDate}
where id=#{id}
</update>
</mapper>
在service层新建ProviderService接口和ProviderServiceImpl实现类
package com.wei.service;
import com.wei.pojo.Provider;
import java.util.List;
public interface ProviderService {
public List<Provider> getProviderList(String proName, Integer pageIndex, Integer pageSize);
//获取供应商的数量
public Integer getProviderCount(String proName);
//添加供应商
public boolean providerAdd(Provider provider);
//修改供应商信息
public boolean modifyProvider(Provider provider);
//删除供应商
public boolean deleteProviderById(String id);
//根据id获取供应商信息
public Provider getProvider(String id);
}
package com.wei.service;
import com.wei.dao.ProviderMapper;
import com.wei.pojo.Provider;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.ArrayList;
import java.util.List;
@Service
public class ProviderServiceImpl implements ProviderService{
//引入Dao层的资源
@Autowired
ProviderMapper providerMapper;
@Override
public List<Provider> getProviderList(String proName, Integer pageIndex, Integer pageSize) {
List<Provider> providers=new ArrayList<Provider>();
try {
providers=providerMapper.getProviderList(proName,pageIndex,pageSize);
}catch(RuntimeException e) {
e.printStackTrace();
throw new RuntimeException("查询异常"+e.toString());
}
return providers;
}
@Override
public Integer getProviderCount(String proName) {
Integer num=0;
try {
num=providerMapper.getProviderCount(proName);
}catch(RuntimeException e) {
e.printStackTrace();
throw new RuntimeException("获取总数异常"+e.toString());
}
return num;
}
@Override
public boolean providerAdd(Provider provider) {
boolean flag=false;
try {
if(providerMapper.providerAdd(provider)>=1) {
flag=true;
}
}catch(RuntimeException e) {
e.printStackTrace();
throw new RuntimeException("添加供应商错误"+e.getMessage());
}
return flag;
}
@Override
public boolean modifyProvider(Provider provider) {
String msg="";
boolean flag=false;
try {
if(null!=provider) {
if(providerMapper.modifyProvider(provider)>0)
flag=true;
}
}catch(RuntimeException e) {
throw new RuntimeException(msg+e);
}
return flag;
}
@Override
public boolean deleteProviderById(String id) {
boolean flag=false;
Integer nid=null;
String msg="";
try {
if(!StringUtils.isEmpty(id)) {
nid=Integer.parseInt(id);
if(providerMapper.deleteProviderById(nid)>0)
flag=true;
}else msg="参数为空!";
}catch(RuntimeException e) {
throw new RuntimeException(msg+e);
}
return flag;
}
@Override
public Provider getProvider(String id) {
String msg="";
Integer nid=null;
Provider provider=new Provider();
try {
if(!StringUtils.isEmpty(id)) {
nid=Integer.parseInt(id);
provider=providerMapper.getProvider(nid);
}else
msg="用户的id为空!";
}catch(RuntimeException e) {
throw new RuntimeException(msg+e);
}
return provider;
}
}
在Controller层中的ProviderController类中实现登录功能
package com.wei.controller;
import com.wei.pojo.Provider;
import com.wei.pojo.User;
import com.wei.service.ProviderService;
import com.wei.utils.Constants;
import com.wei.utils.PageHelper;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import javax.servlet.http.HttpSession;
import java.util.Date;
import java.util.List;
@Controller
public class ProviderController {
@Autowired
ProviderService providerService;
//添加供应商处理方法
@RequestMapping("/providerAddGo")
public String providerAddGo(Provider provider, HttpSession session) {
Provider pro=new Provider();
pro=provider;
Integer uid=null;
uid=((User) session.getAttribute(Constants.USER_SESSION)).getId();
if(null!=uid) {
pro.setCreatedBy(uid);
if(providerService.providerAdd(pro))
return "redirect:getProviders";
else
return "redirect:providerAdd";
}
else
return "/WEB-INF/login.jsp";
}
//添加供应商界面
@RequestMapping("/providerAdd")
public String providerAdd() {
return "providerAdd";
}
@RequestMapping("/getProviders")
public String getProviderList(String proName, Model md, String pageIndex) {
String strName="";
if(!StringUtils.isEmpty(proName)) {
strName=proName;
}
Integer currentPageNo=1;
Integer pageSize=Constants.pageSize;
if(!StringUtils.isEmpty(pageIndex)) {
currentPageNo=Integer.parseInt(pageIndex);
}
//根据条件获取总记录数
Integer totalCount=providerService.getProviderCount(strName);
//计算可以分几页
PageHelper pages=new PageHelper();
pages.setCurrentPageNo(currentPageNo);
pages.setPageSize(pageSize);
pages.setTotalCount(totalCount);
int totalPageCount = pages.getTotalPageCount();
List<Provider> providers=providerService.getProviderList(strName,(currentPageNo-1)*pageSize,pageSize);
md.addAttribute("totalPageCount", totalPageCount);
md.addAttribute("totalCount", totalCount);
md.addAttribute("currentPageNo", currentPageNo);
md.addAttribute("providers",providers);
return "providerList";
}
//添加修改界面
@RequestMapping("/modifyProvider")
public String modifyProvider(String id,Model md) {
Provider provider=new Provider();
provider=providerService.getProvider(id);
md.addAttribute("provider", provider);
return "modifyProvider";
}
//修改供应商
@RequestMapping("/modifyProviderGo")
public String modifyProviderGo(Provider provider,HttpSession session) {
Integer oid=((User)session.getAttribute(Constants.USER_SESSION)).getId();
if(null!=provider) {
provider.setModifyBy(oid);
provider.setModifyDate(new Date());
providerService.modifyProvider(provider);
}
return "redirect:getProviders";
}
//从ID获取某一个供应商信息
@RequestMapping("/viewProvider")
public String viewProvider(String id,Model md) {
Provider provider=new Provider();
provider=providerService.getProvider(id);
md.addAttribute("provider", provider);
return "viewProvider";
}
//删除供应商
@RequestMapping("deleteProviderById")
public String deleteProviderById(String id,Model md) {
String msg="";
if(providerService.deleteProviderById(id)) {
msg="删除订单成功!";
}else
msg="删除订单失败!";
md.addAttribute("msg", msg);
return "redirect:getProviders";
}
}
七、完善用户管理的增删改查功能(略)
总结
- 了解ssm开发思想由Dao层到Service层到controller层逐步实现业务功能
- 熟悉基础业务的使用,
- 熟悉spring注解开发,了解@