二、《学生教务系统》之标签管理模块实现，初级运维工程师面试题

（3）标签功能实现效果图

二、增删/查询所有功能实现

================================================================================

（1）实体类（bean类）

public class Mark implements Serializable {

private Integer mid;

private String mname;

private Date mtime;

private String mtype;

（2）dao接口

public interface MarkDao {

/**

• 添加标签

• @param mark

*/

public void insertMark(Mark mark);

/**

• 删除标签

• @param id

*/

public void deleteMark(Integer id);

/**

• 展示所有标签

• @return

*/

public List selectMark();

}

（3）Mybatis实现Dao接口

insert into t_mark

values (#{mid}, #{mname}, #{mtime}, #{mtype})

delete

from t_mark

where m_id = #{id}

select m_id, m_name, m_time, m_type

from t_mark

（4）Service接口和Service的实现类

• Service接口

public interface MarkService {

/**

• 添加标签

• @param mark

*/

public void insertMark(Mark mark);

/**

• 删除标签

• @param id

*/

public void deleteMark(Integer id);

/**

• 展示所有标签

• @return

*/

public List selectMark();

}

• Service的实现类

public class MarkServiceImpl implements MarkService {

@Override

public void insertMark(Mark mark) {

MarkDao mapper = (MarkDao) MybatisUtil.getMapper(MarkDao.class);

mapper.insertMark(mark);

MybatisUtil.commit();

}

@Override

public void deleteMark(Integer id) {

MarkDao mapper = (MarkDao) MybatisUtil.getMapper(MarkDao.class);

mapper.deleteMark(id);

MybatisUtil.commit();

}

@Override

public List selectMark() {

MarkDao mapper = (MarkDao) MybatisUtil.getMapper(MarkDao.class);

List marks = mapper.selectMark();

MybatisUtil.close();

return marks;

}

}

（5）Struts2实现Controller层

public class MarkAction extends ActionSupport {

private Mark mark;

private List marks;

public String addMark(){

MarkService markService = new MarkServiceImpl();

mark.setMid(null);

mark.setMtime(new Date());

System.out.println(mark);

markService.insertMark(mark);

return SUCCESS;

}

public String deleteMark(){

MarkService markService = new MarkServiceImpl();

markService.deleteMark(mark.getMid());

return SUCCESS;

}

public String selectMark(){

MarkService markService = new MarkServiceImpl();

marks = markService.selectMark();

for (Mark mark : marks) {

System.out.println(mark);

}

return SUCCESS;

}

public Mark getMark() {

return mark;

}

public void setMark(Mark mark) {

this.mark = mark;

}

public List getMarks() {

return marks;

}

public void setMarks(List marks) {

this.marks = marks;

}

}

（6）测试类

public class MarkTest {

@Test

public void insert(){

MarkService markService = new MarkServiceImpl();

Mark mark = new Mark(null,“懒散”,new Date(),“学生”);

markService.insertMark(mark);

}

@Test

public void delete(){

MarkService markService = new MarkServiceImpl();

markService.deleteMark(3);

}

@Test

public void select(){

MarkService markService = new MarkServiceImpl();

List marks = markService.selectMark();

for (Mark mark : marks) {

System.out.println(mark);

}

}

（7）Struts核心配置

selectMark

selectMark

/mark/showMark.jsp

（8）JSP页面

• 展示页面

<%@ page import=“java.util.Date” %>

<%@ page language=“java” contentType=“text/html; charset=utf-8”

pageEncoding=“utf-8” isELIgnored=“false” %>

标签名称:

标签类型:

班级 学生