ssm整合
1、
配置pom.xml文件导入需要的jar包
<!--spring start -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>${org.springframework.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>${org.springframework.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-beans</artifactId>
<version>${org.springframework.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aop</artifactId>
<version>${org.springframework.version}</version>
</dependency>
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjweaver</artifactId>
<version>1.8.10</version>
</dependency>
<!--spring end -->
<!--springmvc start -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
<version>${org.springframework.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>${org.springframework.version}</version>
</dependency>
<!--springmvc end -->
<!-- json start -->
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-core</artifactId>
<version>2.12.6</version>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-annotations</artifactId>
<version>2.12.6</version>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
<version>2.12.6</version>
</dependency>
<!-- json end -->
<!-- mysql start -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.20</version>
</dependency>
<!-- mysql end -->
<!-- datasource dbcp start -->
<dependency>
<groupId>commons-dbcp</groupId>
<artifactId>commons-dbcp</artifactId>
<version>1.2.2</version>
</dependency>
<!-- datasource dbcp end -->
<!-- mybatis start -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>${mybatis.version}</version>
</dependency>
<!-- mybatis end -->
<!-- mybatis生成的实例 交给spring容器管理的jar （mybatis跟spring容器 联动的桥梁） start -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.2.2</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${org.springframework.version}</version>
</dependency>
<!-- mybatis生成的实例 交给spring容器管理的jar （mybatis跟spring容器 联动的桥梁） end -->
配置springmvc.xml文件
<?xml version="1.0" encoding="UTF-8"?>
<beans
xmlns="http://www.springframework.org/schema/beans"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:p="http://www.springframework.org/schema/p"
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.3.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-4.3.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-4.3.xsd">
<!--开启mvc注解-->
<mvc:annotation-driven/>
<!--开启spring注解-->
<context:annotation-config></context:annotation-config>
<!--扫描controller包-->
<context:component-scan base-package="com.bh.controller"></context:component-scan>
<!--配置json的结果解析器-->
<bean class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter">
<property name="cacheSeconds" value="0"/>
<property name="messageConverters">
<list>
<bean class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter"/>
</list>
</property>
</bean>
</beans>
db.properties（包含数据库连接池）
driver=com.mysql.cj.jdbc.Driver
url1=jdbc:mysql://127.0.0.1:3306/class?characterEncoding=utf8
username=root
pwd=root
initialSize=2
maxActive=5
minIdle=1
maxIdle=2
maxWait=20000
配置spring-mybatis.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans
xmlns="http://www.springframework.org/schema/beans"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:p="http://www.springframework.org/schema/p"
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.3.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-4.3.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-4.3.xsd
">
<!--开启spring注解-->
<context:annotation-config></context:annotation-config>
<!--扫描service包-->
<context:component-scan base-package="com.bh.service"></context:component-scan>
<!--使用spring管理.properties配置文件-->
<bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="locations">
<list>
<value>classpath:db.properties</value>
</list>
</property>
</bean>
<!--配置datasource-->
<bean id="datasource" class="org.apache.commons.dbcp.BasicDataSource">
<!--四大金刚-->
<property name="driverClassName" value="${driver}"/>
<property name="url" value="${url1}"/>
<property name="username" value="${username}"/>
<property name="password" value="${pwd}"/>
<!--datasource-->
<property name="initialSize" value="${initialSize}"/>
<property name="maxActive" value="${maxActive}"/>
<property name="minIdle" value="${minIdle}"/>
<property name="maxIdle" value="${maxIdle}"/>
<property name="maxWait" value="${maxWait}"/>
</bean>
<!--mybatis-->
<!-- mybatis干活的的接口的实例 ， 跟spring的联动 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="datasource"/>
<property name="mapperLocations" value="classpath:mapper/*.xml"/>
</bean>
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.bh.dao"/>
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
</bean>
</beans>
配置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_4_0.xsd"
version="4.0">
<!-- 业务类（Service）的配置 和 mybatis的配置 -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring-mybatis.xml</param-value>
</context-param>
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!-- 配置编码的过滤器 -->
<filter>
<filter-name>characterfilter</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>characterfilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!-- springmvc 的核心的转发类 -->
<servlet>
<servlet-name>disp</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:springmvc.xml</param-value>
</init-param>
</servlet>
<servlet-mapping>
<servlet-name>disp</servlet-name>
<url-pattern>*.do</url-pattern>
</servlet-mapping>
</web-app>
po层实体类
package com.bh.po;
public class Dept {
private int deptno;
private String dname;
private String loc;
public int getDeptno() {
return deptno;
}
public void setDeptno(int deptno) {
this.deptno = deptno;
}
public String getDname() {
return dname;
}
public void setDname(String dname) {
this.dname = dname;
}
public String getLoc() {
return loc;
}
public void setLoc(String loc) {
this.loc = loc;
}
}
dao层DeptDAO接口
package com.bh.dao;
import com.bh.po.Dept;
import java.util.List;
public interface DeptDAO {
public List<Dept> findAll();
}
deptmapper.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.bh.dao.DeptDAO">
<select id="findAll" resultType="com.bh.po.Dept">
select * from dept
</select>
</mapper>
service层接口
package com.bh.service;
import java.util.List;
public interface IService {
public List findAll();
}
service层实现类
package com.bh.service.impl;
import com.bh.dao.DeptDAO;
import com.bh.po.Dept;
import com.bh.service.IService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
@Service
public class DeptServiceImpl implements IService {
@Autowired
private DeptDAO deptDAO;
@Override
public List findAll() {
List<Dept> all = deptDAO.findAll();
return all;
}
}
controller层
package com.bh.controller;
import com.bh.service.impl.DeptServiceImpl;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import java.util.List;
@Controller
public class DeptController {
@Autowired
private DeptServiceImpl deptService;
@RequestMapping("/findall.do")
public @ResponseBody List findAll(){
List all = deptService.findAll();
return all;
}
}
结果
[
{
"deptno":0,
"dname":"1",
"loc":"1"
},
{
"deptno":1,
"dname":"hr",
"loc":"weifang"
},
{
"deptno":2,
"dname":"game",
"loc":"qd"
},
{
"deptno":13,
"dname":"55",
"loc":"46"
},
{
"deptno":21,
"dname":"aaa",
"loc":"jinan"
},
{
"deptno":22,
"dname":"aaa",
"loc":"jinan"
},
{
"deptno":31,
"dname":"11",
"loc":"dd"
},
{
"deptno":32,
"dname":"11",
"loc":"a1"
},
{
"deptno":33,
"dname":"11",
"loc":"a2"
},
{
"deptno":34,
"dname":"11",
"loc":"a3"
},
{
"deptno":35,
"dname":"11",
"loc":"dd"
},
{
"deptno":41,
"dname":"eerre",
"loc":"ooo"
},
{
"deptno":42,
"dname":"eerre",
"loc":"ooo"
},
{
"deptno":52,
"dname":"wqe",
"loc":"wqewq"
},
{
"deptno":55,
"dname":"希望i",
"loc":"你哈珀iu"
},
{
"deptno":56,
"dname":"希望i",
"loc":"你哈珀iu"
},
{
"deptno":67,
"dname":"杨奥帆",
"loc":"jinan"
},
{
"deptno":80,
"dname":"asojdf",
"loc":"ewrew"
},
{
"deptno":81,
"dname":"asojdf",
"loc":"ewrew"
},
{
"deptno":88,
"dname":"weqeq",
"loc":"wewq"
},
{
"deptno":89,
"dname":"weqeq",
"loc":"wewq"
},
{
"deptno":999,
"dname":"888",
"loc":"888"
}]
浙公网安备 33010602011771号