java——mybatis——Mybatis注解开发——@Delete——删除数据

r囧r小猫 2024-03-31 14:58 65阅读 0赞

![c436c5fe3f714ab3d11bd9f3d2b67461.png][]

DAO接口：

package com.sunxl.dao;
    
    import com.sunxl.pojo.User;
    import org.apache.ibatis.annotations.*;
    
    import java.util.List;
    
    public interface UserDao {
    
        @Select("select * from users")
        List<User> findAll();
    
        @Insert("insert into users (name,age) values(#{name},#{age})")
        @SelectKey(statement = "select last_insert_id()", keyProperty = "id", keyColumn = "id", resultType = int.class ,before = false)
        int saveUser(User user);
    
    
        @Update("update users set name = #{name},age = #{age} where id = #{id}")
        int updateUser(User user);
    
        @Delete("delete from users where id = #{id}")
        int deleteUser(Integer id);
    //
    //    User findById(Integer id);
    //
    //    List<User> findByName(String name);
    //
    //    int findTotal();
    //
    //    int saveInsertUser(User user);
    
    }

![192096e1eb8bf9b1579344d04957d9c1.png][]

测试执行：

import com.sunxl.dao.UserDao;
    import com.sunxl.pojo.User;
    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 java.io.IOException;
    import java.io.InputStream;
    import java.util.List;
    
    public class MybatisTest {
    
        public static void main(String[] args) throws IOException {
    
    //        InputStream config = Resources.getResourceAsStream("mybatis-config.xml");
    //
    //        SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
    //        SqlSessionFactory factory = builder.build(config);
    //        SqlSession ss = factory.openSession();
    //        UserDao userdao = ss.getMapper(UserDao.class);
    //
    //
    //        List<User> users = userdao.findAll();
    //
    //        for (User user: users){
    //            System.out.println(user);
    //        }
    //
    //
    //        ss.commit();
    //        ss.close();
    //        config.close();
    
    
    
            InputStream config = Resources.getResourceAsStream("mybatis-config.xml");
    
            SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
            SqlSessionFactory factory = builder.build(config);
            SqlSession ss = factory.openSession();
            UserDao userdao = ss.getMapper(UserDao.class);
    
    
    
            int a = userdao.deleteUser(1006);
            System.out.println(a);
    
    
    
            ss.commit();
            ss.close();
            config.close();
    
    
        }
    }

![9ccca5cbb9bb6d90cb7112c355f0676b.png][]

![367b00945f3fab4d29905010b543303b.png][]

![bfcef5fd1fee8267abd1044cc9db7224.png][]

[c436c5fe3f714ab3d11bd9f3d2b67461.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/a250edbb138b43d4833055db09ee9724.png
[192096e1eb8bf9b1579344d04957d9c1.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/dc494c9895754e89bd750254882d4489.png
[9ccca5cbb9bb6d90cb7112c355f0676b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/c52515f2a3404e9f946c5183dc38e7ce.png
[367b00945f3fab4d29905010b543303b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/3322c24a27ac4882850eda6672b52b78.png
[bfcef5fd1fee8267abd1044cc9db7224.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/e073b11216e54f9e818e3a707d6cc74c.png