mybatis学习之一

1、创建一个Java project，JikeBook

2、添加项目所需的依赖包

如 mybatis-3.2.8.jar,是实现mybatis功能所必需的依赖包

    mysql-connector-java-3.0.17-ga-bin.jar是连接mysql数据库的依赖包，

    log4j是日志输出依赖包

 

3、在src目录下创建各个package

4、首先创建log4j.properties

 1 log4j.rootLogger=DEBUG, Console  
 2   
 3 #Console  
 4 log4j.appender.Console=org.apache.log4j.ConsoleAppender  
 5 log4j.appender.Console.layout=org.apache.log4j.PatternLayout  
 6 log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n  
 7   
 8 log4j.logger.java.sql.ResultSet=INFO  
 9 log4j.logger.org.apache=INFO  
10 log4j.logger.java.sql.Connection=DEBUG  
11 log4j.logger.java.sql.Statement=DEBUG  
12 log4j.logger.java.sql.PreparedStatement=DEBUG

将一些日志的输出更改为DEBUG，才能输出相关日志信息

5、在jike.book.map包下创建jikeUser.xml

 1 <?xml version="1.0" encoding="UTF-8" ?>
 2 
 3 
 4 <!DOCTYPE mapper
 5     PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
 6     "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
 7 
 8 <mapper namespace="/">
 9 
10   <select id="findById"  parameterType="int"  resultType="jike.book.pojo.JiKeUser">
11         select * from jikeUser where id=#{id}
12   </select>
13 
14 
15 </mapper>

 

6、在jike.book.map包下创建MyBatisConfig.xml

 1 <?xml version="1.0" encoding="UTF-8" ?>
 2 
 3 
 4 <!DOCTYPE configuration
 5     PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
 6     "http://mybatis.org/dtd/mybatis-3-config.dtd">
 7 
 8 <configuration>
 9 
10   <environments default="development">
11      <environment id="development">
12        <transactionManager type="JDBC">
13        </transactionManager>
14        <dataSource type="POOLED">
15              <property name="driver" value="com.mysql.jdbc.Driver"/>
16              <property name="url" value="jdbc:mysql://localhost:3306/jikebook"/>
17              <property name="username" value="root"/>
18              <property name="password" value=""/>
19        </dataSource>
20      </environment>
21   </environments>
22 
23   <mappers>
24         <mapper resource="jike/book/map/jikeUser.xml"/>
25   </mappers>
26 
27 </configuration>

 

7、在jike.book.pojo下创建JiKeUser.java

 1 package jike.book.pojo;
 2 
 3 public class JiKeUser {
 4     private int id;
 5     private String userName;
 6     private String password;
 7     public int getId() {
 8         return id;
 9     }
10     public void setId(int id) {
11         this.id = id;
12     }
13     public String getUserName() {
14         return userName;
15     }
16     public void setUserName(String userName) {
17         this.userName = userName;
18     }
19     public String getPassword() {
20         return password;
21     }
22     public void setPassword(String password) {
23         this.password = password;
24     }
25 }

 

8、在jike.book.test下创建TestHello.java

 1 package jike.book.test;
 2 
 3 import java.io.IOException;
 4 import java.io.Reader;
 5 
 6 import jike.book.pojo.JiKeUser;
 7 
 8 import org.apache.ibatis.io.Resources;
 9 import org.apache.ibatis.session.SqlSession;
10 import org.apache.ibatis.session.SqlSessionFactory;
11 import org.apache.ibatis.session.SqlSessionFactoryBuilder;
12 
13 public class TestHello {
14 
15     public static void main(String[] args) {
16 
17         String resource = "jike/book/map/MyBatisConfig.xml";
18         Reader reader = null;
19         SqlSession session;
20         try {
21             reader = Resources.getResourceAsReader(resource);
22         } catch (IOException e) {
23             e.printStackTrace();
24         }
25         SqlSessionFactory sqlMapper = new SqlSessionFactoryBuilder()
26                 .build(reader);
27         session = sqlMapper.openSession();
28         JiKeUser temp = session.selectOne("findById", 1);
29         System.out.println(temp.getUserName());
30         session.close();
31     }
32 
33 }

 9.mysql数据库

最后运行项目：