2022年5月20号博客内容操作(方案五利用:对数据的IDUS）Spring框架利用注解的方式操作数据库的增删改查.

package Com.Book.Dao;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;
import java.util.Map;


public interface ITeacherDao {
    //查询老师的数量
    @Select(" select count(*) from teacher")
    int getTeacher();

    //查询编号为10的老师的姓名
    @Select("select teacherName from teacher where id=#{id}")
    String getteacherNameId(@Param("id") int id);

    //查询所有的书籍信息
    @Select(" select * from teacher")
    List> getTeacherAll();

    //查询教师名称为  风花雪夜 和 身份证号为 36042920001009098 teacherName teacherId  转入的两个参数
    @Select(" select teacherNumber,teacherName,teacherId    from teacher where teacherName=#{teacherName } and teacherAge=#{teacherAge}")
    Map getTeacherinfo(@Param("teacherName") String teacherName, @Param("teacherAge") int teacherAge);

    //查询指定名称的所有属性，除了名称外的  teacherNumber  teacherAge  teacherSex  teacherId   teacherClass   teacherPhone
    @Select("select teacherNumber,teacherAge ,teacherSex ,teacherId,teacherClass, teacherPhone from teacher where teacherName=#{teacherName}")
    Map getTeacher2(@Param("teacherName") String teacherName);

    //限制查询的语句
    @Select("select * from teacher limit #{start},#{count}")
    List> getTeacherLimit(@Param("start") int start, @Param("count") int count);

    //增加一条老师的数据信息内容如何增加呢？先看数据库时如何增加的呢？

    
    @Insert("INSERT INTO `test`.`teacher`" +
            "(`teacherNumber`, `teacherName`, `teacherAge`, `teacherSex`, `teacherId`, `teacherClass`," +
            " `teacherPhone`, `teacherAddress`)" +
            "value (#{teacherNumber},#{teacherName},#{teacherAge},#{teacherSex},#{teacherId},#{teacherClass}," +
            "#{teacherPhone},#{teacherAddress})")
    int addTeacher(Map map);

    
    

}

package Com.Book.Test;

import Com.Book.Dao.ITeacherDao;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Test;


import java.io.IOException;
import java.io.InputStream;
import java.util.HashMap;
import java.util.List;
import java.util.Map;



public class TwoTest {
    public SqlSession ss = null;
    public ITeacherDao dao = null;

    public void init() {
        try {
            InputStream is = Resources.getResourceAsStream("mybatis-config.xml");
            ss = new SqlSessionFactoryBuilder().build(is).openSession();
            dao = ss.getMapper(ITeacherDao.class);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    @Test
    public void getTeacherNum() {
        init();
        int count = dao.getTeacher();
        System.out.println("查询到老师的数量为" + count + "位");
    }


    @Test
    public void getteacherNameId() {
        init();
        String teacherName=dao.getteacherNameId(6);
        System.out.println("查询到老师的名称为"+teacherName);
    }

    @Test
    public  void  getTeacherAll(){
        init();
        List> teachers=dao.getTeacherAll();
        teachers.forEach(map -> System.out.println(map));
    }


    @Test
    public  void getTeacherinfo(){
        init();
        Map map=dao.getTeacherinfo("王一飞",45);
        System.out.println(map);
    }

    @Test
    public  void getTeacher2(){
        init();
        Map map=dao.getTeacher2("只想一辈子");
        System.out.println(map);
    }

    @Test
    public void getTeacherLimit(){
        init();
        List> maps=dao.getTeacherLimit(1,4);
        System.out.println("测试数据一");
        maps.forEach(map -> System.out.println(map));
    }

    @Test
    public void getTeacherLimit1(){
        init();
        List> maps=dao.getTeacherLimit(6,10);
        System.out.println("测试数据二");
        maps.forEach(map -> System.out.println(map));
    }


    
    @Test
    public void addTeacher() {
        init();
        Map map = new HashMap<>();
        map.put("teacherNumber", "BiLL_2022034013");
        map.put("teacherName", "项目");
        map.put("teacherAge", 23);
        map.put("teacherSex", "女");
        map.put("teacherId", "345789200310980987");
        map.put("teacherClass", "24级软件三班");
        map.put("teacherPhone", "12345678976");
        map.put("teacherAddress", "上饶市区中心");
        ss.commit();
        int i=dao.addTeacher(map);
        if(i>0){
            System.out.println("恭喜用户成功增加一条用户的数据信息");
        }
    }
    
    }