Mybatis插入语法的使用和如何获得自增主键

插入语句编写

代码：

 <insert id="add" parameterType="work.yspan.online_class.domain.Video" useGeneratedKeys="true" keyProperty="id" keyColumn="id">
        insert into video (title, summary, cover_img, price, create_time,point)
        values (#{title,jdbcType=VARCHAR},#{summary,jdbcType=VARCHAR},#{coverImg,jdbcType=VARCHAR},
        #{price,jdbcType=INTEGER },#{createTime,jdbcType=TIMESTAMP},#{point,jdbcType=DOUBLE })
</insert>

如何获取自增主键

运行代码：

public class SqlSessionDemo {
    public static void main(String [] args) throws IOException {

        //读取配置文件
        String resouce="config/mybatis-config.xml";
        InputStream inputStream= Resources.getResourceAsStream(resouce);

        //构建Session工厂
        SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(inputStream);
        //获取Session
        try(SqlSession sqlSession=sqlSessionFactory.openSession()){

            VideoMapper videoMapper=sqlSession.getMapper(VideoMapper.class);
            
            Video video=new Video();
            video.setTitle("ssm");
            video.setSummary("这是ssm课程");
            video.setCoverImg("http://yspan.work:8232");
            video.setPrice(8888);
            video.setCreateTime(new Date());
            video.setPoint(8.8);

            int rows=videoMapper.add(video);
            System.out.println(rows);
            System.out.println(video.toString());

        }
    }
}

测试结果：