教务系统 城市+标签+班级+小组+学生（上）

于 2021-11-11 09:01:19 发布
阅读量1k 收藏
点赞数 2
分类专栏： 小小的项目 文章标签： java 后端 mybatis struts2
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/qq_51218906/article/details/121222180
版权
本文详细介绍了教务系统后端的开发，涉及城市模块的分页查询、添加和删除，标签模块包括查询所有、添加和删除学生及班级标签，同时实现了班级和学生标签的颜色区别。班级模块涵盖了展示、添加和删除功能，小组模块增加了计数属性并实现了添加、删除和查询。在学生模块中，实现了分页查询、添加、修改、删除和搜索，同时处理了如年龄、星座、生肖等信息的查询，以及城市、小组和标签的相关联查询。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

城市模块

分页查询+添加+删除

标签模块 

查询所有+(添加/删除)学生标签+班级标签

实现班级和学生标签颜色不同

                <c:forEach var="mark" items="${requestScope.marks}">
                    <tr>
                        <td>${mark.id}</td>
                        <td>${mark.name}</td>
                        <td><fmt:formatDate value="${mark.time}" pattern="yyyy-MM-dd"></fmt:formatDate> </td>
                        <td>
                            <c:if test="${mark.type=='学生'}">
                                <span class="label label-warning">${mark.type}</span>

                            </c:if>
                            <c:if test="${mark.type=='班级'}">
                                <span class="label label-info">${mark.type}</span>
                            </c:if>
                        </td>
                        <td><a href="${pageContext.request.contextPath}/mark/delete?id=${mark.id}" class="btn btn-danger btn-sm">删除</a></td>
                    </tr>
                </c:forEach>

 添加标签时设置时间格式为yyyy-MM-dd

<head>
    <script type="text/javascript">
        window.onload = function (){
            var date = new Date();
            var load = document.getElementById("load");
            load.value = date.getFullYear()+"-"+(date.getMonth()+1)+"-"+date.getDate();
        }
    </script>
</head>

<body>
            <form action="${pageContext.request.contextPath}/mark/insert" method="post">
                <div class="form-group">
                    <label>标签名称:</label>
                    <input type="text" class="form-control" name="mark.name"/>
                </div>
                <div class="form-group">
                    <input id="load" type="hidden" class="form-control" value="" name="mark.time"/>
                </div>
                <div class="form-group">
                    <label>标签类型:</label>
                    <select name="mark.type" class="form-control">
                        <option value="班级">班级</option>
                        <option value="学生">学生</option>
                    </select>
                </div>
                <input type="submit" class="btn btn-danger btn-block" value="提交"/>
                <input type="button" class="btn btn-info btn-block" value="返回上级" onclick="history.go(-1);"/>
            </form>

</body>

班级模块

展示所有+添加+删除

 图片这里设置的不显示(存草稿一直显示违规)

上传班级头像+获取班级标签+添加班级

在dao和service中通过type获取所有标签为班级的标签(集合)

jsp：

	//注意要一定要引入js文件
<head>
    <script type="text/javascript" src="${pageContext.request.contextPath}/js/jquery-1.8.3.js"></script>
	<script type="text/javascript">
		$(function (){
			$.post("/sms/mark/selectByType","type=班级",function (data){
				$(data).each(function (){
					$("#select").append("<option value='"+this.id+"'>"+this.name+"</option>");
				})
			},"json")
		})
	</script>
</head>

<body>

			<form action="${pageContext.request.contextPath}/clazz/insert" enctype="multipart/form-data" method="post">
				<div class="form-group">
					<label>班级头像:</label>
					<input type="file" class="form-control" name="upload"/>
				</div>
				<div class="form-group">
					<label>班级名称:</label>
					<input type="text" class="form-control" name="clazz.name"/>
				</div>
				<div class="form-group">
					<label>选择标签:</label>
					<select id="select" name="clazz.mark.id" class="form-control"></select>
				</div>
				<input type="submit" class="btn btn-danger btn-block" value="提交"/>
				<input type="button" class="btn btn-info btn-block" value="返回上级" onclick="history.go(-1);"/>
			</form>

</body>

ClazzAction：

    public String insert() throws IOException {
        String realPath = ServletActionContext.getRequest().getSession().getServletContext().getRealPath(filePath);
        FileUtils.copyFile(upload,new File(realPath+"/"+uploadFileName));
        clazz.setPath("/"+uploadFileName);
        ClazzServiceImpl clazzService = new ClazzServiceImpl();
        clazzService.insert(clazz);
        return "insertOk";
    }

struts.xml

		<action name="insert" class="com.tjcu.action.ClazzAction" method="insert">
			<param name="filePath">/upload</param>
			<result name="insertOk" type="chain">select</result>
		</action>

小组模块

在小组中额外再添加一个属性count 存放人数 默认值为0

每个组都有一个id id是唯一的

展示所有+添加+删除

 同班级模块添加，动态获取班级下拉列表

学生模块

分页查询+添加+修改+删除+搜索

分页查询

①根据生日获取年龄，星座，生肖 这个工具类在另一篇文章中已经发了

②根据小组id查找组 获得组名、班级名 小组id是唯一的 一个小组对应一个班级一个组名(组名可能重复)

③根据城市id获取城市名

④学生标签的关系表(一个学生可能有多个标签)

index.jsp:

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<%@page contentType="text/html; UTF-8" pageEncoding="UTF-8" isELIgnored="false" %>
<!doctype html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport"
          content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title>学生列表</title>
	<link rel="stylesheet" type="text/css" href="../statics/css/bootstrap.min.css">
	 <style>
        .form-control {
            height: 30px;
        }

        .pagination {
            margin-top: 0px;
        }
    </style>

</head>
<body >
<div class="container-fluid">
    <div class="row">
        <div class="col-sm-12" style="text-align: center">
            <form class="form-inline" action="${pageContext.request.contextPath}/student/search" method="post">
                <div class="form-group">
                    <label>请选择:</label>
                    <select class="form-control" style="height: 30px; width: 100px;" name="colName">
                        <option value="s_name">姓名</option>
                        <option value="s_phone">手机</option>
                        <option value="s_qq">QQ</option>
                    </select>
                    <input type="text" class="form-control" name="colValue" style="height: 30px; width: 300px;">
                </div>

                <button type="submit" class="btn btn-primary btn-sm">搜索</button>
            </form>
        </div>
    </div>
    <div class="row" style="margin-top: 15px;height: 300px">
        <c:if test="${sessionScope.user.role==1}">
            <div class="col-sm-12" style="margin-bottom: 10px;">
                <a href="add.jsp" class="btn btn-sm btn-success">添加学生信息</a>
            </div>
        </c:if>
        <div class="col-sm-12">
                <table class="table table-hover table-bordered table-striped">
                    <thead>
                    <tr>
                        <th>姓名</th>
                        <th>电话</th>
                        <th>QQ</th>
                        <th>年龄</th>
                        <th>生日</th>
                        <th>生肖</th>
                        <th>星座</th>
                        <th>班级</th>
                        <th>小组</th>
                        <th>就业城市</th>
                        <th>标签</th>
                        <th>操作</th>
                    </tr>
                    </thead>
                        <c:forEach var="student" items="${requestScope.students}">
                            <tr>
                                <td>${student.name}</td>
                                <td>${student.phone}</td>
                                <td>${student.qq}</td>
                                <td>${student.age}</td>
                                <td><fmt:formatDate value="${student.birthday}" pattern="yyyy-MM-dd"></fmt:formatDate></td>
                                <td>${student.attr}</td>
                                <td>${student.starts}</td>
                                <td>${student.clazz.name}</td>
                                <td>${student.group.name}</td>
                                <td>${student.city.name}</td>
                                <td>
                                    <c:forEach var="mark"  items="${student.marks}">
                                        ${mark.name}
                                    </c:forEach>
                                </td>
                                <td>
                                    <c:if test="${sessionScope.user.role==1}">
                                    <a href="${pageContext.request.contextPath}/student/selectOne?id=${student.id}" class="btn btn-warning btn-sm">修改</a>
                                    <a href="${pageContext.request.contextPath}/student/delete?id=${student.id}" class="btn btn-danger btn-sm">删除</a>
                                    </c:if>
                                </td>

                            </tr>
                        </c:forEach>
                </table>
        </div>
    </div>

    <c:if test="${requestScope.total!=0}">
        <div class="row">
            <div class="col-sm-8">
                    <%--<a href=""
                       class="btn btn-sm btn-info">下载学生信息到文件中</a>--%>
            </div>
            <div class="col-sm-4">
                <nav aria-label="Page navigation">
                    <ul class="pagination">
                        <li>
                            <c:if test="${pageNumber>1}">
                                <a href="${pageContext.request.contextPath}/student/select?pageNumber=${pageNumber-1}"
                                   aria-label="Previous">
                                    <span aria-hidden="true">&laquo;</span>
                                </a>
                            </c:if>
                        </li>
                            <li>
                                <a href="${pageContext.request.contextPath}/student/select?pageNumber=1">1</a>
                                <c:if test="${requestScope.totalPage>1}">
                                    <a href="${pageContext.request.contextPath}/student/select?pageNumber=2">2</a>
                                </c:if>
                                <c:if test="${requestScope.totalPage>2}">
                                    <a href="${pageContext.request.contextPath}/student/select?pageNumber=3">3</a>
                                </c:if>
                            </li>
                      
                        <li>
                            <c:if test="${pageNumber<totalPage}">
                                <a href="${pageContext.request.contextPath}/student/select?pageNumber=${pageNumber+1}"
                                   aria-label="Next">
                                    <span aria-hidden="true">&raquo;</span>
                                </a>
                            </c:if>
                        </li>
                    </ul>
                </nav>
            </div>
        </div>
    </c:if>
</div>
</body>
</html>

add.jsp:

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@page pageEncoding="UTF-8" contentType="text/html; UTF-8" isELIgnored="false" %>
<!doctype html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport"
          content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title>添加学生</title>
	<link rel="stylesheet" type="text/css" href="../statics/css/bootstrap.min.css">
	 <style>
        .form-control {
            height: 30px;
        }
    </style>
    <script type="text/javascript" src="${pageContext.request.contextPath}/js/jquery-1.8.3.js"></script>
    <script type="text/javascript">
        $(function (){
            $.post("/sms/group/selectAll",function (data){
                $(data).each(function (){
                    $("#clazzGroup").append("<option value='"+$(this).attr("id")+"'>"+$($(this).attr("clazz")).attr("name")+"---"+$(this).attr("name")+"("+$(this).attr("count")+"人)"+"</option>")
                })
            },"json");

            $.post("/sms/city/select",function (data){
                $(data).each(function (){
                    $("#city").append("<option value='"+$(this).attr("id")+"'>"+$(this).attr("name")+"</option>");
                });
            },"json");


            $.post("/sms/mark/selectByType","type=学生",function (data){
                $(data).each(function (){
                    $("#mark").append("<label style='margin-right: 5px;'><input id='mark' type='checkbox' value='"+$(this).attr("id")+"' name='ids'>"+$(this).attr("name")+"</label>")
                });
            },"json");

        })
    </script>
</head>
<body>
<div class="container-fluid">
    <div class="row">
        <div class="col-sm-offset-2 col-sm-8">
            <form action="${pageContext.request.contextPath}/student/insert" method="post">
                <div class="form-group">
                    <label>姓名:</label>
                    <input type="text" name="student.name" class="form-control" >
                </div>
                <div class="form-group">
                    <label>生日:</label>
                    <input type="text" name="student.birthday" class="form-control" >
                </div>
                <div class="form-group">
                    <label>QQ:</label>
                    <input type="text" name="student.qq" class="form-control" >
                </div>
                <div class="form-group">
                    <label>Phone:</label>
                    <input type="text" name="student.phone" class="form-control">
                </div>
                <div class="form-group">
                    <label for="clazzGroup">选择班级-小组:</label>
                    <select class="form-control" name="student.group.id" id="clazzGroup"></select>
                </div>
                <div class="form-group">
                    <label for="city">就业城市:</label>
                    <select class="form-control" name="student.city.id" id="city">

                    </select>
                </div>
                <div class="form-group">
                    <label>请选择标签:</label>
                    <div id="mark" class="checkbox" >
                    </div>
                </div>
                <div class="form-group">
                    <label>备注:</label>
                    <div id="div1"></div>
                    <input name="mark" style="display: none;" id="markContent"/>
                </div>
                <button type="submit" class="btn btn-info btn-block btn-sm">保存学生信息</button>
            </form>
        </div>
    </div>
</div>
</body>
</html>
<script src="https://cdn.jsdelivr.net/npm/wangeditor@latest/dist/wangEditor.min.js"></script>
<script type="text/javascript">
	const E = window.wangEditor
	const editor = new E('#div1');
	editor.config.height = 250;
	editor.create()
</script>

update.jsp:

<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<%@page contentType="text/html; UTF-8" pageEncoding="UTF-8" isELIgnored="false" %>
<!doctype html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport"
          content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title>添加学生</title>
	<link rel="stylesheet" type="text/css" href="../statics/css/bootstrap.min.css">
	<style>
		.form-control{
			height: 30px;
		}
	</style>
	<script type="text/javascript" src="${pageContext.request.contextPath}/js/jquery-1.8.3.js"></script>
	<script type="text/javascript">
		$(function (){
			$.post("/sms/group/selectAll",function (data){
				$(data).each(function (){
					$("#clazzGroup").append("<option value='"+$(this).attr("id")+"'>"+$($(this).attr("clazz")).attr("name")+"---"+$(this).attr("name")+"</option>")
				})
			},"json")

			$.post("/sms/city/select",function (data){
				$(data).each(function (){
					$("#city").append("<option value='"+$(this).attr("id")+"'>"+$(this).attr("name")+"</option>")
				})
			},"json")

			$.post("/sms/mark/selectByType","type=学生",function (data){
				$(data).each(function (){
					$("#mark").append("<label style='margin-right: 5px;'><input type='checkbox' value='"+$(this).attr("id")+"'name='ids'>"+$(this).attr("name")+"</label>")
				})
			},"json")
		})
	</script>
</head>
<body>
<div class="container-fluid">
	<div class="row">
		<div class="col-sm-offset-2 col-sm-8">
			<form action="${pageContext.request.contextPath}/student/update" method="post">
				<div class="form-group">
					<input type="hidden" name="student.id" value="${student.id}" class="form-control" >
				</div>
				<div class="form-group">
					<label>名称:</label>
					<input type="text" name="student.name" value="${student.name}" class="form-control" >
				</div>
				<div class="form-group">
					<label>生日:</label>
					<input type="text" name="student.birthday" value="<fmt:formatDate value="${student.birthday}" pattern="yyyy-MM-dd"></fmt:formatDate>" class="form-control" >

				</div>
				<div class="form-group">
					<label>QQ:</label>
					<input type="text" name="student.qq" value="${student.qq}" class="form-control" >

				</div>
				<div class="form-group">
					<label>Phone:</label>
					<input type="text" name="student.phone" value="${student.phone}" class="form-control">
				</div>
				<div class="form-group">
					<label for="clazzGroup">选择班级-小组:</label>
					<select id="clazzGroup" class="form-control" name="student.group.id"></select>
				</div>
				<div class="form-group">
					<label for="city">就业城市:</label>
					<select id="city" class="form-control" name="student.city.id">
					</select>
				</div>
				<div class="form-group">
					<label>请选择标签:</label>
					<div id="mark" class="checkbox"></div>
				</div>
				<div class="form-group">
					<label>备注:</label>
					<div id="div1">
						
					</div>
					<input name="mark" style="display: none;" id="markContent"/>
				</div>
				<button type="submit" class="btn btn-info btn-block btn-sm">保存学生信息</button>
			</form>
		</div>
	</div>
</div>
</body>
</html>
<script src="https://cdn.jsdelivr.net/npm/wangeditor@latest/dist/wangEditor.min.js"></script>
<script type="text/javascript">
	const E = window.wangEditor
	const editor = new E('#div1');
	editor.config.height = 250;
	editor.create()
</script>

Studentdao:

package com.tjcu.dao;

import com.tjcu.entity.Student;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface StudentDao {

    //分页
    public List<Student> selectLimit(@Param("begin") int begin, @Param("size") int size);

    public int totalCount();

    //增加
    public void insertStudent(Student student);

    //删除学生
    public void deleteStudent(int id);

    //通过id查找学生
    public Student selectStudent(int id);

    //修改
    public void update(Student student);

    //通过列名 列值搜索学生
    public List<Student> selectByContent(@Param("colName") String colName,@Param("colValue") String colValue);

}

StudentMarkDao:

package com.tjcu.dao;

import org.apache.ibatis.annotations.Param;

public interface StudentMarkDao {
    public void insert(@Param("sid") int sid, @Param("mid") int mid);

    public void delete(int sid);
}

StudentDaoMapper.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.tjcu.dao.StudentDao">
    <resultMap id="StudentResultMap" type="Student">
        <id column="s_id" property="id"></id>
        <result column="s_name" property="name"></result>
        <result column="s_phone" property="phone"></result>
        <result column="s_qq" property="qq"></result>
        <result column="s_age" property="age"></result>
        <result column="s_birthday" property="birthday"></result>
        <result column="s_starts" property="starts"></result>
        <result column="s_attr" property="attr"></result>
        <association javaType="City" property="city">
            <id column="y_id" property="id"></id>
            <result column="y_name" property="name"></result>
        </association>
        <association javaType="Group" property="group">
            <id column="g_id" property="id"></id>
            <result column="g_name" property="name"></result>
            <result column="g_createdate" property="date"></result>
        </association>
        <association javaType="Clazz" property="clazz">
            <id column="clazz_id" property="id"></id>
            <result column="c_name" property="name"></result>
            <result column="c_logo_path" property="path"></result>
        </association>
        <collection ofType="Mark" property="marks">
            <id column="m_id" property="id"></id>
            <result column="m_name" property="name"></result>
            <result column="m_time" property="time"></result>
            <result column="m_type" property="type"></result>
        </collection>
    </resultMap>

    <sql id="SELECT_SCGC">
        select s.s_id as s_id  ,  s.s_name as s_name  ,  s.s_phone as s_phone  ,  s.s_qq as s_qq  ,  s.s_age as s_age  ,  s.s_birthday as s_birthday  ,  s.s_starts as s_starts  ,  s.s_attr as s_attr,
                c.clazz_id as clazz_id  ,  c.c_name as c_name  ,
                g.g_id as g_id  ,  g.g_name as g_name  ,  g.g_createdate as g_createdate  ,
                y.c_id as y_id  ,  y.c_name as y_name  ,
                m.m_id as m_id  ,  m.m_name as m_name
    </sql>

    <select id="selectLimit" resultMap="StudentResultMap">
        <include refid="SELECT_SCGC"></include>
        from ( select * from T_STUDENT limit #{begin},#{size} )
            s left join T_CITY y
            on s.c_id = y.c_id
            left join T_GROUP g
            on s.g_id = g.g_id
            left join T_CLAZZ as c
            on s.clazz_id = c.clazz_id
            left join M_S_FK ms
            on s.s_id = ms.s_id
            left join T_MARK as m
            on ms.m_id = m.m_id
    </select>
    <select id="totalCount" resultType="int">
        select count(*) from T_STUDENT
    </select>

    <insert id="insertStudent" useGeneratedKeys="true" keyProperty="id">
        insert into T_STUDENT(s_name,s_birthday,s_qq,s_phone,s_age,s_starts,s_attr,clazz_id,g_id,c_id) values(#{name},#{birthday},#{qq},#{phone},#{age},#{starts},#{attr},#{clazz.id},#{group.id},#{city.id})
    </insert>

    <delete id="deleteStudent">
        delete from T_STUDENT where s_id=#{id}
    </delete>

    <select id="selectStudent" resultMap="StudentResultMap">
        select * from T_STUDENT where s_id=#{id}
    </select>

    <update id="update" parameterType="Student">
        update T_STUDENT
        <set>
            <if test="name!=null">s_name=#{name}  ,</if>
            <if test="birthday!=null">s_birthday=#{birthday}  ,</if>
            <if test="qq!=null">s_qq=#{qq}  ,</if>
            <if test="phone!=null">s_phone=#{phone}  ,</if>
            <if test="age!=null">s_age=#{age}  ,</if>
            <if test="starts!=null">s_starts=#{starts}  ,</if>
            <if test="attr!=null">s_attr=#{attr}  ,</if>
            <if test="clazz.id!=null">clazz_id=#{clazz.id}  ,</if>
            <if test="group.id!=null">g_id=#{group.id}  ,</if>
            <if test="city.id!=null">c_id=#{city.id} </if>
        </set>
        where s_id=#{id}
    </update>
    <select id="selectByContent" resultMap="StudentResultMap">
        <include refid="SELECT_SCGC"/>
            from (select * from T_STUDENT where ${colName} like '%${colValue}%')
                s left join T_CITY y
                on s.c_id = y.c_id
                left join T_GROUP g
                on s.g_id = g.g_id
                left join T_CLAZZ as c
                on s.clazz_id = c.clazz_id
                left join M_S_FK ms
                on s.s_id = ms.s_id
                left join T_MARK as m
                on ms.m_id = m.m_id
    </select>

</mapper>

StudentMarkDaoMapper.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.tjcu.dao.StudentMarkDao">

    <insert id="insert">
        insert into M_S_FK values(#{mid},#{sid})
    </insert>

    <delete id="delete">
        delete from M_S_FK where s_id=#{sid}
    </delete>

</mapper>

StudentService:

package com.tjcu.service;

import com.tjcu.entity.Student;

import java.util.List;

public interface StudentService {
    public List<Student> selectLimit(int pageNumber);

    public int queryAllPage();

    //增加
    public void insert(Student student);

    //删除
    public void delete(int id);
    
    //通过id查找学生
    public Student selectStudent(int id);

    //修改
    public void update(Student student);

    //搜索
    public List<Student> selectByContent(String colName,String colValue);

}

StudentServiceImpl:

package com.tjcu.service;

import com.tjcu.dao.GroupDao;
import com.tjcu.dao.StudentDao;
import com.tjcu.dao.StudentMarkDao;
import com.tjcu.entity.Student;
import com.tjcu.util.MybatisUtil;

import java.io.IOException;
import java.util.List;

public class StudentServiceImpl implements StudentService{
    private List<Integer> ids;
    @Override
    public List<Student> selectLimit(int pageNumber) {
        int size =3;
        int begin = (pageNumber-1)*size;
        try {
            StudentDao studentDao = (StudentDao) MybatisUtil.getMapper(StudentDao.class);
            List<Student> students = studentDao.selectLimit(begin, size);
            MybatisUtil.close();
            return students;
        } catch (IOException e) {
            e.printStackTrace();
            MybatisUtil.close();
            return null;
        }

    }

    @Override
    public int queryAllPage() {
        try {
            StudentDao studentDao = (StudentDao) MybatisUtil.getMapper(StudentDao.class);
            int count = studentDao.totalCount();
            //总页数
            int totalPage = count%3==0? count/3:count/3+1;
            MybatisUtil.close();
            return totalPage;
        } catch (IOException e) {
            e.printStackTrace();
            MybatisUtil.close();
            return 0;
        }
    }

    @Override
    public void insert(Student student) {
        try {
            StudentDao studentDao = (StudentDao) MybatisUtil.getMapper(StudentDao.class);
            studentDao.insertStudent(student);
            GroupDao groupDao = (GroupDao) MybatisUtil.getMapper(GroupDao.class);
            int count = groupDao.count(student.getGroup().getId());
            groupDao.updateCount(student.getGroup().getId(),count+1);
            StudentMarkDao studentMarkDao = (StudentMarkDao) MybatisUtil.getMapper(StudentMarkDao.class);
            for (Integer id : ids) {
                studentMarkDao.insert(student.getId(),id);
            }
            MybatisUtil.commit();
        } catch (IOException e) {
            e.printStackTrace();
            MybatisUtil.rollback();
        }

    }

    @Override
    public void delete(int id) {
        try {
            StudentDao studentDao = (StudentDao) MybatisUtil.getMapper(StudentDao.class);
            StudentMarkDao studentMarkDao = (StudentMarkDao) MybatisUtil.getMapper(StudentMarkDao.class);
            studentMarkDao.delete(id);
            Student student = studentDao.selectStudent(id);
            GroupDao groupDao = (GroupDao) MybatisUtil.getMapper(GroupDao.class);
            int count = groupDao.count(student.getGroup().getId());
            groupDao.updateCount(student.getGroup().getId(),count-1);
            studentDao.deleteStudent(id);
            MybatisUtil.commit();
        } catch (IOException e) {
            e.printStackTrace();
            MybatisUtil.rollback();
        }

    }

    @Override
    public Student selectStudent(int id) {
        try {
            StudentDao studentDao = (StudentDao) MybatisUtil.getMapper(StudentDao.class);
            Student student = studentDao.selectStudent(id);
            MybatisUtil.close();
            return student;
        } catch (IOException e) {
            e.printStackTrace();
            MybatisUtil.close();
            return null;
        }
    }

    @Override
    public void update(Student student) {
        try {
            StudentDao studentDao = (StudentDao) MybatisUtil.getMapper(StudentDao.class);
            StudentMarkDao studentMarkDao = (StudentMarkDao) MybatisUtil.getMapper(StudentMarkDao.class);
            studentMarkDao.delete(student.getId());
            for (Integer id : ids) {
                studentMarkDao.insert(student.getId(),id);
            }
            studentDao.update(student);
            MybatisUtil.commit();
        } catch (IOException e) {
            e.printStackTrace();
            MybatisUtil.rollback();
        }
    }

    @Override
    public List<Student> selectByContent(String colName, String colValue) {
        try {
            StudentDao studentDao = (StudentDao) MybatisUtil.getMapper(StudentDao.class);
            List<Student> students = studentDao.selectByContent(colName, colValue);
            MybatisUtil.close();
            return students;
        } catch (IOException e) {
            e.printStackTrace();
            MybatisUtil.close();
            return null;
        }
    }

    public List<Integer> getIds() {
        return ids;
    }

    public void setIds(List<Integer> ids) {
        this.ids = ids;
    }
}

struts.xml:

	<!--student-->
	<package name="student" extends="struts-default" namespace="/student">
		<action name="select" class="com.tjcu.action.StudentAction" method="select">
			<result name="selectOk">index.jsp</result>
		</action>
		<action name="insert" class="com.tjcu.action.StudentAction" method="insert">
			<result name="insertOk" type="chain">select</result>
		</action>
		<action name="delete" class="com.tjcu.action.StudentAction" method="delete">
			<result name="deleteOk" type="chain">select</result>
		</action>
		<action name="update" class="com.tjcu.action.StudentAction" method="update">
			<result name="updateOK" type="chain">select</result>
		</action>
		<action name="selectOne" class="com.tjcu.action.StudentAction" method="selectOne">
			<result name="selectOneOk">update.jsp</result>
		</action>
		<action name="search" class="com.tjcu.action.StudentAction" method="search">
			<result name="searchOk" type="dispatcher">index.jsp</result>
		</action>
	</package>

评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值