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();
}
}