package com.mybatis.myb.model;import java.util.Date;public class ClassBean{ private Integer classId; private String className; private Date classTime; private String classRoom; private TeacherBean teacher; public Integer getClassId() { return classId; } public void setClassId(Integer classId) { this.classId = classId; } public String getClassName() { return className; } public void setClassName(String className) { this.className = className; } public Date getClassTime() { return classTime; } public void setClassTime(Date classTime) { this.classTime = classTime; } public String getClassRoom() { return classRoom; } public void setClassRoom(String classRoom) { this.classRoom = classRoom; } public TeacherBean getTeacher() { return teacher; } public void setTeacher(TeacherBean teacher) { this.teacher = teacher; }}
package com.mybatis.myb.model;public class TeacherBean { private Integer tId; private String cTeacher; private Integer type; public Integer gettId() { return tId; } public void settId(Integer tId) { this.tId = tId; } public String getcTeacher() { return cTeacher; } public void setcTeacher(String cTeacher) { this.cTeacher = cTeacher; } public Integer getType() { return type; } public void setType(Integer type) { this.type = type; }}
7. 编写Mapper接口
package com.mybatis.myb.dao;import java.util.List;import org.apache.ibatis.annotations.Param;import org.apache.ibatis.annotations.Select;import com.mybatis.myb.model.ClassBean;public interface ClassDao { public List queryClass(ClassBean vo); public int insertclass(ClassBean vo); //数据库语句写在注解里面，就不用再在xml文件里面配置了，不推荐这种方式 @Select("select * from t_class where classid=#{a} and classname=#{b}") public List queryClassByVo(@Param("a")int classid,@Param("b")String classname); public List queryInfoByIds(@Param("list")List list); public List queryInfoByIdsaa(@Param("ids")String ids); public List selectAll(); public List selectByClass(); }
8. 编写MapperXML文件
SELECT * FROM t_class update t_class classname=#{className}, class_teacher=#{classTeacher}, insert into t_class(classname,class_teacher,class_time,class_room) values(#{className},#{classTeacher},now(),#{classRoom}) delete from t_class where classid in(${ids})
9. 在mybatis配置文件中注册MapperXML文件
在配置文件中加上：
添加后的mybatis-config.xml
10. 编写一个SqlSessionFactory及SqlSession获取工具类
11. 编写一个测试类
package com.mybatis.myb.dao;import java.io.Reader;import java.util.ArrayList;import java.util.List;import org.apache.ibatis.io.Resources;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;import org.junit.After;import org.junit.Before;import org.junit.Test;import com.mybatis.myb.model.ClassBean;public class ClassDaoTest { SqlSession session = null;//sql会话 Reader reader = null;//文件输入字符流 //测试类运行之前执行 //初始化 @Before public void setUp() throws Exception { String resourse = "mybatis-config.xml"; //加载配置文件，创建会话工厂 reader = Resources.getResourceAsReader(resourse); SqlSessionFactory ssf = new SqlSessionFactoryBuilder().build(reader); //创建会话对象，相当于JDBC获取连接对象 session = ssf.openSession(false); } //测试类运行之后执行 @After public void tearDown() throws Exception { session.close(); reader.close(); } @Test public void testQueryClass() { //创建会话对象后获取接口对象 ClassDao dao = session.getMapper(ClassDao.class); ClassBean model = new ClassBean(); //model.setClassTeacher("刘老师"); model.setClassName("UI"); //经过上面的工作后，直接调用接口方法即可实现响应的查询。 //需要传参的可以根据需要直接传基本数据类型，也可以传一个对象，mybatis会获取有值的对象属性作为参数传给MySQL List list = dao.queryClass(model); for(ClassBean vo : list){ //System.out.println(vo.getClassTeacher()); } } @Test public void testInsertClass() { try{ ClassDao dao = session.getMapper(ClassDao.class); ClassBean model = new ClassBean(); //model.setClassTeacher("xxx"); model.setClassName("javaee"); model.setClassRoom("1hao"); dao.insertclass(model); System.out.println(model.getClassId()); session.commit(); }catch(Exception e){ e.printStackTrace(); session.rollback(); } } @Test public void testqueryClassByVo(){ ClassDao dao = session.getMapper(ClassDao.class); dao.queryClassByVo(8, "javaee"); } @Test public void test(){ ClassDao dao = session.getMapper(ClassDao.class); List list = new ArrayList (); ClassBean model = new ClassBean(); model.setClassId(1); list.add(model); model = new ClassBean(); model.setClassId(2); list.add(model); List s = dao.queryInfoByIds(list); } @Test public void tst(){ ClassDao dao = session.getMapper(ClassDao.class); String ids = "1,2,3,4"; List s = dao.queryInfoByIdsaa(ids); } @Test public void testQueryAll(){ ClassDao dao = session.getMapper(ClassDao.class); List s = dao.selectByClass(); for(ClassBean vo : s){ System.out.println(vo.getTeacher().getcTeacher()); } } @Test public void findUserById() throws Exception { //可以根据查询结果直接调用session的方法，第一个参数是mapper文件的namespace加“.”加方法id，如果需要给数据库传参数则加在第二个参数里。 List cb = session.selectList("com.mybatis.myb.dao.ClassDao.selectByClass"); for (ClassBean classBean : cb) { System.out.println(classBean.getTeacher().getcTeacher()); } }}
