Mybatis学习（一）：HelloWorld简单程序

1. 创建项目，导入jar包，jar包从GitHub上下载https://github.com/mybatis/mybatis-3/tree/master/src/site一个简单的程序只需要这几个jar包
2. 创建数据表

   CREATE TABLE `t_user` (
     `id` int(11) NOT NULL AUTO_INCREMENT,
     `name` varchar(50) DEFAULT NULL,
     `sex` varchar(5) DEFAULT NULL,
     PRIMARY KEY (`id`)
   ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

    

3. 编写实体类（ORM思想，将表与对象映射，通过对对象的操作进行数据操作）

   //实体对应表
   public class User {
   	//实体中的属性对应表中字段，提供get/set方法
   	private Integer id;
   	private String name;
   	private String sex;
   	
   	public Integer getId() {
   		return id;
   	}
   	public void setId(Integer id) {
   		this.id = id;
   	}
   	public String getName() {
   		return name;
   	}
   	public void setName(String name) {
   		this.name = name;
   	}
   	public String getSex() {
   		return sex;
   	}
   	public void setSex(String sex) {
   		this.sex = sex;
   	}
   	@Override
   	public String toString() {
   		return "User [id=" + id + ", name=" + name + ", sex=" + sex + "]";
   	}
   	public User(Integer id, String name, String sex) {
   		super();
   		this.id = id;
   		this.name = name;
   		this.sex = sex;
   	}
   	public User() {
   		super();
   		// TODO Auto-generated constructor stub
   	}
   	
   }

    

4. 编写mybatis配置文件，引入日志文件log4j.properties

   <?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>
   	<!-- 指定 MyBatis 所用日志的具体实现，未指定时将自动查找。 -->
     	<settings>
     		<setting name="logImpl" value="LOG4J"/>
     	</settings>
     	<!-- 类型别名是为 Java 类型设置一个短的名字。存在的意义仅在于用来减少类完全限定名的冗余。 -->
       <typeAliases>
           <package name="com.ljs.Hello.entity"/>
       </typeAliases>
       <!--  配置数据库的环境	-->
       <environments default="test">
           <!--  开发环境	-->
           <environment id="test">
               <!-- 事务管理   -->
               <transactionManager type="JDBC">
               </transactionManager>
               <!-- 连接池 -->
               <dataSource type="POOLED">
                   <property name="driver" value="com.mysql.jdbc.Driver"/>
                   <property name="url" value="jdbc:mysql:///mybatis"/>
                   <property name="username" value="root"/>
                   <property name="password" value="123456"/>
               </dataSource>
           </environment>
       </environments>
       <!-- 关联映射文件 -->
       <mappers>
         	
       </mappers>
   </configuration>

   # Rules reminder:
   # TRACE < DEBUG < INFO < WARN < ERROR < FATAL
   
   # Global logging configuration
   log4j.rootLogger=DEBUG, stdout
   
   # My logging configuration...
   log4j.logger.org.mybatis.jpetstore=DEBUG
   
   ## Console output...
   log4j.appender.stdout=org.apache.log4j.ConsoleAppender
   log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
   log4j.appender.stdout.layout.ConversionPattern=%5p %d %C: %m%n

    

5. 编写dao接口

   public interface UserDAO {
   	void save(User user);
   	User getById(Integer id);
   }
   

    

6. 编写映射文件

   <?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.ljs.Hello.dao.UserDAO">
   	<insert id="save">
   		insert into t_user (name,sex) values (#{name},#{sex})
   	</insert>
   	<select id="getById" resultType="User">
   		select * from t_user where id = #{id}
   	</select>
   </mapper>

    

7. 在配置文件中关联映射文件

   <!-- 关联映射文件 -->
   <mappers>
       <mapper resource="com/ljs/Hello/dao/UserDAOMapper.xml"/>
   </mappers>

    

8. 进行测试

   public class TestHelloMybatis {
   	public static void main(String[] args) throws Exception {
   		//1.读取配置文件生成SqlSessionFactory
   		InputStream inputStream = 
   				Resources.getResourceAsStream("mybatis-config.xml");
   		SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
   		//2.获得SqlSession
   		SqlSession session = sessionFactory.openSession();
   		//3.获取dao实例
   		UserDAO dao = session.getMapper(UserDAO.class);
   		//4.进行持久化操作
   		User user = new User();
   		user.setName("李白");
   		user.setSex("男");
   		dao.save(user);
   		//5.事务提交
   		session.commit();
   		//6.关闭session
   		session.close();
   	}
   }
   

    

9. 测试结果