Example usage for org.apache.ibatis.session SqlSession commit

List of usage examples for org.apache.ibatis.session SqlSession commit

  1. HOME
  2. Java
  3. org.apache.ibatis
  4. org.apache.ibatis.session.*
  5. SqlSession
  6. commit

Introduction

In this page you can find the example usage for org.apache.ibatis.session SqlSession commit.

Prototype

void commit();

Source Link

Document

Flushes batch statements and commits database connection.

Usage

From source file:com.mroza.utils.Utils.java

License:Open Source License

private static void clearDeleteHistory() {
    SqlSession sqlSession = getSqlSession();
    deleteHistoryDao.clearDeleteHistory();
    sqlSession.commit();
}

From source file:com.mybatisX.test.MybatisMapperRefreshTest.java

License:Apache License

/**
 *  Mybatis XML /*from www .j ava  2  s . co  m*/
 */
public static void main(String[] args) throws IOException, InterruptedException {
    InputStream in = UserMapperTest.class.getClassLoader().getResourceAsStream("mysql-config.xml");
    MybatisSessionFactoryBuilder mf = new MybatisSessionFactoryBuilder();
    mf.setSqlInjector(new MySqlInjector());
    Resource[] resource = new ClassPathResource[] { new ClassPathResource("mysql/UserMapper.xml") };
    SqlSessionFactory sessionFactory = mf.build(in);
    new MybatisMapperRefresh(resource, sessionFactory, 0, 5, true);
    boolean isReturn = false;
    SqlSession session = null;
    while (!isReturn) {
        try {
            session = sessionFactory.openSession();
            UserMapper userMapper = session.getMapper(UserMapper.class);
            userMapper.selectListRow(new Pagination(1, 10));
            resource[0].getFile().setLastModified(SystemClock.now());
            session.commit();
            session.close();
            Thread.sleep(5000);
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            if (session != null) {
                session.close();
            }
            Thread.sleep(5000);
        }
    }
    System.exit(0);
}

From source file:com.mybatisX.test.mysql.UserMapperTest.java

License:Apache License

/**
 * RUN //w ww.  j av  a 2 s  . co m
 * <p>
 * <p>
 * MybatisPlus  SQL ?
 * </p>
 * 1?XMLSQL<br>
 * 2?sqlProviderSQL<br>
 * 3?xmlSql  sqlProvider???SQL<br>
 * <br>
 * ?SQLxmlSql > sqlProvider > crudSql <br>
 */
public static void main(String[] args) {

    // ?
    InputStream in = UserMapperTest.class.getClassLoader().getResourceAsStream("mysql-config.xml");

    /*
     *  MybatisSessionFactoryBuilder 
     * SqlSessionFactoryBaseMapper
     */
    MybatisSessionFactoryBuilder mf = new MybatisSessionFactoryBuilder();

    /*
     * 1?????? 2????? 3?????
     * ?? @TableId(value = "test_id") 
     */
    // mf.setDbColumnUnderline(true);

    /**
     *  SQL 
     */
    mf.setSqlInjector(new MySqlInjector());

    /**
     *  
     */
    mf.setMetaObjectHandler(new MyMetaObjectHandler());

    SqlSessionFactory sessionFactory = mf.build(in);
    SqlSession session = sessionFactory.openSession();
    UserMapper userMapper = session.getMapper(UserMapper.class);
    System.err.println(" debug run  user ??? ");
    userMapper.deleteAll();

    /**
     * sjy @TableFieldel
     */
    Role role = new Role();
    role.setId(IdWorker.getId());
    role.setName("admin");

    User userA = new User();
    userA.setId(IdWorker.getId());
    userA.setName("junyu_shi");
    userA.setAge(1);
    userA.setDesc("");
    userA.setTestType(1);
    userA.setRole(role);

    int rlt = userMapper.insert(userA);
    User whereUser = userMapper.selectOne(userA);
    print(whereUser);

    userA.setAge(18);
    userMapper.updateById(userA);
    userMapper.delete(new EntityWrapper<User>(userA));
    System.err.println("--------- @TableField el() --------- " + rlt);

    /**
     * ?
     */
    rlt = userMapper.insertInjector(new User(1L, "1", 1, 1));
    System.err.println("--------- insertInjector --------- " + rlt);

    /**
     * ehcache 
     */
    User cacheUser = userMapper.selectOne(new User(1L, 1));
    print(cacheUser);
    cacheUser = userMapper.selectOne(new User(1L, 1));
    print(cacheUser);

    /**
     * ?
     */
    long id = IdWorker.getId();
    rlt = userMapper.insert(new User(id, "abc", 18, 1));
    System.err.println("\n--------------insert-------" + rlt);
    sleep();

    rlt = userMapper.insert(new User(18));
    System.err.println("\n---------- name ?----insert-------" + rlt);
    sleep();

    List<User> ul = new ArrayList<User>();

    /*  ID */
    ul.add(new User(11L, "1", 1, 0));
    ul.add(new User(12L, "2", 2, 1));
    ul.add(new User(13L, "3", 3, 1));
    ul.add(new User(14L, "delname", 4, 0));
    ul.add(new User(15L, "5", 5, 1));
    ul.add(new User(16L, "6", 6, 0));

    /*  name test_type  */
    ul.add(new User(17L, 7));
    ul.add(new User(18L, 8));
    ul.add(new User(19L, 9));
    ul.add(new User(7));
    ul.add(new User(20L, "deleteByMap", 7, 0));

    /*  ID_WORKER ? ID */
    ul.add(new User("8", 8, 1));
    ul.add(new User("9", 9, 1));
    for (User u : ul) {
        rlt = userMapper.insert(u);
    }
    System.err.println("\n--------------insertBatch----------------" + rlt + "\n\n");

    /**
     * ??????
     */
    session.commit();

    /*
     * 
     */
    rlt = userMapper.deleteById(id);
    System.err.println("---------deleteById------- delete id=" + id + " ,result=" + rlt + "\n\n");
    sleep();

    Map<String, Object> columnMap = new HashMap<String, Object>();
    columnMap.put("name", "deleteByMap");
    columnMap.put("age", null);
    rlt = userMapper.deleteByMap(columnMap);
    System.err.println("---------deleteByMap------- result=" + rlt + "\n\n");
    sleep();

    List<Long> il = new ArrayList<Long>();
    il.add(16L);
    il.add(17L);
    rlt = userMapper.deleteBatchIds(il);
    System.err.println("---------deleteBatchIds------- delete id=" + id + " ,result=" + rlt + "\n\n");
    sleep();

    rlt = userMapper.delete(new EntityWrapper<User>(new User(14L, "delname")));
    System.err.println("--------------delete------------------ result=" + rlt + "\n\n");
    sleep();

    /*
     * <p>  </p>
     * 
     * updateById  BaseMapper ?UserMapper.xmlsql
     */
    rlt = userMapper.updateById(new User(12L, "MybatisPlus"));
    System.err.println("------------------updateById---------------------- result=" + rlt + "\n\n");
    sleep();

    rlt = userMapper.updateById(new User(12L, "update all column", 12, 12));
    System.err.println("------------------updateById---------------------- result=" + rlt + "\n\n");
    sleep();

    rlt = userMapper.update(new User("55", 55, 5), new EntityWrapper<User>(new User(15L, "5")));
    System.err.println("------------------update---------------------- result=" + rlt + "\n\n");
    sleep();

    EntityWrapper<User> ew1 = new EntityWrapper<User>();
    ew1.addFilter("test_id={0} AND name={1}", 15L, "55");
    rlt = userMapper.update(new User("00"), ew1);
    System.err.println("------------------update---------------------- result=" + rlt + "\n\n");
    sleep();

    /* ? */
    // userMapper.update(new User("11"), null);

    List<User> userList = new ArrayList<User>();
    userList.add(new User(11L, "updateBatchById-1", 1, 1));
    userList.add(new User(12L, "updateBatchById-2", 2, 1));
    userList.add(new User(13L, "updateBatchById-3", 3, 1));
    for (User u : userList) {
        rlt = userMapper.updateById(u);
    }
    System.err.println("------------------updateBatchById---------------------- result=" + rlt + "\n\n");
    sleep();

    /*
     * <p>  </p>
     */
    System.err.println("\n------------------selectById----------------------");
    User user = userMapper.selectById(12L);
    print(user);

    System.err.println("\n------------------selectBatchIds----------------------");
    List<Long> idList = new ArrayList<Long>();
    idList.add(11L);
    idList.add(12L);
    List<User> ul0 = userMapper.selectBatchIds(idList);
    for (User anUl0 : ul0) {
        print(anUl0);
    }

    System.err.println("\n------------------selectByMap----- map ??----");
    Map<String, Object> cm = new HashMap<String, Object>();
    cm.put("test_type", 1);
    List<User> ul1 = userMapper.selectByMap(cm);
    for (User anUl1 : ul1) {
        print(anUl1);
    }

    System.err.println("\n------------------selectOne----------------------");
    User userOne = userMapper.selectOne(new User("abc"));
    print(userOne);

    System.err.println("\n------------------selectCount----------------------");
    System.err.println(
            " type=1 " + userMapper.selectCount(new EntityWrapper<User>(new User(1))));
    System.err.println("" + userMapper.selectCount(null));

    System.err.println("\n------------------selectList-----?----id--DESC--?----");
    List<User> ul2 = userMapper.selectList(new EntityWrapper<User>(null, "age,name"));
    for (User anUl2 : ul2) {
        print(anUl2);
    }

    System.err.println(
            "\n------------------list  ---- testType = 1 ?--id--DESC--?--------");
    Page<User> page = new Page<User>(1, 2);
    EntityWrapper<User> ew = new EntityWrapper<User>(new User(1));

    /*
     * 
     */
    ew.setSqlSelect("age,name");

    /*
     * ?SQL (?SQL?????)
     */
    ew.where("name like {0}", "'%dateBatch%'").and("age={0}", 3).orderBy("age,name", true);
    List<User> paginList = userMapper.selectPage(page, ew);
    page.setRecords(paginList);
    for (int i = 0; i < page.getRecords().size(); i++) {
        print(page.getRecords().get(i));
    }
    System.err.println(" " + page.toString());

    System.err.println(
            "\n---------------xml---selectListRow ?? count ----?--------------");
    // TODO  Page ??
    List<User> rowList = userMapper.selectListRow(new Pagination(0, 2, false));
    for (User aRowList : rowList) {
        print(aRowList);
    }

    /*
     * 
     */
    System.err.println(" selectList EntityWrapper == null \n");
    paginList = userMapper.selectList(null);
    for (User aPaginList : paginList) {
        print(aPaginList);
    }

    /*
     * <p>
     *  SQL ???
     * </p>
     * <p>
     * ?/mybatis-plus/src/test/java/com/baomidou/mybatisplus/test/SqlBuilderTest.java
     * </p>
     */
    SQL sql = new SQL() {
        {
            SELECT("a.test_id as id, a.name, a.age");
            FROM("user a");
            WHERE("a.test_type=1");
        }
    };
    // SQL ?
    System.err.println(" insertSql  SQL \n");
    rlt = userMapper.insertSql(new SQL() {
        {
            INSERT_INTO("user");
            VALUES("test_id, name, age, test_type", IdWorker.getId() + ", 'testInsertSql', 5, 1");
        }
    }.toString());
    System.err.println("???" + rlt);

    // SQL 
    System.err.println(" selectListSql  SQL \n");
    List<Map<String, Object>> ul3 = userMapper.selectListSql(sql.toString());
    for (Map<String, Object> u : ul3) {
        System.err.println(u);
    }

    // SQL 
    System.err.println(" selectPageSql  SQL \n");
    Page<Map<String, Object>> page3 = new Page<Map<String, Object>>(0, 10);
    List<Map<String, Object>> ml = userMapper.selectPageSql(page3, sql.toString());
    for (Map<String, Object> map : ml) {
        System.err.println(" map " + map);
    }
    System.err.println("" + page3.toString());

    // SQL 
    System.err.println(" deleteSql  SQL \n");
    rlt = userMapper.deleteSql(new SQL() {
        {
            DELETE_FROM("user");
            WHERE("name='testInsertSql'");
        }
    }.toString());
    System.err.println("??" + rlt);

    // SQL 
    System.err.println(" updateSql  SQL \n");
    rlt = userMapper.updateSql(new SQL() {
        {
            UPDATE("user");
            SET("age=6");
            WHERE("test_type=1");
        }
    }.toString());
    System.err.println("???" + rlt);

    /**
     * ?
     */
    rlt = userMapper.deleteAll();
    System.err.println("?? rlt=" + rlt);

    /**
     * ??
     */
    session.commit();
}

From source file:com.mybatisX.test.oracle.TestUserMapperTest.java

License:Apache License

/**
 * //from ww w.ja v  a  2  s .  co  m
 * RUN   MySql  
 * 
 */
public static void main(String[] args) {

    //?
    InputStream in = TestUserMapperTest.class.getClassLoader().getResourceAsStream("oracle-config.xml");

    /*
     *  MybatisSessionFactoryBuilder 
     * SqlSessionFactoryBaseMapper
     */
    MybatisSessionFactoryBuilder mf = new MybatisSessionFactoryBuilder();

    /** ? oracle */
    mf.setDbType("oracle");

    /*
     * 1??????
     * 2?????
     * 3?????
     *    ?? @TableId(value = "test_id") 
     */
    //mf.setDbColumnUnderline(true);

    SqlSessionFactory sessionFactory = mf.build(in);
    SqlSession session = sessionFactory.openSession();
    TestUserMapper testUserMapper = session.getMapper(TestUserMapper.class);
    System.err.println(" debug run  test_user ??? ");
    session.delete("deleteAll");

    /**
     * ?
     */
    int rlt = testUserMapper.insert(new TestUser("10", "abc", 18, 1));
    System.err.println("\n--------------insert-------" + rlt);
    sleep();

    /**
     * ??
     */
    List<TestUser> ul = new ArrayList<TestUser>();
    ul.add(new TestUser("11", "1a", 11, 1));
    ul.add(new TestUser("12", "2a", 12, 2));
    ul.add(new TestUser("a", 1, 1));
    ul.add(new TestUser("b", 2, 2));
    ul.add(new TestUser("c", 3, 1));
    for (TestUser u : ul) {
        rlt = testUserMapper.insert(u);
    }
    System.err.println("\n--------------insertBatch-------" + rlt);
    sleep();

    /**
     * ?
     */
    List<TestUser> ul1 = new ArrayList<TestUser>();
    ul1.add(new TestUser("10", "update-0a", 11, 1));
    ul1.add(new TestUser("11", "update-1a", 11, 1));
    ul1.add(new TestUser("12", "update-2a", 12, 2));
    for (TestUser u : ul1) {
        rlt = testUserMapper.updateById(u);
    }
    System.err.println("\n--------------updateBatchById-------" + rlt);
    sleep();

    System.err.println(
            "\n------------------list  ---- testType = 1 ?--id--DESC--?--------");
    Page<TestUser> page = new Page<TestUser>(1, 2);
    EntityWrapper<TestUser> ew = new EntityWrapper<TestUser>(new TestUser(1), "TEST_ID DESC");
    List<TestUser> paginList = testUserMapper.selectPage(page, ew);
    page.setRecords(paginList);
    for (int i = 0; i < page.getRecords().size(); i++) {
        print(page.getRecords().get(i));
    }
    System.err.println(" " + page.toString());

    /* ?  */
    rlt = session.delete("deleteAll");
    System.err.println("?? rlt=" + rlt);

    /**
     * ??
     */
    session.commit();
}

From source file:com.oneops.cms.test.CmsTest.java

License:Apache License

/**
 * @param args//from ww w  .j  av a 2 s  .  co m
 * @throws IOException 
 * @throws SQLException 
 */
public static void _main(String[] args) throws IOException, SQLException {
    String resource = "mybatis-config.xml";
    Reader reader = Resources.getResourceAsReader(resource);
    SqlSessionFactory sqlsf = new SqlSessionFactoryBuilder().build(reader);

    SqlSession session = sqlsf.openSession();
    CIMapper ciMapper = session.getMapper(CIMapper.class);
    ClazzMapper clMapper = session.getMapper(ClazzMapper.class);
    NSMapper nsMapper = session.getMapper(NSMapper.class);
    RelationMapper rlMapper = session.getMapper(RelationMapper.class);
    CmsCmProcessor cmProcessor = new CmsCmProcessor();

    cmProcessor.setCiMapper(ciMapper);
    cmProcessor.setCmValidator(cmValidator);
    cmProcessor.setCmsNsProcessor(nsMan);

    cmValidator.setCmsMdProcessor(mdMan);
    cmValidator.setCmsNsProcessor(nsMan);

    nsMan.setNsMapper(nsMapper);

    CmsMdProcessor mdProcessor = new CmsMdProcessor();
    mdProcessor.setClazzMapper(clMapper);
    mdProcessor.setRelationMapper(rlMapper);

    try {
        testQueryAttrs(ciMapper);
        //testState(sqlsf);
        //testClazzes(sqlsf);
        //testCreateOrg();
        //testCreateAssembly();
        //testCreatPlatform(sqlsf);
        //int newRelId = testCreateRelation(sqlsf, 1048, 1052);
        //testGetRelation(sqlsf, newRelId);
        //testGetToFromRelation(sqlsf, 1048);
        //testUpdateCI(sqlsf);
        //testDeleteCi(sqlsf);
        //testGetCiById(sqlsf);
        //testGetCi(sqlsf);
        //testCreateClazz(sqlsf);
        //testGetClazz(sqlsf);
        session.commit();
    } finally {
        session.close();
    }
}

From source file:com.oneops.cms.test.DJTests.java

License:Apache License

/**
 * @param args/*  ww w  .ja v a 2  s .c om*/
 * @throws IOException 
 * @throws SQLException 
 */
public static void main(String[] args) throws IOException, SQLException {
    String resource = "mybatis-config.xml";
    Reader reader = Resources.getResourceAsReader(resource);
    SqlSessionFactory sqlsf = new SqlSessionFactoryBuilder().build(reader);

    SqlSession session = sqlsf.openSession();
    CIMapper ciMapper = session.getMapper(CIMapper.class);
    ClazzMapper clMapper = session.getMapper(ClazzMapper.class);
    NSMapper nsMapper = session.getMapper(NSMapper.class);
    RelationMapper rlMapper = session.getMapper(RelationMapper.class);
    DJMapper djMapper = session.getMapper(DJMapper.class);
    CmsRfcProcessor rfcProcessor = new CmsRfcProcessor();
    CmsCmProcessor cmProcessor = new CmsCmProcessor();

    //cmMan.setCiMapper(ciMapper);
    //cmMan.setCmValidator(cmValidator);
    //cmMan.setNsManager(nsProc);

    cmProcessor.setCiMapper(ciMapper);
    cmProcessor.setCmValidator(cmValidator);
    cmProcessor.setCmsNsProcessor(nsProc);

    cmValidator.setCmsMdProcessor(mdProc);
    cmValidator.setCmsNsProcessor(nsProc);

    djValidator.setCmsMdProcessor(mdProc);
    djValidator.setCmsNsProcessor(nsProc);

    nsProc.setNsMapper(nsMapper);

    CmsMdProcessor mdProcessor = new CmsMdProcessor();
    mdProcessor.setClazzMapper(clMapper);
    mdProcessor.setRelationMapper(rlMapper);

    rfcProcessor.setDjMapper(djMapper);
    rfcProcessor.setCmsNsProcessor(nsProc);
    rfcProcessor.setDjValidator(djValidator);
    rfcProcessor.setCiMapper(ciMapper);

    djMan.setRfcProcessor(rfcProcessor);

    CmsCmRfcMrgProcessor cmrfcProcessor = new CmsCmRfcMrgProcessor();
    cmrfcProcessor.setCmProcessor(cmProcessor);
    cmrfcProcessor.setRfcProcessor(rfcProcessor);
    cmrfcProcessor.setDjValidator(djValidator);

    cmdjMan.setCmRfcMrgProcessor(cmrfcProcessor);

    try {
        //testCreateRelease();
        //testUpdateRelease();
        //testCreateRrfcCi();
        //testUpdateRrfcCi();
        //testRmRrfcCi();
        //testGetRfcCi();
        //testCreateRrfcRelation();
        //testUpdateRrfcRelation();
        testGetRfcCI();
        session.commit();
    } finally {
        session.close();
    }
}

From source file:com.onnurimotors.wm.service.WmService.java

public Object visit(HttpServletRequest request) {
    SqlSession session = sqlSession();
    String license = request.getParameter("license").replaceAll("\\s+", "");
    int is_new_customer;
    String title, msg;//  w  ww. j  av a2s  .  c  o m
    Date date = new Date();
    Calendar cal = Calendar.getInstance();
    cal.setTime(date);
    cal.add(Calendar.HOUR_OF_DAY, 9);
    date = cal.getTime();
    DateFormat format_date = new SimpleDateFormat("yyyy-MM-dd");
    DateFormat format_time = new SimpleDateFormat("HH:mm:ss");
    VEHICLE vehicle = new VEHICLE();
    HISTORY history = new HISTORY();
    vehicle.setLICENSE(license);
    vehicle.setVEHICLE_ID(-1);

    // retrieve vehicle list which match license
    ArrayList<VEHICLE> result = (ArrayList<VEHICLE>) session.selectList("watchman.mybatis.selectVehicle",
            vehicle);

    // if there is no matched vehicle
    if (result.size() == 0) {
        vehicle = new VEHICLE();
        vehicle.setIS_NOTIFIABLE(1);
        vehicle.setLICENSE(license);
        vehicle.setMODEL("");
        vehicle.setUSER_NAME("");
        vehicle.setBIRTH("");
        vehicle.setPHONE_NUMBER("");
        vehicle.setCOMMENT("");
        session.insert("watchman.mybatis.insertVehicle", vehicle);
        session.commit();
        is_new_customer = 1;
    } else {
        vehicle = result.get(0);
        is_new_customer = 0;
    }

    history.setVEHICLE_ID(vehicle.getVEHICLE_ID());
    history.setDATE_VISIT(format_date.format(date));
    history.setTIME_VISIT(format_time.format(date));
    session.insert("watchman.mybatis.insertHistory", history);
    session.commit();

    // msg to app used by employee of onnurimotors
    title = "";
    msg = "";
    if (vehicle.getIS_NOTIFIABLE() == 1) {
        if (is_new_customer == 0) {
            title = title + " ?\n";
            msg = msg + " ?\n";
        } else {
            title = title + "?  ?\n";
            msg = msg + " ?\n";
        }
        msg = msg + ": " + vehicle.getLICENSE() + "\n";
        msg = msg + "?: " + vehicle.getMODEL() + "\n";
        msg = msg + "??: " + vehicle.getUSER_NAME() + "\n";
        msg = msg + "??: " + vehicle.getBIRTH() + "\n";
        msg = msg + ": " + vehicle.getCOMMENT() + "\n";

        /*ArrayList<VEHICLE_HISTORY> result2 = (ArrayList<VEHICLE_HISTORY>) session.selectList("watchman.mybatis.selectAllHistoryVehicle", vehicle);
        for(int i = 0; i < result2.size(); i++) {
           msg = msg + result2.get(i).getDATE_VISIT() + " " + result2.get(i).getTIME_VISIT() + "<br />";
        }*/

        PARAMETER_VEHICLE parameter_vehicle = new PARAMETER_VEHICLE();
        parameter_vehicle.setVEHICLE_ID(vehicle.getVEHICLE_ID());
        ArrayList<MANAGEMENT_DATE> result3 = (ArrayList<MANAGEMENT_DATE>) session
                .selectList("watchman.mybatis.selectManagementDateOfVehicle", parameter_vehicle);
        msg = msg + "<? >\n";
        for (int i = 0; i < 10 && i < result3.size(); i++) {
            msg = msg + result3.get(i).getDATE_VISIT() + " " + result3.get(i).getCOMMENT() + "\n";
        }

        ArrayList<EMPLOYEE> employees = (ArrayList<EMPLOYEE>) session
                .selectList("watchman.mybatis.selectReceivers");
        for (int i = 0; i < employees.size(); i++) {
            pService.sendPushNotification(employees.get(i).getKAKAO_ACCOUNT(), title, msg);
            pService.sendPush(employees.get(i).getKAKAO_ACCOUNT(), title, msg);
        }
    }

    session.close();

    // if is_notifiable is false, return empty message
    return msg;
}

From source file:com.onnurimotors.wm.service.WmService.java

public VEHICLE toggleNotifiable(HttpServletRequest request) {
    SqlSession session = sqlSession();
    VEHICLE vehicle = new VEHICLE();
    String is_notifiable = request.getParameter("IS_NOTIFIABLE");
    vehicle.setVEHICLE_ID(Integer.parseInt(request.getParameter("VEHICLE_ID")));
    if (is_notifiable.equals("on")) {
        vehicle.setIS_NOTIFIABLE(0);/*from   w  w  w. j av  a 2 s . co m*/
    } else {
        vehicle.setIS_NOTIFIABLE(1);
    }
    session.update("watchman.mybatis.updateVehicleIsNotifiable", vehicle);
    session.commit();

    session.close();

    return vehicle;
}

From source file:com.onnurimotors.wm.service.WmService.java

public VEHICLE updateVehicleModel(HttpServletRequest request) {
    SqlSession session = sqlSession();
    VEHICLE vehicle = new VEHICLE();
    String model = request.getParameter("MODEL");
    vehicle.setVEHICLE_ID(Integer.parseInt(request.getParameter("VEHICLE_ID")));
    vehicle.setMODEL(model);/* www  .j  a v  a  2  s . co m*/
    session.update("watchman.mybatis.updateVehicleModel", vehicle);
    session.commit();

    session.close();

    return vehicle;
}

From source file:com.onnurimotors.wm.service.WmService.java

public MANAGEMENT submitManagement(HttpServletRequest request) {
    SqlSession session = sqlSession();
    MANAGEMENT management = new MANAGEMENT();
    management.setCOMMENT(request.getParameter("COMMENT"));
    if (request.getParameter("IS_NEW").equals("1")) {
        HISTORY_MANAGEMENT hm = new HISTORY_MANAGEMENT();
        session.insert("watchman.mybatis.insertManagement", management);
        session.commit();
        hm.setMANAGEMENT_ID(management.getMANAGEMENT_ID());
        hm.setDATE_VISIT(request.getParameter("DATE_VISIT"));
        hm.setVEHICLE_ID(Integer.parseInt(request.getParameter("VEHICLE_ID")));
        session.insert("watchman.mybatis.insertHistoryManagement", hm);
        session.commit();//ww w. jav a  2 s. c  o  m
    } else {
        management.setMANAGEMENT_ID(Integer.parseInt(request.getParameter("MANAGEMENT_ID")));
        session.update("watchman.mybatis.updateManagement", management);
        session.commit();
    }
    session.close();

    return management;
}