环境及工具
1、JDK1.8
2、Idea2019.1
3、Tomcat 7.0.92
4、Win10
创建maven项目
1、file -> new -> project
2、点击maven -> 版本选择1.8 -> 勾选 Create from archetype -> 选择 maven-archetype-webapp -> 点击next
3、填完上面的GroupId和ArtifactId后点击下一步
4、点击next
5、点击finish,完成项目创建
导入jar包
在 pom.xml 中导入
<?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>com.chenjiuli</groupId>
<artifactId>ssm_chenjiuli</artifactId>
<version>1.0-SNAPSHOT</version>
<packaging>war</packaging>
<name>ssm_chenjiuli Maven Webapp</name>
<!-- FIXME change it to the project's website -->
<url>http://www.example.com</url>
<dependencies>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.11</version>
<scope>test</scope>
</dependency>
<!--Spring的包-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>4.3.20.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>4.3.20.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-beans</artifactId>
<version>4.3.20.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
<version>4.3.20.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>4.3.20.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>4.3.20.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>4.3.20.RELEASE</version>
</dependency>
<!--Mybatis和spring的整合包及本身的包、数据库连接池-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.2</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.5</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.6</version>
</dependency>
<!--数据库-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>6.0.6</version>
</dependency>
<!--JSON-->
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
<version>2.9.3</version>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-core</artifactId>
<version>2.9.3</version>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-annotations</artifactId>
<version>2.9.3</version>
</dependency>
</dependencies>
<build>
<finalName>ssm_chenjiuli</finalName>
<pluginManagement><!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) -->
<plugins>
<plugin>
<artifactId>maven-clean-plugin</artifactId>
<version>3.1.0</version>
</plugin>
<!-- see http://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_war_packaging -->
<plugin>
<artifactId>maven-resources-plugin</artifactId>
<version>3.0.2</version>
</plugin>
<plugin>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.8.0</version>
</plugin>
<plugin>
<artifactId>maven-surefire-plugin</artifactId>
<version>2.22.1</version>
</plugin>
<plugin>
<artifactId>maven-war-plugin</artifactId>
<version>3.2.2</version>
</plugin>
<plugin>
<artifactId>maven-install-plugin</artifactId>
<version>2.5.2</version>
</plugin>
<plugin>
<artifactId>maven-deploy-plugin</artifactId>
<version>2.8.2</version>
</plugin>
</plugins>
</pluginManagement>
</build>
</project>
注意:以上jar包都可以在maven库找到
创建配置文件
1、在resources下面创建几个文件夹
1)mybatis
2)spring
3)mapper
2、spring文件夹下创建文件
1)spring-dao.xml
2)spring-service.xml
3)springmvc.xml
3、在mybatis文件夹下创建文件
1)SqlMapConfig.xml
在这里说明下,以上分层是个人习惯,等下会说明
spring-dao.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"
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">
<!--把JDBC 文件扫描进来-->
<context:property-placeholder location="classpath:conf/jdbc.properties" />
<!--数据库连接池-->
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
<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="org.mybatis.spring.SqlSessionFactoryBean">
<!--注入数据库连接池-->
<property name="dataSource" ref="dataSource"/>
<!--扫描mybatis全局配置文件: -->
<property name="configLocation" value="classpath:mybatis/SqlMapConfig.xml" />
<!--扫描sql配置文件:mapper需要的xml文件-->
<property name="mapperLocations" value= "classpath:mapper/*.xml" />
</bean>
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<!--注入sqlSessionFactory-->
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />
<!--扫描Dao接口包-->
<property name="basePackage" value="com.chenjiuli.dao" />
</bean>
</beans>
上面是spring和mybatis的整合,整合的话,可以根据文档来学习,在这里就不跟大家啰嗦了
spring-service.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"
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">
<!--扫描service的包-->
<context:component-scan base-package="com.chenjiuli.service" />
</beans>
在这里, spring-service.xml文件我是用来扫描service层的
springmvc.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: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-3.2.xsd">
<mvc:annotation-driven />
<mvc:default-servlet-handler />
<!--视图解析器-->
<bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF"/>
<property name="suffix" value=".jsp" />
</bean>
<!--扫描controller的包-->
<context:component-scan base-package="com.chenjiuli.controller" />
</beans>
在这里,springmvc.xml是用来配置关于springMVC的配置,起始项目可以很多都没有,不过本人习惯配置上面的三样东西
SqlMapConfig.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>
</configuration>
在这里,Mybatis的主配置文件为空就行,我没有完美整合起来,还是个人习惯,主要是为了容易看,每个文件对应什么,以后改配置文件的时候,比较简单,如果需要添加配置的话,可以访问mybatis的文档
重头戏来了–配置web.xml
<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" metadata-complete="true">
<!--加载Spring容器-->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath*:spring/spring-*.xml</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>
<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>
<!--配置一个监听器-->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<servlet>
<servlet-name>dispatcherServlet</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>dispatcherServlet</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
</web-app>
以下是个人理解,如果有误,请勿喷
在spring项目中,web.xml有起到的一个作用,就是把其它文件给连接起来,让每个文件都可以相互访问到对方,这就是我理解的所谓整合
以下是我理解的图
上面的图,web.xml扫描其它几个,spring-dao.xml扫描了mybatis的主配置文件,所以我用线给他们连起来,根据这些线,所有的文件都可以访问到其它文件,这就是所谓的整合,能相互访问到,个人理解。
创建数据库
1、ssm_chenjiuli
2、创建表:
CREATE TABLE admin(
admin_id VARCHAR(255) PRIMARY KEY,
admin_username VARCHAR(255) NOT NULL,
admin_password VARCHAR(255) NOT NULL
)ENGINE = INNODB
写代码阶段
1、controller包下创建
1)AdminController.java(类)
2、service包下创建
2)AdminService.java(接口)
创建impl包
AdminServiceImpl.java(类)
3、dao包下创建
3)AdminMapper.java(接口)
4、pojo包下创建
4)Admin.java
5、mapper包下创建
5)AdminMapper.xml
Admin
package com.chenjiuli.pojo;
public class Admin {
private String adminId;
private String adminUsername;
private String adminPassword;
public String getAdminId() {
return adminId;
}
public void setAdminId(String adminId) {
this.adminId = adminId;
}
public String getAdminUsername() {
return adminUsername;
}
public void setAdminUsername(String adminUsername) {
this.adminUsername = adminUsername;
}
public String getAdminPassword() {
return adminPassword;
}
public void setAdminPassword(String adminPassword) {
this.adminPassword = adminPassword;
}
}
AdminMapper.java
package com.chenjiuli.dao;
import com.chenjiuli.pojo.Admin;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;
@Repository
public interface AdminMapper {
Admin findAdmin(@Param("adminUsername") String adminUsername,
@Param("adminPassword") String adminPassword);
}
AdminMapper.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.chenjiuli.dao.AdminMapper">
<resultMap id="findAdminResult" type="com.chenjiuli.pojo.Admin">
<id property="adminId" column="admin_id" />
<result property="adminUsername" column="admin_username" />
<result property="adminPassword" column="admin_password" />
</resultMap>
<select id="findAdmin" resultMap="findAdminResult">
SELECT * FROM admin
WHERE
admin_username = #{adminUsername}
AND admin_password = #{adminPassword}
</select>
</mapper>
AdminService.java
package com.chenjiuli.service;
import com.chenjiuli.pojo.Admin;
public interface AdminService {
Admin findAdmin(String username, String password);
}
AdminServiceImpl.java
package com.chenjiuli.service.impl;
import com.chenjiuli.dao.AdminMapper;
import com.chenjiuli.pojo.Admin;
import com.chenjiuli.service.AdminService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@Service
public class AdminServiceImpl implements AdminService {
@Autowired
private AdminMapper adminMapper;
public Admin findAdmin(String username, String password) {
return adminMapper.findAdmin(username, password);
}
}
AdminController.java
package com.chenjiuli.controller;
import com.chenjiuli.pojo.Admin;
import com.chenjiuli.service.AdminService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.ResponseBody;
import java.util.HashMap;
import java.util.Map;
@Controller
public class AdminController {
@Autowired
private AdminService adminService;
@RequestMapping(value = "/login",method = RequestMethod.POST)
@ResponseBody
public Map<String, Object> findAdmin(@RequestBody Admin admin) {
Map<String, Object> map = new HashMap<>();
Admin adminInfo = adminService.findAdmin(admin.getAdminUsername(), admin.getAdminPassword());
if (adminInfo == null) {
map.put("success", false);
map.put("message", "登录失败,请重新登录");
} else {
map.put("success", true);
map.put("message", "登录成功");
map.put("admin", adminInfo);
}
return map;
}
}
配置Tomcat
启动项目
成功显示出页面
测试连接数据库
用postman测试,连接成功显示下面
项目结构
注意:整合项目,就是把所有不同框架连接起来