Mybatis 杂项

Clob：长文本 Blob：二进制文件（图片等）

物理分页：

 @Test
    public void select() throws Exception{
        Logger logger=Logger.getLogger(test.class);
        SqlSession session=MybatisUtils.openSqlSession();
        HashMap<String, Object> map=new HashMap();
        map.put("start", 0);
        map.put("stop", 3);
        StudentMapper studentMapper = session.getMapper(StudentMapper.class);
        List<Student> studentList =  studentMapper.select(map);
        logger.info("添加成功");
        System.out.println(studentList);
        session.commit();
    }

添加照片类型的：

public void add() throws Exception{
        Logger logger=Logger.getLogger(test.class);
        SqlSession session=MybatisUtils.openSqlSession();
        StudentMapper studentMapper = session.getMapper(StudentMapper.class);
        
        byte[] pic=null;
        File file= new File("d:keji.jpg");
        InputStream is=new FileInputStream(file);
        pic=new byte[is.available()];
        is.read(pic);
        is.close();
        
     
        int result=  studentMapper.add(new Student( "cai1", "123",pic));
        if(result==1) logger.info("添加成功");
        session.commit();
    }

读取：

 public void findById() throws Exception{
        Logger logger=Logger.getLogger(test.class);
        SqlSession session=MybatisUtils.openSqlSession();
        StudentMapper studentMapper = session.getMapper(StudentMapper.class);
        Student student =  studentMapper.findById(new Student(7));
        
        byte[] pic=student.getPic();
        System.out.println(pic);
        File file=new File("d://cai.jpg");
        OutputStream os=new FileOutputStream(file);
        os.write(pic);
        System.out.println(student);
        logger.info("添加成功");
        session.commit();
    }