devbox
花生_TL007
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

ssm实现分页（增删改及多条件查询）_ssm实现增加,修改,删除,分页功能的实现

作者：花生_TL007 | 2024-03-18 11:45:34

赞

踩

ssm实现增加,修改,删除,分页功能的实现

1、数据库（分别是年级表、性别表、学生表、学科表）

附上数据库代码(如下)

  1. /*
  2. SQLyog Ultimate v12.09 (64 bit)
  3. MySQL - 5.7.14-log : Database - schooldemo3
  4. *********************************************************************
  5. */
  6.  
  7.  
  8. /*!40101 SET NAMES utf8 */;
  9.  
  10. /*!40101 SET SQL_MODE=''*/;
  11.  
  12. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  13. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  14. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  15. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  16. CREATE DATABASE /*!32312 IF NOT EXISTS*/`schooldemo3` /*!40100 DEFAULT CHARACTER SET utf8 */;
  17.  
  18. USE `schooldemo3`;
  19.  
  20. /*Table structure for table `class` */
  21.  
  22. DROP TABLE IF EXISTS `class`;
  23.  
  24. CREATE TABLE `class` (
  25.   `id` INT(10) NOT NULL AUTO_INCREMENT,
  26.   `sid` INT(10) NOT NULL,
  27.   `classes` VARCHAR(10) NOT NULL,
  28.   PRIMARY KEY (`id`)
  29. ) ENGINE=INNODB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
  30.  
  31. /*Data for the table `class` */
  32.  
  33. INSERT  INTO `class`(`id`,`sid`,`classes`) VALUES (1,1,'一班'),(2,2,'二班'),(3,3,'三班');
  34.  
  35. /*Table structure for table `sex` */
  36.  
  37. DROP TABLE IF EXISTS `sex`;
  38.  
  39. CREATE TABLE `sex` (
  40.   `id` INT(10) NOT NULL AUTO_INCREMENT,
  41.   `sid` INT(10) NOT NULL,
  42.   `sex` VARCHAR(10) NOT NULL,
  43.   PRIMARY KEY (`id`)
  44. ) ENGINE=INNODB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
  45.  
  46. /*Data for the table `sex` */
  47.  
  48. INSERT  INTO `sex`(`id`,`sid`,`sex`) VALUES (1,1,'男'),(2,2,'女');
  49.  
  50. /*Table structure for table `student` */
  51.  
  52. DROP TABLE IF EXISTS `student`;
  53.  
  54. CREATE TABLE `student` (
  55.   `id` INT(10) NOT NULL AUTO_INCREMENT,
  56.   `sname` VARCHAR(20) NOT NULL,
  57.   `ssex` INT(10) NOT NULL,
  58.   `sage` INT(10) NOT NULL,
  59.   `sclass` INT(10) NOT NULL,
  60.   `szym` VARCHAR(50) DEFAULT NULL,
  61.   `ssubject` INT(10) DEFAULT NULL,
  62.   PRIMARY KEY (`id`)
  63. ) ENGINE=INNODB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
  64.  
  65. /*Data for the table `student` */
  66.  
  67. INSERT  INTO `student`(`id`,`sname`,`ssex`,`sage`,`sclass`,`szym`,`ssubject`) VALUES (1,'张三',1,16,1,'读书使我快乐',1),(2,'李四',2,15,1,'我爱读书',2),(3,'王五',1,15,2,'书中自有黄金屋',3),(4,'赵六',1,16,2,'书中自有颜如玉',2),(5,'夏七',2,15,3,'书籍是人类进步的阶梯',1),(6,'jack',1,16,3,'I like china',1),(7,'rouse',2,15,3,'study everyday',3);
  68.  
  69. /*Table structure for table `subject` */
  70.  
  71. DROP TABLE IF EXISTS `subject`;
  72.  
  73. CREATE TABLE `subject` (
  74.   `id` INT(10) NOT NULL AUTO_INCREMENT,
  75.   `sid` INT(10) NOT NULL,
  76.   `subject` VARCHAR(10) NOT NULL,
  77.   PRIMARY KEY (`id`)
  78. ) ENGINE=INNODB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
  79.  
  80. /*Data for the table `subject` */
  81.  
  82. INSERT  INTO `subject`(`id`,`sid`,`subject`) VALUES (1,1,'语文'),(2,2,'数学'),(3,3,'英语');
  83.  
  84. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  85. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  86. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  87. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

 2、项目整体结构

3、导入pom.xml依赖

  1. <?xml version="1.0" encoding="UTF-8"?>
  2.  
  3. <project xmlns="http://maven.apache.org/POM/4.0.0" 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.0</modelVersion>
  6.  
  7.   <groupId>com.hbt</groupId>
  8.   <artifactId>SSMTest6</artifactId>
  9.   <version>1.0-SNAPSHOT</version>
  10.   <packaging>war</packaging>
  11.  
  12.   <name>SSMTest6 Maven Webapp</name>
  13.   <!-- FIXME change it to the project's website -->
  14.   <url>http://www.example.com</url>
  15.  
  16.   <properties>
  17.     <maven.compiler.source>8</maven.compiler.source>
  18.     <maven.compiler.target>8</maven.compiler.target>
  19.   </properties>
  20.  
  21.   <dependencies>
  22.     <!--导入spring的依赖-->
  23.     <dependency>
  24.       <groupId>org.springframework</groupId>
  25.       <artifactId>spring-webmvc</artifactId>
  26.       <version>5.2.5.RELEASE</version>
  27.     </dependency>
  28.     <!--Spring操作数据库的话，还需要一个spring-jdbc-->
  29.     <dependency>
  30.       <groupId>org.springframework</groupId>
  31.       <artifactId>spring-jdbc</artifactId>
  32.       <version>5.3.9</version>
  33.     </dependency>
  34.     <!--aop注入包-->
  35.     <dependency>
  36.       <groupId>org.aspectj</groupId>
  37.       <artifactId>aspectjweaver</artifactId>
  38.       <version>1.9.4</version>
  39.     </dependency>
  40.     <!--mybatis与spring整合的包-->
  41.     <dependency>
  42.       <groupId>org.mybatis</groupId>
  43.       <artifactId>mybatis-spring</artifactId>
  44.       <version>2.0.6</version>
  45.     </dependency>
  46.     <!--junit-->
  47.     <dependency>
  48.       <groupId>junit</groupId>
  49.       <artifactId>junit</artifactId>
  50.       <version>4.7</version>
  51.       <scope>test</scope>
  52.     </dependency>
  53.  
  54.     <!--mysql驱动-->
  55.     <dependency>
  56.       <groupId>mysql</groupId>
  57.       <artifactId>mysql-connector-java</artifactId>
  58.       <version>5.1.47</version>
  59.     </dependency>
  60.     <!--mybatis-->
  61.     <dependency>
  62.       <groupId>org.mybatis</groupId>
  63.       <artifactId>mybatis</artifactId>
  64.       <version>3.5.2</version>
  65.     </dependency>
  66.     <!--log4j-->
  67.     <dependency>
  68.       <groupId>log4j</groupId>
  69.       <artifactId>log4j</artifactId>
  70.       <version>1.2.12</version>
  71.     </dependency>
  72.     <!--Lombok-->
  73.     <dependency>
  74.       <groupId>org.projectlombok</groupId>
  75.       <artifactId>lombok</artifactId>
  76.       <version>1.18.10</version>
  77.     </dependency>
  78.     <!--阿里的连接池-->
  79.     <dependency>
  80.       <groupId>com.alibaba</groupId>
  81.       <artifactId>druid</artifactId>
  82.       <version>1.2.6</version>
  83.     </dependency>
  84.  
  85.     <!--mvc-->
  86.     <dependency>
  87.       <groupId>javax.servlet</groupId>
  88.       <artifactId>servlet-api</artifactId>
  89.       <version>2.5</version>
  90.     </dependency>
  91.     <dependency>
  92.       <groupId>javax.servlet.jsp</groupId>
  93.       <artifactId>jsp-api</artifactId>
  94.       <version>2.2</version>
  95.     </dependency>
  96.     <dependency>
  97.       <groupId>javax.servlet</groupId>
  98.       <artifactId>jstl</artifactId>
  99.       <version>1.2</version>
  100.     </dependency>
  101.  
  102.     <dependency>
  103.       <groupId>com.alibaba</groupId>
  104.       <artifactId>fastjson</artifactId>
  105.       <version>1.2.59</version>
  106.     </dependency>
  107.  
  108.     <dependency>
  109.       <groupId>org.springframework</groupId>
  110.       <artifactId>spring-oxm</artifactId>
  111.       <version>5.2.5.RELEASE</version>
  112.     </dependency>
  113.  
  114.     <dependency>
  115.       <groupId>org.springframework</groupId>
  116.       <artifactId>spring-orm</artifactId>
  117.       <version>5.2.5.RELEASE</version>
  118.     </dependency>
  119.     <dependency>
  120.       <groupId>org.springframework</groupId>
  121.       <artifactId>spring-context-support</artifactId>
  122.       <version>5.2.5.RELEASE</version>
  123.     </dependency>
  124.  
  125.     <dependency>
  126.       <groupId>commons-io</groupId>
  127.       <artifactId>commons-io</artifactId>
  128.       <version>2.6</version>
  129.     </dependency>
  130.  
  131.     <dependency>
  132.       <groupId>commons-fileupload</groupId>
  133.       <artifactId>commons-fileupload</artifactId>
  134.       <version>1.4</version>
  135.     </dependency>
  136.     <!-- 引入JSON -->
  137.     <dependency>
  138.       <groupId>org.codehaus.jackson</groupId>
  139.       <artifactId>jackson-core-asl</artifactId>
  140.       <version>1.9.13</version>
  141.     </dependency>
  142.  
  143.     <dependency>
  144.       <groupId>org.codehaus.jackson</groupId>
  145.       <artifactId>jackson-mapper-asl</artifactId>
  146.       <version>1.9.13</version>
  147.     </dependency>
  148.     <!--    <dependency>-->
  149.     <!--      <groupId>com.fasterxml.jackson.core</groupId>-->
  150.     <!--      <artifactId>jackson-databind</artifactId>-->
  151.     <!--      <version>2.8.5</version>-->
  152.     <!--    </dependency>-->
  153.     <dependency>
  154.       <groupId>com.fasterxml.jackson.core</groupId>
  155.       <artifactId>jackson-core</artifactId>
  156.       <version>2.9.5</version>
  157.     </dependency>
  158.     <dependency>
  159.       <groupId>com.fasterxml.jackson.core</groupId>
  160.       <artifactId>jackson-databind</artifactId>
  161.       <version>2.9.5</version>
  162.     </dependency>
  163.     <dependency>
  164.       <groupId>com.fasterxml.jackson.core</groupId>
  165.       <artifactId>jackson-annotations</artifactId>
  166.       <version>2.9.5</version>
  167.     </dependency>
  168.     <dependency>
  169.       <groupId>com.fasterxml.jackson.module</groupId>
  170.       <artifactId>jackson-module-jaxb-annotations</artifactId>
  171.       <version>2.9.5</version>
  172.     </dependency>
  173.   </dependencies>
  174.  
  175. </project>

 4、编写ssm配置文件

在resources下新建个配置文件database.properties，内容如下：

  1. driver=com.mysql.jdbc.Driver
  2. #在和mysql传递数据的过程中，使用unicode编码格式，并且字符集设置为utf-8
  3. url=jdbc:mysql://127.0.0.1:3306/schooldemo3?useUnicode=true&characterEncoding=utf-8
  4. user=root
  5. password=root

 在resources下新建个配置文件log4j.properties，内容如下：

  1. # rootLogger是所有日志的根日志,修改该日志属性将对所有日志起作用
  2. # 下面的属性配置中,所有日志的输出级别是info,输出源是con
  3. log4j.rootLogger=debugger,con
  4. # 定义输出源的输出位置是控制台
  5. log4j.appender.con=org.apache.log4j.ConsoleAppender
  6. # 定义输出日志的布局采用的类
  7. log4j.appender.con.layout=org.apache.log4j.PatternLayout
  8. # 定义日志输出布局
  9. log4j.appender.con.layout.ConversionPattern=%d{MM-dd HH:mm:ss}[%p]%c%n -%m%n

 在resources下新建个配置文件spring-dao.xml，内容如下：

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"
  3.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.        xmlns:mvc="http://www.springframework.org/schema/mvc"
  5.        xmlns:context="http://www.springframework.org/schema/context"
  6.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  7.                            http://www.springframework.org/schema/beans/spring-beans.xsd
  8.                            http://www.springframework.org/schema/mvc
  9.                            http://www.springframework.org/schema/mvc/spring-mvc.xsd
  10.                            http://www.springframework.org/schema/context
  11.                            http://www.springframework.org/schema/context/spring-context.xsd">
  12.  
  13.     <context:property-placeholder location="classpath:database.properties"/>
  14.  
  15.     <!--配置数据源-->
  16.     <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
  17.         <property name="driverClassName" value="${driver}"></property>
  18.         <property name="url" value="${url}"></property>
  19.         <property name="username" value="${user}"></property>
  20.         <property name="password" value="${password}"></property>
  21.         <property name="maxActive" value="50"></property>
  22.         <property name="initialSize" value="3"></property>
  23.         <property name="maxWait" value="60000"></property>
  24.     </bean>
  25.  
  26.     <!--生成session工厂-->
  27.     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
  28.         <property name="dataSource" ref="dataSource"></property>
  29.         <property name="typeAliasesPackage" value="com.hbt.entity"></property>
  30.         <property name="mapperLocations">
  31.             <array>
  32.                 <value>classpath:mapper/*Mapper.xml</value>
  33.             </array>
  34.         </property>
  35.     </bean>
  36.  
  37.     <!--扫描mapper接口，代理生成mapper实例-->
  38.     <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
  39.         <property name="basePackage" value="com.hbt.dao"></property>
  40.         <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
  41.     </bean>
  42. </beans>
  43.

 在resources下新建个配置文件spring-mvc.xml，内容如下：

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"
  3.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.        xmlns:mvc="http://www.springframework.org/schema/mvc"
  5.        xmlns:context="http://www.springframework.org/schema/context"
  6.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  7.                            http://www.springframework.org/schema/beans/spring-beans.xsd
  8.                            http://www.springframework.org/schema/mvc
  9.                            http://www.springframework.org/schema/mvc/spring-mvc.xsd
  10.                            http://www.springframework.org/schema/context
  11.                            http://www.springframework.org/schema/context/spring-context.xsd">
  12.  
  13.     <context:component-scan base-package="com.hbt"/>
  14.     <!--视图解析器-->
  15.     <bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
  16.         <property name="prefix" value="/WEB-INF/jsp/"></property>
  17.         <property name="suffix" value=".jsp"></property>
  18.     </bean>
  19.     <bean class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter"></bean>
  20. </beans>
  21.

web.xml文件 

  1. <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
  2.          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  3.          xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
  4.          version="4.0">
  5.   <display-name>Archetype Created Web Application</display-name>
  6.   <!--welcome pages-->
  7.   <welcome-file-list>
  8.     <welcome-file>index.jsp</welcome-file>
  9.   </welcome-file-list>
  10.  
  11.   <!--需要配置一个servlet   springmvc的核心类，总控制器-->
  12.   <servlet>
  13.     <servlet-name>dispatchServlet</servlet-name>
  14.     <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
  15.     <init-param>
  16.       <param-name>contextConfigLocation</param-name>
  17.       <param-value>classpath:spring-mvc.xml</param-value>
  18.     </init-param>
  19.     <load-on-startup>1</load-on-startup>
  20.     <async-supported>true</async-supported>
  21.   </servlet>
  22.   <servlet-mapping>
  23.     <servlet-name>dispatchServlet</servlet-name>
  24.     <url-pattern>/</url-pattern>
  25.   </servlet-mapping>
  26.  
  27.   <!-- 注册ServletContext监听器，创建容器对象，并且将ApplicationContext对象放到Application域中 -->
  28.   <listener>
  29.     <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  30.   </listener>
  31.  
  32.   <context-param>
  33.     <param-name>contextConfigLocation</param-name>
  34.     <param-value>classpath:spring-dao.xml</param-value>
  35.   </context-param>
  36.  
  37.   <!-- 解决字符乱码问题 -->
  38.   <filter>
  39.     <filter-name>characterEncodingFilter</filter-name>
  40.     <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
  41.     <init-param>
  42.       <param-name>encoding</param-name>
  43.       <param-value>UTF-8</param-value>
  44.     </init-param>
  45.     <init-param>
  46.       <param-name>forceEncoding</param-name>
  47.       <param-value>true</param-value>
  48.     </init-param>
  49.   </filter>
  50.   <filter-mapping>
  51.     <filter-name>characterEncodingFilter</filter-name>
  52.     <url-pattern>/*</url-pattern>
  53.   </filter-mapping>
  54. </web-app>

iml配置

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <module type="JAVA_MODULE" version="4">
  3.   <component name="FacetManager">
  4.     <facet type="web" name="Web">
  5.       <configuration>
  6.         <descriptors>
  7.           <deploymentDescriptor name="web.xml" url="file://$MODULE_DIR$/web/WEB-INF/web.xml" />
  8.         </descriptors>
  9.         <webroots>
  10.           <root url="file://$MODULE_DIR$/web" relative="/" />
  11.         </webroots>
  12.         <sourceRoots>
  13.           <root url="file://$MODULE_DIR$/src/main/java" />
  14.           <root url="file://$MODULE_DIR$/src/main/resources" />
  15.         </sourceRoots>
  16.       </configuration>
  17.     </facet>
  18.   </component>
  19. </module>

5、entity层代码

Class实体类

  1. package com.hbt.dao;
  2.  
  3. import com.hbt.entity.Sex;
  4. import com.hbt.entity.Student;
  5. import com.hbt.entity.Subject;
  6. import org.apache.ibatis.annotations.Param;
  7.  
  8. import java.util.List;
  9.  
  10. /**
  11.  * @author houbotong
  12.  * @version 0.0.3
  13.  * @description StudentMapper
  14.  * @since 2022-03-23 13:53
  15.  */
  16. public interface StudentMapper {
  17.     //下拉框加载学生性别
  18.     public List<Sex> selsex();
  19.     //下拉框加载学生班级
  20.     public List<Class> selclass();
  21.     //下拉框加载学生最喜欢学科
  22.     public List<Subject> selsubject();
  23.     //分页查询数据
  24.     public List<Student> selAllinfo(@Param("start") Integer start,@Param("end") Integer end,
  25.                                     @Param("sname") String sname,@Param("ssex") Integer ssex,
  26.                                     @Param("sclass") Integer sclass,@Param("ssubject") Integer ssubject);
  27.     //查询总条数
  28.     public Integer count(@Param("sname") String sname,@Param("ssex") Integer ssex,
  29.                          @Param("sclass") Integer sclass,@Param("ssubject") Integer ssubject);
  30.     //新增学生信息
  31.     public void addinfo(Student student);
  32.     //根据id查询出该学生信息
  33.     public Student selByidinfo(Integer id);
  34.     //修改学生信息
  35.     public void upinfo(Student student);
  36.     //删除学生信息
  37.     public void delinfo(Integer id);
  38. }

Page实体类

  1. package com.hbt.entity;
  2.  
  3. import java.util.List;
  4.  
  5. /**
  6.  * @author houbotong
  7.  * @version 0.0.3
  8.  * @description Page
  9.  * @since 2022-03-23 14:02
  10.  */
  11. public class Page {
  12.     private Integer totalPage;      //总页数
  13.     private Integer totalNumber;    //总条数
  14.     private Integer pageNumber;     //每页展示数据
  15.     private Integer currentPage;    //当前页
  16.     private Integer backPage;       //上一页
  17.     private Integer nextPage;       //下一页
  18.     private List<Student> studentList;
  19.  
  20.     public Integer getTotalPage() {
  21.         return totalPage;
  22.     }
  23.  
  24.     public void setTotalPage(Integer totalPage) {
  25.         this.totalPage = totalPage;
  26.     }
  27.  
  28.     public Integer getTotalNumber() {
  29.         return totalNumber;
  30.     }
  31.  
  32.     public void setTotalNumber(Integer totalNumber) {
  33.         this.totalNumber = totalNumber;
  34.     }
  35.  
  36.     public Integer getPageNumber() {
  37.         return pageNumber;
  38.     }
  39.  
  40.     public void setPageNumber(Integer pageNumber) {
  41.         this.pageNumber = pageNumber;
  42.     }
  43.  
  44.     public Integer getCurrentPage() {
  45.         return currentPage;
  46.     }
  47.  
  48.     public void setCurrentPage(Integer currentPage) {
  49.         this.currentPage = currentPage;
  50.     }
  51.  
  52.     public Integer getBackPage() {
  53.         return backPage;
  54.     }
  55.  
  56.     public void setBackPage(Integer backPage) {
  57.         this.backPage = backPage;
  58.     }
  59.  
  60.     public Integer getNextPage() {
  61.         return nextPage;
  62.     }
  63.  
  64.     public void setNextPage(Integer nextPage) {
  65.         this.nextPage = nextPage;
  66.     }
  67.  
  68.     public List<Student> getStudentList() {
  69.         return studentList;
  70.     }
  71.  
  72.     public void setStudentList(List<Student> studentList) {
  73.         this.studentList = studentList;
  74.     }
  75.  
  76.     @Override
  77.     public String toString() {
  78.         return "Page{" +
  79.                 "totalPage=" + totalPage +
  80.                 ", totalNumber=" + totalNumber +
  81.                 ", pageNumber=" + pageNumber +
  82.                 ", currentPage=" + currentPage +
  83.                 ", backPage=" + backPage +
  84.                 ", nextPage=" + nextPage +
  85.                 ", studentList=" + studentList +
  86.                 '}';
  87.     }
  88. }

Sex实体类

  1. package com.hbt.entity;
  2.  
  3. /**
  4.  * @author houbotong
  5.  * @version 0.0.3
  6.  * @description Sex
  7.  * @since 2022-03-23 13:52
  8.  */
  9. public class Sex {
  10.     private Integer id;
  11.     private Integer sid;
  12.     private String sex;
  13.  
  14.     public Integer getId() {
  15.         return id;
  16.     }
  17.  
  18.     public void setId(Integer id) {
  19.         this.id = id;
  20.     }
  21.  
  22.     public Integer getSid() {
  23.         return sid;
  24.     }
  25.  
  26.     public void setSid(Integer sid) {
  27.         this.sid = sid;
  28.     }
  29.  
  30.     public String getSex() {
  31.         return sex;
  32.     }
  33.  
  34.     public void setSex(String sex) {
  35.         this.sex = sex;
  36.     }
  37.  
  38.     @Override
  39.     public String toString() {
  40.         return "Sex{" +
  41.                 "id=" + id +
  42.                 ", sid=" + sid +
  43.                 ", sex='" + sex + '\'' +
  44.                 '}';
  45.     }
  46. }

Student实体类

  1. package com.hbt.entity;
  2.  
  3. /**
  4.  * @author houbotong
  5.  * @version 0.0.3
  6.  * @description Student
  7.  * @since 2022-03-23 13:44
  8.  */
  9. public class Student {
  10.     private Integer id;     //学生表id
  11.     private String sname;   //学生姓名
  12.     private Integer ssex;   //学生性别id
  13.     private String sex;     //学生性别
  14.     private Integer sage;   //学生年龄
  15.     private Integer sclass; //学生班级id
  16.     private String classes; //学生班级
  17.     private String szym;    //座右铭
  18.     private Integer ssubject;//最喜欢学科id
  19.     private String subject; //最喜欢学科
  20.  
  21.     public Integer getId() {
  22.         return id;
  23.     }
  24.  
  25.     public void setId(Integer id) {
  26.         this.id = id;
  27.     }
  28.  
  29.     public String getSname() {
  30.         return sname;
  31.     }
  32.  
  33.     public void setSname(String sname) {
  34.         this.sname = sname;
  35.     }
  36.  
  37.     public Integer getSsex() {
  38.         return ssex;
  39.     }
  40.  
  41.     public void setSsex(Integer ssex) {
  42.         this.ssex = ssex;
  43.     }
  44.  
  45.     public String getSex() {
  46.         return sex;
  47.     }
  48.  
  49.     public void setSex(String sex) {
  50.         this.sex = sex;
  51.     }
  52.  
  53.     public Integer getSage() {
  54.         return sage;
  55.     }
  56.  
  57.     public void setSage(Integer sage) {
  58.         this.sage = sage;
  59.     }
  60.  
  61.     public Integer getSclass() {
  62.         return sclass;
  63.     }
  64.  
  65.     public void setSclass(Integer sclass) {
  66.         this.sclass = sclass;
  67.     }
  68.  
  69.     public String getClasses() {
  70.         return classes;
  71.     }
  72.  
  73.     public void setClasses(String classes) {
  74.         this.classes = classes;
  75.     }
  76.  
  77.     public String getSzym() {
  78.         return szym;
  79.     }
  80.  
  81.     public void setSzym(String szym) {
  82.         this.szym = szym;
  83.     }
  84.  
  85.     public Integer getSsubject() {
  86.         return ssubject;
  87.     }
  88.  
  89.     public void setSsubject(Integer ssubject) {
  90.         this.ssubject = ssubject;
  91.     }
  92.  
  93.     public String getSubject() {
  94.         return subject;
  95.     }
  96.  
  97.     public void setSubject(String subject) {
  98.         this.subject = subject;
  99.     }
  100.  
  101.     @Override
  102.     public String toString() {
  103.         return "Student{" +
  104.                 "id=" + id +
  105.                 ", sname='" + sname + '\'' +
  106.                 ", ssex=" + ssex +
  107.                 ", sex='" + sex + '\'' +
  108.                 ", sage=" + sage +
  109.                 ", sclass=" + sclass +
  110.                 ", classes='" + classes + '\'' +
  111.                 ", szym='" + szym + '\'' +
  112.                 ", ssubject=" + ssubject +
  113.                 ", subject='" + subject + '\'' +
  114.                 '}';
  115.     }
  116. }

Subject实体类

  1. package com.hbt.entity;
  2.  
  3. /**
  4.  * @author houbotong
  5.  * @version 0.0.3
  6.  * @description Subject
  7.  * @since 2022-03-23 13:53
  8.  */
  9. public class Subject {
  10.     private Integer id;
  11.     private Integer sid;
  12.     private String subject;
  13.  
  14.     public Integer getId() {
  15.         return id;
  16.     }
  17.  
  18.     public void setId(Integer id) {
  19.         this.id = id;
  20.     }
  21.  
  22.     public Integer getSid() {
  23.         return sid;
  24.     }
  25.  
  26.     public void setSid(Integer sid) {
  27.         this.sid = sid;
  28.     }
  29.  
  30.     public String getSubject() {
  31.         return subject;
  32.     }
  33.  
  34.     public void setSubject(String subject) {
  35.         this.subject = subject;
  36.     }
  37.  
  38.     @Override
  39.     public String toString() {
  40.         return "Subject{" +
  41.                 "id=" + id +
  42.                 ", sid=" + sid +
  43.                 ", subject='" + subject + '\'' +
  44.                 '}';
  45.     }
  46. }

6、dao层代码

  1. package com.hbt.dao;
  2.  
  3. import com.hbt.entity.Sex;
  4. import com.hbt.entity.Student;
  5. import com.hbt.entity.Subject;
  6. import org.apache.ibatis.annotations.Param;
  7.  
  8. import java.util.List;
  9.  
  10. /**
  11.  * @author houbotong
  12.  * @version 0.0.3
  13.  * @description StudentMapper
  14.  * @since 2022-03-23 13:53
  15.  */
  16. public interface StudentMapper {
  17.     //下拉框加载学生性别
  18.     public List<Sex> selsex();
  19.     //下拉框加载学生班级
  20.     public List<Class> selclass();
  21.     //下拉框加载学生最喜欢学科
  22.     public List<Subject> selsubject();
  23.     //分页查询数据
  24.     public List<Student> selAllinfo(@Param("start") Integer start,@Param("end") Integer end,
  25.                                     @Param("sname") String sname,@Param("ssex") Integer ssex,
  26.                                     @Param("sclass") Integer sclass,@Param("ssubject") Integer ssubject);
  27.     //查询总条数
  28.     public Integer count(@Param("sname") String sname,@Param("ssex") Integer ssex,
  29.                          @Param("sclass") Integer sclass,@Param("ssubject") Integer ssubject);
  30.     //新增学生信息
  31.     public void addinfo(Student student);
  32.     //根据id查询出该学生信息
  33.     public Student selByidinfo(Integer id);
  34.     //修改学生信息
  35.     public void upinfo(Student student);
  36.     //删除学生信息
  37.     public void delinfo(Integer id);
  38. }

7、service层代码

  1. package com.hbt.service;
  2.  
  3. import com.hbt.entity.Page;
  4. import com.hbt.entity.Sex;
  5. import com.hbt.entity.Student;
  6. import com.hbt.entity.Subject;
  7. import org.apache.ibatis.annotations.Param;
  8.  
  9. import java.util.List;
  10.  
  11. /**
  12.  * @author houbotong
  13.  * @version 0.0.3
  14.  * @description StudentService
  15.  * @since 2022-03-23 13:54
  16.  */
  17. public interface StudentService {
  18.     //下拉框加载学生性别
  19.     public List<Sex> selsex();
  20.     //下拉框加载学生班级
  21.     public List<Class> selclass();
  22.     //下拉框加载学生最喜欢学科
  23.     public List<Subject> selsubject();
  24.     //分页查询数据
  25.     public Page selinfo(Integer start, Integer end, String sname, Integer ssex, Integer sclass, Integer ssubject);
  26.     //新增学生信息
  27.     public void addinfo(Student student);
  28.     //根据id查询出该学生信息
  29.     public Student selByidinfo(Integer id);
  30.     //修改学生信息
  31.     public void upinfo(Student student);
  32.     //删除学生信息
  33.     public void delinfo(Integer id);
  34. }

8、serviceimpl层代码

  1. package com.hbt.service.impl;
  2.  
  3. import com.hbt.dao.StudentMapper;
  4. import com.hbt.entity.Page;
  5. import com.hbt.entity.Sex;
  6. import com.hbt.entity.Student;
  7. import com.hbt.entity.Subject;
  8. import com.hbt.service.StudentService;
  9. import org.springframework.beans.factory.annotation.Autowired;
  10. import org.springframework.stereotype.Service;
  11.  
  12. import java.util.List;
  13.  
  14. /**
  15.  * @author houbotong
  16.  * @version 0.0.3
  17.  * @description StudentServiceImpl
  18.  * @since 2022-03-23 13:54
  19.  */
  20. @Service
  21. public class StudentServiceImpl implements StudentService {
  22.     @Autowired
  23.     private StudentMapper studentMapper;
  24.  
  25.     @Override
  26.     public List<Sex> selsex() {
  27.         return studentMapper.selsex();
  28.     }
  29.  
  30.     @Override
  31.     public List<Class> selclass() {
  32.         return studentMapper.selclass();
  33.     }
  34.  
  35.     @Override
  36.     public List<Subject> selsubject() {
  37.         return studentMapper.selsubject();
  38.     }
  39.  
  40.     @Override
  41.     public Page selinfo(Integer start, Integer end, String sname, Integer ssex, Integer sclass, Integer ssubject) {
  42.         Page page = new Page();
  43.         Integer totalcount = studentMapper.count(sname, ssex, sclass, ssubject);
  44.         if (start == null )start =1;
  45.         page.setTotalNumber(totalcount);
  46.         page.setCurrentPage(start == 0 ? 1:start);
  47.         page.setTotalPage(totalcount%3>0 ? totalcount/3+1 : totalcount/3);
  48.         page.setBackPage(start-1<0 ? 1:start-1);
  49.         page.setNextPage(start+1>page.getTotalPage() ? page.getTotalPage() : start+1);
  50.         List<Student> studentList =studentMapper.selAllinfo(
  51.                 (page.getCurrentPage()-1)*3, 3, sname, ssex, sclass, ssubject);
  52.         page.setStudentList(studentList);
  53.         return page;
  54.     }
  55.  
  56.     @Override
  57.     public void addinfo(Student student) {
  58.         studentMapper.addinfo(student);
  59.     }
  60.  
  61.     @Override
  62.     public Student selByidinfo(Integer id) {
  63.         return studentMapper.selByidinfo(id);
  64.     }
  65.  
  66.     @Override
  67.     public void upinfo(Student student) {
  68.         studentMapper.upinfo(student);
  69.     }
  70.  
  71.     @Override
  72.     public void delinfo(Integer id) {
  73.         studentMapper.delinfo(id);
  74.     }
  75. }

9、controller层代码

  1. package com.hbt.controller;
  2.  
  3. import com.alibaba.fastjson.JSONObject;
  4. import com.hbt.entity.Page;
  5. import com.hbt.entity.Sex;
  6. import com.hbt.entity.Student;
  7. import com.hbt.entity.Subject;
  8. import com.hbt.service.StudentService;
  9. import org.springframework.stereotype.Controller;
  10. import org.springframework.ui.Model;
  11. import org.springframework.web.bind.annotation.RequestMapping;
  12. import org.springframework.web.bind.annotation.ResponseBody;
  13.  
  14. import javax.annotation.Resource;
  15. import javax.servlet.http.HttpServletRequest;
  16. import javax.servlet.http.HttpServletResponse;
  17. import java.io.IOException;
  18. import java.util.List;
  19.  
  20. /**
  21.  * @author houbotong
  22.  * @version 0.0.3
  23.  * @description StudentController
  24.  * @since 2022-03-23 13:34
  25.  */
  26. @Controller
  27. public class StudentController {
  28.     @Resource
  29.     private StudentService studentService;
  30.  
  31.     //默认页面
  32.     @RequestMapping("/initWeb")
  33.     public String initWeb(Model model){
  34.         //初始页面下拉框加载
  35.         List<Sex> sexList = studentService.selsex();
  36.         List<Class> classList = studentService.selclass();
  37.         List<Subject> subjectList = studentService.selsubject();
  38.         model.addAttribute("sexList",sexList);
  39.         model.addAttribute("classList",classList);
  40.         model.addAttribute("subjectList",subjectList);
  41.         return "index";
  42.     }
  43.  
  44.     //分页展示所有数据
  45.     @RequestMapping("/studentList")
  46.     @ResponseBody
  47.     public void selAllInfo(HttpServletRequest request, HttpServletResponse response, Integer start, Integer end,
  48.                            String sname, Integer ssex, Integer sclass, Integer ssubject) throws IOException {
  49.         if (start == null) start=1;
  50.         //System.out.println("sname:"+sname+";ssex:"+ssex+";sclass:"+sclass+";ssubject:"+ssubject);
  51.         Page page = studentService.selinfo(start, end, sname, ssex, sclass, ssubject);
  52.         JSONObject jobj = new JSONObject();
  53.         jobj.put("page",page);
  54.         //System.out.println(page);
  55.         response.getWriter().append(jobj.toJSONString());
  56.     }
  57.  
  58.     //新增学生信息
  59.     @RequestMapping("/stuAdd")
  60.     public String addinfo(Student student){
  61.         studentService.addinfo(student);
  62.         return "redirect:/initWeb";
  63.     }
  64.  
  65.     //新增信息跳转
  66.     @RequestMapping("/toAdd")
  67.     public String toAdd(Model model){
  68.         //新增页面下拉框加载
  69.         List<Sex> sexList = studentService.selsex();
  70.         List<Class> classList = studentService.selclass();
  71.         List<Subject> subjectList = studentService.selsubject();
  72.         model.addAttribute("sexList",sexList);
  73.         model.addAttribute("classList",classList);
  74.         model.addAttribute("subjectList",subjectList);
  75.         return "addinfo";
  76.     }
  77.  
  78.     //根据id查出该学生信息
  79.     @RequestMapping("/selupinfo")
  80.     public String selupinfo(Model model,Integer id){
  81.         //修改页面下拉框加载
  82.         List<Sex> sexList = studentService.selsex();
  83.         List<Class> classList = studentService.selclass();
  84.         List<Subject> subjectList = studentService.selsubject();
  85.         model.addAttribute("sexList",sexList);
  86.         model.addAttribute("classList",classList);
  87.         model.addAttribute("subjectList",subjectList);
  88.         Student student = studentService.selByidinfo(id);
  89.         model.addAttribute("student",student);
  90.         return "upinfo";
  91.     }
  92.  
  93.     //修改学生信息
  94.     @RequestMapping("/updateinfo")
  95.     public String updateinfo(Student student){
  96.         studentService.upinfo(student);
  97.         return "redirect:/initWeb";
  98.     }
  99.  
  100.     //删除学生信息
  101.     @RequestMapping("/delindo")
  102.     public String delinfo(Integer id){
  103.         studentService.delinfo(id);
  104.         return "redirect:/initWeb";
  105.     }
  106. }

10、前端页面代码

添加页面

  1. <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
  2. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
  3. <html>
  4. <head>
  5.     <title>新增学生</title>
  6. </head>
  7.  
  8. <body>
  9. <h2>新增学生</h2>
  10. <form action="stuAdd" method="post" accept-charset="UTF-8">
  11.     <table border="1">
  12.         <tr>
  13.             <td>学生姓名</td>
  14.             <td>
  15.                 <input type="text" name="sname">
  16.             </td>
  17.         </tr>
  18.         <tr>
  19.             <td>年龄</td>
  20.             <td>
  21.                 <input type="text" name="sage">
  22.             </td>
  23.         </tr>
  24.         <tr>
  25.             <td>座右铭</td>
  26.             <td>
  27.                 <input type="text" name="szym">
  28.             </td>
  29.         </tr>
  30.         <tr>
  31.             <td>性别</td>
  32.             <td>
  33.                 <select name="ssex" id="ssex">
  34.                     <c:forEach items="${sexList}" var="sex">
  35.                         <option value="${sex.sid}">${sex.sex}</option>
  36.                     </c:forEach>
  37.                 </select>
  38.             </td>
  39.         </tr>
  40.         <tr>
  41.             <td>班级</td>
  42.             <td>
  43.                 <select name="sclass" id="sclass">
  44.                     <c:forEach items="${classList}" var="cl">
  45.                         <option value="${cl.sid}">${cl.classes}</option>
  46.                     </c:forEach>
  47.                 </select>
  48.             </td>
  49.         </tr>
  50.         <tr>
  51.             <td>最爱学科</td>
  52.             <td>
  53.                 <select name="ssubject" id="ssubject">
  54.                     <c:forEach items="${subjectList}" var="sub">
  55.                         <option value="${sub.sid}">${sub.subject}</option>
  56.                     </c:forEach>
  57.                 </select>
  58.             </td>
  59.         </tr>
  60.         <tr>
  61.             <td colspan="2">
  62.                 <input type="submit" value="提交">
  63.             </td>
  64.         </tr>
  65.     </table>
  66. </form>
  67. </body>
  68. </html>

加载页面 

  1. <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
  2. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
  3. <html>
  4. <head>
  5.     <title>学生信息</title>
  6. </head>
  7. <script src="https://cdn.bootcss.com/jquery/2.1.4/jquery.min.js"></script>
  8. <script language="JavaScript">
  9.     window.onload=function (){
  10.         aaa();
  11.     }
  12.     function aaa(start){
  13.         var info={
  14.             sname : document.getElementById("sname").value,
  15.             ssex : document.getElementById("ssex").value,
  16.             sclass : document.getElementById("sclass").value,
  17.             ssubject : document.getElementById("ssubject").value,
  18.             start : start
  19.         };
  20.         //alert(info.ssex);
  21.         $.ajax({
  22.             url:"/SSMTest6_war_exploded/studentList",//服务器地址
  23.             type:"post",//提交方式
  24.             data: info,//提交数据
  25.             dataType:"json",//回调数据类型
  26.             success:function (page){
  27.                 var dataObj = page.page.studentList;//返回的result的json格式的数据
  28.                 var dataObj2 = page.page.totalPage;
  29.                 con = "";
  30.                 con2 = "";
  31.                 con+="<tr>";
  32.                 con+="<th>学生姓名</th>";
  33.                 con+="<th>年龄</th>";
  34.                 con+="<th>座右铭</th>";
  35.                 con+="<th>性别</th>";
  36.                 con+="<th>班级</th>";
  37.                 con+="<th>最爱学科</th>";
  38.                 con+="<th colspan=2>操作</th>";
  39.                 con+="</tr>";
  40.                 $.each(dataObj,function (index,item){
  41.                     con+="<tr>";
  42.                     con+="<td>"+item.sname+"</td>";
  43.                     con+="<td>"+item.sage+"</td>";
  44.                     con+="<td>"+item.szym+"</td>";
  45.                     con+="<td>"+item.sex+"</td>";
  46.                     con+="<td>"+item.classes+"</td>";
  47.                     con+="<td>"+item.subject+"</td>";
  48.                     con+="<td><a href='/SSMTest6_war_exploded/selupinfo?id="+item.id+"'>修改</a>&nbsp|&nbsp<a href='/SSMTest6_war_exploded/delindo?id="+item.id+"'>删除</a></td>";
  49.                     con+="</tr>";
  50.                 });
  51.                 $("#con").html(con);
  52.                 con2+="<button id='aaa' onclick='aaa(1)'>首页</button>";
  53.                 con2+="<button id='aaa' onclick='aaa("+page.page.backPage+")'>上一页</button>";
  54.                 con2+="<button id='aaa' onclick='aaa("+page.page.nextPage+")'>下一页</button>";
  55.                 con2+="<button id='aaa' onclick='aaa("+page.page.totalPage+")'>末页</button>";
  56.                 con2+="<span>第"+page.page.currentPage+"页/共"+page.page.totalPage+"页("+page.page.totalNumber+"条记录)</span><br/>";
  57.                 //con2+="<div>跳转至<input type='text' id='paper' onkeyup='this.value=this.value.replace(/\D/g,'')' onafterpaste='this.value=this.value.replace(/\D/g,'')'/>页<input type='button' value='GO' onclick='aaa()'/></div>";
  58.                 for(var i=1; i<=dataObj2; i++){
  59.                     con2+="<button id='aaa' onclick='aaa("+i+")'>"+i+"</button>";
  60.                 }
  61.                 $("#con2").html(con2);
  62.             }
  63.         });
  64.     }
  65. </script>
  66. <body>
  67. <a href="toAdd">添加学生</a>
  68. <div>
  69.     学生名称<input type="text" name="sname" id="sname">&nbsp;&nbsp;
  70.     性别<select name="ssex" id="ssex">
  71.             <option value="">--请选择--</option>
  72.             <c:forEach items="${sexList}" var="sex">
  73.                 <option value="${sex.sid}">${sex.sex}</option>
  74.             </c:forEach>
  75.         </select>
  76.     班级<select name="sclass" id="sclass">
  77.             <option value="">--请选择--</option>
  78.             <c:forEach items="${classList}" var="cl">
  79.                 <option value="${cl.sid}">${cl.classes}</option>
  80.             </c:forEach>
  81.         </select>
  82.     最爱学科<select name="ssubject" id="ssubject">
  83.             <option value="">--请选择--</option>
  84.             <c:forEach items="${subjectList}" var="sub">
  85.                 <option value="${sub.sid}">${sub.subject}</option>
  86.             </c:forEach>
  87.         </select>
  88.     <button id="aaa" onclick="aaa(1)">查询</button>
  89. </div>
  90. <div id="bbb">
  91.     <table border="1" id="con">
  92.  
  93.     </table>
  94. </div>
  95. <div id="con2">
  96.  
  97. </div>
  98. </body>
  99. </html>

修改页面 

  1. <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
  2. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
  3. <html>
  4. <head>
  5.     <title>修改学生信息</title>
  6. </head>
  7.  
  8. <body>
  9. <h2>修改学生信息</h2>
  10. <form action="updateinfo" method="post">
  11.     <input type="hidden" name="id" value="${student.id}">
  12.     <table border="1">
  13.         <tr>
  14.             <td>学生姓名</td>
  15.             <td>
  16.                 <input type="text" name="sname" value="${student.sname}">
  17.             </td>
  18.         </tr>
  19.         <tr>
  20.             <td>年龄</td>
  21.             <td>
  22.                 <input type="text" name="sage" value="${student.sage}">
  23.             </td>
  24.         </tr>
  25.         <tr>
  26.             <td>座右铭</td>
  27.             <td>
  28.                 <input type="text" name="szym" value="${student.szym}">
  29.             </td>
  30.         </tr>
  31.         <tr>
  32.             <td>性别</td>
  33.             <td>
  34.                 <select name="ssex">
  35.                     <c:forEach items="${sexList}" var="sex">
  36.                         <c:if test="${sex.sid == student.ssex}">
  37.                             <option value="${sex.sid}" selected = "selected">${sex.sex}</option>
  38.                         </c:if>
  39.                         <c:if test="${sex.sid != student.ssex}">
  40.                             <option value="${sex.sid}">${sex.sex}</option>
  41.                         </c:if>
  42.                     </c:forEach>
  43.                 </select>
  44.             </td>
  45.         </tr>
  46.         <tr>
  47.             <td>班级</td>
  48.             <td>
  49.                 <select name="sclass">
  50.                     <c:forEach items="${classList}" var="cl">
  51.                         <c:if test="${cl.sid == student.sclass}">
  52.                             <option value="${cl.sid}" selected = "selected">${cl.classes}</option>
  53.                         </c:if>
  54.                         <c:if test="${cl.sid != student.sclass}">
  55.                             <option value="${cl.sid}">${cl.classes}</option>
  56.                         </c:if>
  57.                     </c:forEach>
  58.                 </select>
  59.             </td>
  60.         </tr>
  61.         <tr>
  62.             <td>最爱学科</td>
  63.             <td>
  64.                 <select name="ssubject">
  65.                     <c:forEach items="${subjectList}" var="sub">
  66.                         <c:if test="${sub.sid == student.ssubject}">
  67.                             <option value="${sub.sid}" selected = "selected">${sub.subject}</option>
  68.                         </c:if>
  69.                         <c:if test="${sub.sid != student.ssubject}">
  70.                             <option value="${sub.sid}">${sub.subject}</option>
  71.                         </c:if>
  72.                     </c:forEach>
  73.                 </select>
  74.             </td>
  75.         </tr>
  76.         <tr>
  77.             <td colspan="2">
  78.                 <input type="submit" value="提	交" />
  79.             </td>
  80.         </tr>
  81.     </table>
  82. </form>
  83. </body>
  84. </html>

11、mapper文件StudentMapper.xml代码（sql）

  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE mapper
  3.         PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  4.         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  5. <!--命名空间是对应接口的包名+类名 -->
  6. <mapper namespace="com.hbt.dao.StudentMapper">
  7.     <!--  下拉框加载学生性别  -->
  8.     <select id="selsex" resultType="com.hbt.entity.Sex">
  9.         SELECT * FROM sex
  10.     </select>
  11.     <!--  下拉框加载学生班级  -->
  12.     <select id="selclass" resultType="com.hbt.entity.Class">
  13.         SELECT * FROM class
  14.     </select>
  15.     <!--  下拉框加载学生最喜欢学科  -->
  16.     <select id="selsubject" resultType="com.hbt.entity.Subject">
  17.         SELECT * FROM SUBJECT
  18.     </select>
  19.     <!--  分页查询学生数据  -->
  20.     <select id="selAllinfo" resultType="com.hbt.entity.Student">
  21.         SELECT a.id,a.sname,a.sage,a.szym,b.sex,c.classes,d.subject FROM student a
  22.             INNER JOIN sex b ON b.sid=a.ssex
  23.             INNER JOIN class c ON c.sid=a.sclass
  24.             INNER JOIN SUBJECT d ON d.sid=a.ssubject
  25.         <if test="sname != null and sname != ''">
  26.             and a.sname like concat('%',#{sname},'%')
  27.         </if>
  28.         <if test="ssex != null and ssex != ''">
  29.             and a.ssex = #{ssex}
  30.         </if>
  31.         <if test="sclass != null and sclass != ''">
  32.             and a.sclass = #{sclass}
  33.         </if>
  34.         <if test="ssubject != null and ssubject != ''">
  35.             and a.ssubject = #{ssubject}
  36.         </if>
  37.         ORDER BY a.id limit #{start },#{end }
  38.     </select>
  39.     <!--  查询总条数  -->
  40.     <select id="count" resultType="java.lang.Integer">
  41.         SELECT COUNT(*) FROM student
  42.         <trim prefix="where">
  43.             1=1
  44.             <if test="sname != null and sname != ''">
  45.                 and sname like concat('%',#{sname},'%')
  46.             </if>
  47.             <if test="ssex != null and ssex != ''">
  48.                 and ssex = #{ssex}
  49.             </if>
  50.             <if test="sclass != null and sclass != ''">
  51.                 and sclass = #{sclass}
  52.             </if>
  53.             <if test="ssubject != null and ssubject != ''">
  54.                 and ssubject = #{ssubject}
  55.             </if>
  56.         </trim>
  57.     </select>
  58.     <!--  新增学生信息  -->
  59.     <insert id="addinfo" parameterType="com.hbt.entity.Student">
  60.         INSERT INTO student(sname,ssex,sage,sclass,szym,ssubject)
  61.         VALUES(#{sname}, #{ssex}, #{sage}, #{sclass}, #{szym}, #{ssubject})
  62.     </insert>
  63.     <!--  根据id查询出该学生信息  -->
  64.     <select id="selByidinfo" resultType="com.hbt.entity.Student">
  65.         SELECT * FROM student WHERE id = #{id}
  66.     </select>
  67.     <!--  修改学生信息  -->
  68.     <update id="upinfo" parameterType="com.hbt.entity.Student">
  69.         UPDATE student SET sname=#{sname},sage=#{sage},szym=#{szym},ssex=#{ssex},sclass=#{sclass},ssubject=#{ssubject}
  70.         where id=#{id}
  71.     </update>
  72.     <!--  根据id删除学生信息  -->
  73.     <delete id="delinfo" parameterType="com.hbt.entity.Student">
  74.         delete from student where id=#{id}
  75.     </delete>
  76. </mapper>
  77.  
  78.  
  79.

功能实现

本文内容由网友自发贡献，转载请注明出处：https://www.wpsshop.cn/w/花生_TL007/article/detail/262796
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号