clob,blob处理、简单多个参数传入

第八讲
1.插入

<resultMap type="Student" id="StudentResult">
    <id property="id" column="id"/>
    <result property="name" column="name"/>
    <result property="age" column="age"/>
</resultMap>    
<insert id="insertStudent" parameterType="Student">
    insert into t_student values(null,#{name},#{age},#{pic},#{remark});
</insert>
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();
}

2.查询

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

@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();
    }
}  

3.传入简单的多个参数

public List<Student> searchStudents6(String name,int age);//dao层接口方法

    xml配置
<select id="searchStudents6" resultMap="StudentResult">
    select * from t_student where name like #{param1} and age=#{param2}
</select>