ibatis別名(mybatis)使用方法jdbcのパッケージ

3558 ワード

1. lib ;

2. src :SqlMapConfig.xml




	
		
		
	
	
		
			
			
				
				
				
				
			
		 
	
	
		
		
	


3. :

Admin.xml




	
		insert into t_admin (username,password) values (#{username},#{password})
	
	
	

4. ibatisAPI :
 
  
 
   
   
  
package cn.com.leadfar.cms.backend.dao.impl;

import org.apache.ibatis.session.SqlSession;

import cn.com.leadfar.cms.backend.dao.AdminDao;
import cn.com.leadfar.cms.backend.model.Admin;
import cn.com.leadfar.cms.utils.MyBatisUtil;

public class AdminDaoForMyBatisImpl extends BaseDao implements AdminDao {

	public void addAdmin(Admin admin) {
		add(admin);
	}

	public Admin findAdminByUsername(String username) {
		//    session
		SqlSession session = MyBatisUtil.getSession();
		Admin admin = null;
		try {
			
			admin = (Admin)session.selectOne(Admin.class.getName()+".findAdminByUsername", username);
			
		} catch (Exception e) {
			e.printStackTrace();
		} finally{
			//  session
			session.close();
		}
		return admin;
	}

}
5.leadfar.cms.utils


package cn.com.leadfar.cms.utils;

import java.io.IOException;
import java.io.Reader;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

public class MyBatisUtil {
	static SqlSessionFactory factory = null;
	static{
		try {
			//      ,      
			Reader reader = Resources.getResourceAsReader("SqlMapConfig.xml");
			factory = new SqlSessionFactoryBuilder().build(reader);
		} catch (IOException e1) {
			e1.printStackTrace();
		}
	}
	
	public static SqlSession getSession(){
		return factory.openSession();
	}
	
}