Maven + Mybatis框架

框架结构

1、首先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>com.wbzkc</groupId>
  <artifactId>MavenMybatis</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  
  <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
  <dependencies>
		<dependency>
		    <groupId>org.mybatis</groupId>
		    <artifactId>mybatis</artifactId>
		    <version>3.2.7</version>
		</dependency>
		<dependency>
		    <groupId>org.mysql</groupId>
		    <artifactId>mysql</artifactId>
		    <version>5.1.7</version>
		</dependency>
  </dependencies>
</project>

其中mysql的包需要自己导入进去
org mysql mysql 5.17 mysql-5.1.7目录结构

2.datasource.properties

mysql数据库链接驱动，url, username,password

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

3、Configuration.xml

mybatis的配置文件

<?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="datasource.properties"/>
	<typeAliases>
		<!-- 
		<typeAlias type="com.wbzkc.pojo.Dept" alias="Dept"/>
		 -->
		 <package name="com.wbzkc.pojo"/>
	</typeAliases>
	<environments default="development">
		<environment id="development">
			<transactionManager type="JDBC"/>
			<dataSource type="POOLED">
				<property name="driver" value="${driver}"/>
				<property name="url" value="${url}"/>
				<property name="username" value="${username}"/>
				<property name="password" value="${password}"/>
			</dataSource>
		</environment>
	</environments>
	<mappers>
		<package name="com.wbzkc.mapper"/>
	</mappers>
</configuration>

4、创建pojo

Dept.java

package com.wbzkc.pojo;

public class Dept {
	private int dno;
	private String dname;
	private String dloc;
	public int getDno() {
		return dno;
	}
	public void setDno(int dno) {
		this.dno = dno;
	}
	public String getDname() {
		return dname;
	}
	public void setDname(String dname) {
		this.dname = dname;
	}
	public String getDloc() {
		return dloc;
	}
	public void setDloc(String dloc) {
		this.dloc = dloc;
	}
	public String toString() {
		return "Dept [dloc=" + dloc + ", dname=" + dname + ", dno=" + dno + "]";
	}
}

5、创建mapper

DeptMapper.java

package com.wbzkc.mapper;

import com.wbzkc.pojo.Dept;

public interface DeptMapper {
	Dept getByNo(int deptNo);
}

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.wbzkc.mapper.DeptMapper">
	<resultMap type="Dept" id="DeptMap">
		<id property="dloc" column="dloc"/>
		<result property="dname" column="dname"/>
		<result property="dloc" column="dloc"/>
	</resultMap>
	
	<select id="getByNo" parameterType="int" resultMap="DeptMap">
		select 
			dno,dname,dloc
			from department
			where dno=#{deptNo}
	</select>
</mapper>

6、测试DeptTest

public class DeptTest {
	public static void main(String[] args) throws IOException {
		SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(Resources.getResourceAsReader("Configuration.xml"));
		//打开sqlsession
		SqlSession sqlSession = factory.openSession();
		DeptMapper deptMapper = (DeptMapper) sqlSession.getMapper(DeptMapper.class);
		Dept dept = deptMapper.getByNo(80);
		System.out.println(dept);
	}
}

7、结果