java - 插入数据库mysql获取问题

Question

当我转到将值插入数据库(不执行任何操作)时遇到问题。在此之前，我选择表来获取最后一个ID，并且它有效。 这是我的代码:

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();

    }
}

问题来了，插入什么也不做。

Answer 1

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

看起来“VALUES”中需要一些结束括号。

打印堆栈跟踪的 catch block 也会告诉您这里的问题。我不是最好的 SQL 专家，我总是使用 this检查我的 SQL 语法，并仔细检查我是否做对了一切。