Spring Mvc那点事---(10)Spring Mvc之mybatis用法_spring mvc 禁用mybatis-优快云博客

本文介绍了一个基于MyBatis框架的实战案例，展示了如何通过MyBatis进行数据库操作，包括配置环境、创建实体类、编写Mapper文件及实现查询等功能。

mybatis是一个持久层框架，支持SQL查询，存储过程等，配置灵活，使用方便。通过使用XML配置很好的和JDBC结合，很方便的操作数据库。

配置POM.XML，首先我们通过maven引入mybatis的第三方组件。

    <dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.39</version>
</dependency>

    
    <dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>3.4.0</version>
</dependency>
    
    
    <dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis-spring</artifactId>
    <version>1.3.0</version>
</dependency>

这里我们创建一个erp数据库，并创建一张skus表

CREATE TABLE `skus` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `SkuName` varchar(50) DEFAULT NULL,
  `SkuCode` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8

创建表实体

package dto;

public class skus {

	private int Id ;
	
	public int getId() {
		return Id;
	}

	public void setId(int id) {
		Id = id;
	}

	private String SkuName ;
	
	public String getSkuCode() {
		return SkuCode;
	}

	public void setSkuCode(String skuCode) {
		SkuCode = skuCode;
	}

	public String getSkuName() {
		return SkuName;
	}

	public void setSkuName(String skuName) {
		SkuName = skuName;
	}

	private String SkuCode;
	
	
}

skusmapper.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="mapping.skusMapper">
   <!-- 指定查询SQL, parameterType是传入参数类型，resultType是返回结果-->
    <select id="getSku" parameterType="int" 
        resultType="dto.skus">
        SELECT * FROM skus WHERE  id=#{id}
    </select>
</mapper>

配置数据库连接信息

<?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>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC" />
            <!-- 配置数据库连接信息  url中的erp为数据名称-->
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver" />
                <property name="url" value="jdbc:mysql://localhost:3306/erp" />
                <property name="username" value="root" />
                <property name="password" value="123456" />
            </dataSource>
        </environment>
    </environments>
    
     <mappers>
        <!-- 指定映射文件 -->
        <mapper resource="mapping/skusMapper.xml"/>
    </mappers>

</configuration>

开始查询

@Controller
@RequestMapping("/Home")
public class HomeController {

	@Resource(name="applePhone")
    private IMobilePhone phone;
	
	@RequestMapping(value="index")
	public String Index()
	{
		String msg=phone.PhoneBrand();
		
		System.out.print(msg);
		
		  String resource = "/conf.xml";
	        //加载mybatis的配置文件
	        InputStream inputstream =this.getClass().getResourceAsStream(resource);
	       
	        SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(inputstream);
	      
	        SqlSession session = sessionFactory.openSession();
	       
	        String statesql= "mapping.skusMapper.getSku";//在skusMapper.xml中有命名空间+方法名
	        
	        skus sku = session.selectOne(statesql, 1);
	        System.out.println(sku.getSkuName());
	        
	        
		return "index";
	}

项目结构图如下