创建maven-web工程
-
创建包
-
导入依赖
mysql
mybatis
mybatis-plus
spring-webmvc -
配置web-xml文件
<!--spring--> <context-param> <param-name>contextConfigLocation</param-name> <param-value>classpath:spring.xml</param-value> </context-param> <listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> <!--spring-mvc--> <servlet> <servlet-name>app</servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> <init-param> <param-name>contextConfigLocation</param-name> <param-value>classpath:spring-mvc.xml</param-value> </init-param> </servlet> <servlet-mapping> <servlet-name>app</servlet-name> <url-pattern>/*</url-pattern> </servlet-mapping>
-
配置properties
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssm
jdbc.username=root
jdbc.password=root
- 配置springmvc.xml
<context:component-scan base-package="com.blb.controller"></context:component-scan>
- 配置spring.xml
<context:component-scan base-package="com.blb"></context:component-scan>
<!--加载外部properties文件-->
<context:property-placeholder location="classpath:mybatis.properties"/>
<!--数据源Bean-->
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
<property name="driverClassName" value="${jdbc.driver}"/>
<property name="url" value="${jdbc.url}"/>
<property name="username" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
</bean>
<!--sqlSessionFactory-->
<bean id="sqlSessionFactory" class="com.baomidou.mybatisplus.extension.spring.MybatisSqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"/>
<!--扫描映射器xml文件路径-->
<property name="mapperLocations" value="classpath:mappers/*.xml"/>
<!--别名-->
<property name="typeAliasesPackage" value="com.blb.entity"/>
<!--指定mybatis.xml所在路径-->
<!--<property name="configLocation" value="classpath:mybatis.xml"/>-->
<property name="configuration">
<bean class="com.baomidou.mybatisplus.core.MybatisConfiguration">
<!--开启驼峰-->
<property name="mapUnderscoreToCamelCase" value="true"/>
<!--开启日志-->
<property name="logImpl" value="org.apache.ibatis.logging.log4j.Log4jImpl"/>
</bean>
</property>
</bean>
<!--扫描mapper-->
<mybatis:scan base-package="com.blb.mappers"/>
- 配置log4j
# 全局日志配置
log4j.rootLogger=DEBUG, stdout
# MyBatis 日志配置
log4j.logger.com.blb.mapper=DEBUG
# 控制台输出
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n
- 配置userMapper.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.blb.mappers.UserMapper">
<select id="list" resultType="User">
select * from s_user;
</select>
</mapper>
9.java代码
service层
mapper层
entity层
controller层