MyBatis的增删改查

MyBatis的新增

使用MyBatis进行数据库的添加

在Test的main函数里面先读取Mybatis.xml里的数据连接池 再创建SqlSessionFactory打开SqlSession紧接着再连接dao包的接口给实体类赋值

InputStream stream = Resources.getResourceAsStream("Myboatis.xml"); SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(stream); SqlSession session = factory.openSession(); Mapperdao mapperdao = session.getMapper(Mapperdao.class); Emp emp = new Emp(); emp.setEname("好好"); mapperdao.add(emp); session.commit(); session.close();

给实体类赋值完成后进入到dao包接口创建方法最后进行在xml文件所在的位置进行sql语句的运行

public interface Mapperdao { int add(Emp emp); }

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "https://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="org.example.dao.Mapperdao"> <insert id="add"> insert into emp(ename) values(#{ename}) </insert> </mapper>

MyBatis的修改

使用mybatis进行数据库的修改

在Test的main函数里面先读取Mybatis.xml里的数据连接池 再创建SqlSessionFactory打开SqlSession紧接着再连接dao包的接口给实体类赋值

InputStream stream = Resources.getResourceAsStream("Myboatis.xml"); SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(stream); SqlSession session = factory.openSession(); Mapperdao mapperdao = session.getMapper(Mapperdao.class); Emp emp = new Emp(); emp.setEname("好"); emp.setEmpno("41"); mapperdao.update(emp);         session.commit();         session.close();

给实体类赋值完成后进入到dao包接口创建方法最后进行在xml文件所在的位置进行sql语句的运行

public interface Mapperdao { int update(Emp emp); }

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "https://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="org.example.dao.Mapperdao"> <update id="update"> update emp set ename=#{ename} where empno=#{empno} </update> </mapper>

MyBatis的查询

使用mybatis进行数据库的查询

在Test的main函数里面先读取Mybatis.xml里的数据连接池 再创建SqlSessionFactory打开SqlSession紧接着再连接dao包的接口给实体类赋值

InputStream stream = Resources.getResourceAsStream("Myboatis.xml"); SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(stream); SqlSession session = factory.openSession(); Mapperdao mapperdao = session.getMapper(Mapperdao.class); Emp emp = new Emp(); List<Emp> list = mapperdao.select(emp); System.out.println(list); session.commit(); session.close();

给实体类赋值完成后进入到dao包接口创建方法最后进行在xml文件所在的位置进行sql语句的运行

public interface Mapperdao { List<Emp> select(Emp emp); }

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "https://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="org.example.dao.Mapperdao"> <select id="select" resultType="org.example.entity.Emp"> select * from emp where empno=#{empno} </select> </mapper>

---

MyBatis的删除

使用mybatis进行数据库的删除

在Test的main函数里面先读取Mybatis.xml里的数据连接池 再创建SqlSessionFactory打开SqlSession紧接着再连接dao包的接口给实体类赋值

InputStream stream = Resources.getResourceAsStream("Myboatis.xml"); SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(stream); SqlSession session = factory.openSession(); Mapperdao mapperdao = session.getMapper(Mapperdao.class); Emp emp = new Emp(); emp.setEmpno("41"); mapperdao.delete(emp); session.commit(); session.close();

给实体类赋值完成后进入到dao包接口创建方法最后进行在xml文件所在的位置进行sql语句的运行

public interface Mapperdao { int delete(Emp emp); }

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "https://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="org.example.dao.Mapperdao"> <delete id="delete"> delete from emp where empno=#{empno} </delete> </mapper>