06-21 23:42:27.179: E/AndroidRuntime(2998): android.database.sqlite.SQLiteException: near "', 12, '": syntax error (code 1): , while compiling: INSERT INTO Ingredient VALUES(null, 'app',12', 12, 'dd');

06-21 23:42:27.179: E/AndroidRuntime(2998): at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)

06-21 23:42:27.179: E/AndroidRuntime(2998): at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:889)

06-21 23:42:27.179: E/AndroidRuntime(2998): at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:500)

06-21 23:42:27.179: E/AndroidRuntime(2998): at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)

06-21 23:42:27.179: E/AndroidRuntime(2998): at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)

06-21 23:42:27.179: E/AndroidRuntime(2998): at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)

06-21 23:42:27.179: E/AndroidRuntime(2998): at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1677)

06-21 23:42:27.179: E/AndroidRuntime(2998): at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1608)

06-21 23:42:27.179: E/AndroidRuntime(2998): at com.example.test01.SQLiteHelper.insert(SQLiteHelper.java:38)

06-21 23:42:27.179: E/AndroidRuntime(2998): at com.example.test01.MainActivity$1.onClick(MainActivity.java:49)

06-21 23:42:27.179: E/AndroidRuntime(2998): at android.view.View.performClick(View.java:5637)

06-21 23:42:27.179: E/AndroidRuntime(2998): at android.view.View$PerformClick.run(View.java:22429)

06-21 23:42:27.179: E/AndroidRuntime(2998): at android.os.Handler.handleCallback(Handler.java:751)

06-21 23:42:27.179: E/AndroidRuntime(2998): at android.os.Handler.dispatchMessage(Handler.java:95)

06-21 23:42:27.179: E/AndroidRuntime(2998): at android.os.Looper.loop(Looper.java:154)

06-21 23:42:27.179: E/AndroidRuntime(2998): at android.app.ActivityThread.main(ActivityThread.java:6119)

06-21 23:42:27.179: E/AndroidRuntime(2998): at java.lang.reflect.Method.invoke(Native Method)

06-21 23:42:27.179: E/AndroidRuntime(2998): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:886)

06-21 23:42:27.179: E/AndroidRuntime(2998): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:776)



이게다에러라니ㅡㅡㅡㅡㅜㅡ해결어떻게해



Button insert = (Button) findViewById(R.id.insert);
insert.setOnClickListener(new View.OnClickListener() {
@Override
 public void onClick(View v) {
String name = edName.getText().toString();
int qty = Integer.parseInt(edQty.getText().toString());
int date = Integer.parseInt(edDate.getText().toString());
String cate = edCate.getText().toString();

Helper.insert(name, qty, date,cate);

// result.setText(Helper.getResult());
 }
});