淘先锋技术网

首页 1 2 3 4 5 6 7

前言

数据库表

CREATE TABLE `gd_flight` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id列',
  `flight_id` varchar(20) CHARACTER SET utf8 DEFAULT NULL COMMENT '航号',
  `company` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '航空公司',
  `departure_airport` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '出发机场',
  `arrive_airport` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '达到机场',
  `departure_time` datetime DEFAULT NULL COMMENT '出发时间',
  `arrive_time` datetime DEFAULT NULL COMMENT '到达时间',
  `model` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '机型',
  `is_delete` int(11) DEFAULT NULL COMMENT '是否隐藏0显示 1隐藏',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4;

项目整体结构目录

在这里插入图片描述

获取源码

码云

整合Spring

1、创建项目

在这里插入图片描述
在这里插入图片描述

2、导包

  <properties>
    <jsonVersion>1.9.13</jsonVersion>
    <jacksonVersion>2.9.0</jacksonVersion>
    <springVersion>5.0.12.RELEASE</springVersion>
    <mysqlVersion>8.0.18</mysqlVersion>
    <mybatisVersion>3.5.6</mybatisVersion>
    <mybatisSpringVersion>1.3.1</mybatisSpringVersion>
  </properties>
   <dependencies>
    <!--junit4-->
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.12</version>
    </dependency>
    <!--日志-->
    <dependency>
      <groupId>commons-logging</groupId>
      <artifactId>commons-logging</artifactId>
      <version>1.2</version>
    </dependency>
    <dependency>
      <groupId>log4j</groupId>
      <artifactId>log4j</artifactId>
      <version>1.2.17</version>
    </dependency>
    <!-- mysql数据库驱动依赖 -->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>${mysqlVersion}</version>
    </dependency>
    <!--c3p0  数据连接池 jar-->
    <dependency>
      <groupId>com.mchange</groupId>
      <artifactId>c3p0</artifactId>
      <version>0.9.5.1</version>
    </dependency>
    <!--C3P0额外依赖的一个jar包-->
    <dependency>
      <groupId>com.mchange</groupId>
      <artifactId>mchange-commons-java</artifactId>
      <version>0.2.10</version>
    </dependency>
    <!-- Mybatis框架:-->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>${mybatisVersion}</version>
    </dependency>
    <!-- MyBatis整合Spring的适配包 -->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis-spring</artifactId>
      <version>${mybatisSpringVersion}</version>
    </dependency>


    <!--json jar包-->
    <!-- json数据 使springMVC可以返回json值 ,视情况添加-->
    <dependency>
      <groupId>org.codehaus.jackson</groupId>
      <artifactId>jackson-mapper-asl</artifactId>
      <version>${jsonVersion}</version>
    </dependency>

    <!-- Jackson可以轻松的将Java对象转换成json对象和xml文档,同样也可以将json、xml转换成Java对象-->
    <dependency>
      <groupId>com.fasterxml.jackson.core</groupId>
      <artifactId>jackson-core</artifactId>
      <version>${jacksonVersion}</version>
    </dependency>
    <dependency>
      <groupId>com.fasterxml.jackson.core</groupId>
      <artifactId>jackson-annotations</artifactId>
      <version>${jacksonVersion}</version>
    </dependency>

    <dependency>
      <groupId>com.fasterxml.jackson.core</groupId>
      <artifactId>jackson-databind</artifactId>
      <version>${jacksonVersion}</version>
    </dependency>
    <!-- Spring依赖 -->
    <!--1. Spring核心依赖,上面已经有日志了 -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-core</artifactId>
      <version>${springVersion}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-beans</artifactId>
      <version>${springVersion}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-context</artifactId>
      <version>${springVersion}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-expression</artifactId>
      <version>${springVersion}</version>
    </dependency>
    <!--spring的aop jar包-->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-aop</artifactId>
      <version>${springVersion}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-aspects</artifactId>
      <version>${springVersion}</version>
    </dependency>
    <!--这两个jar包是阿帕奇的-->
    <dependency>
      <groupId>org.aspectj</groupId>
      <artifactId>aspectjrt</artifactId>
      <version>1.8.13</version>
    </dependency>
    <dependency>
      <groupId>org.aspectj</groupId>
      <artifactId>aspectjweaver</artifactId>
      <version>1.8.13</version>
    </dependency>
    <dependency>
      <groupId>aopalliance</groupId>
      <artifactId>aopalliance</artifactId>
      <version>1.0</version>
    </dependency>
    <!--2. SpringDAO层依赖 -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-jdbc</artifactId>
      <version>${springVersion}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-tx</artifactId>
      <version>${springVersion}</version>
    </dependency>
    <!--3. Spring WEB依赖 -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-web</artifactId>
      <version>5.0.12.RELEASE</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-webmvc</artifactId>
      <version>${springVersion}</version>
    </dependency>
    <!--4.Spring-test相关依赖 -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-test</artifactId>
      <version>${springVersion}</version>
    </dependency>
    
    <!-- lombok插件导包-->
    <dependency>
      <groupId>org.projectlombok</groupId>
      <artifactId>lombok</artifactId>
      <version>1.18.10</version>
      <scope>provided</scope>
    </dependency>
    <!--EL表达式-->
    <dependency>
      <groupId>taglibs</groupId>
      <artifactId>standard</artifactId>
      <version>1.1.2</version>
      <type>jar</type>
    </dependency>
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>jstl</artifactId>
      <version>1.2</version>
      <type>jar</type>
    </dependency>

    <dependency>
      <groupId>javax.servlet.jsp</groupId>
      <artifactId>javax.servlet.jsp-api</artifactId>
      <version>2.3.3</version>
      <scope>provided</scope>
    </dependency>

    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>javax.servlet-api</artifactId>
      <version>4.0.1</version>
      <scope>provided</scope>
    </dependency>
  </dependencies>

3、创建 FlightService

package com.oyzk.service;

import com.oyzk.entity.FlightEntity;

import java.util.List;

/**
 * @author Kingkang
 * @title FlightService
 * @create 2022/12/7
 **/
public interface FlightService {
      List<FlightEntity> findAll();
}

4、创建 FlightServiceImpl

package com.oyzk.service.impl;

import com.oyzk.entity.FlightEntity;
import com.oyzk.service.FlightService;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * @author Kingkang
 * @title FlightServiceImpl
 * @create 2022/12/7
 **/
@Service("FlightService")//取个别名,测试需要,
public class FlightServiceImpl implements FlightService {
    public List<FlightEntity> findAll() {
        System.out.println("查询所有用户。。。");
        return null;
    }
}

5、创建配置文件 applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xsi:schemaLocation="http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.3.xsd
		http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
		http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.3.xsd
		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd">


 <!-- 自动扫描 -->
    <context:component-scan base-package="com.oyzk">
        <!-- 扫描时跳过 @Controller 注解的JAVA类(控制器) -->
        <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    </context:component-scan>

</beans>

6、在web.xml添加配置

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://java.sun.com/xml/ns/javaee"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
         version="3.0">  
<!-- 地址为http://localhost:8080/  显示的默认网页-->
  <welcome-file-list>
    <welcome-file>/index.jsp</welcome-file>
  </welcome-file-list>

  <!--加载Spring的配置文件到上下文中去-->
  <context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value> classpath:applicationContext.xml </param-value>
  </context-param>

  <!-- Spring监听器 -->
  <listener>
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>
  <!--  字符集过滤  -->
  <filter>
    <filter-name>encodingFilter</filter-name>
    <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
    <init-param>
      <param-name>encoding</param-name>
      <param-value>UTF-8</param-value>
    </init-param>
    <init-param>
      <param-name>forceEncoding</param-name>
      <param-value>true</param-value>
    </init-param>
  </filter>
  <filter-mapping>
    <filter-name>encodingFilter</filter-name>
    <url-pattern>/*</url-pattern>
  </filter-mapping>
</web-app>

7、测试

package com.oyzk.test;

import com.oyzk.service.FlightService;
import com.oyzk.service.impl.FlightServiceImpl;
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

/**
 * @author Kingkang
 * @title FlightTest
 * @create 2022/12/7
 **/
public class FlightTest {
    @Test
    public void  findAllTest(){
        ApplicationContext applicationContext = new ClassPathXmlApplicationContext("classpath:applicationContext.xml");
        FlightService service = (FlightService) applicationContext.getBean("FlightService"); // 因为给service起了别名,所以通过id的方式获取class
        service.findAll();

    }
}

看到如下效果,说明spring已经没有问题

在这里插入图片描述

spring+springmvc整合

1、创建springmvc.xml

在resources文件夹下创建springmvc.xml文件,开启注解扫描,视图解析器以及过滤静态资源和springmvc注解支持

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="
        http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/mvc
        http://www.springframework.org/schema/mvc/spring-mvc.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context.xsd">
    <!--.配置spring开启注解mvc 的支持-->
    <mvc:annotation-driven></mvc:annotation-driven>
    <!--扫描控制层-->
    <context:component-scan base-package="com.oyzk.controller"></context:component-scan>
    <!--4.视图解析器  对模型视图名称的解析,在请求时模型视图名称添加前后缀-->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/WEB-INF/views/"/>
        <!--后缀-->
        <property name="suffix" value=".jsp"/>
    </bean>
    <!--这里是对静态资源的映射-->
    <mvc:resources mapping="/js/**" location="/js/" />
    <mvc:resources mapping="/css/**" location="/css/" />
    <mvc:resources mapping="/img/**" location="/img/" />

</beans>

创建配置类里面的js、css、img文件夹

2、添加web.xml文件配置


  <!-- spring MVC config start-->
  <servlet>
    <servlet-name>dispatcherServlet</servlet-name>
    <!--通过java的反射机制加载-->
    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    <init-param>
      <param-name>contextConfigLocation</param-name>
      <!-- 此处指向的的是SpringMVC的配置文件 -->
      <param-value>classpath:springmvc.xml</param-value>
    </init-param>
    <!--让我们springmvc DispatcherServlet优先被加载-->
    <load-on-startup>1</load-on-startup>
  </servlet>
  <!--客户端发送所有请求 都会达到我们的 DdispatcherServlet 静态资源 控制器中,请求-->
  <servlet-mapping>
    <servlet-name>dispatcherServlet</servlet-name>
    <url-pattern>/</url-pattern>
  </servlet-mapping>
  <!-- spring MVC config end-->

3、创建controller

package com.oyzk.controller;

import com.oyzk.entity.FlightEntity;
import com.oyzk.service.FlightService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;

import java.util.List;

/**
 * @author Kingkang
 * @title FlightController
 * @create 2022/12/7
 **/
@Controller
public class FlightController {

    @RequestMapping("/findAll")
    public String findAll(){
        System.out.println("success");
        return "homePage";
    }

}

4、创建homePage.jsp

<%--
  Created by IntelliJ IDEA.
  User: Kingkang
  Date: 2022/12/7
  Time: 17:22
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>信息展示页面</title>
</head>
<body>
信息展示页面
</body>
</html>

5、配置tomcat以及启动测试

在这里插入图片描述

在这里插入图片描述
http://localhost:8080/findAll

在这里插入图片描述

能到这个效果说明,恭喜你spring+springmvc已经整合成功

spring+springmvc+mybatis整合

1、创建FlightEntity实体类

package com.oyzk.entity;

import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;

import java.util.Date;

/**
 * @author Kingkang
 * @title FlightEntity
 * @create 2022/12/6
 **/
@Data
public class FlightEntity {

    private int id;
    private String flightId;
    private String company;
    private String departureAirport;
    private String arriveAirport;
    /**
     * 实例
     * 把从前端到后端的日期格式化
     * timezone="GMT+8" 东八区
     * pattern:是你需要转换的时间日期的格式
     * 		 "yyyy-MM-dd HH:mm:ss"
     * 		 "yyyy-MM-dd HH:mm"
     * 		 "yyyy-MM-dd HH"
     * 		 "yyyy-MM-dd"
     * 		 "yyyy-MM"
     * 根据需要自行选择
     */
/*    @JsonFormat(timezone="GMT+8", pattern="yyyy-MM-dd")
    private Date departureTime;
    @JsonFormat(timezone="GMT+8", pattern="yyyy-MM-dd")
    private Date arriveTime;*/

    private String departureTime;
    private String arriveTime;
    private String model;
    private int isDelete;
}


2、创建FlightDao

在dao文件夹下面创建FlightDao

package com.oyzk.dao;

import com.oyzk.entity.FlightEntity;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @author Kingkang
 * @title FlightDao
 * @create 2022/12/7
 **/
@Repository
public interface FlightDao {
    @Select("select*from gd_flight")
    public List<FlightEntity> findAll();
}

3、创建mysqlConfig.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<!--数据库相关的配置-->
<configuration>
    <settings>
        <!-- 打印sql日志 -->
        <setting name="logImpl" value="STDOUT_LOGGING" />
    </settings>

    <environments default="mysql">
        <!--配置mysql-->
        <environment id="mysql">
            <!--配置事务类型-->
            <transactionManager type="JDBC"/>
            <!--配置数据源/连接池-->
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/frame?serverTimezone=Asia/Shanghai&amp;useUnicode=true&amp;characterEncoding=utf8&amp;useSSL=false"/>
                <property name="username" value="root"/>
                <property name="password" value="root"/>
            </dataSource>
        </environment>
    </environments>


    <!--指定映射配置文件的位置,映射配置文件指的是每个dao独立的配置文件-->
    <mappers>
        <!--使用xml进行查询-->
       <!-- <mapper resource="mapper/flightMapper.xml"/>-->
        <!--使用注解-->
        <mapper class="com.oyzk.dao.FlightDao"/>

    </mappers>
</configuration>

4、测试mybatis


    @Test
    public void test() throws IOException {
        InputStream resourceAsStream = Resources.getResourceAsStream("mybatis-config.xml");
        SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
        SqlSessionFactory factory = builder.build(resourceAsStream);
        SqlSession session = factory.openSession(true);
        FlightDao mapper = session.getMapper(FlightDao.class);
        List<FlightEntity> all = mapper.findAll();
        for (FlightEntity flight : all) {
            System.out.println(flight);
        }
    }

能看到如下效果,说明是mybatis没有问题了l

整合ssm+bootstrap(实现增删改查)

在spring的文件中整合mybatis,配置连接池,factory,dao所在的包,此时有无将mysqlConfig.xml都不重要!

1、在application配置文件里面添加mybatis的配置

  <!--引入外部文件-->
    <context:property-placeholder location="classpath:dbconfig.properties"></context:property-placeholder>

    <!--配置数据源-->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
        <property name="driverClass" value="${jdbc.driver}" />  <!--数据库连接驱动-->
        <property name="jdbcUrl" value="${jdbc.url}" />     <!--数据库地址-->
        <property name="user" value="${jdbc.username}" />   <!--用户名-->
        <property name="password" value="${jdbc.password}" />   <!--密码-->
        <property name="maxPoolSize" value="40" />      <!--最大连接数-->
        <property name="minPoolSize" value="1" />       <!--最小连接数-->
        <property name="initialPoolSize" value="10" />      <!--初始化连接池内的数据库连接-->
        <property name="maxIdleTime" value="20" />  <!--最大空闲时间-->
    </bean>

    <!--配置sqlSessionFactory-->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
    </bean>

    <!--配置dao所在的包-->
    <bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.oyzk.dao"/>
    </bean>

2、创建 dbconfig.properties

#database connection config
jdbc.driver = com.mysql.cj.jdbc.Driver
jdbc.url = jdbc:mysql://localhost:3306/frame?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone = GMT
jdbc.username = root
jdbc.password = root

3、创建 log4j.properties

Global logging configuration
log4j.rootLogger=INFO, stdout
# Console output...
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

4、创建FlightDao并写出crud接口

package com.oyzk.dao;

import com.oyzk.entity.FlightEntity;
import org.apache.ibatis.annotations.*;
import org.omg.CORBA.INTERNAL;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @author Kingkang
 * @title FlightDao
 * @create 2022/12/7
 **/
@Repository
public interface FlightDao {
    /**
     * 查询所有信息
     * MyBatis为我们提供了注解@Results,@Result,@ResultMap
     * 用来代替mapper文件中的<resultMap>,<result>,<select id="showAll" resultMap="id">
     * @return
     */
    @Select("select*from gd_flight")
    @Results(id="floghtResultMap", value={
            @Result(column = "id",property = "id"),
            @Result(column = "flight_id",property = "flightId"),
            @Result(column = "company",property = "company"),
            @Result(column = "departure_airport",property = "departureAirport"),
            @Result(column = "arrive_airport",property = "arriveAirport"),
            @Result(column = "departure_time",property = "departureTime"),
            @Result(column = "arrive_time",property = "arriveTime"),
            @Result(column = "model",property = "model"),
            @Result(column = "is_delete",property = "isDelete")
    }
    )
    List<FlightEntity> findAll();

    @Select("select*from gd_flight where id=#{id}")
    @ResultMap("floghtResultMap")// //这里直接使用@ResultMap引入就好啦~
    FlightEntity findById(int id);

    @Insert("INSERT INTO gd_flight(`flight_id`, `company`, `departure_airport`, `arrive_airport`, `departure_time`, `arrive_time`, `model`, `is_delete`) " +
            "VALUES(#{flightId},#{company},#{departureAirport},#{arriveAirport},#{departureTime},#{arriveTime},#{model},#{isDelete});")
    int insertFlight(FlightEntity flightEntity);

    @Update("UPDATE gd_flight set " +
            " company=#{company},flight_id=#{flightId}, " +
            " departure_airport=#{departureAirport},arrive_airport=#{arriveAirport}," +
            " departure_time=#{departureTime},arrive_time=#{arriveTime}," +
            " model=#{model},is_delete=#{isDelete}"+
            " where id=#{id}")
    int updateFligth(FlightEntity flightEntity);

    @Delete("delete from gd_flight where id=#{id}")
    int deleteByIdFligth(int id);
}

5、创建FlightService文件以及接口

package com.oyzk.service;

import com.oyzk.entity.FlightEntity;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Update;

import java.util.List;

/**
 * @author Kingkang
 * @title FlightService
 * @create 2022/12/7
 **/
public interface FlightService {
      List<FlightEntity> findAll();

      FlightEntity findById(int id);

      int insertFlight(FlightEntity flightEntity);

      int updateFligth(FlightEntity flightEntity);

      int deleteByIdFligth(int id);
}

6、创建FlightServiceImpl

package com.oyzk.service.impl;

import com.oyzk.dao.FlightDao;
import com.oyzk.entity.FlightEntity;
import com.oyzk.service.FlightService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * @author Kingkang
 * @title FlightServiceImpl
 * @create 2022/12/7
 **/
//@Service("FlightService")//取个别名,测试需要,
@Service
public class FlightServiceImpl implements FlightService {

    @Autowired
    private FlightDao flightDao;

    public List<FlightEntity> findAll() {
        return flightDao.findAll();
    }

    public FlightEntity findById(int id) {
        return flightDao.findById(id);
    }

    public int insertFlight(FlightEntity flightEntity) {
        return flightDao.insertFlight(flightEntity);
    }

    public int updateFligth(FlightEntity flightEntity) {
        return flightDao.updateFligth(flightEntity);
    }

    public int deleteByIdFligth(int id) {
        return flightDao.deleteByIdFligth(id);
    }
  /*  public List<FlightEntity> findAll() {
        System.out.println("查询所有用户。。。");
        return null;
    }*/
}

7、创建FlightController

package com.oyzk.controller;

import com.oyzk.entity.FlightEntity;
import com.oyzk.service.FlightService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.servlet.ModelAndView;

import java.util.ArrayList;
import java.util.List;

/**
 * @author Kingkang
 * @title FlightController
 * @create 2022/12/7
 **/
@Controller
@RequestMapping("/flight")
public class FlightController {

    @RequestMapping("/findAll")
    public String findAll(){
        System.out.println("success");
        return "homePage";
    }

    @Autowired
    private FlightService flightService;

    /**
     * 查询所有信息
     * @param module
     * @return
     */
    @RequestMapping(value = "/getAllFlight", method = RequestMethod.GET)
    public  String getAllFlight(Model module){
        List<FlightEntity> all = flightService.findAll();
        module.addAttribute("infoList",all);
        return "homePage";
    }

    /**
     *@description TODO
     *通过id查询
     *@return org.springframework.web.servlet.ModelAndView
     *@author Kingkang
     *@time 2022/11/27
     */
    @RequestMapping(value = "/getFlightById", method = RequestMethod.GET)
    public ModelAndView getFlightById(int id){
        ModelAndView modelAndView=new ModelAndView();
        FlightEntity flightById = flightService.findById(id);
        List<FlightEntity> flightEntities=new ArrayList<FlightEntity>();
        flightEntities.add(flightById);
        modelAndView.addObject("infoList",flightEntities);
        //跳转信息展示页面
        modelAndView.setViewName("homePage");
        return modelAndView;
    }

    /**
     * 跳转新增页面
     * @return
     */
    @RequestMapping(value = "/saveFlightPage", method = RequestMethod.GET)
    public String saveFlightPage(){
        return "addFlight";
    }
    /**
     * 新增
     * @param flightEntity
     * @return
     */
    @RequestMapping(value = "/saveFlight", method = RequestMethod.POST)
    public String saveFlight(FlightEntity flightEntity){
        flightService.insertFlight(flightEntity);
        return "redirect:/flight/getAllFlight";
    }

    /**
     * 通过id查询数据,在跳转到更新页面
     * @param id
     * @param model
     * @return
     */
    @RequestMapping(value = "/toUpdateFlightPage", method = RequestMethod.GET)
    public String toUpdateFlightPage(int id,Model model){
        FlightEntity flight = flightService.findById(id);
        model.addAttribute("flight",flight);
        return "updateFlight";
    }

    /**
     * 更新
     * @param flightEntity
     * @param model
     * @return
     */
    @RequestMapping(value = "/toUpdateFlight", method = RequestMethod.POST)
    public String toUpdateFlight(FlightEntity flightEntity,Model model){
        int i = flightService.updateFligth(flightEntity);
        if (i>0){
            model.addAttribute("flageMsg","更新成功");
        }else{
            model.addAttribute("flageMsg","更新失败");
        }
        return "redirect:/flight/getAllFlight";
    }

    /**
     * 删除
     * @param
     * @return
     */
    @RequestMapping(value = "/deleteFlight", method = RequestMethod.GET)
    public String deleteFlight(int id){
        flightService.deleteByIdFligth(id);
        return "redirect:/flight/getAllFlight";
    }



}

8、创建homePage.jsp

<%--
  Created by IntelliJ IDEA.
  User: Kingkang
  Date: 2022/12/7
  Time: 17:22
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
    <title>信息展示页面</title>
    <link type="text/css" rel="stylesheet" href="../../css/bootstrap.css">
    <script type="text/javascript" src="../../js/jquery.min.js"></script>
    <script type="text/javascript" src="../../js/bootstrap.min.js"></script>
</head>
<body>
<div class="container">
    <div class="row clearfix">
        <div class="col-md-12 column">
            <div class="page-headr">
                <h1>
                    <small>信息列表 ———————— 显示所有人员信息</small>
                </h1>
                <span style="color:#FAF520 ;font-weight: bold">${flageMsg}</span>
            </div>
        </div>
        <div class="col-md-4 column">
            <a class="btn btn-primary" href="${pageContext.request.contextPath}/flight/saveFlightPage">新增</a>
            <a class="btn btn-primary" href="${pageContext.request.contextPath}/flight/getAllFlight">显示全部信息</a>
        </div>
        <div class="col-md-4"></div>
        <div class="col-md-4">
            <form class="form-inline" action="${pageContext.request.contextPath}/flight/getFlightById" method="get" style="float:right">
                <span style="color:#FAF520 ;font-weight: bold">${error}</span>
                <input type="text" name="id" class="form-control" placeholder="请输入要查询的人员id">
                <input type="submit" value="查询" class="btn btn-primary">
            </form>
        </div>

    </div>

    <div class="row clearfix">
        <div class="col-md-12 column">
            <table class="table table-hover table-striped">
                <thead>
                <tr>
                    <th>id</th>
                    <th>航班号</th>
                    <th>航班公司</th>
                    <th>出发地</th>
                    <th>目的地</th>
                    <th>出发时间</th>
                    <th>到达时间</th>
                    <th>飞机类型</th>
                    <th>是否删除</th>
                    <th>操作</th>
                </tr>
                </thead>

                <%--                        人员从数据库中查询出来--%>
                <tbody>
                <c:forEach items="${infoList}" var="flight">
                    <tr>
                        <td>${flight.id}</td>
                        <td>${flight.flightId}</td>
                        <td>${flight.company}</td>
                        <td>${flight.departureAirport}</td>
                        <td>${flight.arriveAirport}</td>
                        <td>${flight.departureTime}</td>
                        <td>${flight.arriveTime}</td>
                        <td>${flight.model}</td>
                        <td>${flight.isDelete}</td>
                        <td>
                            <a href="${pageContext.request.contextPath}/flight/toUpdateFlightPage?id=${flight.id}">修改</a>
                            &nbsp; ||&nbsp;
                            <a href="${pageContext.request.contextPath}/flight/deleteFlight?id=${flight.id}">刪除</a>
                        </td>
                    </tr>
                </c:forEach>
                </tbody>
            </table>
        </div>
    </div>
</div>
</body>

</html>


9、创建addFlight.jsp

<%--
  Created by IntelliJ IDEA.
  User: Kingkang
  Date: 2022/12/7
  Time: 20:09
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>新增人员信息页面</title>
    <link type="text/css" rel="stylesheet" href="../../css/bootstrap.css">
    <script type="text/javascript" src="../../js/jquery.min.js"></script>
    <script type="text/javascript" src="../../js/bootstrap.min.js"></script>
</head>
<body>
<div class="container">
    <div class="row clearfix">
        <div class="col-md-12 column">
            <div class="page-headr">
                <h1>
                    <samll>新增人员</samll>
                </h1>
            </div>
        </div>
    </div>
    <form action="${pageContext.request.contextPath}/flight/saveFlight" method="post">
        <div class="form-group">
            <table>航班号</table>
            <input type="text" name="flightId" class="form-control"  >
        </div>
        <div class="form-group">
            <table>航班公司</table>
            <input type="text" name="company" class="form-control"  required>
        </div>
        <div class="form-group">
            <table>出发地</table>
            <input type="text" name="departureAirport" class="form-control"  required>
        </div>
        <div class="form-group">
            <table>目的地</table>
            <input type="text" name="arriveAirport" class="form-control" required>
        </div>
        <div class="form-group">
            <table>出发时间</table>
            <input type="date" name="departureTime" class="form-control" required>
        </div>
        <div class="form-group">
            <table>到达时间</table>
            <input type="date" name="arriveTime" class="form-control"  required>
        </div>
        <div class="form-group">
            <table>飞机类型</table>
            <input type="text" name="model" class="form-control" required>
        </div>
        <div class="form-group">
            <table>是否删除</table>
            <input type="text" name="isDelete" class="form-control"  required>
        </div>
        <div class="form-group">
            <input type="submit" class="form-control" value="添加">
        </div>
    </form>


</div>
</body>
</html>

10、updateFlight.jsp

<%--
  Created by IntelliJ IDEA.
  User: Kingkang
  Date: 2022/12/7
  Time: 20:03
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
    <title>修改人员信息页面</title>
    <link type="text/css" rel="stylesheet" href="../../css/bootstrap.css">
    <script type="text/javascript" src="../../js/jquery.min.js"></script>
    <script type="text/javascript" src="../../js/bootstrap.min.js"></script>
</head>
<body>

<div class="container">
    <div class="row clearfix">
        <div class="col-md-12 column">
            <div class="page-headr">
                <h1>
                    <samll>修改人员</samll>
                </h1>
            </div>
        </div>
    </div>
    <form action="${pageContext.request.contextPath}/flight/toUpdateFlight" method="post">

        <input type="hidden" name="id" value="${flight.id}">
        <div class="form-group">
            <table>id</table>
            <input type="text" name="id" class="form-control" value="${flight.id}" disabled>
        </div>
        <div class="form-group">
            <table>航班号</table>
            <input type="text" name="flightId" class="form-control" value="${flight.flightId}"required>
        </div>
        <div class="form-group">
            <table>航班公司</table>
            <input type="text" name="company" class="form-control"  value="${flight.company}" required>
        </div>
        <div class="form-group">
            <table>出发地</table>
            <input type="text" name="departureAirport" class="form-control" value="${flight.departureAirport}" required>
        </div>
        <div class="form-group">
            <table>目的地</table>
            <input type="text" name="arriveAirport" class="form-control" value="${flight.arriveAirport}" required>
        </div>
        <div class="form-group">
            <table>出发时间</table>
            <input type="date" name="departureTime" class="form-control" value="${flight.departureTime}" required>
        </div>
        <div class="form-group">
            <table>到达时间</table>
            <input type="date" name="arriveTime" class="form-control" value="${flight.arriveTime}" required>
        </div>
        <div class="form-group">
            <table>飞机类型</table>
            <input type="text" name="model" class="form-control" value="${flight.model}" required>
        </div>
        <div class="form-group">
            <table>是否删除</table>
            <input type="text" name="isDelete" class="form-control" value="${flight.isDelete}" required>
        </div>
        <div class="form-group">
            <input type="submit" class="form-control" value="修改">
        </div>
    </form>

</div>
</body>
</html>


10、创建index.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>首页</title>

    <style>
        a{
            text-decoration: none;
            color: black;
            font-size: 18px;
        }

        h3{
            width: 180px;
            height: 50px;
            margin: 100px auto;
            text-align: center;
            line-height:50px;
            background:#FAF520;
            border-radius: 5px;
        }
    </style>
</head>
<body>
<h3>
    <a href="${pageContext.request.contextPath}/flight/getAllFlight">进入到人员信息页面</a>
</h3>
</body>
</html>

11、启动测试

项目启动页面在这里插入图片描述