MyBatis的增删改操作 insert update delete

系统管理员 2023-07-20 10:50 1阅读 0赞

首先需要在配置文件当中配置sql语句，然后在测试类当中调用即可。  
insert语句  
在原先的CustomerMapper.xml文件当中的mapper标签当中添加insert标签。

<insert id="addCustomer" parameterType="com.lzq.po.Customer">
    		insert into t_customer(username,jobs,phone)
    		values(#{ username},#{ jobs},#{ phone})
    	</insert>

在测试类当中测试：

@Test  //添加用户
    	public void add() throws Exception { 
    		String resource = "mybatis-config.xml";
    		InputStream inputStream = Resources.getResourceAsStream(resource);
    		SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
    		SqlSession sqlSession = sqlSessionFactory.openSession();
    		Customer customer = new Customer();
    		customer.setUsername("瓜皮");
    		customer.setJobs("student");
    		customer.setPhone("15173413526");
    		int row = sqlSession.insert("com.lzq.mapper" + ".CustomerMapper.addCustomer", customer);
    		System.out.println("插入了" + row + "条数据。");
    		sqlSession.commit();//提交到数据库
    		sqlSession.close();
    	}

update语句  
同理：

<update id="updateCustomer" parameterType="com.lzq.po.Customer">
    		update t_customer set
    		username=#{ username},jobs=#{ jobs},phone=#{ phone}
    		where id=#{ id}
    	</update>

测试代码：

@Test  //更新用户数据
    	public void update() throws Exception { 
    		String resource = "mybatis-config.xml";
    		InputStream inputStream = Resources.getResourceAsStream(resource);
    		SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
    		SqlSession sqlSession = sqlSessionFactory.openSession();
    		Customer customer = new Customer();
    		customer.setId(6);
    		customer.setUsername("李瓜皮");
    		customer.setJobs("Faker");
    		customer.setPhone("15173413526");
    		int row = sqlSession.update("com.lzq.mapper" + ".CustomerMapper.updateCustomer", customer);
    		System.out.println("更新了" + row + "条数据。");
    		sqlSession.commit();
    		sqlSession.close();
    	}

delete语句  
xml代码：

<delete id="deleteCustomer" parameterType="Integer">
    		delete from t_customer where id=#{ id}
    	</delete>

Java测试代码：

@Test
    	public void delete() throws Exception { 
    		String resource = "mybatis-config.xml";
    		InputStream inputStream = Resources.getResourceAsStream(resource);
    		SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
    		SqlSession sqlSession = sqlSessionFactory.openSession();
    		int row = sqlSession.update("com.lzq.mapper" + ".CustomerMapper.deleteCustomer", 7);
    		System.out.println("删除了" + row + "条数据。");
    		sqlSession.commit();
    		sqlSession.close();
    	}