insert into student(firstName, lastName, age, man)values (#{firstName},#{lastName},#{age},#{man})update studentset firstName = #{firstName}, lastName=#{lastName}, age = #{age}, man = #{man}where id = #{id};delete from Student where id = #{id}
然后在代码中调用就可以了
public class Main {public static void printRet(SqlSession sess) {// 查询List students = sess.selectList("ljw.findAll");for (Student stu: students) {System.out.println(stu.toString());}}public static void main(String[] args) throws Exception {String resource = "com/ljw/mybatis-cfg.xml";InputStream inputStream = Resources.getResourceAsStream(resource);SqlSessionFactory sqlSessionFactory =new SqlSessionFactoryBuilder().build(inputStream);try(SqlSession sess = sqlSessionFactory.openSession()) {// 查询printRet(sess);// 增加一个学生System.out.println("增加一个学生");Student stu = Student.builder().firstName("huang").lastName("he").age(30).man(true).build();sess.insert("ljw.insertStu", stu);printRet(sess);// 删除一个学生System.out.println("删除一个学生");stu.id = 2;sess.delete("ljw.deleteStu", stu);printRet(sess);// 更新一个学生System.out.println("改一个学生");stu.setFirstName("liu");stu.setId(1);System.out.println(stu.toString());sess.update("ljw.updateStu", stu);printRet(sess);}} }