mybatis

1、导入MyBatis的坐标和其他相关坐标
2、创建user数据表
3、编写User实体
4、编写用户表t_user对应的sql映射文件
5、编写MyBatis核心配置文件

1、导入MyBatis的坐标和其他相关坐标

<!--mybatis坐标-->
<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>3.4.5</version>
</dependency>
<!--mysql驱动坐标-->
<dependency>    
    <groupId>mysql</groupId>   
    <artifactId>mysql-connector-java</artifactId>    
    <version>5.1.6</version>    
    <scope>runtime</scope>
</dependency>
<!--单元测试坐标-->
<dependency>    
    <groupId>junit</groupId>    
    <artifactId>junit</artifactId>    
    <version>4.12</version>    
    <scope>test</scope>
</dependency>
<!--日志坐标-->
<dependency>    
    <groupId>log4j</groupId>    
    <artifactId>log4j</artifactId>    
    <version>1.2.12</version>
</dependency>

2、创建user数据表

create database  mybatis_01 character set utf8;

use mybatis_01 ;

CREATE TABLE `user` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(32) NOT NULL COMMENT '用户名称',
  `birthday` datetime default NULL COMMENT '生日',
  `sex` char(1) default NULL COMMENT '性别',
  `address` varchar(256) default NULL COMMENT '地址',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

insert  into `user`(`id`,`username`,`birthday`,`sex`,`address`) values
(41,'郭靖','2018-02-27 17:47:08','男','襄阳'),
(42,'黄蓉','2018-03-02 15:09:37','女','襄阳'),
(43,'洪七公','2018-03-04 11:34:34','男','扬州'),
(45,'杨过','2018-03-04 12:04:06','男','古墓'),
(46,'小龙女','2018-03-07 17:37:26','男','终南山'),
(48,'黄老邪','2018-03-08 11:44:00','男','桃花岛');

3、编写User实体

public class User {

    private int id;
    private String username;
    private Date birthday;
    private String sex;
    private String address;
    
    //省略get个set方法
}

4、编写用户表t_user对应的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="userMapper">    
	<select id="findAll" resultType="com.itheima.domain.User">
		select * from User    
	</select>
</mapper>

5、编写MyBatis核心配置文件

<!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"/>            
			<dataSource type="POOLED">                
				<property name="driver" value="com.mysql.jdbc.Driver"/>
				<property name="url" value="jdbc:mysql:///test"/>
				<property name="username" value="root"/>
				<property name="password" value="root"/>  
			</dataSource>
		</environment> 
	</environments>
	<mappers>
		<mapper resource="com/itheima/mapper/UserMapper.xml"/> 
	</mappers>
</configuration>