本篇基于 idea 2019-03 版本创建
第一步:创建一个maven web 项目
Next后创建组名与项目名
Next后
Next后继续Finsh即可
联网状态默认会下载一些插件和依赖
删除之后
替换项目中WEB-INF下的web.xml版本为3.1 (默认2.3)
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="http://xmlns.jcp.org/xml/ns/javaee"
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
id="WebApp_ID" version="3.1">
</web-app>
先在pom中引入spring所需依赖
<properties>
<!-- 声明spring版本为5.1.5 -->
<spring.version>5.1.5.RELEASE</spring.version>
</properties>
<dependencies>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>test</scope>
</dependency>
<!--Spring官方依赖包 start-->
<!-- bean context core expression -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-beans</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context-support</artifactId>
<version>${spring.version}</version>
</dependency>
<!--Spring对JDBC的支持-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${spring.version}</version>
</dependency>
<!--spring测试jar,用于Junit单元测试-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>${spring.version}</version>
</dependency>
<!--spring aop官方包-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aop</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aspects</artifactId>
<version>${spring.version}</version>
</dependency>
<!--其他厂商aop支持依赖包-->
<dependency>
<groupId>aopalliance</groupId>
<artifactId>aopalliance</artifactId>
<version>1.0</version>
</dependency>
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjweaver</artifactId>
<version>1.9.2</version>
</dependency>
<!--Spring官方依赖包 end-->
</dependencies>
在项目main下创建resources文件夹,并创建applicationContext.xml配置文件 并配置context属性扫描
<?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 http://www.springframework.org/schema/context/spring-context.xsd">
<!--配置自动扫描包 路径以你的路径为准-->
<context:component-scan base-package="com.hliedu"/>
</beans>
在pom中接着引入spring-mvc依赖
<dependency>
//spring-mvc核心包
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>${spring.version}</version>
</dependency>
<!--文件上传依赖的jar包-->
<dependency>
<groupId>commons-fileupload</groupId>
<artifactId>commons-fileupload</artifactId>
<version>1.3.3</version>
</dependency>
<dependency>
<groupId>commons-io</groupId>
<artifactId>commons-io</artifactId>
<version>2.6</version>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.0.1</version>
<scope>provided</scope>
</dependency>
web.xml中配置springmvc核心控制器、字符编码、REST提交过滤器
<!--最前面添加过滤器-->
<filter>
<filter-name>encodingFilter</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>encodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!--SpringMVC是基于Servlet的-->
<servlet>
<servlet-name>dispatcherServlet</servlet-name>
<!--SpringMVC的核心控制器,中央控制器-->
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<!--默认加载springmvc.xml-->
<!-- 也可以修改为读取applicationContext.xml (推荐这种)
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath*:springmvc.xml</param-value>
</init-param>
<!--大于0 ,表示启动服务器加载-->
<load-on-startup>1</load-on-startup>
</servlet>
<!--Struts2 是基于拦截器 filter-->
<!--配置映射-->
<servlet-mapping>
<servlet-name>dispatcherServlet</servlet-name>
<!--映射根路径,所有的请求,包括静态资源都走 dispatcherServlet-->
<!--/* 一般是指拦截所有的请求,/是指跟目录映射-->
<url-pattern>/</url-pattern>
</servlet-mapping>
<!--发送PUT和DELETE请求需要配置的过滤器-->
<filter>
<filter-name>HiddenHttpMethodFilter</filter-name>
<filter-class>org.springframework.web.filter.HiddenHttpMethodFilter</filter-class>
</filter>
<filter-mapping>
<filter-name>HiddenHttpMethodFilter</filter-name>
<servlet-name>dispatcherServlet</servlet-name>
</filter-mapping>
新建spring-mvc配置文件
<?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"
xmlns:mvc="http://www.springframework.org/schema/mvc"
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">
</beans>
在applicationContext.xml中引入spring-mvc配置文件
<import resource="classpath*:spring-mvc.xml" />
注意:此时applicationContext.xml文件为核心配置,springmvc.xml为mvc配置,将来会有更多的类似于mvc这样的附属配置被加入到核心配置中。
所以需要修改web.xml中contextConfigLocation属性为applicationContext.xml
配置spring-mvc
<!--配置视图解析器-->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<!--配置视图前缀-->
<property name="prefix" value="/view/"/>
<!--配置视图解析后缀,目前的视图采用JSP-->
<property name="suffix" value=".jsp"/>
</bean>
<!--注解驱动-->
<mvc:annotation-driven/>
<!--注意:文件上传的配置,必须配置ID,而且ID的值固定为:multipartResolver-->
<bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
<!--最大的上传大小,字节 ,如果设置为-1的话,就表示无限制-->
<property name="maxUploadSize" value="102400"/>
<!--文件编码-->
<property name="defaultEncoding" value="UTF-8"/>
</bean>
在pom中引入mybatis所需依赖
<!--mybatis所需jar包-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.0</version>
</dependency>
<!--注意该jar包为com.mchange下的0.9.5.2版本-->
<dependency>
<groupId>com.mchange</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.5.2</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.13</version>
</dependency>
<!--逆向工程所需包-->
<dependency>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-core</artifactId>
<version>1.3.7</version>
</dependency>
<!--日志所需包-->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
<!-- Spring集成MyBatis -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.2</version>
</dependency>
在src/resources下创建jdbc配置文件,log4j日志配置文件
# 主要配置 log4j.properties
log4j.rootLogger=DEBUG,Console
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
log4j.logger.org.apache=INFO
# 电脑mysql版本与驱动依赖版本不同一样可以测试:例:本机5.5版本 mysql驱动8.0版本 一样可以运行
# jdbc.properties
jdbc.username=test
jdbc.password=123456
# mysql8 加入时区 mysql5删除?serverTimezone=UTC即可
jdbc.url=jdbc:mysql://localhost:3306/jdbcdb?serverTimezone=UTC
# 采用新版的cj驱动 mysql 5 删除cj即可
jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.maxActive=50
app.xml中读取jdbc配置文件
<context:property-placeholder location="classpath*:jdbc.properties" ignore-unresolvable="true"/>
<!-- C3P0数据源 用户名密码以自己为主 -->
<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="${jdbc.password}" />
</bean>
<!--sqlSessionFactory配置-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"/>
<!--注册映射文件-->
<property name="mapperLocations" value="classpath*:com/hliedu/hosweb/mapper/*Mapper.xml"/>
<!--配置别名, 扫描实体类包,不支持ant通配符风格,必须配置到位-->
<property name="typeAliasesPackage">
<value>
com.hliedu.hosweb.domain
<!--可换行配置多个-->
</value>
</property>
</bean>
<!--MyBatis中Mapper接口的扫描-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<!--配置mapper接口所在的包-->
<property name="basePackage" value="com.hliedu.hosweb.mapper"/>
</bean>
配置完成,编写测试代码
新建com.hliedu.hosweb.domain.User类
public class User {
private Integer id;
private Integer usercode;
private String username;
private String password;
private String shenfen;
//set get ......
新建com.hliedu.hosweb.mapper.UserMapper类
@Repository
public interface UserMapper {
//查询方法
List<User> findUser();
新建com.hliedu.hosweb.service.UserService类
public interface UserService {
List<User> findUser();
新建com.hliedu.hosweb.service.UserServiceImpl类
@Service
public class UserServiceImpl implements UserService {
//属性注入
@Autowired
UserMapper userMapper;
//查询方法
public List<User> findUser() {
return userMapper.findUser();
}
在src/resources下创建包com.hliedu.hosweb.mapper,编写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">
<!--注意namespace所指定的接口-->
<mapper namespace="com.hliedu.hosweb.mapper.UserMapper">
<!--注意statement配置与接口中的方法描述一致-->
<select id="findUser" resultType="user">
select * from user
</select>
编写Controller层
新建com.hliedu.hosweb.controller.UserControlller类
@Controller
@RequestMapping("user")
public class UserContorller {
@Autowired
private UserService userService;
@RequestMapping("find")
public String find(Model model){
List<User> userList = userService.findUser();
model.addAttribute("userList",userList);
return "UserList";
}
在wepapp下创建view文件夹并编写userList页面
userList.jsp取值
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<h1>${userList}</h1>
</body>
</html>
运行tomcat并访问user/find
运行成功:数据展示在浏览器
数据库数据
第一次写博客,有什么问题可以指正,谢谢!