MyBatis框架(9.0)
使用Annotation配置MyBatis
1,建立INewsDao.java文件;
package cn.mldn.dao;
import java.util.List;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.SelectKey;
import org.apache.ibatis.annotations.Update;
import cn.mldn.vo.News;
public interface INewsDAO {
@Insert("INSERT INTO news(title,pub_date) VALUES (#{title},#{pubdate})")
@SelectKey(before = false, keyProperty = "nid", resultType = java.lang.Integer.class, statement = "SELECT LAST_INSERT_ID()")
public boolean doCreate(News vo) throws Exception;
@Update("UPDATE news SET title=#{title},pub_date=#{pubdate} WHERE nid=#{nid}")
public boolean doUpdate(News vo) throws Exception;
@Delete("DELETE FROM news WHERE nid=#{nid}")
public boolean doRemove(Integer id) throws Exception;
@Select("SELECT nid,title,pub_date AS pubdate FROM news WHERE nid=#{nid}")
public News findById(Integer id) throws Exception;
@Select("SELECT nid,title,pub_date AS pubdate FROM news")
public List<News> findAll() throws Exception;
@Select("SELECT nid,title,pub_date AS pubdate FROM news WHERE #{column} LIKE #{keyWord} LIMIT #{start},#{lineSize}")
public List<News> findAllSplit(
@Param("column") String column,
@Param("keyWord") String keyWord,
@Param("start") Integer start,
@Param("lineSize") Integer lineSize) throws Exception;
@Select("SELECT COUNT(*) FROM nid WHERE #{column} LIKE #{keyWord}")
public Integer getAllCount(
@Param("column") String column,
@Param("keyWord") String keyWord) throws Exception;
}
2,修改MyBatisSessionFactory工厂类;
对于接口文件的绑定处理操作都可以直接通过SqlSessionFactory接口完成,在此接口中定义了可以取得全部的配置文件的方法:
public Configuration getConfiguration( )。
该方法返回的是Configuration类对象,在该类中定义有两个方法:
addMapper(); 追加一个类型的定义,包含有Annotation的接口;
addMappers(); 表示将指定包下的具备Annotation的接口自动加载;
修改MyBatisSessionFactory程序类
try {
input = Resources.getResourceAsStream(CONFIG_FILE) ; // 读取配置文件
factory = new SqlSessionFactoryBuilder().build(input) ; // 创建SqlSessionFactory接口对象
factory.getConfiguration().addMappers("cn.mldn.dao");
} catch (Exception e) {
e.printStackTrace();
}
}
使用Annotation实现的接口来进行数据库的操作,那么必须利用SqlSession接口所定义的方法来取得该对象。
范例:实现数据的增加处理
package cn.mldn.anno;
import java.util.Date;
import cn.mldn.dao.INewsDAO;
import cn.mldn.util.MyBatisSessionFactory;
import cn.mldn.vo.News;
public class TestNewsAdd {
public static void main(String[] args) throws Exception {
News vo = new News() ;
vo.setTitle("今天放假!");
vo.setPubdate(new Date());
INewsDAO dao = MyBatisSessionFactory.getSession().getMapper(INewsDAO.class) ;
System.out.println(dao.doCreate(vo));
System.out.println("增长后的ID主键:" + vo.getNid());
MyBatisSessionFactory.getSession().commit();
MyBatisSessionFactory.close();
}
}
不再关注DAO的子类如何实现。
范例:查询全部
package cn.mldn.anno;
import cn.mldn.dao.INewsDAO;
import cn.mldn.util.MyBatisSessionFactory;
public class TestNewsList {
public static void main(String[] args) throws Exception {
INewsDAO dao = MyBatisSessionFactory.getSession().getMapper(
INewsDAO.class);
System.out.println(dao.findAllSplit("title", "%%", 0, 10));
MyBatisSessionFactory.close();
}
}
但在注解里面使用动态sql语句很复杂。