创建数据库与表并插入测试数据

CREATE DATABASE `mybatis` /*!40100 COLLATE 'utf8_general_ci' */;CREATE USER 'mybatis'@'192.168.%' IDENTIFIED BY 'mybatis';GRANT USAGE ON *.* TO 'mybatis'@'192.168.%';GRANT SELECT, EXECUTE, SHOW VIEW, ALTER, ALTER ROUTINE, CREATE, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE VIEW, DELETE, DROP, EVENT, INDEX, INSERT, REFERENCES, TRIGGER, UPDATE, LOCK TABLES  ON `mybatis`.* TO 'mybatis'@'192.168.%' WITH GRANT OPTION;FLUSH PRIVILEGES;SHOW GRANTS FOR 'mybatis'@'192.168.%';CREATE TABLE IF NOT EXISTS `user` (  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,  `name` varchar(50) DEFAULT NULL,  `age` int(10) unsigned DEFAULT NULL,  PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;INSERT INTO `user` (`id`, `name`, `age`) VALUES	(1, 'Neo', 35),	(2, 'Jerry', 36);

Maven pom.xml 中加入依赖包

    		
     			
      
       org.mybatis
      			
      
       mybatis
      			
      
       3.3.0
      		
     		
     			
      
       mysql
      			
      
       mysql-connector-java
      			
      
       5.1.37
      		
     	
    

pom.xml

    	
     
      4.0.0
     	
     
      MyBatis
     	
     
      MyBatis
     	
     
      0.0.1-SNAPSHOT
     	
     		
      			
       
        junit
       			
       
        junit
       			
       
        3.8.1
       			
       
        test
       		
      		
      			
       
        org.mybatis
       			
       
        mybatis
       			
       
        3.3.0
       		
      		
      			
       
        mysql
       			
       
        mysql-connector-java
       			
       
        5.1.37
       		
      	
     	
     		
      
       src
      		
      			
       				
        
         maven-compiler-plugin
        				
        
         3.3
        				
        					
         1.8					
         
          1.8
         				
        			
       		
      	
     
    

src/mybatis.xml

src/cn/netkiller/mapping/userMapping.xml

    
    	
     		select * from user where id=#{id}	
    

resultType 文件

package cn.netkiller.model;public class User {	private String id;	private String name;	private int age;	public String getId() {		return id;	}	public void setId(String id) {		this.id = id;	}	public String getName() {		return name;	}	public void setName(String name) {		this.name = name;	}	public int getAge() {		return age;	}	public void setAge(int age) {		this.age = age;	}	@Override	public String toString() {		return "User [id=" + id + ", name=" + name + ", age=" + age + "]";	}}

测试代码

package cn.netkiller.test;import java.io.InputStream;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;import cn.netkiller.model.*;public class Tests {	public static void main(String[] args) {		// TODO Auto-generated method stub		String resource = "mybatis.xml";		InputStream is = Tests.class.getClassLoader().getResourceAsStream(resource);		SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(is);		SqlSession session = sessionFactory.openSession();		String statement = "cn.netkiller.mapping.UserMapping.getUser";// 映射sql的标识字符串		User user = session.selectOne(statement, "2");		System.out.println(user.toString());	}}