javaweb第五次课后作业

使用mybatis操作数据库

1.创建springboot工程

数据库表user

实体类pojo.User

public class User {
    private Integer id;
    private String name;
    private Short age;
    private Short gender;
    private String phone;

public User(){

}
    public User(Integer id, String name, Short age, Short gender, String phone) {
        this.id = id;
        this.name = name;
        this.age = age;
        this.gender = gender;
        this.phone = phone;
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Short getAge() {
        return age;
    }

    public void setAge(Short age) {
        this.age = age;
    }

    public Short getGender() {
        return gender;
    }

    public void setGender(Short gender) {
        this.gender = gender;
    }

    public String getPhone() {
        return phone;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", age=" + age +
                ", gender=" + gender +
                ", phone='" + phone + '\'' +
                '}';
    }

    public void setPhone(String phone) {
        this.phone = phone;
    }
}

2.引入mybatis相关依赖

即pom文件

<?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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <groupId>com.itheima</groupId>
    <artifactId>springboot-mybatis-quickstart</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>springboot-mybatis-quickstart</name>
    <description>springboot-mybatis-quickstart</description>
    <properties>
        <java.version>11</java.version>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
        <spring-boot.version>2.6.13</spring-boot.version>
    </properties>
    <dependencies>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.2.2</version>
        </dependency>

        <dependency>
            <groupId>com.mysql</groupId>
            <artifactId>mysql-connector-j</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>
    <dependencyManagement>
        <dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-dependencies</artifactId>
                <version>${spring-boot.version}</version>
                <type>pom</type>
                <scope>import</scope>
            </dependency>
        </dependencies>
    </dependencyManagement>

    <build>
        <plugins>
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-compiler-plugin</artifactId>
                <version>3.8.1</version>
                <configuration>
                    <source>11</source>
                    <target>11</target>
                    <encoding>UTF-8</encoding>
                </configuration>
            </plugin>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
                <version>${spring-boot.version}</version>
                <configuration>
                    <mainClass>com.itheima.SpringbootMybatisQuickstartApplication</mainClass>
                    <skip>true</skip>
                </configuration>
                <executions>
                    <execution>
                        <id>repackage</id>
                        <goals>
                            <goal>repackage</goal>
                        </goals>
                    </execution>
                </executions>
            </plugin>
        </plugins>
    </build>

</project>

3.编写sql语句

Mapper接口

package com.itheima.mapper;

import com.itheima.pojo.User;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper//在运行时，会自动生成该接口的实现类对象（代理对象），并且将该对象交给ioc容器管理
public interface UserMapper {
    //查询全部用户信息
    @Select("select * from user")
    public List<User> list();

applicationtests

运行结果

作业

1.配置数据源

2.查询修改删除插入操作

userMapper中

更新插入操作

tests中

结果

删除查找操作

        mapper

       tests

3.采用lombok 

用注解生成方法

4.对poem列表进行mybatis操作

创建表格

CREATE TABLE poem(
                     id int unsigned PRIMARY KEY AUTO_INCREMENT COMMENT '编号',
                     name varchar(100) COMMENT '姓名',
                     gender tinyint unsigned COMMENT '性别, 1:男, 2:女',
                     dynasty varchar(100) COMMENT '朝代',
                     title varchar(100) COMMENT '头衔',
                     style varchar(100) COMMENT '风格'
) COMMENT '诗人信息表';

INSERT INTO poem(id, name, gender, dynasty, title, style) VALUES (null,'陶渊明','1','东晋末至南朝宋初期','诗人和辞赋家','古今隐逸诗人之宗');
INSERT INTO poem(id, name, gender, dynasty, title, style) VALUES (null,'王维','1','唐代','诗佛','空灵，寂静');
INSERT INTO poem(id, name, gender, dynasty, title, style) VALUES (null, '李白','1','唐代','诗仙','豪放飘逸的诗风和丰富的想象力');
INSERT INTO poem(id, name, gender, dynasty, title, style) VALUES (null,'李商隐','1','唐代','诗坛鬼才','无');
INSERT INTO poem(id, name, gender, dynasty, title, style) VALUES (null,'李清照','2','宋代','女词人','婉约风');
INSERT INTO poem(id, name, gender, dynasty, title, style) VALUES (null,'杜甫','1','唐代','诗圣','反映社会现实和人民疾苦');
INSERT INTO poem(id, name, gender, dynasty, title, style) VALUES (null,'苏轼','1','北宋','诗神，文学家，书画家','清新豪健，独具表现力');

pojo Poem

PoemMapper

查询 插入操作

test

结果