六、Spring整合Mybatis

最新推荐文章于 2024-10-01 13:49:09 发布

檬柠猿

最新推荐文章于 2024-10-01 13:49:09 发布

阅读量55

点赞数 1

分类专栏： mybatis 文章标签： spring java

本文链接：https://blog.csdn.net/weixin_46203713/article/details/120815731

版权

mybatis 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

六、Spring整合Mybatis

1、domain : Student.java

package com.mnyuan.domain;
//    id  studentName  gender  classId
public class Student {
    private Integer id;
    private String studentName;
    private String gender;
}

2、controller : StudentController.java

package com.mnyuan.controller;

@Controller
@RequestMapping("/student")
public class StudentController {
    @Autowired
    private StudentService service;
	//查询所有学生信息
    @RequestMapping("/getStudents")
    public String getAll(Model model){
        List<Student> lists = service.getAll();
        model.addAttribute("stus",lists);
        return "list";
    }
}

3、service : StudentService.java

package com.mnyuan.service;

@Service
public class StudentService {
    @Autowired
    private StudentMapper studentMapper;
    /**
     * 获取全部学生信息
     */
    public List<Student> getAll(){
        List<Student> list = studentMapper.getAll();
        return list;
    }
}

4、dao : StudentMapper.java

package com.mnyuan.mapper;

@Repository
public interface StudentMapper {
    /**
     * 根据id查询信息
     */
    public Student getStudentById(Integer id);
    /**
     * 查询全部信息
     */
    public List<Student> getAll();
}

5、dao : StudentMapper.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.mnyuan.mapper.StudentMapper">
    
<!--    public Student getStudentById(Integer id);-->
    <select id="getStudentById" resultType="com.mnyuan.domain.Student">
        select * from tbl_student where id = #{id}
    </select>

<!--    public List<Student> getAll();-->
    <select id="getAll" resultType="com.mnyuan.domain.Student">
        select * from tbl_student
    </select>
</mapper>

6、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">
<!--    1.配置编码过滤器 CharacterEncodingFilter-->
    <filter>
        <filter-name>CharacterEncodingFilter</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>forceResponseEncoding</param-name>
            <param-value>true</param-value>
        </init-param>
    </filter>
    <filter-mapping>
        <filter-name>CharacterEncodingFilter</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>
<!--    2.配置DispatcherServlet-->
    <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: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>

7、druid.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/mybatis
jdbc.username=root
jdbc.password=1234

8、MybatisConfig.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>
<!--全部的配置都可以交到Spring中去做-->
<!--    可以配置一些容易发生改变的配置-->
</configuration>

9、ApplicationContext.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.alibaba.com/schema/stat"
       xmlns:mybatis-spring="http://mybatis.org/schema/mybatis-spring"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
           http://www.springframework.org/schema/beans/spring-beans.xsd
           http://www.springframework.org/schema/context
           https://www.springframework.org/schema/context/spring-context.xsd
           http://www.alibaba.com/schema/stat http://www.alibaba.com/schema/stat.xsd
           http://mybatis.org/schema/mybatis-spring
           http://mybatis.org/schema/mybatis-spring.xsd">
<!--    开启注解扫描包-->
    <context:component-scan base-package="com.mnyuan">
        <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    </context:component-scan>

<!--    加载druid.properties-->
    <context:property-placeholder location="classpath:druid.properties"/>
<!--    配置druid数据源-->
    <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>

<!--    配置事务管理器-->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<!--        注入数据源-->
        <property name="dataSource" ref="dataSource"/>
    </bean>
<!--    开启事务注解-->
    <tx:annotation-driven/>

<!--    Spring整合Mybatis-->
    <!--        在Mybatis全局配置文件中配置的，在SqlSessionFactoryBean中都可以进行配置-->
    <bean class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
<!--        指定mybatis全局配置文件的位置-->
        <property name="configLocation" value="classpath:MybatisConfig.xml"/>
<!--        指定注册mapper配置文件-->
        <property name="mapperLocations" value="classpath:com/mnyuan/mapper/*.xml"/>
    </bean>
<!--    扫描所有mapper接口的实现，让这些mapper能够自动注入-->
    <mybatis-spring:scan base-package="com.mnyuan.mapper"/>
</beans>

10、SpringMVC.xml (可以完全整合到ApplicationContext.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
            https://www.springframework.org/schema/context/spring-context.xsd
            http://www.springframework.org/schema/mvc
            https://www.springframework.org/schema/mvc/spring-mvc.xsd">
    <import resource="classpath:ApplicationContext.xml"/>
<!--    1.开启注解扫描-->
    <context:component-scan base-package="com.mnyuan.controller"/>
<!--    2.配置视图解析器-->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/WEB-INF/pages/"/>
        <property name="suffix" value=".jsp"/>
    </bean>
<!--    3.配置视图控制器-->
    <mvc:view-controller path="/" view-name="index"/>
<!--    4.开启注解驱动开发-->
    <mvc:annotation-driven/>
<!--    5.开启默认servlet处理器处理静态资源-->
    <mvc:default-servlet-handler/>
</beans>

11、jsp页面

index.jsp


    <h1>首页</h1>
    <a href="${pageContext.request.contextPath}/student/getStudents">获取所有学生信息</a>

list.jsp

    <table>
        <tr>
            <td>学生编号</td>
            <td>学生姓名</td>
            <td>学生性别</td>
        </tr>
        <c:forEach items="${stus}" var="stu">
            <tr>
                <td>${stu.id}</td>
                <td>${stu.studentName}</td>
                <td>${stu.gender}</td>
            </tr>
        </c:forEach>
    </table>