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

1、在idea中配置好数据源

2、入门程序

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

查看

 

 插入

查询 

删除

 

package edu.wust;

import edu.wust.mapper.PoetMapper;
import edu.wust.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;
@Test
public void testListPoet(){
    List<Poet> poetList = poetMapper.list();
    poetList.stream().forEach(poet -> {
        System.out.println(poet);
    });
}

    @Test
    public void testDelete(){
       poetMapper.delete(8);
        testListPoet();
    }
    @Test
    public void testInsert(){
    poetMapper.insert();
    testListPoet();
    }

/*@Test
    public void testUpdate(){
    poetMapper.update(1,4);
    testListPoet();
}*/
@Test
    public void testSelect(){
    Poet poet=poetMapper.getById(1);
    System.out.println(poet);
}


}

package edu.wust.mapper;

import edu.wust.pojo.Poet;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.*;
import java.security.PublicKey;
import java.util.List;

@Mapper
public interface PoetMapper {
    @Select("select * from poet")
    public List<Poet> list();
    //删除数据
    @Delete("delete from poet where id=#{id}" )
    public  void delete(Integer id);
//新增
    @Insert("insert into poet( name, gender, dynasty, title, style)\n" +
            "value ('苏轼',1,'北宋','文学家，书画家，诗神','清新豪健的诗风和独特的艺术表现力')")
    public void insert();

    /*//更新
    @Update("update poet set gender=#{gender} where id=#{id}")
    public void update(Integer gender,Integer id);
*/
    //查询
    @Select("select * from poet where id= #{id}" )
    public Poet getById(Integer id);
}