一、项目结构示意图
项目结构
二、pom文件配置
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>org.caiweiwei</groupId>
<artifactId>Jetty</artifactId>
<version>1.0-SNAPSHOT</version>
<!--必须改成war-->
<packaging>war</packaging>
<dependencies>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>5.1.6.RELEASE</version>
</dependency>
<!-- SpringMVC支持的JSON序列化工具包Jackson -->
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-core</artifactId>
<version>2.9.8</version>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-annotations</artifactId>
<version>2.9.8</version>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
<version>2.9.8</version>
</dependency>
<!-- freemarker核心jar -->
<dependency>
<groupId>org.freemarker</groupId>
<artifactId>freemarker</artifactId>
<version>2.3.28</version>
</dependency>
<!--SpringFramework整合三方组件的支持包-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context-support</artifactId>
<version>5.1.6.RELEASE</version>
</dependency>
<!--SM整合依赖-->
<!--Spring的JDBC封装组件-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>5.1.6.RELEASE</version>
</dependency>
<!--引入mybatisplus-->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus</artifactId>
<version>3.1.0</version>
</dependency>
<!--Mybatis核心组件若使用mybatis则这样配置-->
<!--<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.0</version>
</dependency>-->
<!--Mybatis与Spring整合组件-->
<!--<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.2</version>
</dependency>-->
<!--Druid连接池-->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.13</version>
</dependency>
<!--MySql 5.xJDBC驱动-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.47</version>
</dependency>
<!--引入日志包-->
<dependency>
<groupId>ch.qos.logback</groupId>
<artifactId>logback-classic</artifactId>
<version>1.2.3</version>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.eclipse.jetty</groupId>
<artifactId>jetty-maven-plugin</artifactId>
<version>9.4.14.v20181114</version>
<configuration>
<webApp>
<!--找到修改后的xml文件-->
<defaultsDescriptor>src/main/resources/webdefault.xml</defaultsDescriptor>
</webApp>
<!--启动后去加载webapp网页与资源-->
<webAppSourceDirectory>src/main/webapp</webAppSourceDirectory>
<httpConnector>
<port>80</port>
</httpConnector>
</configuration>
</plugin>
</plugins>
</build>
</project>
三、application配置
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xmlns:context="http://www.springframework.org/schema/context"
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.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd">
<!-- 启用Spring注解形式扫描对象 -->
<context:component-scan base-package="com.caiweiwei"></context:component-scan>
<!-- 启用Spring MVC的注解模式 -->
<mvc:annotation-driven>
<mvc:message-converters>
<!--StringHttpMessageConverter 用于设置文本类型http响应的设置-->
<bean class="org.springframework.http.converter.StringHttpMessageConverter">
<!--配置支持的媒体类型（MIME)-->
<property name="supportedMediaTypes">
<list>
<!-- 响应输出的文本被浏览器作为html进行解释，使用字符集为UTF-8 -->
<value>text/html;charset=utf-8</value>
</list>
</property>
</bean>
</mvc:message-converters>
</mvc:annotation-driven>
<!--将静态资源排除在外-->
<mvc:default-servlet-handler></mvc:default-servlet-handler>
<!-- FreeMarkerViewResolver是Spring-Context-Support提供的整合类，
在IOC容器初始化时通知SpringMVC默认使用Freemarker进行数据展现
-->
<bean id="ViewResolver" class="org.springframework.web.servlet.view.freemarker.FreeMarkerViewResolver">
<!-- 设置响应输出，并解决中文乱码 -->
<property name="contentType" value="text/html;charset=utf-8"></property>
<!-- 指定Freemarker模板文件扩展名 -->
<property name="suffix" value=".ftl"/>
</bean>
<!--Freemarker设置类-->
<bean id="freemarkerConfig" class="org.springframework.web.servlet.view.freemarker.FreeMarkerConfigurer">
<!--设置模板保存的目录-->
<property name="templateLoaderPath" value="/WEB-INF/ftl"/>
<!--其他模板引擎设置-->
<property name="freemarkerSettings">
<props>
<!--设置Freemarker脚本与数据渲染时使用的字符集-->
<prop key="defaultEncoding">UTF-8</prop>
</props>
</property>
</bean>
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
<!-- 定义数据库 -->
<property name="driverClassName" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/data?useUnicode=true&characterEncoding=UTF-8"/>
<property name="username" value="root"/>
<property name="password" value="root"/>
<!--初始化连接池的时候默认创建5个连接-->
<property name="initialSize" value="5"/>
<!--最大连接数量-->
<property name="maxActive" value="20"/>
<!-- 设置空闲连接数最少为5个 -->
<property name="minIdle" value="5"/>
<!-- 数据库连接最大等待时间60秒 -->
<property name="maxWait" value="60000"/>
<!--是否在分配连接时测试连接有效性-->
<property name="testOnBorrow" value="false"/>
<!--是否在连接空闲状态时测试连接有效性-->
<property name="testWhileIdle" value="true"/>
<!--是否在归还连接时测试有效性-->
<property name="testOnReturn" value="false"/>
<!--测试有效性的SQL语句-->
<property name="validationQuery" value="SELECT 1"/>
<!--filters用于开启监控过滤器
stat 是SQL及Web监控
wall 是预防SQL注入攻击
slf4j 是日志输出-->
<property name="filters" value="stat,wall,slf4j"/>
<!--mergeSQL对相同SQL进行合并
slowSqlMillis定义超过500毫秒执行时间的SQL为慢查询-->
<property name="connectionProperties" value="druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500"/>
</bean>
<!--定义sqlSessionFactory连接工厂-->
<!-- MybatisSqlSessionFactoryBean对Mybatis-Spring整合插件进行了重写与扩展.提供自动生成SQL的功能 -->
<bean id="sqlSessionFactory" class="com.baomidou.mybatisplus.extension.spring.MybatisSqlSessionFactoryBean">
<!--关联数据源-->
<property name="dataSource" ref="dataSource"/>
<!--配置文件地址-->
<property name="configLocation" value="classpath:mybatis-config.xml"/>
<!--mapper XML文件保存目录-->
<property name="mapperLocations" value="classpath:mappers/*.xml"/>
<!-- mapper resource="goods.xml" -->
</bean>
<!--Spring为Mybatis提供了一种新的开发方式“Mapper接口”，
这个配置用于扫描com.itlaoqi.ssm包下所有有效的Mapper接口类-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.caiweiwei.ssm"/>
</bean>
<!-- 事务管理器transactionManager提供了声明式事务的支持,在程序成功提交,运行时异常回滚 -->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"/>
</bean>
<!-- 开启注解形式的声明式事务 -->
<tx:annotation-driven transaction-manager="transactionManager"/>
</beans>
四、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>
<settings>
<!--驼峰命名转换-->
<setting name="mapUnderscoreToCamelCase" value="true"/>
</settings>
<!--开启Mybatis-Plus分页功能-->
<plugins>
<plugin interceptor="com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor">
</plugin>
</plugins>
</configuration>
五、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_3_1.xsd"
version="3.1">
<servlet>
<servlet-name>springmvc</servlet-name>
<!-- 用于拦截请求，创建对应的Controller进行处理 -->
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<!-- 指明在DispatcherServlet初始化时加载的配置文件 -->
<param-name>contextConfigLocation</param-name>
<param-value>classpath:applicationContext.xml</param-value>
</init-param>
<!-- 在启动时对Servlet进行加载，0代表被先被加载 -->
<load-on-startup>0</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>springmvc</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
<filter>
<filter-name>characterFilter</filter-name>
<!-- CharacterEncodingFilter 将Post请求中的参数字符集设置为UTF-8-->
<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>characterFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!--Druid连接池监控界面-->
<!--DruidWebStateFilter过滤器用于数据收集-->
<filter>
<filter-name>DruidWebStateFilter</filter-name>
<filter-class>com.alibaba.druid.support.http.WebStatFilter</filter-class>
<init-param>
<param-name>exclusions</param-name>
<param-value>*.js,*.gif,*.jpg,*.css,*.ico,/druid/*</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>DruidWebStateFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!--配置Druid监控页面-->
<servlet>
<servlet-name>DruidServlet</servlet-name>
<servlet-class>com.alibaba.druid.support.http.StatViewServlet</servlet-class>
<init-param>
<param-name>loginUsername</param-name>
<param-value>admin</param-value>
</init-param>
<init-param>
<param-name>loginPassword</param-name>
<param-value>123456</param-value>
</init-param>
</servlet>
<servlet-mapping>
<servlet-name>DruidServlet</servlet-name>
<url-pattern>/druid/*</url-pattern>
</servlet-mapping>
</web-app>
六、具体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.caiweiwei.ssm.mapper.GoodsDetailMapper">
<!--使用mybatis-plus分页插件后,必须在引用参数时增加#{前缀.xxx}-->
<select id="selectMap" parameterType="java.util.Map" resultType="java.util.LinkedHashMap">
select
d.* , g.title
from
t_goods_detail d , t_goods g
where
d.goods_id = g.goods_id
and d.gd_order = #{p.order}
and d.goods_id = #{p.goodsId}
</select>
</mapper>
七、对应接口编写
package com.caiweiwei.ssm.mapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.caiweiwei.ssm.entity.GoodsDetail;
import org.apache.ibatis.annotations.Param;
import java.util.Map;
//BaseMapper定义了CRUD的方法声明,在运行时会自动根据实体的注解生成对应的SQL语句
public interface GoodsDetailMapper extends BaseMapper<GoodsDetail> {
/**
* 自定义SQL分页查询
* @param page 第一个对象固定为分页对象
* @param param 第二个参数Map向SQL传递多参数,但要使用@Param()定义前缀
* @return 返回分页结果
*/
public IPage<Map> selectMap(IPage page ,@Param("p") Map param);
}
八、对应实体类
package com.caiweiwei.ssm.entity;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
//@TableName设置实体与表的对应关系
@TableName("t_goods_detail")
public class GoodsDetail {
//@TableId用于设置主键属性
//IdType.AUTO是指自动利用Mysql底层的自动生成功能产生主键
//主键生成后会自动回填到gdId属性
@TableId(type = IdType.AUTO)
private Integer gdId;
private Integer goodsId;//goods_id
//如果属性与字段名对应不上,则需要使用@TableField进行说明
@TableField("gd_pic_url")
private String picUrl;//gd_pic_url
// @TableField("gd_order")
private Integer gdOrder;
public Integer getGdId() {
return gdId;
}
public void setGdId(Integer gdId) {
this.gdId = gdId;
}
public Integer getGoodsId() {
return goodsId;
}
public void setGoodsId(Integer goodsId) {
this.goodsId = goodsId;
}
public String getPicUrl() {
return picUrl;
}
public void setPicUrl(String picUrl) {
this.picUrl = picUrl;
}
public Integer getGdOrder() {
return gdOrder;
}
public void setGdOrder(Integer gdOrder) {
this.gdOrder = gdOrder;
}
}
网友评论