基于注解的mybatis整合spring开发流程?

来源:互联网 发布:单片机算法导论 编辑:程序博客网 时间:2024/06/08 05:17

废话不多说,卷起袖子直接干。
(1)先上一张项目结构图
项目结构
(2)pom.xml【各个包的说明在注释】

<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/maven-v4_0_0.xsd"><modelVersion>4.0.0</modelVersion><groupId>cn.edu.hdu</groupId><artifactId>Mybatis</artifactId><packaging>war</packaging><version>0.0.1-SNAPSHOT</version><name>Mybatis Maven Webapp</name><url>http://maven.apache.org</url><dependencies><!-- 导入Spring核心包。 这个案例只是mybatis整合spring还用不到MVC框架, 那为什么还要导入springwebmvc包呢? 因为导入springwebmvc包,会自动下载Spring核心包,省得自己还得手动导入七八个核心包。 --><dependency><groupId>org.springframework</groupId><artifactId>spring-webmvc</artifactId><version>4.3.9.RELEASE</version></dependency><!-- mybatis与mybatis整合spring的包 --><dependency><groupId>org.mybatis</groupId><artifactId>mybatis</artifactId><version>3.4.1</version></dependency><dependency><groupId>org.mybatis</groupId><artifactId>mybatis-spring</artifactId><version>1.3.0</version></dependency><!-- 连接池的包(当然你也可以用c3p0连接池 --><dependency><groupId>commons-dbcp</groupId><artifactId>commons-dbcp</artifactId><version>1.4</version></dependency><!-- 数据库访问的包 --><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>5.1.38</version></dependency><!-- 事务管理包 --><dependency><groupId>org.springframework</groupId><artifactId>spring-tx</artifactId><version>3.0.5.RELEASE</version></dependency><!-- spring对数据库访问包 --><dependency><groupId>org.springframework</groupId><artifactId>spring-jdbc</artifactId><version>4.3.9.RELEASE</version></dependency> <!-- test,spring-test是用来测试的包 --><dependency><groupId>junit</groupId><artifactId>junit</artifactId><version>4.12</version><scope>test</scope></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-test</artifactId><version>4.3.9.RELEASE</version><scope>test</scope></dependency></dependencies><build><finalName>Mybatis</finalName><plugins><plugin><groupId>org.apache.maven.plugins</groupId><artifactId>maven-compiler-plugin</artifactId><configuration><source>1.8</source><target>1.8</target></configuration></plugin></plugins></build></project>

(3)web.xml

<?xml version="1.0" encoding="UTF-8"?><web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0">  <display-name>Mybatis</display-name>  <welcome-file-list>    <welcome-file>index.html</welcome-file>    <welcome-file>index.htm</welcome-file>    <welcome-file>index.jsp</welcome-file>    <welcome-file>default.html</welcome-file>    <welcome-file>default.htm</welcome-file>    <welcome-file>default.jsp</welcome-file>  </welcome-file-list>  <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:config/applicationContext.xml</param-value>        </init-param>        <load-on-startup>1</load-on-startup>  </servlet>  <servlet-mapping>    <servlet-name>DispatcherServlet</servlet-name>    <url-pattern>*.do</url-pattern>  </servlet-mapping></web-app>

(4)spring配置文件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:jdbc="http://www.springframework.org/schema/jdbc" xmlns:jee="http://www.springframework.org/schema/jee"    xmlns:tx="http://www.springframework.org/schema/tx" xmlns:aop="http://www.springframework.org/schema/aop"    xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:util="http://www.springframework.org/schema/util"    xmlns:jpa="http://www.springframework.org/schema/data/jpa"    xsi:schemaLocation="        http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.2.xsd        http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-3.2.xsd        http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-3.2.xsd        http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.2.xsd        http://www.springframework.org/schema/data/jpa http://www.springframework.org/schema/data/jpa/spring-jpa-1.3.xsd        http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.2.xsd        http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd        http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-3.2.xsd">    <context:component-scan base-package="dao" /><!--spring会扫描带有注解的类 -->    <!-- 看好name不要写错了 -->      <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">        <property name="url" value="jdbc:mysql://localhost:3306/test"/>        <property name="driverClassName" value="com.mysql.jdbc.Driver"/>        <property name="username" value="root"/>        <property name="password" value="123456"/>    </bean>    <!-- 这个作用请专看本系列其他文章 -->    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">        <property name="dataSource" ref="dataSource"/>        <property name="configLocation" value="classpath:config/mybatis-spring.xml"/>        <property name="mapperLocations" value="classpath:mapper/mapper.xml"/>    </bean>    <!-- MapperScannerConfigurer会创建dao层的实现类,所以不用在dao里写daoImpl实现类了 -->    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">        <property name="basePackage" value="dao"/>        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>    </bean></beans>

(5)mybatis的配置文件mybatis-spring.xml

<?xml version="1.0" encoding="UTF-8"?><!-- 从mybatis官网拿到下面这个标头 --><!DOCTYPE configuration  PUBLIC "-//mybatis.org//DTD Config 3.0//EN"  "http://mybatis.org/dtd/mybatis-3-config.dtd">  <configuration>    <settings>        <setting name="mapUnderscoreToCamelCase" value="true"/>    </settings>    <typeAliases>        <package name="entity"/>    </typeAliases>  </configuration>

(6)Navicat软件中创建mysql表【id设置成主键,且自增】,如图

(7)mybatis的映射文件mapper.xml

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapperPUBLIC "-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mapper namespace="dao.CityDao">    <insert id="insertCity" parameterType="City">        insert into china (id,name,province) values (            #{id},            #{name},            #{province}            )    </insert></mapper>

(8)dao包下的接口CityDao

package dao;import entity.City;public interface CityDao {    public void insertCity(City city);}

这里写图片描述

(9)entity包下的实体City

package entity;public class City {    private int id;    private String name;    private String province;    public int getId() {        return id;    }    public void setId(int id) {        this.id = id;    }    public String getName() {        return name;    }    public void setName(String name) {        this.name = name;    }    public String getProvince() {        return province;    }    public void setProvince(String province) {        this.province = province;    }}

City
(10)测试类

package test;import org.junit.Test;import org.junit.runner.RunWith;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.test.context.ContextConfiguration;import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;import dao.CityDao;import entity.City;@RunWith(SpringJUnit4ClassRunner.class)@ContextConfiguration({"classpath:config/applicationContext.xml"})//,"classpath:mapper/mapper.xml"public class testDemo {    @Autowired    private CityDao cityDao;    @Test    public void insert(){        try {            City city = new City();            city.setId(3);            city.setName("嘉兴");            city.setProvince("浙江");            cityDao.insertCity(city);            System.out.println("insert successfully");        } catch (Exception e) {            // TODO: handle exception            e.printStackTrace();        }    }}

test
(11)效果展示
show

原创粉丝点击