天天看点

#JdbcTemplate 插入返回主键

@Override
    public int insertOne(Teacher object) {

        int row = jdbcTemplate.update(
                "INSERT INTO `t_teacher`(`teacher_name`, `teacher_password`,`sex`,`is_deleted`,`gmt_create`,`gmt_modified`) VALUES (?,?,?,?,?,?)" ,
                object.getTeacherName(),object.getTeacherPassword(),object.getSex(),object.getDeleted(),object.getGmtCreate(),object.getGmtModified());
        if(row <=0) {
            return row;
        }
        int l = jdbcTemplate.queryForObject("SELECT LAST_INSERT_ID()", (rs,i) -> rs.getInt("LAST_INSERT_ID()"));
        return l;
    }