android java.lang.RuntimeException:无法启动活动ComponentInfo

f4t66c6m  于 2022-12-21  发布在  Android
关注(0)|答案(1)|浏览(172)
**java.lang.RuntimeException: Unable to start activity ComponentInfo{com.ardaak.nottutma/com.ardaak.nottutma.MainActivity}: android.database.sqlite.SQLiteException: near "TABLENot": syntax error (code 1 SQLITE_ERROR): , while compiling: CREATE TABLENot(Counter INTEGER PRIMARY KEY AUTOINCREMENT, id INT, baslik TEXT, aciklama TEXT, silinmisTEXT)
at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:3449)
at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:3601)
at android.app.servertransaction.LaunchActivityItem.execute(LaunchActivityItem.java:85)
at android.app.servertransaction.TransactionExecutor.executeCallbacks(TransactionExecutor.java:135)
at android.app.servertransaction.TransactionExecutor.execute(TransactionExecutor.java:95)
at android.app.ActivityThread$H.handleMessage(ActivityThread.java:2066)
at android.os.Handler.dispatchMessage(Handler.java:106)
at android.os.Looper.loop(Looper.java:223)
at android.app.ActivityThread.main(ActivityThread.java:7656)
at java.lang.reflect.Method.invoke(Native Method)
at com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:592)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:947)
Caused by: android.database.sqlite.SQLiteException: near "TABLENot": syntax error (code 1 SQLITE_ERROR): , while compiling: CREATE TABLENot(Counter INTEGER PRIMARY KEY AUTOINCREMENT, id INT, baslik TEXT, aciklama TEXT, silinmisTEXT)
at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:1045)
at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:652)
at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:590)
at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:61)
at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:33)
at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1919)
at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1841)
at com.ardaak.nottutma.SQLite.onCreate(SQLite.java:68)
at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:411)
at android.database.sqlite.SQLiteOpenHelper.getReadableDatabase(SQLiteOpenHelper.java:340)
# ```at com.ardaak.nottutma.SQLite.populateNotListArray(SQLite.java:101)
at com.ardaak.nottutma.MainActivity.VeritabanindanMemorye(MainActivity.java:45)
at com.ardaak.nottutma.MainActivity.onCreate(MainActivity.java:20)
at android.app.Activity.performCreate(Activity.java:8000)
at android.app.Activity.performCreate(Activity.java:7984)
at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1309)
at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:3422)
at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:3601) 
at android.app.servertransaction.LaunchActivityItem.execute(LaunchActivityItem.java:85) 
at android.app.servertransaction.TransactionExecutor.executeCallbacks(TransactionExecutor.java:135) 
at android.app.servertransaction.TransactionExecutor.execute(TransactionExecutor.java:95) 
at android.app.ActivityThread$H.handleMessage(ActivityThread.java:2066) 
at android.os.Handler.dispatchMessage(Handler.java:106) 
at android.os.Looper.loop(Looper.java:223) 
at android.app.ActivityThread.main(ActivityThread.java:7656) 
at java.lang.reflect.Method.invoke(Native Method) 
at com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:592) 
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:947) 
2022-12-19 03:24:15.800 9217-9217/com.ardaak.nottutma I/Process: Sending signal. PID: 9217 SIG: 9**

这里是MainActivity.java**

package com.ardaak.nottutma;

import androidx.appcompat.app.AppCompatActivity;

import android.content.Intent;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;
import android.widget.ListView;

public class MainActivity extends AppCompatActivity
{
    private ListView notListview;
    @Override
    protected void onCreate(Bundle savedInstanceState)
    {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        initWidgets();
        VeritabanindanMemorye();
        setNotUyarlama();
    }

    private void setNotUyarlama()
    {
        NotUyarlama notUyarlama = new NotUyarlama(getApplicationContext(),Not.notArrayList);
        notListview.setAdapter(notUyarlama);
    }

    private void initWidgets()
    {
        notListview = findViewById(R.id.lstNotlarim);
    }

    public void YeniNot(View view)
    {
        Intent YeniNotIntent = new Intent(this,NotDuzenleme.class);
        startActivity(YeniNotIntent);
    }
    public void VeritabanindanMemorye()
    {
        SQLite sqLite = SQLite.instanceOfDatabase(this);
        sqLite.populateNotListArray();
    }
}

这是主活动. xml

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout
    xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:tools="http://schemas.android.com/tools"
    android:orientation="vertical"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    tools:context=".MainActivity">

    <androidx.appcompat.widget.Toolbar
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:background="@color/KoyuYesil"
        android:minHeight="?actionBarSize"
        android:theme="?actionBarTheme">

        <TextView
            android:id="@+id/txtNotlarim"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:layout_gravity="center"
            android:text="NOTLARIM"
            android:textColor="@color/Gri"
            android:textSize="50sp"
            android:textStyle="bold" />
        <Button
            android:id="@+id/btnEkle"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:layout_gravity="end"
            android:onClick="YeniNot"
            android:text="Ekle +"
            android:textColor="@color/Sari" />

    </androidx.appcompat.widget.Toolbar>

    <ListView
        android:id="@+id/lstNotlarim"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:layout_marginTop="3dp"
        android:divider="@color/teal_700"
        android:dividerHeight="4dp" />

</LinearLayout>

NotDuzenleme类与其NoteDetailActivity类相同

import androidx.appcompat.app.AppCompatActivity;
    import android.os.Bundle;
    import android.view.View;
    import android.widget.EditText;
    
    public class NotDuzenleme extends AppCompatActivity
    {
        private EditText baslikEditText,aciklamaEditText;
    
        @Override
        protected void onCreate(Bundle savedInstanceState) {
            super.onCreate(savedInstanceState);
            setContentView(R.layout.activity_not_duzenleme);
            initWidgets();
        }
    
        private void initWidgets()
        {
            baslikEditText = findViewById(R.id.editBaslik);
            aciklamaEditText = findViewById(R.id.editNot);
        }
    
        public void KaydetNot(View view)
        {
            SQLite sqLite = SQLite.instanceOfDatabase(this);
            String baslik = String.valueOf(baslikEditText.getText());
            String aciklama = String.valueOf(aciklamaEditText.getText());
    
            int id = Not.notArrayList.size();
            Not yeniNot = new Not(id,baslik,aciklama);
            Not.notArrayList.add(yeniNot);
            sqLite.DatabaseNotEkle(yeniNot);
            finish();
        }
    }

**This is the NotUyarlama class NoteAdapter  class in his video**

    import android.content.Context;
    import android.view.LayoutInflater;
    import android.view.View;
    import android.view.ViewGroup;
    import android.widget.ArrayAdapter;
    import android.widget.TextView;
    
    import androidx.annotation.NonNull;
    import androidx.annotation.Nullable;
    
    import org.w3c.dom.Text;
    
    import java.util.ArrayList;
    import java.util.List;
    
    public class NotUyarlama extends ArrayAdapter<Not>
    {
        public NotUyarlama(Context context, List<Not> nots)
        {
            super(context, 0, nots);
    
        }
    
        @NonNull
        @Override
        public View getView(int position, @Nullable View convertView, @NonNull ViewGroup parent)
        {
            Not not = getItem(position);
            if(convertView == null)
                convertView = LayoutInflater.from(getContext()).inflate(R.layout.not_hucreleri,parent,false);
    
            TextView baslik = convertView.findViewById(R.id.txtBaslik);
            TextView aciklama = convertView.findViewById(R.id.txtAciklama);
    
            baslik.setText(not.getBaslik());
            aciklama.setText(not.getAciklama());
    
    
            return convertView;
        }
    }

注解类

import java.util.ArrayList;
import java.util.Date;

public class Not {

    public static ArrayList<Not> notArrayList = new ArrayList<>();

    private int id;
    private String baslik;
    private String aciklama;
    private Date silinmis;

    public Not(int id, String baslik, String aciklama, Date silinmis) {
        this.id = id;
        this.baslik = baslik;
        this.aciklama = aciklama;
        this.silinmis = silinmis;
    }

    public Not(int id, String baslik, String aciklama) {
        this.id = id;
        this.baslik = baslik;
        this.aciklama = aciklama;
        silinmis =null;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getBaslik() {
        return baslik;
    }

    public void setBaslik(String baslik) {
        this.baslik = baslik;
    }

    public String getAciklama() {
        return aciklama;
    }

    public void setAciklama(String aciklama) {
        this.aciklama = aciklama;
    }

    public Date getSilinmis() {
        return silinmis;
    }

    public void setSilinmis(Date silinmis) {
        this.silinmis = silinmis;
    }
}

SQLite类

import android.annotation.SuppressLint;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;

public class SQLite extends SQLiteOpenHelper
{
    private static SQLite sqLite;
    private static final String DATABASE_NAME = "NotDB";
    private static final int DATABASE_VERSION = 1;
    private static final String TABLE_NAME = "NotList";
    private static final String COUNTER = "Counter";

    private static final String ID_FIELD = "id";
    private static final String BASLIK_FIELD = "baslik";
    private static final String ACIKLAMA_FIELD = "aciklama";
    private static final String SILINMIS_FIELD = "silinmis";

    @SuppressLint("SimpleDateFormat")
    private static final DateFormat dateFormat = new SimpleDateFormat("MM-dd-yyyy HH:mm:ss");

    public SQLite(Context context)
    {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }

    public static SQLite instanceOfDatabase(Context context)
    {
        if(sqLite == null)
            sqLite = new SQLite(context);

        return sqLite;
    }



    @Override
    public void onCreate(SQLiteDatabase sqLiteDatabase)
    {
        StringBuilder sql;
        sql = new StringBuilder()
                .append("CREATE TABLE")
                .append(TABLE_NAME)
                .append("(")
                .append(COUNTER)
                .append(" INTEGER PRIMARY KEY AUTOINCREMENT, ")
                .append(ID_FIELD)
                .append(" INT ")
                .append(BASLIK_FIELD)
                .append(" TEXT, ")
                .append(ACIKLAMA_FIELD)
                .append(" TEXT, ")
                .append(SILINMIS_FIELD)
                .append("TEXT)");
        sqLiteDatabase.execSQL(sql.toString());

    }

    @Override
    public void onUpgrade(SQLiteDatabase sqLiteDatabase, int oldVersion, int newVersion)
    {
//        switch (oldVersion)
//        {
//            case 1:
//               sqLiteDatabase.execSQL("ALTER TABLE " + TABLE_NAME + " ADD COLUMN " + NEW_COLUMN + " TEXT");
//            case 2:
//                sqLiteDatabase.execSQL("ALTER TABLE " + TABLE_NAME + " ADD COLUMN " + NEW_COLUMN + " TEXT");
//        }
    }
    public void DatabaseNotEkle(Not not)
    {
        SQLiteDatabase sqLiteDatabase = this.getWritableDatabase();

        ContentValues contentValues = new ContentValues();
        contentValues.put(ID_FIELD,not.getId());
        contentValues.put(BASLIK_FIELD,not.getBaslik());
        contentValues.put(ACIKLAMA_FIELD,not.getAciklama());
        contentValues.put(SILINMIS_FIELD, getStringFromDate(not.getSilinmis()));
        
        sqLiteDatabase.insert(TABLE_NAME,null,contentValues);

    }

        public void populateNotListArray()
        {
            SQLiteDatabase sqLiteDatabase = this.getReadableDatabase();

         try  (Cursor result = sqLiteDatabase.rawQuery("SELECT * FROM " + TABLE_NAME, null))
         {
             if(result.getCount() != 0)
             {
                 while(result.moveToNext())
                 {
                     int id = result.getInt(1);
                     String baslik=result.getString(2);
                     String aciklama=result.getString(3);
                     String silinmisString=result.getString(4);
                     Date silinmis = getDateFromString(silinmisString);
                     Not not = new Not(id,baslik,aciklama,silinmis);
                     Not.notArrayList.add(not);
                 }
             }
         }
        }

    private void NotGuncelle (Not not)
    {
        SQLiteDatabase sqLiteDatabase = this.getWritableDatabase();
        ContentValues contentValues = new ContentValues();
        contentValues.put(ID_FIELD,not.getId());
        contentValues.put(BASLIK_FIELD,not.getBaslik());
        contentValues.put(ACIKLAMA_FIELD,not.getAciklama());
        contentValues.put(SILINMIS_FIELD,getStringFromDate(not.getSilinmis()));

        sqLiteDatabase.update(TABLE_NAME, contentValues, ID_FIELD + " =? ",new String[]{String.valueOf(not.getId())});

    }

    private String getStringFromDate(Date date)
    {
        if(date == null)
            return null;
        return dateFormat.format(date);
    }
    private Date getDateFromString(String string)
    {
        try{
            return dateFormat.parse(string);
        }
        catch (ParseException | NullPointerException e)
        {
            return null;
        }

    }
}

https://www.youtube.com/watch?v=4k1ZMpO9Zn0&t=732s我试图做这个应用程序，他做的一切，在一个视频中，我做了14：12，然后他测试保存数据到数据库，我猜他运行设备，但当我试图运行设备时，我遇到了问题，我的应用程序不断停止，我不能运行它，我像他一样使用SQLite，它在Android工作室.

android

1条答案

按热度按时间
pcww981p

pcww981p1#

您的代码有一个问题。
在创建表时，SQL中缺少了一个空格，因此假设您将表重命名为NotEntity，代码如下所示：

import android.annotation.SuppressLint;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;

public class SQLite extends SQLiteOpenHelper
{
    private static SQLite sqLite;
    private static final String DATABASE_NAME = "NotDB";
    private static final int DATABASE_VERSION = 1;
    private static final String TABLE_NAME = "NotList";
    private static final String COUNTER = "Counter";

    private static final String ID_FIELD = "id";
    private static final String BASLIK_FIELD = "baslik";
    private static final String ACIKLAMA_FIELD = "aciklama";
    private static final String SILINMIS_FIELD = "silinmis";

    @SuppressLint("SimpleDateFormat")
    private static final DateFormat dateFormat = new SimpleDateFormat("MM-dd-yyyy HH:mm:ss");

    public SQLite(Context context)
    {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }

    public static SQLite instanceOfDatabase(Context context)
    {
        if(sqLite == null)
            sqLite = new SQLite(context);

        return sqLite;
    }



    @Override
    public void onCreate(SQLiteDatabase sqLiteDatabase)
    {
        StringBuilder sql;
        sql = new StringBuilder()
                .append("CREATE TABLE ")
                .append(TABLE_NAME)
                .append(" (")
                .append(COUNTER)
                .append(" INTEGER PRIMARY KEY AUTOINCREMENT, ")
                .append(ID_FIELD)
                .append(" INT ")
                .append(BASLIK_FIELD)
                .append(" TEXT, ")
                .append(ACIKLAMA_FIELD)
                .append(" TEXT, ")
                .append(SILINMIS_FIELD)
                .append("TEXT)");
        sqLiteDatabase.execSQL(sql.toString());

    }

    @Override
    public void onUpgrade(SQLiteDatabase sqLiteDatabase, int oldVersion, int newVersion)
    {
//        switch (oldVersion)
//        {
//            case 1:
//               sqLiteDatabase.execSQL("ALTER TABLE " + TABLE_NAME + " ADD COLUMN " + NEW_COLUMN + " TEXT");
//            case 2:
//                sqLiteDatabase.execSQL("ALTER TABLE " + TABLE_NAME + " ADD COLUMN " + NEW_COLUMN + " TEXT");
//        }
    }
    public void DatabaseNotEkle(Not not)
    {
        SQLiteDatabase sqLiteDatabase = this.getWritableDatabase();

        ContentValues contentValues = new ContentValues();
        contentValues.put(ID_FIELD,not.getId());
        contentValues.put(BASLIK_FIELD,not.getBaslik());
        contentValues.put(ACIKLAMA_FIELD,not.getAciklama());
        contentValues.put(SILINMIS_FIELD, getStringFromDate(not.getSilinmis()));
        
        sqLiteDatabase.insert(TABLE_NAME,null,contentValues);

    }

        public void populateNotListArray()
        {
            SQLiteDatabase sqLiteDatabase = this.getReadableDatabase();

         try  (Cursor result = sqLiteDatabase.rawQuery("SELECT * FROM " + TABLE_NAME, null))
         {
             if(result.getCount() != 0)
             {
                 while(result.moveToNext())
                 {
                     int id = result.getInt(1);
                     String baslik=result.getString(2);
                     String aciklama=result.getString(3);
                     String silinmisString=result.getString(4);
                     Date silinmis = getDateFromString(silinmisString);
                     Not not = new Not(id,baslik,aciklama,silinmis);
                     Not.notArrayList.add(not);
                 }
             }
         }
        }

    private void NotGuncelle (Not not)
    {
        SQLiteDatabase sqLiteDatabase = this.getWritableDatabase();
        ContentValues contentValues = new ContentValues();
        contentValues.put(ID_FIELD,not.getId());
        contentValues.put(BASLIK_FIELD,not.getBaslik());
        contentValues.put(ACIKLAMA_FIELD,not.getAciklama());
        contentValues.put(SILINMIS_FIELD,getStringFromDate(not.getSilinmis()));

        sqLiteDatabase.update(TABLE_NAME, contentValues, ID_FIELD + " =? ",new String[]{String.valueOf(not.getId())});

    }

    private String getStringFromDate(Date date)
    {
        if(date == null)
            return null;
        return dateFormat.format(date);
    }
    private Date getDateFromString(String string)
    {
        try{
            return dateFormat.parse(string);
        }
        catch (ParseException | NullPointerException e)
        {
            return null;
        }

    }
}
赞(0）分享  回复(0）举报  2022-12-21
我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com