导航：首页 > 开发技术 >

Mybatis如何实现增删改查

发表于：2025-02-07 作者：千家信息网编辑

千家信息网最后更新 2025年02月07日，这篇文章主要介绍了Mybatis如何实现增删改查，具有一定借鉴价值，感兴趣的朋友可以参考下，希望大家阅读完这篇文章之后大有收获，下面让小编带着大家一起了解一下。Mybatis实现增删改查一.mybat

千家信息网最后更新 2025年02月07日Mybatis如何实现增删改查

这篇文章主要介绍了Mybatis如何实现增删改查，具有一定借鉴价值，感兴趣的朋友可以参考下，希望大家阅读完这篇文章之后大有收获，下面让小编带着大家一起了解一下。

Mybatis实现增删改查

一.mybatis的配置

1.1 添加相应的jar包

在lib文件夹下面添加mybatis的核心jar包以及依赖的jar包
同在lib文件夹下面加入mysql的驱动jar包

1.2 配置mybatis.xml文件

1.3 创建数据库

注意：在设计数据库时，id的类型为int并且设置为主键。自动递增。

1.4 创建实体类

package com.sxt.domain;public class User {    private Integer  id;    private String  name;    private String  address;    private String  sex;        public User(){    }    //插入    public User(String name, String address, String sex) {        super();        this.name = name;        this.address = address;        this.sex = sex;    }    //查询    public User(Integer id, String name, String address, String sex) {        super();        this.id = id;        this.name = name;        this.address = address;        this.sex = sex;    }    public Integer getId() {        return id;    }    public void setId(Integer id) {        this.id = id;    }    public String getName() {        return name;    }    public void setName(String name) {        this.name = name;    }    public String getAddress() {        return address;    }    public void setAddress(String address) {        this.address = address;    }    public String getSex() {        return sex;    }    public void setSex(String sex) {        this.sex = sex;    }    @Override    public String toString() {        return "User [id=" + id + ", name=" + name + ", address=" + address + ", sex=" + sex + "]";    }        }

1.5 创建接口实现的方法

package com.sxt.mapper;import com.sxt.domain.User;import java.util.List;public interface UserMapper {   public void add(User user);   public void update(User user);   public void delete(Integer id); //删除的构造方法   public User queryById(Integer id);//查询的构造方法   public List queryAll();   public List queryLike(User user); //模糊查询}

1.6 配置UserMapper.xml 文件

               insert into user (name,address,sex) values(#{name},#{address},#{sex})                  update user set name=#{name},address=#{address},sex=#{sex} where id=#{id}                   delete form user where id=#{value}

1.7 创建MybatisUtils的方法

package com.sxt.utils;import java.io.InputStream;import javax.websocket.Session;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;public class MybatisUtils {    static InputStream is=MybatisUtils.class.getResourceAsStream("/mybatis.xml");    //得到SqlSessionFactory    static SqlSessionFactory factory=new SqlSessionFactoryBuilder().build(is);    //得到session   public static SqlSession openSession() {       return factory.openSession();   }   //关闭session   public static void closeSession(SqlSession session) {       //提交       session.commit();       //关闭       session.close();          }}

二、Mybatis的增删改查

2.1 添加

package com.sxt.text;import java.util.List;import org.apache.ibatis.session.SqlSession;import org.junit.Test;import com.sxt.domain.User;import com.sxt.mapper.UserMapper;import com.sxt.utils.MybatisUtils;public class mybatisTest {    public static void main(String[] args) {        SqlSession session=MybatisUtils.openSession();        UserMapper userMapper=session.getMapper(UserMapper.class);        // TODO Auto-generated method stub         User user=new User("小花", "武汉", "男");         userMapper.add(user);         System.out.println("chen");         MybatisUtils.closeSession(session);    }

2.2 修改

package com.sxt.text;import java.util.List;import org.apache.ibatis.session.SqlSession;import org.junit.Test;import com.sxt.domain.User;import com.sxt.mapper.UserMapper;import com.sxt.utils.MybatisUtils;public class mybatisTest {//    SqlSession session=MybatisUtils.openSession();//    UserMapper userMapper=session.getMapper(UserMapper.class);//  @Test//    public void initData(){    public static void main(String[] args) {        SqlSession session=MybatisUtils.openSession();        UserMapper userMapper=session.getMapper(UserMapper.class);        // TODO Auto-generated method stub//         User user=new User("小明", "武汉", "男");        User user=new User(2,"小花","河北","女");         userMapper.update(user);         MybatisUtils.closeSession(session);    }

2.3 查询

package com.sxt.text;import java.util.List;import org.apache.ibatis.session.SqlSession;import org.junit.Test;import com.sxt.domain.User;import com.sxt.mapper.UserMapper;import com.sxt.utils.MybatisUtils;public class mybatisTest {//    SqlSession session=MybatisUtils.openSession();//    UserMapper userMapper=session.getMapper(UserMapper.class);//  @Test//    public void initData(){    public static void main(String[] args) {        SqlSession session=MybatisUtils.openSession();        UserMapper userMapper=session.getMapper(UserMapper.class);        // TODO Auto-generated method stub//         User user=new User("小明", "武汉", "男");        //User user=new User(2,"小花","河北","女");         List list=userMapper.queryAll();         System.out.println(list);         MybatisUtils.closeSession(session);    }

2.4 删除

package com.sxt.text;import java.util.List;import org.apache.ibatis.session.SqlSession;import org.junit.Test;import com.sxt.domain.User;import com.sxt.mapper.UserMapper;import com.sxt.utils.MybatisUtils;public class mybatisTest {//    SqlSession session=MybatisUtils.openSession();//    UserMapper userMapper=session.getMapper(UserMapper.class);//  @Test//    public void initData(){    public static void main(String[] args) {        SqlSession session=MybatisUtils.openSession();        UserMapper userMapper=session.getMapper(UserMapper.class);        // TODO Auto-generated method stub//         User user=new User("小明", "武汉", "男");        //User user=new User(2,"小花","河北","女");        // List list=userMapper.queryAll();         //System.out.println(list);        userMapper.delete(3);         MybatisUtils.closeSession(session);    }

感谢你能够认真阅读完这篇文章，希望小编分享的"Mybatis如何实现增删改查"这篇文章对大家有帮助，同时也希望大家多多支持，关注行业资讯频道，更多相关知识等着你来学习!

很赞哦！