【Java】jdbctemplate实现增删改查maven项目（个人梳理）

最新推荐文章于 2021-09-16 09:01:27 发布

博桑根本提不起劲

最新推荐文章于 2021-09-16 09:01:27 发布

阅读量577

点赞数 1

CC 4.0 BY-SA版权

分类专栏：互联网之路的开启文章标签： java jdbc spring javascript maven

本文刊载的所有内容，均由个人在工作学习中整理用于个人的工作或学习的复习之用，为原创文章本文章不得用于各种商业用途不得侵犯本文及相关权利人的合法权利。使用本文章进行转载或刊登以及其他涉及文章著作版权时，必须经过此csdn博客博主账号人lsb543284593同意，违者必究

本文链接：https://blog.youkuaiyun.com/lsb543284593/article/details/112506792

本文档详细介绍了如何在不使用MyBatis框架的情况下，利用jdbctemplate在Maven项目中实现增删改查操作。首先，展示了项目的整体结构，并逐步讲解了配置SpringMVC的步骤，包括数据源连接、spring-config.xml和spring-servlet.xml的配置。接着，介绍了创建后端CRUD逻辑的过程，从持久化对象（PO）到DAO接口及其实现，再到Service业务层和Controller控制层。此外，还提到了前端页面的创建和web.xml的配置，以及测试和JS文件的添加。文章末尾强调了内容的原创性和版权声明。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

@T jdbctemplate实现增删改查maven项目OC

jdbctemplate实现增删改查maven项目

由于项目不使用mybatis框架的局限性，我整理了这篇个人文档用于工作中的复习使用，如果对你也有帮助请点赞评论收藏，你的支持是我的动力

先附整体结构图

这是整体的结构图结构是由spring+springMVC+jdbctemplate+maven构成前端运用的jsp页面

第一步添加依赖环境（全部可挑选）

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">

  <modelVersion>4.0.0</modelVersion>

  <groupId>换成你自己的</groupId>
  <artifactId>换成你自己的</artifactId>
  <packaging>war</packaging>
  <version>1.0-SNAPSHOT</version>

  <name>training</name>

  <properties>
      <java.version>1.8</java.version>
      <maven.compiler.version>3.1</maven.compiler.version>
      <maven.surefire.version>2.19</maven.surefire.version>
      <junit.version>4.12</junit.version>
      <servelet.api.version>3.1.0</servelet.api.version>
      <spring.version>4.2.3.RELEASE</spring.version>
      <google.guava.version>22.0</google.guava.version>
      <jstl.version>1.2</jstl.version>
      <slf4j.version>1.7.25</slf4j.version>
      <commons.lang3.version>3.4</commons.lang3.version>
      <jackson.version>2.12.0</jackson.version>
      <commons.dbcp2.version>2.1.1</commons.dbcp2.version>
      <mysql.version>5.1.37</mysql.version>
      <jedis.version>2.9.0</jedis.version>
      <commons.codec.version>1.10</commons.codec.version>
      <httpclient.version>4.5.2</httpclient.version>
      <jsoup.version>1.8.3</jsoup.version>
  </properties>

  <dependencies>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>${junit.version}</version>
      <scope>test</scope>
    </dependency>
      <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-test</artifactId>
          <version>4.2.3.RELEASE</version>
          <scope>test</scope>
      </dependency>
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>javax.servlet-api</artifactId>
      <version>${servelet.api.version}</version>
      <scope>provided</scope>
    </dependency>
    <dependency>
        <groupId>com.google.guava</groupId>
        <artifactId>guava</artifactId>
        <version>${google.guava.version}</version>
    </dependency>
    <!-- spring -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-jdbc</artifactId>
      <version>${spring.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-context</artifactId>
      <version>${spring.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-webmvc</artifactId>
      <version>${spring.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-aop</artifactId>
      <version>${spring.version}</version>
    </dependency>
    <dependency>
      <groupId>org.aspectj</groupId>
      <artifactId>aspectjweaver</artifactId>
      <version>1.8.7</version>
    </dependency>
    <!-- logging -->
    <dependency>
      <groupId>org.slf4j</groupId>
      <artifactId>slf4j-log4j12</artifactId>
      <version>${slf4j.version}</version>
    </dependency>
    <dependency>
      <groupId>org.apache.commons</groupId>
      <artifactId>commons-lang3</artifactId>
      <version>${commons.lang3.version}</version>
    </dependency>
    <dependency>
      <groupId>com.fasterxml.jackson.core</groupId>
      <artifactId>jackson-core</artifactId>
      <version>${jackson.version}</version>
    </dependency>
    <dependency>
      <groupId>com.fasterxml.jackson.core</groupId>
      <artifactId>jackson-annotations</artifactId>
      <version>${jackson.version}</version>
    </dependency>
    <dependency>
      <groupId>com.fasterxml.jackson.core</groupId>
      <artifactId>jackson-databind</artifactId>
      <version>${jackson.version}</version>
    </dependency>
    <!--web dependency-->
    <dependency>
      <groupId>jstl</groupId>
      <artifactId>jstl</artifactId>
      <version>${jstl.version}</version>
    </dependency>

      <dependency>
          <groupId>org.apache.commons</groupId>
          <artifactId>commons-dbcp2</artifactId>
          <version>${commons.dbcp2.version}</version>
      </dependency>

      <!--mysql-->
      <dependency>
          <groupId>mysql</groupId>
          <artifactId>mysql-connector-java</artifactId>
          <version>${mysql.version}</version>
      </dependency>

      <dependency>
          <groupId>redis.clients</groupId>
          <artifactId>jedis</artifactId>
          <version>${jedis.version}</version>
      </dependency>

      <dependency>
          <groupId>commons-codec</groupId>
          <artifactId>commons-codec</artifactId>
          <version>${commons.codec.version}</version>
      </dependency>
      <dependency>
          <groupId>org.apache.httpcomponents</groupId>
          <artifactId>httpclient</artifactId>
          <version>${httpclient.version}</version>
      </dependency>
      <dependency>
          <groupId>org.jsoup</groupId>
          <artifactId>jsoup</artifactId>
          <version>${jsoup.version}</version>
      </dependency>

  </dependencies>

  <build>
      <finalName>换成你自己的</finalName>
      <plugins>
          <plugin>
              <groupId>org.apache.maven.plugins</groupId>
              <artifactId>maven-compiler-plugin</artifactId>
              <version>${maven.compiler.version}</version>
              <configuration>
                  <source>${java.version}</source>
                  <target>${java.version}</target>
                  <encoding>${file.encoding}</encoding>
              </configuration>
          </plugin>
          <plugin>
              <groupId>org.apache.maven.plugins</groupId>
              <artifactId>maven-surefire-plugin</artifactId>
              <version>${maven.surefire.version}</version>
              <configuration>
                  <skipTests>true</skipTests>
              </configuration>
          </plugin>
      </plugins>
  </build>

</project>

<?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:util="http://www.springframework.org/schema/util"
	   xsi:schemaLocation="http://www.springframework.org/schema/beans
                        http://www.springframework.org/schema/beans/spring-beans-4.0.xsd http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util.xsd">
                        <!--	//添加的数据库-->
	<bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource"
		  destroy-method="close">
		<property name="driverClassName" value="com.mysql.jdbc.Driver" />
		<property name="url" value="jdbc:mysql://192.168.1.201:3306/practice?useUnicode=true&amp;characterEncoding=utf-8&amp;autoReconnect=true&amp;rewriteBatchedStatements=true" />
		<property name="username" value="换成你自己的" />
		<property name="password" value="换成你自己的" />
	</bean>
	<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
		<property name="dataSource" ref="dataSource"/>
	</bean>
	</beans>

上面的代码是连接上我们的数据源（要把数据库信息账号密码改成自己的）

配置springMVC 分两个文件（位置看上面结构图）

spring-config.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:task="http://www.springframework.org/schema/task" xmlns:aop="http://www.springframework.org/schema/aop"
	   xsi:schemaLocation="http://www.springframework.org/schema/beans
                        http://www.springframework.org/schema/beans/spring-beans-4.0.xsd  
                        http://www.springframework.org/schema/context
                        http://www.springframework.org/schema/context/spring-context-4.0.xsd http://www.springframework.org/schema/task http://www.springframework.org/schema/task/spring-task.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">

	<!-- 扫描注解 -->
	<context:component-scan base-package="你自己的包名">
		<context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller" />
	</context:component-scan>
	<aop:aspectj-autoproxy/>

	<!-- 支持sync方法-->
	<task:annotation-driven />

	<!-- 引入SPRING配置文件 -->
	<import resource="spring/*.xml"/>
</beans>

下面是另外一个springMVC文件配置
spring-servlet.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:mvc="http://www.springframework.org/schema/mvc"
       xmlns:aop="http://www.springframework.org/schema/aop"
	   xsi:schemaLocation="http://www.springframework.org/schema/beans
                        http://www.springframework.org/schema/beans/spring-beans-4.2.xsd  
                        http://www.springframework.org/schema/context  
                        http://www.springframework.org/schema/context/spring-context-4.2.xsd  
                        http://www.springframework.org/schema/mvc  
                        http://www.springframework.org/schema/mvc/spring-mvc-4.2.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">

	<!-- 自动扫描该包，使SpringMVC认为包下用了@controller注解的类是控制器 -->
	<context:component-scan base-package="改成你自己的包名.*" />     <!-- 注意包名后面的符号不要删除 -->
	<mvc:annotation-driven />
	<aop:aspectj-autoproxy/>

	<!-- 视图解析 -->
	<mvc:view-resolvers>
	    <mvc:jsp cache-views="false" prefix="/WEB-INF/jsp/" suffix=".jsp" />  
	</mvc:view-resol