先建立一个maven项目，将mybatis依赖写入pom文件
org.mybatis mybatis3.5.10 cglib cglib2.2.2 asm asm3.3.1
根据数据库中的表建立实体类
package com.mypro.entity;
public class Class {
Integer cid ;
String cname;
String cteacher;
public Class(Integer cid, String cname, String cteacher) {
this.cid = cid;
this.cname = cname;
this.cteacher = cteacher;
}
public Class() {
}
public Integer getCid() {
return cid;
}
public void setCid(Integer cid) {
this.cid = cid;
}
@Override
public String toString() {
return "Class{" +
"cid=" + cid +
", cname='" + cname + ''' +
", cteacher='" + cteacher + ''' +
'}';
}
public String getCname() {
return cname;
}
public void setCname(String cname) {
this.cname = cname;
}
public String getCteacher() {
return cteacher;
}
public void setCteacher(String cteacher) {
this.cteacher = cteacher;
}
}
建立mapper接口
public interface ClassMapper {
@Select("select * from class")
public List queryAllClass();
public Class querySingeClass(Integer cid);
public boolean updateClass(Class cla);
public boolean addClass(Class cla);
public boolean deleteClass(Integer cid);
}
写入mappar的配置文件
将写入的mapper的配置文件与configuration.xml文件关联
二、配置工作完成，建立测试类 测试类一使用sqlSession.selectList（）形式运行
public class test1 {
public static void main(String[] args) {
SqlSession sqlSession = DbUtil.getSqlSession();
List list =sqlSession.selectList("queryAllClass");
for (Class c :list){
System.out.println(c);
}
Class querySingeClass = (Class)sqlSession.selectOne("querySingleClass", new Integer(1));
System.out.println(querySingeClass);
int deleteClass = sqlSession.insert("deleteClass", new Integer(7));
sqlSession.commit();
sqlSession.close();
}
}
输出结果
测试类二使用sqlSession.getMapper
将获得的mapper作为dao对象使用增删改查。
public class test2 {
public static void main(String[] args) {
SqlSession sqlSession = DbUtil.getSqlSession();
StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
List students = mapper.queryAllStudent();
Student student = mapper.querySingeStudent(1);
System.out.println(students);
System.out.println(student);
Student student1 = new Student(10,"lmj","man",2,99,22);
Student student2 = new Student(6,"lq","man",2,99,22);
mapper.updateStudent(student2);
sqlSession.commit();
sqlSession.close();
}
}
输出结果
三、总结
使用mapper配置很麻烦一不小心就会报错，配置是需小心谨慎，将配置内容写成文档，以后使用时直接复制粘贴即可。
