Maven+mybatis 不整合Spring框架

1、使用Maven构建一个webapp项目

2、pom.xml中导入mybatis和mysql依赖

**

<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>niceu</groupId>
  <artifactId>mybatis.demo</artifactId>
  <packaging>war</packaging>
  <version>0.0.1-SNAPSHOT</version>
  <name>mybatis.demo Maven Webapp</name>
  <url>http://maven.apache.org</url>
  <dependencies>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>3.8.1</version>
      <scope>test</scope>
    </dependency>
    <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
	<dependency>
	    <groupId>org.mybatis</groupId>
	    <artifactId>mybatis</artifactId> 
	    <version>3.5.3</version>
	</dependency>
	   <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
	<dependency>
	    <groupId>mysql</groupId>
	    <artifactId>mysql-connector-java</artifactId>
	    <version>8.0.16</version>
	</dependency>
  </dependencies>
  <build>
    <finalName>mybatis.demo</finalName>
  </build>
</project>

**

3、新建db.pproperties（名称可以自定义）

**

-- 配置数据库的相关信息
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/****?serverTimezone=UTC 
jdbc.username=**
jdbc.password=**

**

4、新建mybatis-config.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>
    <properties resource="db.properties"></properties>
    <typeAliases>
      <package name="com.niceu.mybatis.demo.pojo"></package>
    </typeAliases>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="POOLED">
                <property name="driver" value="${jdbc.driver}"></property>
                <property name="url" value="${jdbc.url}"></property>
                <property name="username" value="${jdbc.username}"></property>
                <property name="password" value="${jdbc.password}"></property>
            </dataSource>
        </environment>
    </environments>
    <!-- 全局变量的配置 -->

    <!--加载映射文件-->
    <mappers>
        <mapper resource="xml/UserMapper.xml"></mapper>
    </mappers>
</configuration>

**
配置数据源信息

5、mysql数据库中提前准备User表和数据

**

**

6、编写表的映射类User

**

package com.niceu.mybatis.demo.pojo;

import org.apache.ibatis.type.Alias;

@Alias("UserInfo")
public class User {
	
	private int id;
	private String userName;
	private String password;
	
	

	public int getId() {
		return id;
	}


	public void setId(int id) {
		this.id = id;
	}


	public String getUserName() {
		return userName;
	}


	public void setUserName(String userName) {
		this.userName = userName;
	}


	public String getPassword() {
		return password;
	}


	public void setPassword(String password) {
		this.password = password;
	}


	@Override
	public String toString() {
		StringBuilder sb = new StringBuilder();
		sb.append("用户ID：").append(this.getId()).append("  ").
		append("用户名：").append(this.getUserName()).append("  ").
		append("密码：").append(this.getPassword());
		return sb.toString();
	}

}

注意这里的别名。
**

7、新建UserMapper接口

**

package com.niceu.mybatis.demo.dao;

import com.niceu.mybatis.demo.pojo.User;

public interface UserMapper {
	
	User getUserInfoByUserName(String userName);
	
}

**

8、新建UserMapper.xml，写相关SQL语句

**

<?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.niceu.mybatis.demo.dao.UserMapper">
    <resultMap id="myuser" type="UserInfo" >
        <id property="id" column="id"/>
        <result property="userName" column="username"/>
        <result property="password" column="password"/>
    </resultMap>
    
    <select id="getUserInfoByUserName" parameterType="String" resultMap="myuser">
      	select id,username,password from user where username=#{userName}
  	</select>
</mapper>

这里的type和User类的别名映射
id和UserMapper接口中的方法名对应，namespace对应的就是UserMapper接口的全限定名
这样也就完成了映射。