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

原文链接:这里

0.前言
操作mybaits和mysql进行增删改查是必备的一步,今天写一篇文章简单记录一下mybatis的增删改查操作。

本文源代码放在github上。

1.具体操作
studnetsMapper文件

package com.cat.dao;
import com.cat.pojo.Students;
import java.util.List;
public interface StudentsMapper {
//所有学生
List listAllStudents();
//删除一名学生信息
int deleteStudent(int id);
//新增一名学生
int addStudent(Students students);
//修改一名学生信息
int updateStudentById(Students students);
}
StudentsMapper.xml文件

<?xml version="1.0" encoding="UTF-8"?> select * from students; delete from students where id = #{id} insert into students(stu_name,stu_sex,class_id,age) values (#{stu_name},#{stu_sex},#{class_id},#{age}) update students set stu_name= #{stu_name}, stu_sex= #{stu_sex}, class_id =#{class_id}, age=#{age} where id =#{id} Test文件

package com.cat.test;
import com.cat.dao.StudentsMapper;
import com.cat.pojo.Students;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Test;
import java.io.IOException;
import java.io.InputStream;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
public class MyBatisTest {
//输出所有学生信息
@Test
public void test() throws IOException{
//获得核心配置文件
InputStream in = Resources.getResourceAsStream(“MyBatisConfig.xml”);
//获得session工厂对象
SqlSessionFactoryBuilder builder =new SqlSessionFactoryBuilder();
SqlSessionFactory factory=builder.build(in);
SqlSession session =factory.openSession();
//获得会话对象
List students =session.selectList(“listAllStudents”);
System.out.println(students);
session.close(); //关闭
}
//测试删除一名学生信息
@Test
public void deleteStudent() throws IOException{
//获得核心配置文件
InputStream in = Resources.getResourceAsStream(“MyBatisConfig.xml”);
//获得session工厂对象
SqlSessionFactoryBuilder builder =new SqlSessionFactoryBuilder();
SqlSessionFactory factory=builder.build(in);
SqlSession session =factory.openSession();
//获得会话对象
StudentsMapper studentsMapper = session.getMapper(StudentsMapper.class);
studentsMapper.deleteStudent(1000); //调用deleteStudent方法,删除id是1000的这个学生
session.close(); //关闭
}
//新增一名学生信息
@Test
public void addStudent() throws IOException{
//获得核心配置文件
InputStream in = Resources.getResourceAsStream(“MyBatisConfig.xml”);
//获得session工厂对象
SqlSessionFactoryBuilder builder =new SqlSessionFactoryBuilder();
SqlSessionFactory factory=builder.build(in);
SqlSession session =factory.openSession();
//获得会话对象
StudentsMapper studentsMapper = session.getMapper(StudentsMapper.class);
//构造一个新的学生
Students s =new Students();
s.setStu_name(“呵呵”);
s.setClass_id(1042);
s.setAge(16);
s.setStu_sex(“男”);
int res = studentsMapper.addStudent(s); //调用
session.commit(); //增删改必须提交事务
session.close(); //关闭
}
//修改一名学生信息
@Test
public void updateStudent() throws IOException{
//获得核心配置文件
InputStream in = Resources.getResourceAsStream(“MyBatisConfig.xml”);
//获得session工厂对象
SqlSessionFactoryBuilder builder =new SqlSessionFactoryBuilder();
SqlSessionFactory factory=builder.build(in);
SqlSession session =factory.openSession();
//获得会话对象
StudentsMapper studentsMapper = session.getMapper(StudentsMapper.class);
//把原来的学生信息修改
Students s= new Students();
s.setId(1001); //定向修改id是1001的学生
s.setStu_name(“李十三”); //这个人的名字改成李十三
s.setStu_sex(“男”); //性别改为男
s.setAge(24); //年龄修改为24
s.setClass_id(3002);
int res = studentsMapper.updateStudentById(s); //调用
session.commit(); //增删改必须提交事务
session.close(); //关闭
}
}

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值