Insert database mysql get issue

Question

i got issue when i go to Insert value to DB (do nothing). before that i do select table to get last id, and it worked. Here's my Code:

IDBManager dbManager = getParentExtension().getParentZone().getDBManager();
    Connection connection = null;   

    int idRoom = params.getInt("idRoom");
    String betsmall = params.getUtfString("betsmall");
    int Uid  = params.getInt("recid");

    try{
        connection = dbManager.getConnection();
        PreparedStatement stmt = connection.prepareStatement("SELECT id_game from detail_game ORDER BY id_game DESC LIMIT 1");

        ResultSet res = stmt.executeQuery();
        if (!res.first())
        {
            trace("bla bla");
        }

        int id = res.getInt("id_game");
       trace (id);
    //  **till here there is no problem, i can get id from select query

      PreparedStatement stmts = connection.prepareStatement("INSERT INTO detil_bet (id_user, id_room, id_bet, bettype) VALUES (?, ?, ?, ? ");
      stmts.setInt(1, Uid);
      stmts.setInt(2, idRoom);
      stmts.setInt(3, id);
      stmts.setString(4, betsmall);
      stmts.executeUpdate();

    }
}

Here's the problem, insert do nothing.

In the case there is a ) missing you should get an exception?! — Jens
– Jens, Commented Sep 1, 2016 at 8:02

user6781230 · Accepted Answer · 2016-09-01 08:01:22Z

1

PreparedStatement stmts = connection.prepareStatement("INSERT INTO detil_bet (id_user, id_room, id_bet, bettype) VALUES (?, ?, ?, ? ");

Looks like you need some end parentheses in "VALUES".

A catch block to print stack trace would have told you the issue here as well. I'm not the best SQL guy, I always use this to check my SQL syntax as well to double check if I've done everything right.

answered Sep 1, 2016 at 8:01

user6781230

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

Comments

ytang · Accepted Answer · 2016-09-01 08:09:14Z

0

your connection seems not auto commit. Try to add

stmts.commit();

after "stmts.executeUpdate();".

answered Sep 1, 2016 at 8:09

ytang

11 silver badge1 bronze badge

Collectives™ on Stack Overflow

Insert database mysql get issue

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related