一个SpringMVC+SpringJDBC项目

水深无声 2022-09-15 14:54 174阅读 0赞

# 创建项目 #

![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAXzIzXw_size_20_color_FFFFFF_t_70_g_se_x_16]  
![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAXzIzXw_size_20_color_FFFFFF_t_70_g_se_x_16 1]  
![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAXzIzXw_size_20_color_FFFFFF_t_70_g_se_x_16 2]

# 代码目录 #

![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAXzIzXw_size_20_color_FFFFFF_t_70_g_se_x_16 3]

# 界面代码 #

## 主界面 ##

![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAXzIzXw_size_20_color_FFFFFF_t_70_g_se_x_16 4]

## List界面 ##

![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAXzIzXw_size_20_color_FFFFFF_t_70_g_se_x_16 5]

## 增加页面 ##

![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAXzIzXw_size_20_color_FFFFFF_t_70_g_se_x_16 6]

## 修改页面 ##

![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAXzIzXw_size_20_color_FFFFFF_t_70_g_se_x_16 7]

# Java文件 #

## Book实体类 ##

![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAXzIzXw_size_20_color_FFFFFF_t_70_g_se_x_16 8]

## BookDao工具类 ##

![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAXzIzXw_size_20_color_FFFFFF_t_70_g_se_x_16 9]

## BookController控制类 ##

![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAXzIzXw_size_20_color_FFFFFF_t_70_g_se_x_16 10]

# 其他文件 #

## applicationConText.xml ##

![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAXzIzXw_size_20_color_FFFFFF_t_70_g_se_x_16 11]

<context:component-scan base-package="com.c201901020110.mvc"/>
    
        
        <bean class="org.springframework.jdbc.datasource.DriverManagerDataSource" id="dataSource">
            
            <property name="driverClassName" value="com.mysql.cj.jdbc.Driver"/>
            
            <property name="url" value="jdbc:mysql://localhost:3306/bookstore?useSSL=false&characterEncoding=utf8&serverTimezone=UTC"/>
            
            <property name="username" value="root"></property>
            
            <property name="password" value="root"></property>
        </bean>
        
        <bean id="jdbcTemplate"
              class="org.springframework.jdbc.core.JdbcTemplate">
            
            <property name="dataSource" ref="dataSource"></property>
        </bean>

## web.xml ##

![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAXzIzXw_size_20_color_FFFFFF_t_70_g_se_x_16 12]

<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
             version="3.1">
      <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>/WEB-INF/applicationContext.xml</param-value>
      </context-param>
      <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
      </listener>
    
      <welcome-file-list>
        <welcome-file>index.jsp</welcome-file>
      </welcome-file-list>
      <servlet>
        <servlet-name>springmvc</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <init-param>
          <param-name>contextConfigLocation</param-name>
          <param-value>/WEB-INF/dispatcher-servlet.xml</param-value>
        </init-param>
      </servlet>
      <servlet-mapping>
        <servlet-name>springmvc</servlet-name>
        <url-pattern>/</url-pattern>
      </servlet-mapping>
    </web-app>

## pom.xml ##

<dependency>
          <groupId>javax.servlet</groupId>
          <artifactId>javax.servlet-api</artifactId>
          <version>4.0.1</version>
          <scope>provided</scope>
        </dependency>
        
        <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-core</artifactId>
          <version>5.3.8</version>
        </dependency>
        <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-web</artifactId>
          <version>5.3.8</version>
        </dependency>
    
        <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-webmvc</artifactId>
          <version>5.3.8</version>
        </dependency>
        <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-aop</artifactId>
          <version>5.3.8</version>
        </dependency>
        <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-context-support</artifactId>
          <version>5.2.12.RELEASE</version>
        </dependency>
    
        
        <dependency>
          <groupId>org.slf4j</groupId>
          <artifactId>slf4j-log4j12</artifactId>
          <version>1.8.0-alpha0</version>
          <scope>test</scope>
        </dependency>
    
        
        <dependency>
          <groupId>javax.servlet</groupId>
          <artifactId>javax.servlet-api</artifactId>
          <version>4.0.1</version>
          <scope>provided</scope>
        </dependency>
        <dependency>
          <groupId>javax.servlet.jsp</groupId>
          <artifactId>jsp-api</artifactId>
          <version>2.2</version>
        </dependency>
        <dependency>
          <groupId>javax.servlet</groupId>
          <artifactId>jstl</artifactId>
          <version>1.2</version>
        </dependency>
    
        
        <dependency>
          <groupId>mysql</groupId>
          <artifactId>mysql-connector-java</artifactId>
          <version>8.0.20</version>
        </dependency>
        <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-jdbc</artifactId>
          <version>5.3.8</version>
        </dependency>
        <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-tx</artifactId>
          <version>5.3.8</version>
        </dependency>
    
        <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-aop</artifactId>
          <version>5.3.8</version>
        </dependency>

[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAXzIzXw_size_20_color_FFFFFF_t_70_g_se_x_16]: /images/20220828/56e62ef0ddd14ffba97209573f0fac06.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAXzIzXw_size_20_color_FFFFFF_t_70_g_se_x_16 1]: /images/20220828/d378a0075acc40ffa1d4d984f7617bdb.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAXzIzXw_size_20_color_FFFFFF_t_70_g_se_x_16 2]: /images/20220828/21c456adc10949d587f51c9d895ebac6.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAXzIzXw_size_20_color_FFFFFF_t_70_g_se_x_16 3]: /images/20220828/eb2a326fcfb146fe850a446c56b6a7f8.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAXzIzXw_size_20_color_FFFFFF_t_70_g_se_x_16 4]: /images/20220828/deb2deb498464e03930b7d803c541287.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAXzIzXw_size_20_color_FFFFFF_t_70_g_se_x_16 5]: /images/20220828/07a845147efd409a990ded70da443042.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAXzIzXw_size_20_color_FFFFFF_t_70_g_se_x_16 6]: /images/20220828/a6bfbb5512a94e148f1b75b96cb2b4d4.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAXzIzXw_size_20_color_FFFFFF_t_70_g_se_x_16 7]: /images/20220828/9cb6ee04c5864cd9ace2c4eb20b33fb5.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAXzIzXw_size_20_color_FFFFFF_t_70_g_se_x_16 8]: /images/20220828/bbd2303fb5754434a88da9663470bce7.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAXzIzXw_size_20_color_FFFFFF_t_70_g_se_x_16 9]: /images/20220828/711d34211b7a4224ba63162525868742.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAXzIzXw_size_20_color_FFFFFF_t_70_g_se_x_16 10]: /images/20220828/7d45e28e98db4a70a5854275809b8a63.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAXzIzXw_size_20_color_FFFFFF_t_70_g_se_x_16 11]: /images/20220828/acb7c65efef340cf905ba3abcc7994db.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAXzIzXw_size_20_color_FFFFFF_t_70_g_se_x_16 12]: /images/20220828/d92aca5e46644d85876040ee1acce1ad.png