一:后端配置
1、(设置里面)配置maven本地仓库
2、 配置Tomcat
2.1点击编辑配置
2.2.1点击左上角加号搜索tomcat,点击本地配置JDK
2.2.2点击部署,点击加号选择工作,然后选下面那个长的,应用程序上下文里面可以编辑成自己想要的路径
3、配置resource里jdbc.properties文件,设置好自己的数据库,用户名,密码
(其他的可以自己选择配好至可以运行为止)
二:后端代码
1、mapper.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.zking.ssm.mapper.OrderMapper">
<resultMap id="BaseResultMap" type="com.zking.ssm.model.Order">
<id column="id" jdbcType="INTEGER" property="id" />
<result column="order_desc" jdbcType="VARCHAR" property="orderDesc" />
<result column="amount" jdbcType="FLOAT" property="amount" />
<result column="cust_name" jdbcType="VARCHAR" property="custName" />
<result column="cust_phone" jdbcType="VARCHAR" property="custPhone" />
<result column="cust_addr" jdbcType="VARCHAR" property="custAddr" />
</resultMap>
<sql id="Base_Column_List">
id, order_desc, amount, cust_name, cust_phone, cust_addr
</sql>
<select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultMap="BaseResultMap">
select
<include refid="Base_Column_List" />
from t_order
where id = #{id,jdbcType=INTEGER}
</select>
<select id="listOrders" resultType="com.zking.ssm.model.Order">
select
<include refid="Base_Column_List" />
from t_order
<where>
<if test="orderDesc != null and orderDesc != ''">
and order_desc like concat(#{orderDesc,jdbcType=VARCHAR}, '%')
</if>
</where>
</select>
<delete id="deleteByPrimaryKey" parameterType="java.lang.Integer">
delete from t_order
where id = #{id,jdbcType=INTEGER}
</delete>
<insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.zking.ssm.model.Order" useGeneratedKeys="true">
insert into t_order (order_desc, amount, cust_name,
cust_phone, cust_addr)
values (#{orderDesc,jdbcType=VARCHAR}, #{amount,jdbcType=FLOAT}, #{custName,jdbcType=VARCHAR},
#{custPhone,jdbcType=VARCHAR}, #{custAddr,jdbcType=VARCHAR})
</insert>
<insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.zking.ssm.model.Order" useGeneratedKeys="true">
insert into t_order
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="orderDesc != null">
order_desc,
</if>
<if test="amount != null">
amount,
</if>
<if test="custName != null"