IDEA+mybatis实现增删改查(CURD)

目录0.前言1.具体操作0.前言操作mybaits和mysql进行增删改查是必备的一步今天写一篇文章简单记录一下mybatis的增删改查操作。本文源代码下载地址1百度网盘通过网盘分享的文件demo-mybiats-curd.zip链接: https://pan.baidu.com/s/1G5Aq45f9ZpwhsJAY6cY1lg?pwd1ijt 提取码: 1ijt2夸克网盘我用夸克网盘给你分享了「demo-mybiats-curd.zip」点击链接或复制整段内容打开「夸克APP」即可获取。/43353b70rU链接https://pan.quark.cn/s/79ec885e220b?pwdWVgN提取码WVgN1.具体操作studnetsMapper文件package com.cat.dao;importcom.cat.pojo.Students;importjava.util.List;public interface StudentsMapper{//所有学生 ListStudentslistAllStudents();//删除一名学生信息 int deleteStudent(intid);//新增一名学生 int addStudent(Students students);//修改一名学生信息 int updateStudentById(Students students);}StudentsMapper.xml文件?xmlversion1.0encodingUTF-8?!DOCTYPE mapper PUBLIC-//mybatis.org//DTD Mapper 3.0//ENhttp://mybatis.org/dtd/mybatis-3-mapper.dtdmappernamespacecom.cat.dao.StudentsMapper!--展示所有学生--selectidlistAllStudentsresultTypecom.cat.pojo.Studentsselect* from students;/select!--删除一条学生信息--deleteiddeleteStudentparameterTypeintdelete from students whereid#{id}/delete!--增加一名学生信息--insertidaddStudentparameterTypecom.cat.pojo.Studentsinsert into students(stu_name,stu_sex,class_id,age)values(#{stu_name},#{stu_sex},#{class_id},#{age})/insert!--更新一名学生的信息--updateidupdateStudentByIdparameterTypecom.cat.pojo.Studentsupdate studentssetstu_name#{stu_name},stu_sex#{stu_sex},class_id#{class_id},age#{age}whereid#{id}/update/mapperTest文件packagecom.cat.test;importcom.cat.dao.StudentsMapper;importcom.cat.pojo.Students;importorg.apache.ibatis.io.Resources;importorg.apache.ibatis.session.SqlSession;importorg.apache.ibatis.session.SqlSessionFactory;importorg.apache.ibatis.session.SqlSessionFactoryBuilder;importorg.junit.Test;importjava.io.IOException;importjava.io.InputStream;importjava.util.HashMap;importjava.util.List;importjava.util.Map;publicclassMyBatisTest{//输出所有学生信息Testpublicvoidtest()throwsIOException{//获得核心配置文件InputStreaminResources.getResourceAsStream(MyBatisConfig.xml);//获得session工厂对象SqlSessionFactoryBuilderbuildernewSqlSessionFactoryBuilder();SqlSessionFactoryfactorybuilder.build(in);SqlSessionsessionfactory.openSession();//获得会话对象ListStudentsstudentssession.selectList(listAllStudents);System.out.println(students);session.close();//关闭}//测试删除一名学生信息TestpublicvoiddeleteStudent()throwsIOException{//获得核心配置文件InputStreaminResources.getResourceAsStream(MyBatisConfig.xml);//获得session工厂对象SqlSessionFactoryBuilderbuildernewSqlSessionFactoryBuilder();SqlSessionFactoryfactorybuilder.build(in);SqlSessionsessionfactory.openSession();//获得会话对象StudentsMapperstudentsMappersession.getMapper(StudentsMapper.class);studentsMapper.deleteStudent(1000);//调用deleteStudent方法删除id是1000的这个学生session.close();//关闭}//新增一名学生信息TestpublicvoidaddStudent()throwsIOException{//获得核心配置文件InputStreaminResources.getResourceAsStream(MyBatisConfig.xml);//获得session工厂对象SqlSessionFactoryBuilderbuildernewSqlSessionFactoryBuilder();SqlSessionFactoryfactorybuilder.build(in);SqlSessionsessionfactory.openSession();//获得会话对象StudentsMapperstudentsMappersession.getMapper(StudentsMapper.class);//构造一个新的学生StudentssnewStudents();s.setStu_name(呵呵);s.setClass_id(1042);s.setAge(16);s.setStu_sex(男);intresstudentsMapper.addStudent(s);//调用session.commit();//增删改必须提交事务session.close();//关闭}//修改一名学生信息TestpublicvoidupdateStudent()throwsIOException{//获得核心配置文件InputStreaminResources.getResourceAsStream(MyBatisConfig.xml);//获得session工厂对象SqlSessionFactoryBuilderbuildernewSqlSessionFactoryBuilder();SqlSessionFactoryfactorybuilder.build(in);SqlSessionsessionfactory.openSession();//获得会话对象StudentsMapperstudentsMappersession.getMapper(StudentsMapper.class);//把原来的学生信息修改StudentssnewStudents();s.setId(1001);//定向修改id是1001的学生s.setStu_name(李十三);//这个人的名字改成李十三s.setStu_sex(男);//性别改为男s.setAge(24);//年龄修改为24s.setClass_id(3002);intresstudentsMapper.updateStudentById(s);//调用session.commit();//增删改必须提交事务session.close();//关闭}}