创建项目使用SpringJdbc实现增删改查的步骤
? ? ? ?由学生数据库studb为例:
一.创建数据库
DROP DATABASE IF EXISTS studb; CREATE DATABASE studb; USE studb; CREATE TABLE student ( ??id INT PRIMARY KEY, ??NAME VARCHAR(50) NOT NULL, ??gender VARCHAR(10) NOT NULL, ??age INT, ??classes VARCHAR(50) ); INSERT INTO student (id, NAME, gender, age, classes) VALUES ??(1, '张三', '男', 20, '高中一班'), ??(2, '李四', '男', 19, '高中二班'), ??(3, '王五', '女', 18, '高中一班'), ??(4, '赵六', '女', 20, '高中三班'), ??(5, '刘七', '男', 19, '高中二班'), ??(6, '陈八', '女', 18, '高中一班'), ??(7, '杨九', '男', 20, '高中三班'), ??(8, '吴十', '男', 19, '高中二班'); |
二.创建javaSE的maven项目,搭建Spring框架的环境
? ? ? ? 1.引入spring-jdbc相关的坐标以及核心坐标
<dependencies> ????????<dependency>????????<groupId>org.springframeworkgroupId>????????<artifactId>spring-contextartifactId>????????<version>6.0.6version>????dependency> ????????<dependency>????????<groupId>jakarta.annotationgroupId>????????<artifactId>jakarta.annotation-apiartifactId>????????<version>2.1.1version>????dependency> ????????<dependency>????????<groupId>org.projectlombokgroupId>????????<artifactId>lombokartifactId>????????<version>1.18.26version>????dependency> ????????<dependency>????????<groupId>org.springframeworkgroupId>????????<artifactId>spring-jdbcartifactId>????????<version>6.0.6version>????dependency> ????????<dependency>????????<groupId>mysqlgroupId>????????<artifactId>mysql-connector-javaartifactId>????????<version>8.0.25version>????dependency> ????????<dependency>????????<groupId>com.alibabagroupId>????????<artifactId>druidartifactId>????????<version>1.2.8version>????dependency> ????????<dependency>????????<groupId>org.junit.jupitergroupId>????????<artifactId>junit-jupiter-apiartifactId>????????<version>5.3.1version>????????<scope>testscope>????dependency> ????????<dependency> ???????<groupId>org.springframeworkgroupId> ???????<artifactId>spring-testartifactId> ???????<version>6.0.6version> ????dependency> ????????<dependency>????????<groupId>ch.qos.logbackgroupId>????????<artifactId>logback-classic |