Java Code Examples for org.apache.ibatis.session.SqlSession#delete()

The following examples show how to use org.apache.ibatis.session.SqlSession#delete() . You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example 1
Source File: CeshiMyBatis.java    From cg-blog with MIT License 5 votes vote down vote up 
@Test
public void testDeleteById(){
    String resource = "sqlMapConfig.xml";           //定位核心配置文件
    InputStream inputStream = Resources.getResourceAsStream(resource);
    SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);        // 创建 SqlSessionFactory

    SqlSession sqlSession = sqlSessionFactory.openSession();            // 获取到 SqlSession

    sqlSession.delete("yeepay.payplus.mapper.UserMapper.deleteById", 2);
    sqlSession.commit();            //默认是不自动提交，必须手工提交
}
Example 2
Source File: CeshiMyBatis.java    From cg-blog with MIT License 5 votes vote down vote up 
@Test
public void testDeleteArray() {   // 批量删除
    String resource = "sqlMapConfig.xml";            //定位核心配置文件
    InputStream inputStream = Resources.getResourceAsStream(resource);
    SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);        // 创建 SqlSessionFactory

    SqlSession sqlSession = sqlSessionFactory.openSession();            // 获取到 SqlSession

    sqlSession.delete("yeepay.payplus.mapper.UserMapper.deleteArray", new Integer[]{2, 3, 4});
    sqlSession.commit();            //默认是不自动提交，必须手工提交
}
Example 3
Source File: TestBatisXML.java    From java-course-ee with MIT License 5 votes vote down vote up 
public static void main(String[] args) throws IOException {
    String resource = "Configuration.xml";
    Reader reader = Resources.getResourceAsReader(resource);
    SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);

    SqlSession session = sqlSessionFactory.openSession();
    try {
        Region region = new Region();
        region.setRegionName("12345");

        session.insert("ibatis.RegionMapper.insertRegion", region);
        session.commit();

        System.out.println("Region ID: " + region.getRegionId());

        findAndGet(session);

        region.setRegionName("54321");
        session.update("ibatis.RegionMapper.updateRegion", region);
        session.commit();
        findAndGet(session);

        session.delete("ibatis.RegionMapper.deleteRegion", region.getRegionId());
        session.commit();
        findAndGet(session);

    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        session.close();
    }

}
Example 4
Source File: SqlSessionTestBase.java    From pinpoint with Apache License 2.0 5 votes vote down vote up 
protected final void testAndVerifyDelete() throws Exception {
    // Given
    final String deleteId = "deleteId";
    SqlSession sqlSession = getSqlSession();
    // When
    sqlSession.delete(deleteId);
    sqlSession.delete(deleteId, new Object());
    // Then
    PluginTestVerifier verifier = PluginTestVerifierHolder.getInstance();
    Method delete1 = sqlSession.getClass().getDeclaredMethod("delete", String.class);
    Method delete2 = sqlSession.getClass().getDeclaredMethod("delete", String.class, Object.class);
    verifier.verifyTrace(event("MYBATIS", delete1, Expectations.cachedArgs(deleteId)));
    verifier.verifyTrace(event("MYBATIS", delete2, Expectations.cachedArgs(deleteId)));
}
Example 5
Source File: MonitNotifyHistoryDao.java    From JavaTutorial with Apache License 2.0 5 votes vote down vote up 
public int deleteByPrimaryKey(Long recordId) {
    SqlSession session = _ssFactory.openSession(true);
    int result = 0;
    try {
        session.delete(assembleStatement("deleteByPrimaryKey"), recordId);
    } finally {
        close(session);
    }
    
    return result;
}
Example 6
Source File: BulkDeleteOperation.java    From activiti6-boot2 with Apache License 2.0 4 votes vote down vote up 
public void execute(SqlSession sqlSession) {
  sqlSession.delete(statement, parameter);
}
Example 7
Source File: BulkDeleteOperation.java    From flowable-engine with Apache License 2.0 4 votes vote down vote up 
public void execute(SqlSession sqlSession, Class<? extends Entity> clazz) {
    sqlSession.delete(statement, parameter);
}
Example 8
Source File: MybatisTest.java    From Oceanus with Apache License 2.0 4 votes vote down vote up 
@Test
public void deleteTest() throws SQLException {
	SqlSession session = sqlSessionFactory.openSession(true);
	session.delete("com.bj58.oceanus.plugins.mybatis.entity.UserMapper.deleteUser");
	session.close();
}