Mybatis-02：执行各类SQL语句

2.1.SELECT带参

• 在映射配置文件中进行设置：通过“parameterType”指定参数类型，通过“#{id}”占位；

<select id="selectById" resultType="com.itheima.bean.Student" parameterType="java.lang.Integer">
      SELECT * FROM student WHERE id = #{id}
</select>

• 执行查询语句：输入参数3。

//执行查询语句，返回对象
Student student = sqlSession.selectOne("StudentMapper.selectById", 3);

2.2.INSERT插入数据

• 映射配置文件如下：设定参数为student对象，插入对象属性；

<insert id="insert" parameterType="com.itheima.bean.Student">
     INSERT INTO student VALUE(#{id},#{name},#{age})
</insert>

• 执行语句如下：增删改操作后需要提交事务；

SqlSession sqlSession = sqlSessionFactory.openSession();
Student student = new Student(4, "赵六", 26);
int result = sqlSession.insert("StudentMapper.insert", student);
sqlSession.commit();//增删改操作，需要提交事务后才可生效，或者openSession(True)为自动提交；

2.3.UPDATE修改数据

• 映射配置文件如下：其中name=#{name}：缺一不可，必须对应上；

<update id="update" parameterType="com.itheima.bean.Student">
    UPDATE student SET name=#{name}, age=#{age} WHERE id=#{id}
</update>

• 执行语句如下：

Student student = new Student(1,"王八",45);
int result = sqlSession.update("StudentMapper.update",student);
sqlSession.commit();
sqlSession.close();
is.close();

2.4. DELETE删除数据

• 映射配置文件：

<delete id="delete" parameterType="java.lang.Integer">
     DELETE FROM student WHERE id=#{id}
</delete>

• 执行语句：

SqlSession sqlSession = sqlSessionFactory.openSession();
int result = sqlSession.delete("StudentMapper.delete",4);
System.out.println(result);
sqlSession.commit();
sqlSession.close();
inputStream.close();