mybatis：处理clob、blob类型数据

以下知识来源说明：http://www.java1234.com/

 数据库表

create table t_student(
    id int primary key auto_increment,
    name varchar(20),
    age int,
    pic longblob,
    remark longtext
)

entity：student

public class Student {

	private Integer id;
	private String name;
	private Integer age;
	private byte[] pic;
	private String remark;
        
        Getter and Setter……

        toString……
}

mapping

<insert id="insertStudent" parameterType="Student">
    insert into t_student values(null,#{name},#{age},#{pic},#{remark});
</insert>

<select id="getStudentById" parameterType="Integer" resultType="Student">
    select * from t_student where id=#{id}
</select>

JUnit测试

@Test
public void testInsertStudent(){
    logger.info("添加学生");
    Student student=new Student();
    student.setName("张三4");
    student.setAge(14);
    student.setRemark("很长的本文...");
    byte []pic=null;
    try{
        File file=new File("c://boy.jpg");
        InputStream inputStream=new FileInputStream(file);
        pic=new byte[inputStream.available()];
        inputStream.read(pic);
        inputStream.close();
    }catch(Exception e){
        e.printStackTrace();
    }
    student.setPic(pic);
    studentMapper.insertStudent(student);
    sqlSession.commit();
}

@Test
public void testGetStudentById(){
    logger.info("通过ID查找学生");
    Student student=studentMapper.getStudentById(4);
    System.out.println(student);
    byte []pic=student.getPic();
    try{
        File file=new File("d://boy2.jpg");
        OutputStream outputStream=new FileOutputStream(file);
        outputStream.write(pic);
        outputStream.close();
    }catch(Exception e){
        e.printStackTrace();
    }
}