ssm框架Dao层、Service层

ny060501

已于 2022-11-10 09:44:55 修改

阅读量180

点赞数

文章标签： java 服务器

于 2022-06-13 17:11:08 首次发布

本文链接：https://blog.csdn.net/hs1452/article/details/125263761

版权

该博客介绍了如何使用MyBatis框架定义DAO接口，包括创建部门、按ID查询部门、按名称查询部门、更新部门名称以及删除部门的方法。通过@Insert、@Select、@Update和@Delete注解实现SQL操作，并在Service层进行调用。

摘要由CSDN通过智能技术生成

public interface DepartmentDao {

   @Insert("insert into department(name,description) values(#{name},#{description})")
       @Options(useGeneratedKeys=true,keyProperty="id",keyColumn="id")
        public int createDepartment(Department department);

        @Select("select id,name,description from department where id=#{id}")
       public DepartmentDao readDepartmentById(int id);

        @Select("select id,name,description from department where name like #{name}")
       public List<Department> readDepartmentByName(String name);

        @Update("update department set name=#{name} where id=#{id}")
        public int updateDepartmentNameById(Department department);

        @Delete("delete from department where id=#{id}")
       public int deleteDepartmentById(int id);
   }

public interface DepartmentService {

   public   int pubDepartment(Department department);

   public List<Department> queryDepartmentName(String name);

public int modifyDepartmentNameById(Department department);

public int deleteDepartmentById(int id);
}

ServiceImpl层

@Service
public class DepartmentServiceImpl implements DepartmentService{
   @Autowired
   private DepartmentDao departmentDao;
   @Override
   public int pubDepartment(Department department) {
       int result = departmentDao.createDepartment(department);
       return result;

}

   @Override
   public List<Department> queryDepartmentName(String name) {
       // TODO Auto-generated method stub
       return departmentDao.readDepartmentByName("%"+name+"%");
   }

   @Override
   public int modifyDepartmentNameById(Department department) {
       // TODO Auto-generated method stub
       return departmentDao.updateDepartmentNameById(department);
   }

   @Override
   public int deleteDepartmentById(int id) {
       // TODO Auto-generated method stub
       return departmentDao.deleteDepartmentById(id);
   }

}

Dto