完成ssm整合后，进行crud练习
controller
@Controller
@RequestMapping("/dept")
public class DepartmentController {
private static final Logger l
= LoggerFactory
.getLogger(DepartmentController
.class);
@Autowired
private IDepartmentService iDepartmentService
;
@RequestMapping(path
= "/listUI", method
= RequestMethod
.GET
)
public String
list(HttpServletRequest request
, Model model
) {
List
<Department> depts
= iDepartmentService
.findAllDepartments();
model
.addAttribute("list",depts
);
return "list_depts";
}
@RequestMapping(path
= "/addUI", method
= RequestMethod
.GET
)
public String
addUI() {
l
.info("addUI ");
return "add_dept";
}
@RequestMapping(path
= "/save", method
= RequestMethod
.POST
)
public String
save(Department dept
, Model model
) {
if (dept
.getDname() != null
&& !"".equals(dept
.getDname())) {
iDepartmentService
.saveDepartment(dept
);
l
.info("save dept=" + dept
);
return "redirect:/dept/list";
} else {
model
.addAttribute("error_msg", "部门名称不能为空");
return "forward:/error.jsp";
}
}
@RequestMapping(path
= "/delete", method
= RequestMethod
.GET
)
public String
delete(Integer did
) {
l
.info("delete did = " + did
);
try {
iDepartmentService
.deleteDepartmentById(did
);
} catch (Exception e
) {
e
.printStackTrace();
}
return "list_depts";
}
@RequestMapping(path
= "/updateUI", method
= RequestMethod
.GET
)
public String
updateUI(Integer did
, Model model
) {
l
.info("updateUI did = " + did
);
Department department
= iDepartmentService
.findDepartmentById(did
);
model
.addAttribute("dept", department
);
return "update_dept";
}
@RequestMapping(path
= "/find", method
= RequestMethod
.GET
)
public @ResponseBody
Object
find(Integer did
) {
l
.info("find did=" + did
);
if (did
!= null
) {
Department dept
= iDepartmentService
.findDepartmentById(did
);
if (dept
!= null
) {
return Msg
.init(200, null
, dept
);
}
}
return Msg
.init(-200, "没有查询结果", null
);
}
@RequestMapping("/pageUI")
public String
getPageUI(){
return "listPage";
}
}
service
@Service
public class DempartmentServiceImpl implements IDepartmentService {
@Autowired
private IDepartmentDao dao
;
@Override
public List
<Department> findAllDepartments() {
List
<Department> list
= dao
.findAll();
return list
;
}
@Override
public void saveDepartment(Department dept
) {
dao
.save(dept
);
}
@Override
public void deleteDepartmentById(int id
) {
dao
.deleteById(id
);
}
@Override
public void updateDepartmentById(Department dept
) {
dao
.update(dept
);
}
@Override
public Department
findDepartmentById(int did
) {
return dao
.findById(did
);
}
}
dao
public interface IDepartmentDao {
List
<Department> findAll();
void save(Department dept
);
void deleteById(int id
);
void update(Department dept
);
Department
findById(int did
);
}
<?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.xy.dao.IDepartmentDao">
<select id="findAll" resultType="department">
select * from department order by did asc
</select>
<insert id="save" parameterType="department">
insert into department values(null,#{dname})
</insert>
<delete id="deleteById" parameterType="int">
delete from department where did =#{id}
</delete>
<update id="update" parameterType="department">
update department set dname = #{dname} where did = #{did}
</update>
<select id="findById" parameterType="int" resultType="department">
select * from department where did = #{did}
</select>
</mapper>
界面截图
