Как выполнить вставку SQL в Java

Я пытаюсь вставить данные в таблицу с первичным ключом автоматического увеличения. Моя структура таблицы такова:

int:PK varchar:Item_ID varchar:Item_name int:FK_type 

Когда я попробую подготовленное заявление:

 prep = conn.prepareStatement("insert into Inventory values (?, ?, ?);"); 

Я получаю эту ошибку:

 Exception in thread "main" java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (table Inventory has 4 columns but 3 values were supplied) at org.sqlite.DB.newSQLException(DB.java:383) at org.sqlite.DB.newSQLException(DB.java:387) at org.sqlite.DB.throwex(DB.java:374) at org.sqlite.NativeDB.prepare(Native Method) at org.sqlite.DB.prepare(DB.java:123) at org.sqlite.PrepStmt.<init>(PrepStmt.java:42) at org.sqlite.Conn.prepareStatement(Conn.java:404) at org.sqlite.Conn.prepareStatement(Conn.java:399) at org.sqlite.Conn.prepareStatement(Conn.java:383) at org.checkout.CheckInventory.<init>(CheckInventory.java:58) at org.checkout.main.main(main.java:18) 

Когда я пытаюсь выполнить утверждение:

 stat.executeUpdate("insert into Inventory (Item_ID, Item_name, FK_type ) values ('TP1', 'NX Tripod 1', 2)"); 

Я получаю эту ошибку:

 java.sql.SQLException: [SQLITE_MISUSE] Library used incorrectly (out of memory) at org.sqlite.DB.newSQLException(DB.java:383) at org.sqlite.DB.newSQLException(DB.java:387) at org.sqlite.DB.throwex(DB.java:374) at org.sqlite.NativeDB._exec(Native Method) at org.sqlite.Stmt.executeUpdate(Stmt.java:152) at org.checkout.CheckInventory.insertItem(CheckInventory.java:73) at org.checkout.CheckInventory$1.actionPerformed(CheckInventory.java:25) at javax.swing.AbstractButton.fireActionPerformed(Unknown Source) at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.setPressed(Unknown Source) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source) at java.awt.Component.processMouseEvent(Unknown Source) at javax.swing.JComponent.processMouseEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Window.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEventImpl(Unknown Source) at java.awt.EventQueue.access$200(Unknown Source) at java.awt.EventQueue$3.run(Unknown Source) at java.awt.EventQueue$3.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source) at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source) at java.awt.EventQueue$4.run(Unknown Source) at java.awt.EventQueue$4.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) 

Что я делаю не так?

Редактировать:

Я получаю ошибку [SQLITE_MISUSE], когда я пытаюсь добавить четыре столбца в оператор.

Вот метод, который вводит данные

 protected static void insertItem() throws Exception { stat.execute("insert into Inventory (Item_ID, Item_name, FK_type ) values ('TP1', 'NX Tripod 1', 2)"); } 

Ваша таблица имеет четыре столбца, и ваши вставки только вставляют три значения. Попробуйте удалить столбец из таблицы или, альтернативно, вставить четыре значения при вставке строки.