mybatis基于接口增删改查小例子

1、idea新建web项目并配置classes、lib

2、将数据库、mybatis的jar包拷贝到lib下

3、src下创建config目录,在config下新建配置文件Configure.xml:

<!--?xml version="1.0" encoding="UTF-8" ?-->
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>
    <typeAliases>
        <typeAlias alias="User" type="com.lxj.entiry.User" />
    </typeAliases>

    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC" />
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver" />
                <property name="url" value="jdbc:mysql://127.0.0.1:3306/javatest" />
                <property name="username" value="root" />
                <property name="password" value="root" />
            </dataSource>
        </environment>
    </environments>

    <mappers>
        <!--&lt;!&ndash; // power by http://www.yiibai.com &ndash;&gt;-->
        <mapper resource="com/lxj/entiry/User.xml" />
    </mappers>
</configuration>

4、src下创建com.lxj.entiry目录,在该目录下新建实体类User:

package com.lxj.entiry;

public class User {
    private int id;
    private String name;
    private String dept;
    private String phone;
    private String website;

    public String getWebsite() {
        return website;
    }
    public void setWebsite(String website) {
        this.website = website;
    }
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public String getDept() {
        return dept;
    }
    public void setDept(String dept) {
        this.dept = dept;
    }
    public String getPhone() {
        return phone;
    }
    public void setPhone(String phone) {
        this.phone = phone;
    }
}

5、在com.lxj.entiry目录下新建映射文件User.xml(!!!这里一定要注意namespace,是对应的接口名称!!!):

<?xml version="1.0" encoding="UTF-8"?>
        <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
                "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.lxj.dao.IUser">
    <select id="getUser" parameterType="int" resultType="com.lxj.entiry.User">
        SELECT * FROM USER WHERE id = #{userId}
    </select >

    <insert id="insertUser" parameterType="com.lxj.entiry.User">
        INSERT INTO USER(name,dept,website,phone)VALUES (#{name},#{dept},#{website},#{phone})
    </insert>

    <select id="getUserList" resultType="com.lxj.entiry.User">
         SELECT * FROM USER
    </select>

    <update id="updateUser" parameterType="com.lxj.entiry.User">
        UPDATE USER SET name=#{name},dept = #{dept},website = #{website},phone = #{phone} WHERE id = #{id}
    </update>

    <delete id="deleteUser" parameterType="int">
        DELETE FROM USER WHERE id = #{id}
    </delete>

</mapper>

6、在src下新建文件夹com.lxj.dao,在此文件夹下新建接口IUser:

package com.lxj.dao;

import com.lxj.entiry.User;

import java.util.List;

public interface IUser {

    public List<User> getUserList();

    public void insertUser(User user);

    public void updateUser(User user);

    public  void deleteUser(int userId);

    public User getUser(int id);
}

7、src下新建test文件夹,在test文件夹下新建测试类Main:

package test;

import java.io.Reader;
import java.util.List;

import com.lxj.dao.IUser;
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 com.lxj.entiry.*;

public class Main {
    private static SqlSessionFactory sqlSessionFactory;
    private static Reader reader;

    static {
        try{
            reader = Resources.getResourceAsReader("config/Configure.xml");
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
        }catch (Exception e){
            e.getStackTrace();
        }
    }

    public static SqlSessionFactory getSession(){
        return sqlSessionFactory;
    }

    public static void main(String[] args){
//        testInsertUser();
//        testGetList();
//        testUpdateUser();
        testDeleteUser();
    }

    private static void testInsertUser(){
        SqlSession session = sqlSessionFactory.openSession();

        IUser userMapper = session.getMapper(IUser.class);
        System.out.printf("insert user start ....");

        //插入数据
        User user = new User();
        user.setName("aa");
        user.setDept("ddd");
        user.setPhone("13247629622");
        user.setWebsite("http://www.qqq.com");
        userMapper.insertUser(user);
        session.commit();

        System.out.printf("after insert ...");
    }

    private static void testGetList(){

        SqlSession session = sqlSessionFactory.openSession();
        IUser iUser = session.getMapper(IUser.class);

        List<User> list = iUser.getUserList();

        for(User user: list){
            System.out.printf(user.getName()+" " +user.getDept()+" "+user.getPhone()+" "+user.getWebsite());
        }
    }

    private static void testUpdateUser(){
        SqlSession session = sqlSessionFactory.openSession();
        IUser iUser = session.getMapper(IUser.class);

        User user = iUser.getUser(1);
        user.setName("ppp");
        iUser.updateUser(user);

        session.commit();
        System.out.printf("update success");
    }

    private static void testDeleteUser(){
        SqlSession session = sqlSessionFactory.openSession();
        IUser iUser = session.getMapper(IUser.class);

        iUser.deleteUser(1);
        session.commit();
        System.out.printf("delete success");

    }
}

8、运行测试类Main中的main方法

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
回答: 下面是一个使用Spring Boot和MyBatis实现增删改查例子: 首先,我们需要创建一个Book实体类,包含书籍的相关属性。然后,我们创建一个BookMapper接口,使用@Mapper注解标记该接口MyBatis的Mapper接口,并定义了一些常用的数据库操作方法,如查询全部书籍、添加书籍、删除书籍、修改书籍等。接着,我们创建一个BookMapper.xml文件,配置了具体的SQL语句。最后,我们创建一个BookService接口和一个BookServiceImpl实现类,用于处理业务逻辑。 在Controller层,我们创建一个PublishController类,使用@Autowired注解注入PublishService,并定义了一些接口方法,如查询全部书籍、添加书籍、删除书籍、修改书籍等。 在Spring Boot的启动类中,我们使用@SpringBootApplication注解标记该类为Spring Boot的启动类,并使用@MapperScan注解指定Mapper接口所在的包。 这样,我们就可以通过访问Controller层的接口来实现增删改查的功能了。 以上是一个简单的springboot mybatis实现增删改查例子。希望对你有帮助。\[1\]\[2\]\[3\] #### 引用[.reference_title] - *1* *2* *3* [SpringBoot中的增删改查案例](https://blog.csdn.net/woshishq1210/article/details/130981372)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^control_2,239^v3^insert_chatgpt"}} ] [.reference_item] [ .reference_list ]

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

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

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值