學習目標
- （1）CRUD-不包含ajax
- （2）CRUD-包含ajax
- （3）CRUD-包含ajax-bootstrap
專案簡介
-（1）專案的經典模塊-CRUD功能
- （2）什么是CRUD
CRUD：Create（ 創 建 ） Retrieve（查詢） Update（更新） Delete（洗掉）
- （3）使用什么技術
ssm:SpringMVC+Spring+MyBatis - （4）版本
V1 : ssm
V2 : ssm+Ajax
V3 : ssm+Ajax+bootstrap
sql資料庫的設計
create database crud;
use crud;
create table department(
did int primary key auto_increment,
dname varchar(20)
)
insert into department values(null,'java');
insert into department values(null,'測驗');
insert into department values(null,'需求');
create table employee(
eid int primary key auto_increment,
ename varchar(20),
gender varchar(20),
did int
)
insert into employee values(null,'jack','1',1);
insert into employee values(null,'rose','1',1);
insert into employee values(null,'tony','1',2);
ssm搭建
》復制搭建好的SSM為SSM_CRUD
》修改SSM_CRUD pom.xml
<artifactId>ssm02_crud</artifactId>
...
<name>ssm02_crud</name>
》修改Project pom.xml
<modules>
<module>ssm01</module>
<module>ssm02_crud</module>
</modules>
執行一下以上兩個pom.xml
查詢后臺代碼：保證資料正確
TestDepartmentService
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("classpath:applicationContext.xml")
public class TestDepartmentService {
private static final Logger l = LoggerFactory.getLogger(TestDepartmentService.class);
@Autowired
IDepartmentService service;
@Test
public void test01() {//
List<Department> list = service.findAllDepartments();
l.info("test01 list=" + list);
}
}
Department
public class Department {
private Integer did;
private String dname;
public Department() {
}
public Department(String dname) {
this.dname = dname;
}
@Override
public String toString() {
return "Department{" +
"did=" + did +
", dname='" + dname + '\'' +
'}';
}
DepartmentServiceImpl
@Service
public class DempartmentServiceImpl implements IDepartmentService {
@Autowired
private IDepartmentDao dao;
@Override
public List<Department> findAllDepartments() {
List<Department> list = dao.findAll();
return list;
}
}
IDepartmentDao
public interface IDepartmentDao {
//select * from department order by did asc;
List<Department> findAll();
}
IDepartmentDao.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.wzx.dao.IDepartmentDao">
<select id="findAll" resultType="department">
select * from department order by did asc;
</select>
</mapper>
查詢前臺代碼：顯示
DepartmentController
@RequestMapping("/dept")
public class DepartmentController {
private static final Logger l = LoggerFactory.getLogger(DepartmentController.class);
@Autowired
private IDepartmentService iDepartmentService;
@RequestMapping(path = "/list",method = RequestMethod.GET)
public String list(Model model){
List<Department> depts = iDepartmentService.findAllDepartments();
l.info("list depts="+depts);
//資料添加到頁面
model.addAttribute("depts",depts);
return "list_depts";
}
}
list_depts.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" isELIgnored="false" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<a href="">新增</a>
<table border="1px" width="100%">
<tr>
<td>編號</td>
<td>部門名稱</td>
<td>管理</td>
</tr>
<c:forEach items="${depts}" var="dept">
<tr>
<td>${dept.did}</td>
<td>${dept.dname}</td>
<td><a href="">洗掉</a><a href="">修改</a></td>
</tr>
</c:forEach>
</table>
</body>
</html>
添加后臺代碼
TestDepartmentService
@Test
public void test02() {//
Department dept = new Department("UI設計部門");
service.saveDepartment(dept);
}
IDepartmentService
//添加一個新的部門
void saveDepartment(Department dept);
DepartmentServiceImpl
@Override
public void saveDepartment(Department dept) {
dao.save(dept);
}
IDepartmentDao
//insert into department values(null,'UI');
void save(Department dept);
IDepartmentDao.xml
<insert id="save" parameterType="department">
insert into department values(null,#{dname});
</insert>
添加前臺代碼
DepartmentController
@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";
}
}
add_dept.jsp
<form method="post" action="${pageContext.request.contextPath}/dept/save">
<input type="text" name="dname"/><br/>
<input type="submit" value="保存"/><br/>
</form>
洗掉后臺代碼
TestDepartmentService
@Test
public void test03() {//
service.deleteDepartmentById(1);
}
IDepartmentService
//洗掉指定id的部門資料
void deleteDepartmentById(int i);
DepartmentServiceImpl
@Override
public void deleteDepartmentById(int id) {
dao.deleteById(id);
}
IDepartmentDao
//delete from department where did = 5;
void deleteById(int id);
IDepartmentDao.xml
<delete id="deleteById" parameterType="int">
delete from department where did =#{id};
</delete>
洗掉前臺代碼
list_depts.jsp
<a href="${pageContext.request.contextPath}/dept/delete?did=${dept.did}">洗掉</a>
DepartmentController
//delete
@RequestMapping(path = "/delete",method = RequestMethod.GET)
public String delete(Integer did){
l.info("delete did = "+did);
iDepartmentService.deleteDepartmentById(did);
return "redirect:/dept/list";
}
修改后臺代碼
- 修改功能，需要在打開頁面的同時，查詢一下資料，把資料帶到頁面進行同賦值，這操作叫做回顯
TestDepartmentService
@Test
public void test04() {//
Department dept = new Department();
dept.setDid(3);
dept.setDname("最牛部門");
service.updateDepartmentById(dept);
}
@Test
public void test05() {//為了方便用戶修改，會在打開修改頁面時做一個回顯
//獲取id，查找資料，再將資料帶到頁面賦值
Department dept = service.findDepartmentById(1);
l.info("test05 dept="+dept);
}
IDepartmentService
//根據指定id修改部門名稱
void updateDepartmentById(Department dept);
//查找指定id的部門資料
Department findDepartmentById(int did);
DepartmentServiceImpl
@Override
public void updateDepartmentById(Department dept) {
dao.update(dept);
}
@Override
public Department findDepartmentById(int did) {
return dao.findById(did);
}
IDepartmentDao
//update department set dname = ? where did = 1;
void update(Department dept);
//select * from department where did = 1;
Department findById(int did);
IDepartmentDao.xml
<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>
修改前臺代碼
DepartmentController
//updateUI?did=23
@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";
}
//update
@RequestMapping(path="/update",method = RequestMethod.POST)
public String update(Department dept){
//列印
l.info("update dept="+dept);
//呼叫service
iDepartmentService.updateDepartmentById(dept);//
//跳到查詢頁面
return "redirect:/dept/list";
}
update_dept.jsp
<form method="post" action="${pageContext.request.contextPath}/dept/update">
<input type="hidden" name="did" value="${dept.did}" >
<input type="text" value="${dept.did}" disabled="disabled"/><br/>
<input type="text" name="dname" value="${dept.dname}"/><br/>
<input type="submit" value="保存修改"/><br/>
</form>
- form表單 不會將 標記為
disabled="disabled"作為引數提交到后臺 - 所以，必須增加一個
type="hidden"的input標簽
轉載請註明出處，本文鏈接：https://www.uj5u.com/ruanti/181683.html
標籤：其他