本篇文章主要内容是介绍如何使用IntelliJ IDEA创建spring + SpringMVC + MyBatis项目,下面会给出项目搭建的详细步骤以及相关的配置文件。
代码下载地址:http://download.csdn.net/detail/lijinzhou2017/9861191
1. 创建maven项目
1.1 File -> New Module,进入创建项目窗口。
1.2 点击Next,填写GroupId、ArtifactId和Version
1.3 接着下一步,这里需要注在Properties中添加一个参数 archetypeCatalog=internal,不加这个参数,在maven生成骨架的时候将会非常慢,有时候直接卡住。
来自网上的解释:
archetypeCatalog表示插件使用的archetype元数据,不加这个参数时默认为remote,local,即中央仓库archetype元数据,由于中央
仓库的archetype太多了所以导致很慢,指定internal来表示仅使用内部元数据。
1
.4 填写Module name
1.5 生成maven的项目骨架之后,我们还需要手动在 src/main 下创建 java目录。现在可以直接编写了,我把项目所需要的文件都编写完成之后,项目的工程结构如图。
到此为止,项目的框架基本搭建完成,下面重点说一下项目的配置文件
sql语句:
/*
Navicat MySQL Data Transfer
Source Server : zhangxq
Source Server Version : 50051
Source Host : localhost:3306
Source Database : db_ssm
Target Server Type : MYSQL
Target Server Version : 50051
File Encoding : 65001
Date: 2016-07-17 13:23:09
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `t_user`
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
`id` bigint(11) NOT NULL auto_increment,
`user_name` varchar(255) default NULL COMMENT '用户名',
`user_phone` varchar(20) default NULL COMMENT '手机号',
`user_email` varchar(255) default NULL COMMENT '邮箱地址',
`user_pwd` varchar(32) default NULL COMMENT '加盐后用户密码',
`pwd_salt` varchar(6) default NULL COMMENT 'MD5盐',
`create_time` datetime default NULL COMMENT '创建时间',
`modify_time` datetime default NULL COMMENT '最后修改时间',
`is_delete` tinyint(4) default NULL COMMENT '是否删除,0-未删除;1-已删除',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='用户登录表';
-- ----------------------------
-- Records of t_user
-- ----------------------------
INSERT INTO `t_user` VALUES ('1', '赵大宝', '13285250574', '1045221654@qq.com', '05126a423a9379d529e4ee61a212fa55', 'KJUYT5', '2016-07-15 23:38:56', '2016-07-15 23:39:09', '0');
INSERT INTO `t_user` VALUES ('2', '张三丰', '15985250574', '1198224554@qq.com', '98bd3a1bebde01ad363d3c5a0d1e56da', '656JHU', '2016-07-15 23:39:01', '2016-07-15 23:39:13', '0');
INSERT INTO `t_user` VALUES ('3', '王尼玛', '13685250574', '1256221654@qq.com', '5470db9b63c354f6c8d628b80ae2f3c3', '89UIKQ', '2016-07-15 23:39:05', '2016-07-15 23:39:16', '0');
mapping中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.heitian.ssm.dao.UserDao">
<resultMap id="UserBaseMap" type="com.heitian.ssm.model.User">
<id column="id" property="id" jdbcType="BIGINT"/>
<result column="user_name" property="userName" jdbcType="VARCHAR"/>
<result column="user_phone" property="userPhone" jdbcType="VARCHAR"/>
<result column="user_email" property="userEmail" jdbcType="VARCHAR"/>
<result column="user_pwd" property="userPwd" jdbcType="VARCHAR"/>
<result column="pwd_salt" property="pwdSalt" jdbcType="VARCHAR"/>
<result column="create_time" property="createTime" jdbcType="DATE"/>
<result column="modify_time" property="modifyTime" jdbcType="DATE"/>
<result column="is_delete" property="isDelete" jdbcType="SMALLINT"></result>
</resultMap>
<select id="selectUserById" parameterType="java.lang.Long" resultMap="UserBaseMap">
SELECT * FROM t_user
WHERE id = #{userId}
</select>
<select id="selectUserByPhoneOrEmail" resultMap="UserBaseMap">
SELECT * FROM t_user
WHERE user_email = #{emailOrPhone} OR user_phone = #{emailOrPhone}
AND user_state = #{state}
</select>
<select id="selectAllUser" resultMap="UserBaseMap">
SELECT * FROM t_user
</select>
</mapper>
dao:
package com.heitian.ssm.dao;
import com.heitian.ssm.model.User;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Component;
import java.util.List;
/**
* Created by Zhangxq on 2016/7/15.
*/
@Component
public interface UserDao {
User selectUserById(@Param("userId") Long userId);
User selectUserByPhoneOrEmail(@Param("emailOrPhone") String emailOrPhone, @Param("state") Short state);
List<User> selectAllUser();
}
model:
package com.heitian.ssm.model;
import lombok.Data;
import java.util.Date;
/**
* Created by Zhangxq on 2016/7/15.
*/
@Data
public class User {
private Long id;
private String userName;
private String userPhone;
private String userEmail;
private String userPwd;
private String pwdSalt;
private Date createTime;
private Date modifyTime;
private Short isDelete;
}
2. 项目配置文件
2.1 这里使用maven来引入项目所需要的jar包,所以也就不需要手动来管理jar包了。
pom.xml
2.2 新建jdbc.properties文件
jdbc.properties
- driverClasss=com.mysql.jdbc.Driver
- jdbcUrl=jdbc:mysql://localhost:3306/db_ssm?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull
- username=root
- password=root
-
- #定义初始连接数
- initialSize=0
- #定义最大连接数
- maxActive=20
- #定义最大空闲
- maxIdle=20
- #定义最小空闲
- minIdle=1
- #定义最长等待时间
- maxWait=60000
2.3 新建log4j 配置文件
log4j.properties
- log4j.rootLogger=INFO,Console,File
-
- #控制台日志
- log4j.appender.Console=org.apache.log4j.ConsoleAppender
- log4j.appender.Console.Target=System.out
- log4j.appender.Console.layout=org.apache.log4j.PatternLayout
- log4j.appender.Console.layout.ConversionPattern=[%p][%t][%d{yyyy-MM-dd HH\:mm\:ss}][%C] - %m%n
-
- #普通文件日志
- log4j.appender.File=org.apache.log4j.RollingFileAppender
- log4j.appender.File.File=logs/ssm.log
- log4j.appender.File.MaxFileSize=10MB
- #输出日志,如果换成DEBUG表示输出DEBUG以上级别日志
- log4j.appender.File.Threshold=ALL
- log4j.appender.File.layout=org.apache.log4j.PatternLayout
- log4j.appender.File.layout.ConversionPattern=[%p][%t][%d{yyyy-MM-dd HH\:mm\:ss}][%C] - %m%n
2.4 新建springmvc配置文件
spring-mvc.xml
- <?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.0.xsd
- http://www.springframework.org/schema/context
- http://www.springframework.org/schema/context/spring-context-4.0.xsd
- http://www.springframework.org/schema/mvc
- http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">
-
-
- <context:component-scan base-package="com.heitian.ssm.controller"/>
-
-
- <bean id="mappingJacksonHttpMessageConverter"
- class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter">
- <property name="supportedMediaTypes">
- <list>
- <value>text/html;charset=UTF-8</value>
- </list>
- </property>
- </bean>
-
- <bean class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter">
- <property name="messageConverters">
- <list>
- <ref bean="mappingJacksonHttpMessageConverter"/>
- </list>
- </property>
- </bean>
-
-
-
- <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
- <property name="prefix" value="/WEB-INF/jsp/" />
- <property name="suffix" value=".jsp"/>
- </bean>
-
-
- <bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
-
- <property name="defaultEncoding" value="UTF-8"/>
-
- <property name="maxUploadSize" value="32505856"/>
-
- <property name="maxInMemorySize" value="4096"/>
- </bean>
- </beans>
2.5 新建spring和mybatis整合所需的配置文件
spring-mybatis.xml
- <?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:tx="http://www.springframework.org/schema/tx"
- xsi:schemaLocation="http://www.springframework.org/schema/beans
- http://www.springframework.org/schema/beans/spring-beans-3.1.xsd
- http://www.springframework.org/schema/context
- http://www.springframework.org/schema/context/spring-context-3.1.xsd
- http://www.springframework.org/schema/tx
- http://www.springframework.org/schema/tx/spring-tx.xsd">
-
-
- <context:component-scan base-package="com.heitian.ssm"/>
-
-
- <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
- <property name="location" value="classpath:jdbc.properties"/>
- </bean>
-
-
- <!-- 第二种方式:加载多个properties文件
- <bean id="configProperties" class="org.springframework.beans.factory.config.PropertiesFactoryBean">
- <property name="locations">
- <list>
- <value>classpath:jdbc.properties</value>
- <value>classpath:common.properties</value>
- </list>
- </property>
- <property name="fileEncoding" value="UTF-8"/>
- </bean>
- <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PreferencesPlaceholderConfigurer">
- <property name="properties" ref="configProperties"/>
- </bean>
- -->
-
-
- <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
- destroy-method="close">
- <property name="driverClassName" value="${driverClasss}"/>
- <property name="url" value="${jdbcUrl}"/>
- <property name="username" value="${username}"/>
- <property name="password" value="${password}"/>
-
- <property name="initialSize" value="${initialSize}"></property>
-
- <property name="maxActive" value="${maxActive}"></property>
-
- <property name="maxIdle" value="${maxIdle}"></property>
-
- <property name="minIdle" value="${minIdle}"></property>
-
- <property name="maxWait" value="${maxWait}"></property>
- </bean>
-
-
- <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
- <property name="dataSource" ref="dataSource"/>
-
- <property name="mapperLocations" value="classpath:mapping/*.xml"></property>
- </bean>
-
-
- <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
- <property name="basePackage" value="com.heitian.ssm.dao"/>
- <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
- </bean>
-
-
-
- <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
- <property name="dataSource" ref="dataSource"/>
- </bean>
-
-
- <tx:annotation-driven transaction-manager="transactionManager"/>
- </beans>
2.6 web.xml配置文件
web.xml
- <?xml version="1.0" encoding="UTF-8"?>
- <web-app xmlns="http://java.sun.com/xml/ns/javaee"
- xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
- xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
- http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
- version="3.0">
-
- <display-name>web-ssm</display-name>
-
- <context-param>
- <param-name>contextConfigLocation</param-name>
- <param-value>classpath:spring-mybatis.xml</param-value>
- </context-param>
-
- <context-param>
- <param-name>log4jConfigLocation</param-name>
- <param-value>classpath:log4j.properties</param-value>
- </context-param>
-
-
- <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>
- </filter>
- <filter-mapping>
- <filter-name>encodingFilter</filter-name>
- <url-pattern>/*</url-pattern>
- </filter-mapping>
-
-
- <listener>
- <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
- </listener>
-
-
- <listener>
- <listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class>
- </listener>
-
-
-
- <servlet>
- <servlet-name>SpringMVC</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>
- <load-on-startup>1</load-on-startup>
- <async-supported>true</async-supported>
- </servlet>
- <servlet-mapping>
- <servlet-name>SpringMVC</servlet-name>
-
- <url-pattern>/</url-pattern>
- </servlet-mapping>
-
- <welcome-file-list>
- <welcome-file>/index.jsp</welcome-file>
- </welcome-file-list>
-
-
- <session-config>
- <session-timeout>15</session-timeout>
- </session-config>
-
- </web-app>
3. 项目配置和部署
3.1
File -> Project Structure,进入创建项目配置窗口。
3.2 创建一个Tomcat容器实例,并把项目部署进去
3.3 项目所需配置好项目访问的根路径,然后启动Tomcat。
![](https://img-blog.csdn.net/20160718220343257?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQv/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center)
3.4 在浏览器地址栏中输入:http://localhost:8080/web-ssm/user/showUser
3.5 项目所需看到图中显示效果,则表示项目搭建成功。
4. 值得注意的地方
搭建好项目的框架之后,启动Tomcat,如果访问 http://localhost:8080/user/showUser 出现如下错误:
出现这个错误是因为少了依赖的jar包,只要在pom文件中添加如下依赖即可。
-
- <dependency>
- <groupId>com.fasterxml.jackson.core</groupId>
- <artifactId>jackson-core</artifactId>
- <version>2.8.0</version>
- </dependency>
-
- <dependency>
- <groupId>com.fasterxml.jackson.core</groupId>
- <artifactId>jackson-databind</artifactId>
- <version>2.8.0</version>
- </dependency>