第5次课后作业《web应用技术》

最新推荐文章于 2024-07-11 16:46:08 发布

影Nothing

最新推荐文章于 2024-07-11 16:46:08 发布

阅读量395

点赞数 3

文章标签： spring boot 后端 java

本文链接：https://blog.csdn.net/qq_74105106/article/details/138451389

版权

1、在idea中配置好数据源

准备工作（创建springboot工程、数据库表user、实体类user）

创建springboot工程

数据库表user

实体类user

配置连接信息

入门程序测试

2、视频案例中只给出了查询所有结果的示例，请自己完成添加、删除、修改操作的代码。以下供参考。

连接池

1.查询全部用户信息

Mapper接口

package com.itheiying.mapper;


import com.itheiying.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();
}

测试类

package com.itheiying;

import com.itheiying.mapper.UserMapper;
import com.itheiying.pojo.User;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

import java.util.List;

@SpringBootTest//springboot整合单元测试的注解
class SpringBootMybatisQuickstartApplicationTests {

    @Autowired//依赖注入
    private UserMapper userMapper;

    @Test
    public void testListUser(){
        List<User> userList=userMapper.list();
        userList.stream().forEach(user -> {
            System.out.println(user);
        });
    }

}

2.添加用户信息

//2.添加用户信息
    @Insert("insert into user(name, age, gender, phone) values (#{name}, #{age}, #{gender}, #{phone})")
    public void insert(User user);

//2.添加用户信息
    @Test
    public void insert() {
        User c = new User();
        c.setName("李赫宰");
        c.setGender((short)1);
        c.setAge((short)38);
        c.setPhone("12343234543");
        userMapper.insert(c);
        testListUser();
    }

3.删除用户信息

   //3.删除用户信息
    @Delete("delete from user where id= #{id} ")
    public void delete(int id);

//3.删除用户信息
    @Test
    public void delete() {
        userMapper.delete(7);
        testListUser();
    }

4.用id查询一条用户信息

//4.用id查询一条用户信息
    @Select("select * from user where id= #{id} ")
    public User get(int id);

//4.查询其中一条用户信息
    @Test
    public void get() {
        User c= userMapper.get(9);
        System.out.print(c.getId()+",");
        System.out.print(c.getName()+",");
        System.out.print(c.getAge()+",");
        System.out.print(c.getGender()+",");
        System.out.println(c.getPhone());
    }

5.更改信息

//5.修改
    @Update("update user set name=#{name} where id=#{id} ")
      public int update(User user);

 //5.修改
    @Test
    public void update() {
        User c = userMapper.get(2);
        c.setName("hezai");
        userMapper.update(c);
        testListUser();
    }

UserMapper接口

package com.itheiying.mapper;


import com.itheiying.pojo.User;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper //在运行时，会自动生成该接口的实现类对象（代理对象），并将该对象交给IOC容器
public interface UserMapper {

    //1.查询全部用户信息
    @Select("select * from user")
    public List<User> list();

    //2.添加用户信息
    @Insert("insert into user(name, age, gender, phone) values (#{name}, #{age}, #{gender}, #{phone})")
    public void insert(User user);

    //3.删除用户信息
    @Delete("delete from user where id= #{id} ")
    public void delete(int id);

    //4.用id查询一条用户信息
    @Select("select * from user where id= #{id} ")
    public User get(int id);

    //5.修改
    @Update("update user set name=#{name} where id=#{id} ")
      public int update(User user);

}

Test类

package com.itheiying;

import com.itheiying.mapper.UserMapper;
import com.itheiying.pojo.User;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

import java.util.List;

@SpringBootTest//springboot整合单元测试的注解
class SpringBootMybatisQuickstartApplicationTests {

    @Autowired//依赖注入
    private UserMapper userMapper;

    //1.查询全部用户信息
    @Test
    public void testListUser(){
        List<User> userList=userMapper.list();
        userList.stream().forEach(user -> {
            System.out.println(user);
        });
    }

    //2.添加用户信息
    @Test
    public void insert() {
        User c = new User();
        c.setName("李东海");
        c.setGender((short)1);
        c.setAge((short)37);
        c.setPhone("1232393834");
        userMapper.insert(c);
        testListUser();
    }

    //3.删除用户信息
    @Test
    public void delete() {
        userMapper.delete(8);
        testListUser();
    }
    //4.查询其中一条用户信息
    @Test
    public void get() {
        User c= userMapper.get(9);
        System.out.print(c.getId()+",");
        System.out.print(c.getName()+",");
        System.out.print(c.getAge()+",");
        System.out.print(c.getGender()+",");
        System.out.println(c.getPhone());
    }

    //5.修改
    @Test
    public void update() {
        User c = userMapper.get(2);
        c.setName("hezai");
        userMapper.update(c);
        testListUser();
    }
}

3、idea的sql 控制台，可以测试sql语句是否正确。所以mapper接口中的sql语句可以先测试。对于有参数的情况，用？代替。

4、lombok库的使用。尝试将实体类采用注解的方式来实现。

lombok

依赖

 <!--lombok-->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>

user类

/*@Getter
@Setter
@ToString
@EqualsAndHashCode*/

@Data
@NoArgsConstructor//无参构造
@AllArgsConstructor//全参构造
public class User {

    private Integer id;
    private String name;
    private Short age;
    private Short gender;
    private String phone;

5、学习idea的调试技巧，并尝试使用。

Debug步骤：

1.添加断点

2.启动调试

3.单步执行

4.观察变量和执行流程，并找出问题

6、对以下案例使用mybatis进行添加、删除、修改、更新的操作。（不需要实现页面，test中控制台能输出结果就行。）

准备工作

use db01;
create table Poet
(
    id      int unsigned primary key auto_increment comment '主键ID',
    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 Poet (id, name,gender,dynasty,title,style) values(null,'陶渊明','1','东晋末至南朝宋初期','诗人和辞赋家','古今隐逸诗人之宗');
insert into Poet (id, name,gender,dynasty,title,style) values(null,'王维','1','唐代','诗佛','空灵、寂静');
insert into poet(id, name, gender, dynasty, title,style) VALUES (null,'李白','1','唐代','诗仙','豪放飘逸的诗风和丰富的想象力');
insert into poet(id, name, gender, dynasty, title,style) VALUES (null,'李商隐','2','唐代','诗坛鬼才','无');
insert into poet(id, name, gender, dynasty, title,style) VALUES (null,'李清照','2','宋代','女词人','婉约风格');
insert into poet(id, name, gender, dynasty, title,style) VALUES (null,'杜甫','1','唐代','诗圣','反映社会现实和人民疾苦');
insert into poet(id, name, gender, dynasty, title,style) VALUES (null,'苏轼','1','北宋','文学家、书画家，诗神','清新豪健的诗风和独特的艺术表现力');

1.查询全部用户信息

运行结果

2.添加诗人信息

3.删除诗人信息

4.修改诗人信息

Poet.java

package com.itheiying.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

@NoArgsConstructor
@AllArgsConstructor
@Data
public class Poet {
    private Integer id;
    private String name;
    private String gender;
    private String dynasty;
    private String title;
    private String style;


}

PoetMapper

package com.itheiying.mapper;

import com.itheiying.pojo.Poet;
import com.itheiying.pojo.User;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface PoetMapper {
    //1.查询全部诗人信息
    @Select("select * from poet")
    public List<Poet> list();

    //2.添加诗人信息
    @Insert("insert into poet(name,gender,dynasty, title,style) values (#{name},#{gender},#{dynasty},#{title},#{style})")
    public void insertwriter(Poet poet);

    //3.删除诗人信息
    @Delete("delete from Poet where id= #{id} ")
    public void deletewriter(int id);

    //4.修改诗人信息
    @Update("update Poet set name=#{name} ,gender=#{gender} where id=#{id} ")
    public int update(Poet poet);
}

Test

package com.itheiying;

import com.itheiying.mapper.PoetMapper;
import com.itheiying.pojo.Poet;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

import java.util.List;

@SpringBootTest//springboot整合单元测试的注解
class SpringBootMybatisQuickstartApplicationTests{
    @Autowired
    private PoetMapper poetMapper;

    //1.查询全部诗人信息
    @Test
    public void testListPoet() {
        List<Poet> poetList = poetMapper.list();
        poetList.stream().forEach(poet -> {
            System.out.println(poet);
        });
    }
    //2.添加诗人信息
    @Test
    public void insertwriter(){
        Poet writer=new Poet();
        writer.setName("高适");
        writer.setGender("1");
        writer.setDynasty("唐代");
        writer.setTitle("高岑");
        writer.setStyle("边塞风光");
        poetMapper.insertwriter(writer);
        testListPoet();
    }

    //3.删除诗人信息
    @Test
    public void delete() {
        poetMapper.deletewriter(3);
        testListPoet();
    }

    //4.修改诗人信息
    @Test
    public void update() {
        Poet c = poetMapper.list().get(2);
        c.setName("李煜");
        c.setGender("2");
        poetMapper.update(c);
        testListPoet();
    }
}