Web应用技术第五次作业

---

一、在idea中配置好数据源

新建数据表、数据库，在idea中配置好数据源，实现与数据库的连接

二、完成添加、删除、修改操作的代码

增加

    @Insert("insert into user(name, age, gender, phone) value (#{name},#{age},#{gender},#{phone})")
    public void insert(User user);

删除

    @Delete("delete from user where id = #{id}")
    public void deleteById(int id);

修改

   @Update("update user set name=#{name},gender=#{gender},age=#{age},phone=#{phone} where id=#{id}")
    public void updateById(User user);

三、lombok库的使用

引入lombok依赖

import lombok.*;
 
 
@NoArgsConstructor
@AllArgsConstructor
@Data
public class User {
    private Integer id;
    private String name;
    private short age;
    private short gender;
    private String phone;
 
}

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

添加断点，单步执行，使用debug解决问题

五、对poet案例使用mybatis进行添加、删除、修改、更新的操作

新建poet表格，输入信息

package com.liuxiaocan.springbootmybatis.data;
 
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
 
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Poet {
    private short id;
    private String name;
    private String gender;
    private String dynasty;
    private String title;
    private String style;
}

编写PoetMapper接口，使用sql语句查询poet数据表信息

@Mapper
public interface PoetMapper {
@Select("select * from poet")
    public List<Poet> selectall();
 
}

@SpringBootTest
class SpringbootMybatisApplicationTests {
    @Autowired
    PoetMapper poetMapper;
    @Test
    public void test1(){
        List<Poet> poets=poetMapper.selectall();
        for (Poet poet:poets
             ) {
            System.out.println(poet);
        }
    }
}

添加

@Insert("insert into poet values(#{id},#{name},#{gender},#{dynasty},#{title},#{style})")
    public void insert(Poet poet);

@Test
    public void test2(){
        Poet poet=new Poet((short) 8,"陆游","男","宋代","小李白","语言平易晓畅章法整饬谨严");
        poetMapper.insert(poet);
        test1();

删除

@Delete("delete from poet where name=#{name}")
    public void delete(String name);

 @Test
    public void test5(){
        poetMapper.delete("陆游");
        test1();
    }

修改

@Update("update poet set gender=#{gender} where id=#{id}")
    public void update(String gender,short id);

 @Test
    public void test4(){
        poetMapper.update("男",(short) 4);
        test1();
    }