• MyBatis注解开发实现学生管理页面（分页pagehelper,多条件搜索，查看课程信息）

    pom.xml

    1. "1.0" encoding="UTF-8"?>
    2. <project xmlns="http://maven.apache.org/POM/4.0.0"
    3.          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    4.          xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    5.     <modelVersion>4.0.0modelVersion>
    6.  
    7.     <groupId>org.examplegroupId>
    8.     <artifactId>studentSystemWorkartifactId>
    9.     <version>1.0-SNAPSHOTversion>
    10.  
    11.     <properties>
    12.         <maven.compiler.source>8maven.compiler.source>
    13.         <maven.compiler.target>8maven.compiler.target>
    14.     properties>
    15.  
    16.     <dependencies>
    17.         <dependency>
    18.             <groupId>org.projectlombokgroupId>
    19.             <artifactId>lombokartifactId>
    20.             <version>1.18.16version>
    21.         dependency>
    22.         <dependency>
    23.             <groupId>org.mybatisgroupId>
    24.             <artifactId>mybatisartifactId>
    25.             <version>3.5.1version>
    26.         dependency>
    27.         <dependency>
    28.             <groupId>mysqlgroupId>
    29.             <artifactId>mysql-connector-javaartifactId>
    30.             <version>8.0.25version>
    31.             <scope>runtimescope>
    32.         dependency>
    33.         <dependency>
    34.             <groupId>junitgroupId>
    35.             <artifactId>junitartifactId>
    36.             <version>4.12version>
    37.             <scope>testscope>
    38.         dependency>
    39.         
    40.         <dependency>
    41.             <groupId>javax.servletgroupId>
    42.             <artifactId>javax.servlet-apiartifactId>
    43.             <version>3.1.0version>
    44.         dependency>
    45.         
    46.         <dependency>
    47.             <groupId>com.fasterxml.jackson.coregroupId>
    48.             <artifactId>jackson-coreartifactId>
    49.             <version>2.7.3version>
    50.         dependency>
    51.         <dependency>
    52.             <groupId>com.fasterxml.jackson.coregroupId>
    53.             <artifactId>jackson-databindartifactId>
    54.             <version>2.7.3version>
    55.         dependency>
    56.         <dependency>
    57.             <groupId>com.fasterxml.jackson.coregroupId>
    58.             <artifactId>jackson-annotationsartifactId>
    59.             <version>2.7.3version>
    60.         dependency>
    61.         
    62.         <dependency>
    63.             <groupId>commons-langgroupId>
    64.             <artifactId>commons-langartifactId>
    65.             <version>2.6version>
    66.         dependency>
    67.         <dependency>
    68.             <groupId>org.apache.commonsgroupId>
    69.             <artifactId>commons-lang3artifactId>
    70.             <version>3.4version>
    71.         dependency>
    72.         <dependency>
    73.             <groupId>junitgroupId>
    74.             <artifactId>junitartifactId>
    75.             <version>4.13version>
    76.             <scope>testscope>
    77.         dependency>
    78.         
    79.         <dependency>
    80.             <groupId>commons-beanutilsgroupId>
    81.             <artifactId>commons-beanutilsartifactId>
    82.             <version>1.8.3version>
    83.         dependency>
    84.  
    85.         <dependency>
    86.             <groupId>commons-logginggroupId>
    87.             <artifactId>commons-loggingartifactId>
    88.             <version>1.1.1version>
    89.         dependency>
    90.         
    91.         <dependency>
    92.             <groupId>commons-dbutilsgroupId>
    93.             <artifactId>commons-dbutilsartifactId>
    94.             <version>1.6version>
    95.         dependency>
    96.         
    97.         <dependency>
    98.             <groupId>log4jgroupId>
    99.             <artifactId>log4jartifactId>
    100.             <version>1.2.17version>
    101.         dependency>
    102.         
    103.         <dependency>
    104.             <groupId>com.mchangegroupId>
    105.             <artifactId>c3p0artifactId>
    106.             <version>0.9.5version>
    107.         dependency>
    108.         
    109.         <dependency>
    110.             <groupId>com.github.pagehelpergroupId>
    111.             <artifactId>pagehelperartifactId>
    112.             <version>5.1.10version>
    113.         dependency>
    114.     dependencies>
    115.  
    116. project>

    index.html

    1. html>
    2. <html>
    3.  
    4. <head>
    5.     <title>title>
    6.     <meta charset="UTF-8">
    7.     <link rel="stylesheet" href="element-ui-2.13.0/lib/theme-chalk/index.css" />
    8.     <script type="text/javascript" src="vue/vue-v2.6.10.js">script>
    9.     <script type="text/javascript" src="element-ui-2.13.0/lib/index.js">script>
    10.     <script type="text/javascript" src="vue/axios-0.18.0.js">script>
    11. head>
    12.  
    13. <body>
    14. <div id="app">
    15.     <template>
    16.         <el-table :data="tableData" @selection-change="handleSelectionChange" size="medium"
    17.                   highlight-current-row="true" style="width: 100%">
    18.             <el-table-column type="selection" width="55" prop="sid">
    19.             el-table-column>
    20.             <el-table-column width="100px" label="序号" type="index">
    21.             el-table-column>
    22.             <el-table-column label="姓名" prop="sname">
    23.             el-table-column>
    24.             <el-table-column label="性别" prop="gender">
    25.             el-table-column>
    26.             <el-table-column label="班级" prop="tbClass.caption">
    27.             el-table-column>
    28.             <el-table-column>
    29.                 <template slot="header" slot-scope="scope">
    30.                     <el-input v-model="search" size="mini" placeholder="请输入姓名" />
    31.                 template>
    32.             el-table-column>
    33.             
    34.             <el-table-column>
    35.                 <template slot="header" slot-scope="scope">
    36.                     <el-radio v-model="sex" label="男">男el-radio>
    37.                     <el-radio v-model="sex" label="女">女el-radio>
    38.                 template>
    39.             el-table-column>
    40.             <el-table-column>
    41.                 <template slot="header" slot-scope="scope">
    42.                     <el-button type="success" @click="findAll()">搜索el-button>
    43.                 template>
    44.                 <template slot-scope="scope">
    45.                     <el-button size="mini" @click="handleLook(scope.$index, scope.row)">查看课程信息el-button>
    46.                 template>
    47.             el-table-column>
    48.         el-table>
    49.     template>
    50.     <br />
    51.     <el-row>
    52.         <el-button type="warning" @click="delAll()">删除选中el-button>
    53.     el-row>
    54.     <template>
    55.         <div class="block" align="right">
    56.             <el-pagination @size-change="handleSizeChange" @current-change="handleCurrentChange"
    57.                            :current-page="currentPage" :page-sizes="[3, 4, 5, 6]" :page-size="pageSize"
    58.                            layout="total, sizes, prev, pager, next, jumper" :total="totalCount">
    59.             el-pagination>
    60.         div>
    61.     template>
    62.  
    63.     
    64.     <el-dialog title="查看课程信息" :visible.sync="dialogFormVisible">
    65.         <el-form ref="ruleForm" :model="ruleForm" label-width="80px">
    66.             <el-form-item label="学生姓名">
    67.                 <el-input v-model="ruleForm.sname" style="width: 210px;" readonly>el-input>
    68.             el-form-item>
    69.         el-form>
    70.         <el-table :data="tableCourse" @selection-change="handleSelectionChange" size="medium"
    71.                   highlight-current-row="true" style="width: 100%">
    72.             <el-table-column width="100px" label="序号" type="index">
    73.             el-table-column>
    74.             <el-table-column label="课程" prop="courses[0].cname">
    75.             el-table-column>
    76.             <el-table-column label="成绩" prop="num">
    77.             el-table-column>
    78.             <el-table-column label="老师" prop="courses[0].teacher.tname">
    79.             el-table-column>
    80.         el-table>
    81.     el-dialog>
    82. div>
    83. body>
    84. <script>
    85.     axios.defaults.withCredentials = true
    86.     new Vue({
    87.         el: "#app",
    88.         data: {
    89.             /*表格数据*/
    90.             tableData: [],
    91.             tableCourse: [],
    92.             /*条件查询关键字*/
    93.             search: '',
    94.             sex: "",
    95.             //批量删除存放选中的复选框
    96.             multipleSelection: [],
    97.             //存放删除的数据
    98.             delarr: [],
    99.             //当前页
    100.             currentPage: 1,
    101.             //每页显示条数
    102.             pageSize: 3,
    103.             //总条数
    104.             totalCount: '',
    105.             //总页数
    106.             totalPage: '',
    107.             // 是否展示课程信息对话框
    108.             dialogFormVisible: false,
    109.             ruleForm: {
    110.                 sid: '',
    111.                 sname: '',
    112.                 gender: '',
    113.                 tbClass: '',
    114.                 class_id: '',
    115.             },
    116.         },
    117.         methods: {
    118.  
    119.             findAll() {
    120.                 let param = new URLSearchParams();
    121.                 param.append("type", "showStuByPage");
    122.                 param.append("page", this.currentPage);
    123.                 param.append("rows", this.pageSize);
    124.                 param.append("sname", this.search);
    125.                 param.append("gender", this.sex);
    126.                 axios({
    127.                     method: "post",
    128.                     url: "http://localhost:8080/studentSystemWork_war_exploded/studentServlet",
    129.                     data: param
    130.                 }).then(obj => {
    131.                     this.tableData = obj.data.list;
    132.                     this.totalCount = obj.data.total;
    133.                 });
    134.             },
    135.  
    136.             handleSizeChange: function (size) {
    137.                 this.pageSize = size;
    138.                 this.findAll();
    139.             },
    140.  
    141.             handleCurrentChange: function (currentPage) {
    142.                 this.currentPage = currentPage;
    143.                 this.findAll();
    144.             },
    145.  
    146.             delAll() {
    147.                 //获取删除的ID
    148.                 this.delarr = [];
    149.                 for (let i = 0; i < this.multipleSelection.length; i++) {
    150.                     this.delarr.push(this.multipleSelection[i].sid);
    151.                 }
    152.                 //判断要删除的文件是否为空
    153.                 if (this.delarr.length == 0) {
    154.                     this.$message.warning("请选择要删除的数据！")
    155.                 } else {
    156.                     this.$confirm("是否确认删除？", "提示", { type: 'warning' }).then(() => {
    157.                         //点击确认删除
    158.                         let param = new URLSearchParams();
    159.                         param.append("sids", this.delarr.join())
    160.                         param.append("type", "deleteStudents")
    161.                         axios({
    162.                             method: "post",
    163.                             url: "http://localhost:8080/studentSystemWork_war_exploded/studentServlet",
    164.                             data: param
    165.                         }).then(obj => {
    166.                             if (obj.data) {
    167.                                 this.$message.success("删除成功！");
    168.                                 setTimeout(function () {
    169.                                     window.location.href = "index.html"
    170.                                 }, 1500)
    171.                             } else {
    172.                                 this.$message.error("删除失败！")
    173.                             }
    174.                         });
    175.                     });
    176.                 }
    177.             },
    178.  
    179.             handleSelectionChange(val) {
    180.                 this.multipleSelection = val;
    181.             },
    182.  
    183.             handleLook(index, row) {
    184.                 this.dialogFormVisible = true;
    185.                 this.ruleForm = row;
    186.                 let param = new URLSearchParams();
    187.                 param.append("type","getStudentCourseById")
    188.                 param.append("sid",row.sid);
    189.                 axios({
    190.                     method: "post",
    191.                     url: "http://localhost:8080/studentSystemWork_war_exploded/scoreServlet",
    192.                     data: param
    193.                 }).then(obj => {
    194.                     this.tableCourse = obj.data;
    195.                 });
    196.             },
    197.  
    198.         },
    199.  
    200.         created() {
    201.             this.findAll();
    202.         }
    203.  
    204.     })
    205. script>
    206.  
    207. html>

    studentDao

    1. package com.etime.dao;
    2.  
    3. import com.etime.pojo.Student;
    4. import com.etime.pojo.TbClass;
    5. import org.apache.ibatis.annotations.*;
    6.  
    7. import java.util.List;
    8.  
    9. public interface StudentDao {
    10.     @Select({""})
    11.     int getCountStudent(Student student);
    12.  
    13.     @Select({""})
    14.     @Results({
    15.             @Result(property = "sid",column = "sid"),
    16.             @Result(property = "gender",column = "gender"),
    17.             @Result(property = "class_id",column = "class_id"),
    18.             @Result(property = "sname",column = "sname"),
    19.             @Result(property = "tbClass",column = "class_id",javaType = TbClass.class,
    20.                     one = @One(select = "com.etime.dao.TbClassDao.getClassByCid"))
    21.     })
    22.     List showStuByPage(Student student);
    23.  
    24.     @Delete({""})
    25.     int deleteStudents(List list);
    26. }

    具体完整代码看资源

  • 相关阅读:
    【andriod】 设备APP连接云端平台的各种细节部署和操作
    2023苏州科技大学计算机考研信息汇总
    Flutter 使用Screen保持屏幕常亮不息屏
    C++库Eigen中拟合线性方程(最小二乘法)
    Linux-centos系统安装MySql5.7
    php简单后门实现及php连接数据库
    UE4 MVP 坐标转换
    Java入门必备基础知识
    Python解题 - CSDN周赛第11期 - 圆桌请客（脑筋急转弯）
    华为机试 - 模拟商场优惠打折
  • 原文地址：https://blog.csdn.net/weixin_62971115/article/details/133756891