【mybatis实现数据库表增删改查】

以你之姓@ 2024-04-01 18:27 121阅读 0赞

我的项目目录如下：

![5b493f2bd1154dbe851b12cd66af4d68.png][]

数据库表

![e54d3245f1e14e8dbd9134b1595b380d.png][]

![a18d8a98c0a34152b4343b464296ea0c.png][]

## 代码部分 ##

1、Dept.java

>     package com.qingruan.bean;
>     
>     public class Dept {
>         private Integer dno;
>         private String deptName;
>         private String deptLoc;
>     
>         @Override
>         public String toString() {
>             return "Dept{" +
>                     "dno=" + dno +
>                     ", deptName='" + deptName + '\'' +
>                     ", deptLoc='" + deptLoc + '\'' +
>                     '}';
>         }
>     
>         public Dept(Integer dno, String deptName, String deptLoc) {
>             this.dno = dno;
>             this.deptName = deptName;
>             this.deptLoc = deptLoc;
>         }
>     
>         public Dept() {
>         }
>     
>         public Integer getDno() {
>             return dno;
>         }
>     
>         public void setDno(Integer dno) {
>             this.dno = dno;
>         }
>     
>         public String getDeptName() {
>             return deptName;
>         }
>     
>         public void setDeptName(String deptName) {
>             this.deptName = deptName;
>         }
>     
>         public String getDeptLoc() {
>             return deptLoc;
>         }
>     
>         public void setDeptLoc(String deptLoc) {
>             this.deptLoc = deptLoc;
>         }
>     }

2、IDeptDao.java

>     package com.qingruan.dao;
>     
>     import com.qingruan.bean.Dept;
>     
>     import java.util.List;
>     
>     public interface IDeptDao {
>         /**
>          * 查询所有部门信息
>          */
>         public List<Dept> findAllDept();
>     
>         /**
>          * 根据id查询单条数据
>          * @param deptNo
>          * @return
>          */
>         public Dept findById(Integer deptNo);
>     
>         /**
>          * 新增部门
>          * @param dept
>          * @return 受影响的行数
>          */
>         public int saveDept(Dept dept);
>     
>         /**
>          * 修改
>          * @param dept
>          * @return
>          */
>         public int updateDept(Dept dept);
>     
>         /**
>          * 删除
>          * @param dno
>          * @return
>          */
>         public int deleteDept(Integer dno);
>     
>         /**
>          * 模糊查询
>          * @return
>          */
>         public List<Dept> findByDeptName(String deptName);
>     
>         /**
>          * 总记录数
>          * @return
>          */
>         public int findTotal();
>     
>     }

3、IDeptDao.xml

>     <?xml version="1.0" encoding="UTF-8" ?>
>     <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
>     
>     
>     <mapper namespace="com.qingruan.dao.IDeptDao">
>     
>         
>         <select id="findAllDept"  resultType="com.qingruan.bean.Dept">
>             select * from dept
>         </select>
>     
>         
>         <select id="findById" resultType="com.qingruan.bean.Dept" parameterType="int">
>             select * from dept where dno=#{deptno}
>         </select>
>     
>         
>         <insert id="saveDept" parameterType="com.qingruan.bean.Dept">
>             /*配置保存时获取插入的id*/
>             <selectKey keyColumn="dno" keyProperty="dno" resultType="int">
>                 /*得到刚新增进去的自增主键id*/
>                 select last_insert_id();
>             </selectKey>
>     
>             insert into dept(deptName,deptLoc) values(#{deptName},#{deptLoc})
>         </insert>
>     
>         <update id="updateDept" parameterType="com.qingruan.bean.Dept">
>             update dept set deptName&

[5b493f2bd1154dbe851b12cd66af4d68.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/01/b2aad5f9d64a4aa98f923900fe6de6a2.png
[e54d3245f1e14e8dbd9134b1595b380d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/01/4d25a36199a244fc9da05fc21bb87c03.png
[a18d8a98c0a34152b4343b464296ea0c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/01/e1d09b27c5f6430b92a9132f6d895988.png