mybaties 入门

一、理解什么是MyBatis？

MyBatis 是支持普通 SQL 查询，存储过程和高级映射的优秀持久层框架。 MyBatis 消除了几乎所有的 JDBC 代码和参数的手工设置以及对结果集的检索。 MyBatis 可以使用简单的XML 或注解用于配置和原始映射，将接口和 Java 的 POJO（ Plain Old Java Objects，普通的Java 对象）映射成数据库中的记录.

mybatis的着力点，则在于POJO与SQL之间的映射关系。

二、简单例子（快速入门）

1、oracle.properties文件

jdbc.driver=oracle.jdbc.driver.OracleDriver jdbc.url=jdbc:oracle:thin:@127.0.0.1:1521:test jdbc.username=test jdbc.password=root

2、mybaties-config.xml文件

 
  xml version="1.0" encoding="UTF-8"?> configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">  
     
     
     
     resource 
     ="oracle.properties" 
     > 
        
       
     
      
      
       
     
     name 
     ="com.cy.mybatis.beans" 
     />  
       
       
      
        
       
      
       
       default 
       ="cybatis" 
       >  
        
         
         id 
         ="cybatis" 
         >  
           
          
            
           
          
           
           type 
           ="JDBC"  
           />  
             
             
            
              
            
              
            
              
            
              
             
            
             
             type 
             ="POOLED" 
             >  
              
               
               name 
               ="driver"  
               value 
               ="${jdbc.driver}"  
               />  
                
                 
                 name 
                 ="url"  
                 value 
                 ="${jdbc.url}"  
                 />  
                  
                   
                   name 
                   ="username"  
                   value 
                   ="${jdbc.username}"  
                   />  
                    
                     
                     name 
                     ="password"  
                     value 
                     ="${jdbc.password}"  
                     />  
                       
                     
                   
                 
               
              
             
           
          
         
        
      
       
       
       
      
        
      
        
       
      
       
       name 
       ="com.spring.mapper" 
       />  
         
        
       
    

3、UserMapper.xml文件

 
  xml version="1.0" encoding="UTF-8"?> mapper PUBLIC "-//mybatis.org/DTD Mapper 3.0" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">  
     
     namespace 
     ="com.spring.mapper.UserMapper" 
     > 
       
       
      
       
       id 
       ="insertUser"  
       parameterType 
       ="UserBean" 
       >  
        insert into t_users(username,password,account) values (#{username},#{password},#{account}) 
        
        
      
       
       id 
       ="updateUser"  
       parameterType 
       ="UserBean" 
       >  
        update t_users set username=#{username},password=#{password},account=#{account} where id=#{id} 
        
        
      id="selectUser" resultType="UserBean">  
      id="selectAllUser" resultType="UserBean"> select * from t_users where id=#{id}   
      
       
       id 
       ="deleteUser" 
       >  
        delete from t_users where id=#{id} 
        
        
      
    

4、UserMapper

public interface UserMapper { public int insertUser(UserBean user);  public int deleteUser(UserBean user);  public UserBean selectUser(UserBean user);  public int updateUser(UserBean user);  public List<UserBean> selectAllUser(String id);  }

5,UserBean

public class UserBean { private String id;  private String username;  private String password;  private Integer account;}

6、DBtools

public class DBTools { public static SqlSessionFactory sqlSessionFactory;  static{ try{ Reader resourceAsReader = Resources.getResourceAsReader("mybaties-config.xml");  sqlSessionFactory= new SqlSessionFactoryBuilder().build(resourceAsReader);   }catch (Exception e){ e.printStackTrace();  } } public static SqlSession getSession(){ return sqlSessionFactory.openSession();  } }

7、测试

public class testDemo2 { public static void main(String[] args){ insertUser();   } private static void insertUser() { SqlSession session = DBTools.getSession();  UserMapper mapper = session.getMapper(UserMapper.class);  UserBean user = new UserBean("001001","懿", "", 700);  try { mapper.insertUser(user);  System.out.println(user.toString());  session.commit();  } catch (Exception e) { e.printStackTrace();  session.rollback();  } } }

三、问题

org.apache.ibatis.binding.BindingException: Invalid bound statement (not found)

<build> 　　<resources> 　　　　<resource> 　　　　　　　　<directory>src/main/java 
   directory> 　　　　　　<includes> 　　　　　　　　<include>/*.xml 
   include> 　　　　　　 
   includes> 　　　　 
   resource> 　　　　<resource> 　　　　　　<directory>src/main/resources 
   directory> 　　　　 
   resource> 　　 
   resources>  
   build>