myBatis的入门配置

一、下载相关jar包
http://download.csdn.net/detail/eson_15/9542081

 

 二、引入数据库驱动包

 

三、编写mybatis的核心配置文件mybatis.cfg.xml 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> default="development">
name="url" value="jdbc:mysql://localhost:3306/dbuser"/>

 

1

2

5

6
        
7
    
8
                
9
        
10
            
11
            
12
            
13
            
14
                
15
                
16
                
17
         
18
     
19
   
20
    
21
        
22
        
23
     
24
      
25

 

四、创建数据库

五、创建实体类User

 

六、创建UserMapper.xml
3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
insert into user values(null,#{uname},#{uage},#{upsw})

七、创建UserDAO

八、建立UserDaoImpl实现类
public class UserDAOImpl implements UserDao { @Override public void addUser(User user) { //1
创建SqlSessionFactoryBuilder对象 SqlSessionFactoryBuilder ssfb = new SqlSessionFactoryBuilder(); //2
通过ssfb对象，构造SqlSessionFactory对象 SqlSessionFactory ssf = ssfb.build(this.getClass().getClassLoader()
.getResourceAsStream("mybatis.cfg.xml")); //3 通过ssf创建SqlSession对象 SqlSession sqlSession =ssf.openSession(); //4 数据库crud操作
sqlSession.insert("com.sxt.mapper.UserMapper.addUser", user); //5 提交事务 sqlSession.commit(); } }

 

 九、测试

@Test public void testMybatis(){ UserDAO dao=new UserDAOImpl(); User user = new
User("张三",22,"123456"); dao.addUser(user); }

 

 

十、Log4j的配置log4j.properties

# Global logging configuration log4j.rootLogger=DEBUG, stdout # MyBatis logging configuration...
log4j.logger.org.mybatis.example.BlogMapper=TRACE # Console output...
log4j.appender.stdout=org.apache.log4j.ConsoleAppender log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n