mybatis integer data update, no effect

Question

public int createCountry(String countryCode) {
    // TODO Auto-generated method stub
    SqlSession session = null;
    boolean commit = false;

    int result = 0;

    //System.out.println("바보 :" + countryCode);
    try {
        session = dbutil.getSqlSession();
        result = session.update("board.updateIsCreate", countryCode);
    } finally {
        dbutil.closeSqlSession(session, commit);
    }
    System.out.println("count" + result);

    return result;
}

Here's my DapIml.java

<update id="updateIsCreate" parameterType="String">
    UPDATE country
    SET isCreated = '1'
</update>

and, This is my mapper.xml.

I already checked update's return value is correct, but it has no effect in my database. isCreated value is not changed to '1'. Any suggestion on how to achieve this? I will appreciate for your help.

show your closeSqlSession method from dbUtil

Prasanna Kumar H A
– Prasanna Kumar H A

2017-01-02 09:16:55 +00:00
Commented Jan 2, 2017 at 9:16 — Prasanna Kumar H A
– Prasanna Kumar H A, Commented Jan 2, 2017 at 9:16

정동구 · Accepted Answer · 2016-12-17 17:03:29Z

0

Sorry, I didn't write commit code...

I modified my daoImplement code like this :

public int createCountry(CountryVo countryVo) {
    // TODO Auto-generated method stub
    SqlSession session = null;
    boolean commit = false;

    int result = 0;

    //System.out.println("바보 :" + countryCode);
    try {
        session = dbutil.getSqlSession();
        result = session.update("board.updateIsCreate", countryVo);
        commit = result > 0 ? true : false;
    } finally {
        dbutil.closeSqlSession(session, commit);
    }
    System.out.println("count" + result);

    return result;
}

answered Dec 17, 2016 at 17:03

정동구

1

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

mybatis integer data update, no effect

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related