mapper层

AnswerMapper.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.example.academicadministration.dao.AnswerDao">
<insert id="addAnswer" parameterType="com.example.academicadministration.pojo.Answer">
    insert into answer (stuid, homeworkid, score, answerfile, submittime)
    VALUES(#{stuid},#{homeworkid},#{score},#{answerfile},#{submittime})
</insert>
    <update id="updateAnswer" parameterType="com.example.academicadministration.pojo.Answer">
        update answer set answerfile=#{answerfile},submittime=#{submittime} where stuid=#{stuid} and homeworkid=#{homeworkid}
    </update>
    <select id="myAnswer" resultType="com.example.academicadministration.pojo.Answer">
        select * from answer where stuid=#{stuid} and homeworkid=#{homeworkid}
    </select>
    <update id="updateScore" parameterType="com.example.academicadministration.pojo.Answer">
        update answer set score=#{score} where stuid=#{stuid} and homeworkid=#{homeworkid}
    </update>
    <delete id="deleteAnswer">
        delete from answer where stuid=#{stuid} and homeworkid=#{homeworkid}
    </delete>
</mapper>

CourseMapper.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.example.academicadministration.dao.CourseDao">
    <insert id="addCourse" parameterType="com.example.academicadministration.pojo.Course">
        insert into course
(coursename, courselimit, courseday, coursetime, courseroom, coursekind)
values (#{coursename},#{courselimit},#{courseday},#{coursetime},#{courseroom},#{coursekind})
    </insert>
    <delete id="deleteCourse">
        delete from course where courseid=#{courseid}
    </delete>

    <select id="browseCourse" resultType="com.example.academicadministration.pojo.Course">
        select * from course where courseid like #{condition} or courseroom like #{condition} or coursetime like #{condition} or courseday like #{condition} or coursekind like #{condition} or coursename like #{condition} or courselimit like #{condition} or coursenumber like #{condition}
    </select>
    <select id="checkTeacher" resultType="java.lang.String">
        select teaid from teacourse where courseid=#{courseid} and teaid=#{teaid}
    </select>
    <insert id="addTeacherCourse">
        insert ignore  into teacourse (teaid, courseid) values (#{teaid},#{courseid})
    </insert>
    <delete id="deleteTeacherCourse">
        delete from teacourse where teaid=#{stuid} and courseid=#{courseid}
    </delete>
    <insert id="addStudentCourse">
        insert ignore into stucourse (stuid, courseid) values (#{stuid},#{courseid})
    </insert>
    <update id="addNum">
        update course set coursenumber=coursenumber+1 where courseid=#{courseid}
    </update>
    <delete id="deleteStudentCourse">
        delete from stucourse where stuid=#{stuid} and courseid=#{courseid}
    </delete>
    <update id="deleteNum">
        update course set coursenumber=coursenumber-1 where courseid=#{courseid}
    </update>
    <select id="myCourse" resultType="com.example.academicadministration.pojo.Course">
        select * from course where courseid in (select courseid from stucourse where stuid=#{stuid})
    </select>
    <select id="TmyCourse" resultType="com.example.academicadministration.pojo.Course">
        select * from course where courseid in (select courseid from teacourse where teaid=#{teaid})
    </select>
    <select id="browseScore" resultType="java.lang.String">
        select coursescore from stucourse where stuid=#{stuid} and courseid=#{courseid}
    </select>
    <update id="updateScore">
        update stucourse set coursescore=#{coursescore} where stuid=#{stuid} and courseid=#{courseid}
    </update>
</mapper>

HomeworkMapper.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.example.academicadministration.dao.HomeworkDao">
<insert id="addHomework" parameterType="com.example.academicadministration.pojo.Homework">
    insert into homework (courseid, startline, endline, homeworkrequest, homeworkfile)
    VALUES(#{courseid},#{startline},#{endline},#{homeworkrequest},#{homeworkfile})
</insert>
    <delete id="deleteHomework">
        delete from homework where homeworkid=#{homeworkid}
    </delete>
    <select id="browseHomeworkAll" resultType="com.example.academicadministration.pojo.Homework">
        select * from homework where courseid = #{courseid}
    </select>
    <select id="browseHomework1" resultType="com.example.academicadministration.pojo.Homework">
        select * from homework where endline &lt;= (select curdate()) and  courseid =#{courseid}
    </select>
    <select id="browseHomework2" resultType="com.example.academicadministration.pojo.Homework">
        select * from homework where endline &gt; (select curdate()) and  courseid =#{courseid}
    </select>
</mapper>

MangerMapper.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.example.academicadministration.dao.MangerDao">
<select id="login" resultType="java.lang.String">
    select mangerpwd from manger where mangerid=#{id}
</select>
    <update id="reset">
        update manger set mangerpwd=MD5(#{newpwd}) where mangerid=#{mangerid} and MD5(mangerpwd=#{oldpwd})
    </update>
</mapper>

StudentMapper.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.example.academicadministration.dao.StudentDao">
    <insert id="addStudent" parameterType="com.example.academicadministration.pojo.Student">
        insert ignore into student
            (stuid, stupwd, stuname, stusex, sturace, stuorigin, stuenrollment, stucollege, stumajor, stuclass, stuphone, stuphoto)
        VALUES(#{stuid},MD5(#{stupwd}),#{stuname},#{stusex},#{sturace},#{stuorigin},#{stuenrollment},#{stucollege},#{stumajor},#{stuclass},#{stuphone},#{stuphoto})
    </insert>
    <delete id="deleteStudent">
        delete from student where stuid=#{stuid}
    </delete>
    <update id="inauditStudent">
        update student set stustate=false where stuid=#{stuid}
    </update>
    <update id="auditStudent">
        update student set stustate=true where stuid=#{stuid}
    </update>
    <update id="reset">
        update student set stupwd=MD5(#{newpwd}) where stuid=#{stuid} and stupwd=#{stupwd}
    </update>
    <select id="browseStudent" resultType="com.example.academicadministration.pojo.Student">
        select * from student where stuid like #{condition} or stusex like #{condition} or stuclass like #{condition} or stuorigin like #{condition}
or sturace like #{condition} or stucollege like #{condition} or stuenrollment like #{condition} or stumajor like #{condition} or stuname like #{condition}
or stuphone like #{condition}
    </select>
    <select id="myStudent" resultType="com.example.academicadministration.pojo.Student">
        select * from student where stuid in (select stuid from stucourse where courseid=#{courseid})
    </select>
</mapper>

TeacherMapper.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.example.academicadministration.dao.TeacherDao">
    <insert id="addTeacher" parameterType="com.example.academicadministration.pojo.Teacher">
        insert ignore into teacher
            (teaid, teapwd, teaname, teasex, tearace, teaorigin, teacollege, teapost, teagraduation, teadegree, teaphone, teaphoto)
        VALUES (#{teaid},MD5(#{teapwd}),#{teaname},#{teasex},#{tearace},#{teaorigin},#{teacollege},#{teapost},#{teagraduation},#{teadegree},#{teaphone},#{teaphoto})
    </insert>
    <delete id="deleteTeacher">
        delete from teacher where teaid=#{teaid}
    </delete>
    <update id="inauditTeacher">
        update teacher set teastate=false where teaid=#{teaid}
    </update>
    <update id="auditTeacher">
        update teacher set teastate=true where teaid=#{teaid}
    </update>
    <update id="reset">
        update teacher set teapwd=MD5(#{newpwd}) where teaid=#{teaid} and teapwd=#{teapwd}
    </update>
    <select id="browseTeacher" resultType="com.example.academicadministration.pojo.Teacher">
        select * from teacher where teaid like #{condition} or teaname like #{condition} or teadegree like #{condition} or teagraduation like #{condition}
or teaorigin like #{condition} or tearace like #{condition} or teacollege like #{condition} or teaphone like #{condition} or teapost like #{condition} or teasex like #{condition}
    </select>
</mapper>

VideoMapper.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.example.academicadministration.dao.VideoDao">
    <insert id="addVideo" parameterType="com.example.academicadministration.pojo.Video">
        insert into video (courseid, videoname, videointroducation,videocover, videofile,videotime)
        VALUES (#{courseid},#{videoname},#{videointroducation},#{videocover},#{videofile},#{videotime})
    </insert>
    <select id="browseVideo" resultType="com.example.academicadministration.pojo.Video">
        select * from video where videoid like #{condition} or videoname like #{condition} or videointroducation like #{condition} order by videotime
    </select>
    <delete id="deleteVideo">
        delete from video where videoid=#{videoid}
    </delete>
</mapper>