Mybatis的sql注释

//mapper下的sql注释packagecom.msb.mapper;importcom.msb.pojo.Dept;importcom.msb.pojo.Emp;importorg.apache.ibatis.annotations.delete;importorg.apache.ibatis.annotations.insert;importorg.apache.ibatis.annotations.select;importorg.apache.ibatis.annotations.update;importjava.awt.*;publicinterfaceEmpTestMapper{@select("select*fromdeptwheredeptno=#{deptno}")DeptfindByDeptno(intdeptno);@update("updatedeptsetdname=#{dname},loc=#{loc}wheredeptno=#{deptno}")intupdateDept(Deptdept);@insert("insertintodeptvalues(DEFAULT,#{dname},#{loc})")intaddDept(Deptdept);@delete("deletefromdeptwheredeptno=#{deptno}")intremoveDept(intdeptno);}

<?xmlversion="1.0"encoding="UTF-8"?><!DOCTYPEmapperPUBLIC"-//mybatis.org//DTDMapper3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mappernamespace="com.msb.mapper.EmpTestMapper"><!--resultMap是一个映射表,对应的字段会对应数据表的字段--><!--List<Emp>findEmp();--></mapper>

importcom.msb.mapper.DeptMapper;importcom.msb.mapper.EmpMapper;importcom.msb.mapper.EmpTestMapper;importcom.msb.pojo.Dept;importcom.msb.pojo.Emp;importcom.msb.pojo.Projectrecord;importcom.msb.pojo.Projects;importorg.apache.ibatis.io.Resources;importorg.apache.ibatis.session.SqlSession;importorg.apache.ibatis.session.SqlSessionFactory;importorg.apache.ibatis.session.SqlSessionFactoryBuilder;importorg.junit.After;importorg.junit.Before;importorg.junit.Test;importjava.io.IOException;importjava.io.InputStream;importjava.util.Date;importjava.util.List;publicclassTest1{SqlSessionsqlSession=null;EmpMappermapper=null;@Beforepublicvoidtest1(){//首先做一个对象SqlSessionFactoryBuilder建立一个绘话SqlSessionFactoryBuilderssfb=newSqlSessionFactoryBuilder();//有一个文本输入的io流进行读取操作InputStreamstream=null;try{//这里的路径直接会定位到配置文件classes下面;所以这个文件在次目录下--编译和//-图纸;对数据库文件进行读取,获取一个io流,由于配置文件在classes下面,直接写文件名即可stream=Resources.getResourceAsStream("sqlMapConfig.xml");}catch(IOExceptione){e.printStackTrace();}//build需要指向一个文件进行读取出来--工厂SqlSessionFactoryfactory=ssfb.build(stream);//需要用sqlSession去调用增删改查--工人去获取数据,打开这个绘话sqlSession=factory.openSession(true);}@Testpublicvoidtest4(){EmpTestMappermapper=sqlSession.getMapper(EmpTestMapper.class);Deptemp=mapper.findByDeptno(20);Deptdept=newDept();dept.setDeptno(null);dept.setLoc("大格");dept.setDname("水军");intaddDept=mapper.addDept(dept);System.out.println(addDept);System.out.println(emp);}@Afterpublicvoidtest3(){if(sqlSession!=null){sqlSession.close();}}}

到此,关于“Mybatis的sql注释问题怎么解决”的学习就结束了,希望能够解决大家的疑惑。理论与实践的搭配能更好的帮助大家学习,快去试试吧!若想继续学习更多相关知识,请继续关注本站网站,小编会继续努力为大家带来更多实用的文章!