Intellij 基于Maven聚合工程 SSM框架整合

作者: 054ab278d5d9 | 来源:发表于2019-03-21 17:55 被阅读0次

三、maven工程下创建resources文件夹

步骤：File——>Project Struture——>Modules——>maven工程，如果没有maven工程就点+号来添加

选择到创建resources文件夹的路径，比如图上的选择到main，右击鼠标，选择New Folder新建文件夹resources

再选择resources，右击鼠标选择Resources，可以看到resources文件夹的图标和之前不一样了，就是这样创建一个resources文件夹。再点Ok保存退出。

很明图标都不一样了。

四、整合ssm框架

直接看项目路径，直接上代码，不懂ssm框架整合的可以百度学习下。

SqlMapConfig.xml

View Code

<?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>

</configuration>

db.properties

View Code

jdbc.driver=com.mysql.jdbc.Driver

jdbc.url=jdbc:mysql://localhost:3306/e3mall?charactherEncoding=utf-8

jdbc.username=root

jdbc.password=*****

applicationContext-Dao.xml

View Code

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

xmlns:context="http://www.springframework.org/schema/context" xmlns:p="http://www.springframework.org/schema/p"

xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

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/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

http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.2.xsd">





<context:property-placeholder location="classpath:properties/db.properties"></context:property-placeholder>



<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">

<property name="driverClassName" value="${jdbc.driver}"></property>

<property name="url" value="${jdbc.url}"></property>

<property name="username" value="${jdbc.username}"></property>

<property name="password" value="${jdbc.password}"></property>

<property name="maxActive" value="10"></property>

<property name="minIdle" value="5"></property>

</bean>



<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">



<property name="dataSource" ref="dataSource"></property>



<property name="configLocation" value="classpath:mybatis/SqlMapConfig.xml"></property>

</bean>



<bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">

<property name="basePackage" value="cn.e3mall.mapper"></property>

</bean>

</beans>

applicationContext-service.xml

View Code

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

xmlns:context="http://www.springframework.org/schema/context" xmlns:p="http://www.springframework.org/schema/p"

xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

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/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

http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.2.xsd">

<context:component-scan base-package="cn.e3mall.service"></context:component-scan>

</beans>

applicationContext-trans.xml

View Code

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

xmlns:context="http://www.springframework.org/schema/context" xmlns:p="http://www.springframework.org/schema/p"

xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

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/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

http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.2.xsd">



<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">



<property name="dataSource" ref="dataSource"/>

</bean>



<tx:advice id="txAdvice" transaction-manager="transactionManager">

<tx:attributes>

<tx:method name="save*" propagation="REQUIRED"/>

<tx:method name="insert*" propagation="REQUIRED"/>

<tx:method name="add*" propagation="REQUIRED"/>

<tx:method name="create*" propagation="REQUIRED"/>

<tx:method name="delete*" propagation="REQUIRED"/>

<tx:method name="update*" propagation="REQUIRED"/>

<tx:method name="find*" propagation="SUPPORTS" read-only="true"/>

<tx:method name="select*" propagation="SUPPORTS" read-only="true"/>

<tx:method name="get*" propagation="SUPPORTS" read-only="true"/>

</tx:attributes>

</tx:advice>



<aop:config>

<aop:advisor advice-ref="txAdvice" pointcut="execution(* cn.e3mall.mapper.*.*(..))"></aop:advisor>

</aop:config>

</beans>

springmvc.xml

View Code

<?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.2.xsd

http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.2.xsd

http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.2.xsd">



<context:component-scan base-package="cn.e3mall.controller"/>



<mvc:annotation-driven></mvc:annotation-driven>



<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">

<property name="prefix" value="/WEB-INF/jsp/"/>

<property name="suffix" value=".jsp"/>

</bean>

</beans>

web.xml

View Code

<?xml version="1.0" encoding="UTF-8"?>

<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xmlns="http://java.sun.com/xml/ns/javaee"

xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"

id="WebApp_ID" version="2.5">

<display-name>e3-manager</display-name>

<welcome-file-list>

<welcome-file>index.jsp</welcome-file>

</welcome-file-list>



<context-param>

<param-name>contextConfigLocation</param-name>

<param-value>classpath:spring/applicationContext-*.xml</param-value>

</context-param>

<listener>

<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>

</listener>



<filter>

<filter-name>CharacterEncodingFilter</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>

</filter>

<filter-mapping>

<filter-name>CharacterEncodingFilter</filter-name>

<url-pattern>/*</url-pattern>

</filter-mapping>



<servlet>

<servlet-name>e3-manager</servlet-name>

<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>

<init-param>

<param-name>contextConfigLocation</param-name>

<param-value>classpath:spring/springmvc.xml</param-value>

</init-param>

<load-on-startup>1</load-on-startup>

</servlet>

<servlet-mapping>

<servlet-name>e3-manager</servlet-name>

<url-pattern>/</url-pattern>

</servlet-mapping>

</web-app>

TbItem.class

View Code

package cn.e3mall.pojo;

import java.util.Date;

public class TbItem {

private Long id;

private String title;

private String sellPoint;

private Long price;

private Integer num;

private String barcode;

private String image;

private Long cid;

private Byte status;

private Date created;

private Date updated;

public Long getId() {

return id;

}

public void setId(Long id) {

this.id = id;

}

public String getTitle() {

return title;

}

public void setTitle(String title) {

this.title = title == null ? null : title.trim();

}

public String getSellPoint() {

return sellPoint;

}

public void setSellPoint(String sellPoint) {

this.sellPoint = sellPoint == null ? null : sellPoint.trim();

}

public Long getPrice() {

return price;

}

public void setPrice(Long price) {

this.price = price;

}

public Integer getNum() {

return num;

}

public void setNum(Integer num) {

this.num = num;

}

public String getBarcode() {

return barcode;

}

public void setBarcode(String barcode) {

this.barcode = barcode == null ? null : barcode.trim();

}

public String getImage() {

return image;

}

public void setImage(String image) {

this.image = image == null ? null : image.trim();

}

public Long getCid() {

return cid;

}

public void setCid(Long cid) {

this.cid = cid;

}

public Byte getStatus() {

return status;

}

public void setStatus(Byte status) {

this.status = status;

}

public Date getCreated() {

return created;

}

public void setCreated(Date created) {

this.created = created;

}

public Date getUpdated() {

return updated;

}

public void setUpdated(Date updated) {

this.updated = updated;

}

}

TbItemMapper.class 接口

View Code

package cn.e3mall.mapper;

import cn.e3mall.pojo.TbItem;

import cn.e3mall.pojo.TbItemExample;

import java.util.List;

import org.apache.ibatis.annotations.Param;

public interface TbItemMapper {

int countByExample(TbItemExample example);

int deleteByExample(TbItemExample example);

int deleteByPrimaryKey(Long id);

int insert(TbItem record);

int insertSelective(TbItem record);

List<TbItem> selectByExample(TbItemExample example);

TbItem selectByPrimaryKey(Long id);

int updateByExampleSelective(@Param("record") TbItem record, @Param("example") TbItemExample example);

int updateByExample(@Param("record") TbItem record, @Param("example") TbItemExample example);

int updateByPrimaryKeySelective(TbItem record);

int updateByPrimaryKey(TbItem record);

}

TbItemMapper.xml

View Code

<?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="cn.e3mall.mapper.TbItemMapper" >

<resultMap id="BaseResultMap" type="cn.e3mall.pojo.TbItem" >

<id column="id" property="id" jdbcType="BIGINT" />

<result column="title" property="title" jdbcType="VARCHAR" />

<result column="sell_point" property="sellPoint" jdbcType="VARCHAR" />

<result column="price" property="price" jdbcType="BIGINT" />

<result column="num" property="num" jdbcType="INTEGER" />

<result column="barcode" property="barcode" jdbcType="VARCHAR" />

<result column="image" property="image" jdbcType="VARCHAR" />

<result column="cid" property="cid" jdbcType="BIGINT" />

<result column="status" property="status" jdbcType="TINYINT" />

<result column="created" property="created" jdbcType="TIMESTAMP" />

<result column="updated" property="updated" jdbcType="TIMESTAMP" />

</resultMap>

<sql id="Example_Where_Clause" >

<where >

<foreach collection="oredCriteria" item="criteria" separator="or" >

<if test="criteria.valid" >

<trim prefix="(" suffix=")" prefixOverrides="and" >

<foreach collection="criteria.criteria" item="criterion" >

<choose >

<when test="criterion.noValue" >

and ${criterion.condition}

</when>

<when test="criterion.singleValue" >

and ${criterion.condition} #{criterion.value}

</when>

<when test="criterion.betweenValue" >

and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}

</when>

<when test="criterion.listValue" >

and ${criterion.condition}

<foreach collection="criterion.value" item="listItem" open="(" close=")" separator="," >

#{listItem}

</foreach>

</when>

</choose>

</foreach>

</trim>

</if>

</foreach>

</where>

</sql>

<sql id="Update_By_Example_Where_Clause" >

<where >

<foreach collection="example.oredCriteria" item="criteria" separator="or" >

<if test="criteria.valid" >

<trim prefix="(" suffix=")" prefixOverrides="and" >

<foreach collection="criteria.criteria" item="criterion" >

<choose >

<when test="criterion.noValue" >

and ${criterion.condition}

</when>

<when test="criterion.singleValue" >

and ${criterion.condition} #{criterion.value}

</when>

<when test="criterion.betweenValue" >

and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}

</when>

<when test="criterion.listValue" >

and ${criterion.condition}

<foreach collection="criterion.value" item="listItem" open="(" close=")" separator="," >

#{listItem}

</foreach>

</when>

</choose>

</foreach>

</trim>

</if>

</foreach>

</where>

</sql>

<sql id="Base_Column_List" >

id, title, sell_point, price, num, barcode, image, cid, status, created, updated

</sql>

<select id="selectByExample" resultMap="BaseResultMap" parameterType="cn.e3mall.pojo.TbItemExample" >

select

<if test="distinct" >

distinct

</if>

<include refid="Base_Column_List" />

from tb_item

<if test="_parameter != null" >

<include refid="Example_Where_Clause" />

</if>

<if test="orderByClause != null" >

order by ${orderByClause}

</if>

</select>

<select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Long" >

select

<include refid="Base_Column_List" />

from tb_item

where id = #{id,jdbcType=BIGINT}

</select>

<delete id="deleteByPrimaryKey" parameterType="java.lang.Long" >

delete from tb_item

where id = #{id,jdbcType=BIGINT}

</delete>

<delete id="deleteByExample" parameterType="cn.e3mall.pojo.TbItemExample" >

delete from tb_item

<if test="_parameter != null" >

<include refid="Example_Where_Clause" />

</if>

</delete>

<insert id="insert" parameterType="cn.e3mall.pojo.TbItem" >

insert into tb_item (id, title, sell_point,

price, num, barcode,

image, cid, status,

created, updated)

values (#{id,jdbcType=BIGINT}, #{title,jdbcType=VARCHAR}, #{sellPoint,jdbcType=VARCHAR},

#{price,jdbcType=BIGINT}, #{num,jdbcType=INTEGER}, #{barcode,jdbcType=VARCHAR},

#{image,jdbcType=VARCHAR}, #{cid,jdbcType=BIGINT}, #{status,jdbcType=TINYINT},

#{created,jdbcType=TIMESTAMP}, #{updated,jdbcType=TIMESTAMP})

</insert>

<insert id="insertSelective" parameterType="cn.e3mall.pojo.TbItem" >

insert into tb_item

<trim prefix="(" suffix=")" suffixOverrides="," >

<if test="id != null" >

id,

</if>

<if test="title != null" >

title,

</if>

<if test="sellPoint != null" >

sell_point,

</if>

<if test="price != null" >

price,

</if>

<if test="num != null" >

num,

</if>

<if test="barcode != null" >

barcode,

</if>

<if test="image != null" >

image,

</if>

<if test="cid != null" >

cid,

</if>

<if test="status != null" >

status,

</if>

<if test="created != null" >

created,

</if>

<if test="updated != null" >

updated,

</if>

</trim>

<trim prefix="values (" suffix=")" suffixOverrides="," >

<if test="id != null" >

#{id,jdbcType=BIGINT},

</if>

<if test="title != null" >

#{title,jdbcType=VARCHAR},

</if>

<if test="sellPoint != null" >

#{sellPoint,jdbcType=VARCHAR},

</if>

<if test="price != null" >

#{price,jdbcType=BIGINT},

</if>

<if test="num != null" >

#{num,jdbcType=INTEGER},

</if>

<if test="barcode != null" >

#{barcode,jdbcType=VARCHAR},

</if>

<if test="image != null" >

#{image,jdbcType=VARCHAR},

</if>

<if test="cid != null" >

#{cid,jdbcType=BIGINT},

</if>

<if test="status != null" >

#{status,jdbcType=TINYINT},

</if>

<if test="created != null" >

#{created,jdbcType=TIMESTAMP},

</if>

<if test="updated != null" >

#{updated,jdbcType=TIMESTAMP},

</if>

</trim>

</insert>

<select id="countByExample" parameterType="cn.e3mall.pojo.TbItemExample" resultType="java.lang.Integer" >

select count(*) from tb_item

<if test="_parameter != null" >

<include refid="Example_Where_Clause" />

</if>

</select>

<update id="updateByExampleSelective" parameterType="map" >

update tb_item

<set >

<if test="record.id != null" >

id = #{record.id,jdbcType=BIGINT},

</if>

<if test="record.title != null" >

title = #{record.title,jdbcType=VARCHAR},

</if>

<if test="record.sellPoint != null" >

sell_point = #{record.sellPoint,jdbcType=VARCHAR},

</if>

<if test="record.price != null" >

price = #{record.price,jdbcType=BIGINT},

</if>

<if test="record.num != null" >

num = #{record.num,jdbcType=INTEGER},

</if>

<if test="record.barcode != null" >

barcode = #{record.barcode,jdbcType=VARCHAR},

</if>

<if test="record.image != null" >

image = #{record.image,jdbcType=VARCHAR},

</if>

<if test="record.cid != null" >

cid = #{record.cid,jdbcType=BIGINT},

</if>

<if test="record.status != null" >

status = #{record.status,jdbcType=TINYINT},

</if>

<if test="record.created != null" >

created = #{record.created,jdbcType=TIMESTAMP},

</if>

<if test="record.updated != null" >

updated = #{record.updated,jdbcType=TIMESTAMP},

</if>

</set>

<if test="_parameter != null" >

<include refid="Update_By_Example_Where_Clause" />

</if>

</update>

<update id="updateByExample" parameterType="map" >

update tb_item

set id = #{record.id,jdbcType=BIGINT},

title = #{record.title,jdbcType=VARCHAR},

sell_point = #{record.sellPoint,jdbcType=VARCHAR},

price = #{record.price,jdbcType=BIGINT},

num = #{record.num,jdbcType=INTEGER},

barcode = #{record.barcode,jdbcType=VARCHAR},

image = #{record.image,jdbcType=VARCHAR},

cid = #{record.cid,jdbcType=BIGINT},

status = #{record.status,jdbcType=TINYINT},

created = #{record.created,jdbcType=TIMESTAMP},

updated = #{record.updated,jdbcType=TIMESTAMP}

<if test="_parameter != null" >

<include refid="Update_By_Example_Where_Clause" />

</if>

</update>

<update id="updateByPrimaryKeySelective" parameterType="cn.e3mall.pojo.TbItem" >

update tb_item

<set >

<if test="title != null" >

title = #{title,jdbcType=VARCHAR},

</if>

<if test="sellPoint != null" >

sell_point = #{sellPoint,jdbcType=VARCHAR},

</if>

<if test="price != null" >

price = #{price,jdbcType=BIGINT},

</if>

<if test="num != null" >

num = #{num,jdbcType=INTEGER},

</if>

<if test="barcode != null" >

barcode = #{barcode,jdbcType=VARCHAR},

</if>

<if test="image != null" >

image = #{image,jdbcType=VARCHAR},

</if>

<if test="cid != null" >

cid = #{cid,jdbcType=BIGINT},

</if>

<if test="status != null" >

status = #{status,jdbcType=TINYINT},

</if>

<if test="created != null" >

created = #{created,jdbcType=TIMESTAMP},

</if>

<if test="updated != null" >

updated = #{updated,jdbcType=TIMESTAMP},

</if>

</set>

where id = #{id,jdbcType=BIGINT}

</update>

<update id="updateByPrimaryKey" parameterType="cn.e3mall.pojo.TbItem" >

update tb_item

set title = #{title,jdbcType=VARCHAR},

sell_point = #{sellPoint,jdbcType=VARCHAR},

price = #{price,jdbcType=BIGINT},

num = #{num,jdbcType=INTEGER},

barcode = #{barcode,jdbcType=VARCHAR},

image = #{image,jdbcType=VARCHAR},

cid = #{cid,jdbcType=BIGINT},

status = #{status,jdbcType=TINYINT},

created = #{created,jdbcType=TIMESTAMP},

updated = #{updated,jdbcType=TIMESTAMP}

where id = #{id,jdbcType=BIGINT}

</update>

</mapper>

ItemService.class 接口

View Code

package cn.e3mall.service;

import cn.e3mall.pojo.TbItem;

/**

* 商品管理Service

*/

public interface ItemService {

/**

* 根据商品id查询商品信息

*

* @param id

* @return

*/

public TbItem getItemByid(long id);

}

ItemServiceImpl.class 实现类

View Code

package cn.e3mall.service.impl;

import cn.e3mall.service.ItemService;

import cn.e3mall.mapper.TbItemMapper;

import cn.e3mall.pojo.TbItem;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Service;

/**

* 商品管理Service

*/

@Service

class ItemServiceImpl implements ItemService {

@Autowired

private TbItemMapper itemMapper;

/**

* 根据id查询商品

* @param id

* @return

*/

@Override

public TbItem getItemByid(long id) {

TbItem item = itemMapper.selectByPrimaryKey(id);

return item;

}

}

ItemController.Class

package cn.e3mall.controller;

import cn.e3mall.service.ItemService;

import cn.e3mall.pojo.TbItem;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Controller;

import org.springframework.web.bind.annotation.PathVariable;

import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.bind.annotation.ResponseBody;

/**

* 商品管理Controller

*/

@Controller

public class ItemController {

@Autowired

private ItemService itemService;

@RequestMapping("/item/{itemId}")

@ResponseBody

public TbItem getItemById(@PathVariable Long itemId){

System.out.println(itemId);

TbItem item=itemService.getItemByid(itemId);

System.out.println(item.toString());

return item;

}

}