Mybatis - 2.入门案例

入门案例

1.前期准备 - 数据库准备

2.Mybatis的环境搭建

2.1.创建maven工程并导入坐标

2.2.创建实体类和dao的接口

2.3.创建Mybatis的主配置文件

SqlMapConfig.xml

2.4.创建映射配置文件

UserDao.xml

2.5.配置完成后结构

3.Mybatis的入门案例

3.1测试类

3.2.注解的方式

4.Mybatis配置文件COPY

4.1.pom.xml

<?xml version="1.0" encoding="UTF-8"?><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/xsd/maven-4.0.0.xsd">    
<parent>        <artifactId>mybatis_test</artifactId>        <groupId>com.rohnin</groupId>        <version>1.0-SNAPSHOT</version>        <relativePath>../day03_eesy_03one2many/pom.xml</relativePath>    
</parent>

<modelVersion>4.0.0</modelVersion>    <groupId>com.rohnin</groupId>    <artifactId>mybatis_test2</artifactId>    

<dependencies>       
<dependency>            <groupId>org.mybatis</groupId>            <artifactId>mybatis</artifactId>            <version>3.4.5</version>        </dependency>        <dependency>            <groupId>mysql</groupId>            <artifactId>mysql-connector-java</artifactId>            <version>5.1.6</version>        </dependency>        
<dependency>            <groupId>log4j</groupId>            <artifactId>log4j</artifactId>            <version>1.2.12</version>        </dependency>        <dependency>            <groupId>junit</groupId>            <artifactId>junit</artifactId>            <version>4.10</version>        
</dependency>   
</dependencies>
</project>

4.2.SqlMapConfig.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-->    
<properties resource="jdbcConfig.properties"></properties>    
<!--使用typeAliases配置别名，它只能配置domain中类的别名 -->    
<typeAliases>        
<package name="com.rohnin.domain"></package>    
</typeAliases>    
<!--配置环境-->    
<environments default="mysql">        
<!-- 配置mysql的环境-->        
<environment id="mysql">            
<!-- 配置事务 -->            
<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>        
<package name="com.rohnin.dao"></package>    
</mappers>
</configuration>

4.3.jdbcConfig.properties

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