Spring04

创建项目使用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

上一篇:6700k带核显吗(I7 4790k和I7 6700k哪个好,差距在哪里)
下一篇:z82次列车时刻表(请问从广州到浙江义乌的车票多钱`有没有直达的车次)