gpt4 book ai didi

java - 如何在 SQLite 数据库中存储 DatePicker 时间?我的老是崩溃

转载 作者:行者123 更新时间:2023-12-01 14:44:41 26 4
gpt4 key购买 nike

我使用互联网上的各种资源创建了一个简单的记录保存应用程序。我能够成功存储文本数据 - 但是,当我尝试合并 TimePicker 时,我最终导致整个应用程序崩溃。在上一篇文章中,我被指导如何添加此功能 - 但是当我尝试为时间选择器数据添加字段时,整个应用程序将关闭(当然不会保存数据)

How do I store TimePicker Data in my simple record keeping app?

我被指示(上面的用户)使用以下内容:

CREATE TABLE ...... dtField date, tmpName Text.....

使用以下内容将日期保存为文本

//示例日期格式 - 2013-03-21 13:12:00

android.text.format.DateFormat.format("yyyy-MM-dd hh:mm:ss", dtDate.getTime())

我已经实现了前半部分(我相信)。后半部分我不太确定如何正确实现(我需要帮助的第一件事),并且我的应用程序在进行这些更改后也会强制关闭(我需要帮助的第二件事。)

非常感谢任何解决此问题的帮助! (我有点菜鸟 - 所以说明越详细 - 越好!)

提前致谢,

阿曼尼·斯旺

附注

我根据 Robby Pond 的建议更新了下面的源代码:

替换

编辑文本时间Et与

时间选择器时间Et

但我仍然无法运行下面所示的代码。

有人可以查看一下 logcat 或问题日志,并告诉我您是否能说出目前导致问题的原因吗? Robby Pond 的建议很有帮助,但我对下面的(当前)源代码有更深层次的问题。

附注

我知道错误无法解析为类型通常表示缺少类或可能存在 XML 问题,但错误表示“TimePicker 无法解析为类型”,但是我没有 TimePicker.Java - I只是想使用下面 XML 中编码的时间选择器按钮。

XML:数据输入

<?xml version="1.0" encoding="utf-8"?>
<ScrollView xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="fill_parent"
android:layout_height="wrap_content" android:layout_weight="1">

<LinearLayout android:id="@+id/linearLayout"
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:orientation="vertical"
android:padding="5dp">

<EditText android:id="@+id/nameEdit"
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:imeOptions="actionNext"
android:hint="@string/name_hint"
android:inputType="textPersonName|textCapWords"/>

<EditText android:id="@+id/capEdit"
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:imeOptions="actionNext"
android:hint="@string/cap_hint"
android:inputType="textPersonName|textCapWords"/>

<TextView
android:id="@+id/textView3"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="Data Limit"
android:textColor="#ffffff"
android:textAppearance="?android:textAppearanceMedium" />

<SeekBar
android:id="@+id/seekBar1"
android:layout_width="fill_parent"
android:layout_height="wrap_content" />

<LinearLayout
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:orientation="horizontal" >

<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_weight="1.0"
android:gravity="left"
android:textColor="#ffffff"
android:text="10MB" />

<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_weight="1.0"
android:gravity="right"
android:textColor="#ffffff"
android:text="Unlimited Data" />
</LinearLayout>

<TextView
android:id="@+id/textView3"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="Bandwidth Limit"
android:textColor="#ffffff"
android:textAppearance="?android:textAppearanceMedium" />

<SeekBar
android:id="@+id/seekBar1"
android:layout_width="fill_parent"
android:layout_height="wrap_content" />

<LinearLayout
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:orientation="horizontal" >

<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_weight="1.0"
android:gravity="left"
android:textColor="#ffffff"
android:text="10kbs" />

<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_weight="1.0"
android:textColor="#ffffff"
android:gravity="right"
android:text="Unlimited Bandwidth" />
</LinearLayout>

<TextView
android:id="@+id/TextView02"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:textAppearance="?android:textAppearanceSmall" />

<TextView
android:id="@+id/TextView02"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="WiFi Time Limit"
android:textColor="#ffffff"
android:textAppearance="?android:textAppearanceMedium" />

<TimePicker
android:id="@+id/timeEdit"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_gravity="center"
android:gravity="center"
android:layout_weight="1.0" />

<EditText
android:id="@+id/codeEdit"
android:inputType="textUri"
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:ems="10"
android:lines="1"
android:hint="@string/code_hint"
android:imeOptions="actionNext" />




<Button android:id="@+id/saveBtn"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_marginTop="15dp"
android:layout_gravity="center_horizontal"
android:text="@string/save_btn"/>
</LinearLayout>
</ScrollView>

JAVA:数据输入

package com.nfc.linkingmanager;


import android.app.Activity;
import android.app.AlertDialog;
import android.os.AsyncTask;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;

public class AddEditCountry extends Activity {

private long rowID;
private EditText nameEt;
private EditText capEt;
private EditText codeEt;
private TimePicker timeEt;

@Override
public void onCreate(Bundle savedInstanceState)
{
super.onCreate(savedInstanceState);
setContentView(R.layout.add_country);

nameEt = (EditText) findViewById(R.id.nameEdit);
capEt = (EditText) findViewById(R.id.capEdit);
codeEt = (EditText) findViewById(R.id.codeEdit);
timeEt = (TimePicker) findViewById(R.id.timeEdit);


Bundle extras = getIntent().getExtras();

if (extras != null)
{
rowID = extras.getLong("row_id");
nameEt.setText(extras.getString("name"));
capEt.setText(extras.getString("cap"));
codeEt.setText(extras.getString("code"));
timeEt.setText(extras.getString("time"));
}

Button saveButton =(Button) findViewById(R.id.saveBtn);
saveButton.setOnClickListener(new OnClickListener() {

public void onClick(View v)
{
if (nameEt.getText().length() != 0)
{
AsyncTask<Object, Object, Object> saveContactTask =
new AsyncTask<Object, Object, Object>()
{
@Override
protected Object doInBackground(Object... params)
{
saveContact();
return null;
}

@Override
protected void onPostExecute(Object result)
{
finish();
}
};

saveContactTask.execute((Object[]) null);
}

else
{
AlertDialog.Builder alert = new AlertDialog.Builder(AddEditCountry.this);
alert.setTitle(R.string.errorTitle);
alert.setMessage(R.string.errorMessage);
alert.setPositiveButton(R.string.errorButton, null);
alert.show();
}
}
});
}

private void saveContact()
{
DatabaseConnector dbConnector = new DatabaseConnector(this);

if (getIntent().getExtras() == null)
{
dbConnector.insertContact(nameEt.getText().toString(),
capEt.getText().toString(),
timeEt.getText().toString(),
codeEt.getText().toString());
}
else
{
dbConnector.updateContact(rowID,
nameEt.getText().toString(),
capEt.getText().toString(),
timeEt.getText().toString(),
codeEt.getText().toString());
}
}
}

XML:数据输出

<?xml version="1.0" encoding="utf-8"?>

<TableLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:stretchColumns="1"
android:layout_margin="5dp">

<TableRow>
<TextView
style="@style/StyleLabel"
android:text="@string/name_lbl"/>
<TextView
android:id="@+id/nameText"
style="@style/StyleText"/>
</TableRow>

<TableRow>
<TextView
style="@style/StyleLabel"
android:text="@string/cap_lbl"/>
<TextView
android:id="@+id/capText"
style="@style/StyleText"/>
</TableRow>

<TableRow>
<TextView
style="@style/StyleLabel"
android:text="@string/code_lbl"/>
<TextView
android:id="@+id/codeText"
style="@style/StyleText"/>
</TableRow>
<TableRow>
<TextView
style="@style/StyleLabel"
android:text="Linked Users"/>
<TextView
android:id="@+id/codeText"
style="@style/StyleText"/>
</TableRow>
<TableRow>
<TextView
style="@style/StyleLabel"
android:text="Time Limit"/>
<TextView
android:id="@+id/timeText"
style="@style/StyleText"/>
</TableRow>
</TableLayout>

数据输出:JAVA

import android.app.Activity;
import android.app.AlertDialog;
import android.content.DialogInterface;
import android.content.Intent;
import android.database.Cursor;
import android.os.AsyncTask;
import android.os.Bundle;
import android.view.Menu;
import android.view.MenuInflater;
import android.view.MenuItem;
import android.widget.TextView;

public class ViewCountry extends Activity {

private long rowID;
private TextView nameTv;
private TextView capTv;
private TextView codeTv;
private TextView timeTv;

@Override
public void onCreate(Bundle savedInstanceState)
{
super.onCreate(savedInstanceState);
setContentView(R.layout.view_country);

setUpViews();
Bundle extras = getIntent().getExtras();
rowID = extras.getLong(CountryList.ROW_ID);
}

private void setUpViews() {
nameTv = (TextView) findViewById(R.id.nameText);
capTv = (TextView) findViewById(R.id.capText);
timeTv = (TextView) findViewById(R.id.timeText);
codeTv = (TextView) findViewById(R.id.codeText);
}

@Override
protected void onResume()
{
super.onResume();
new LoadContacts().execute(rowID);
}

private class LoadContacts extends AsyncTask<Long, Object, Cursor>
{
DatabaseConnector dbConnector = new DatabaseConnector(ViewCountry.this);

@Override
protected Cursor doInBackground(Long... params)
{
dbConnector.open();
return dbConnector.getOneContact(params[0]);
}

@Override
protected void onPostExecute(Cursor result)
{
super.onPostExecute(result);

result.moveToFirst();
// get the column index for each data item
int nameIndex = result.getColumnIndex("name");
int capIndex = result.getColumnIndex("cap");
int codeIndex = result.getColumnIndex("code");
int timeIndex = result.getColumnIndex("time");

nameTv.setText(result.getString(nameIndex));
capTv.setText(result.getString(capIndex));
timeTv.setText(result.getString(timeIndex));
codeTv.setText(result.getString(codeIndex));

result.close();
dbConnector.close();
}
}


@Override
public boolean onCreateOptionsMenu(Menu menu)
{
super.onCreateOptionsMenu(menu);
MenuInflater inflater = getMenuInflater();
inflater.inflate(R.menu.view_country_menu, menu);
return true;
}

@Override
public boolean onOptionsItemSelected(MenuItem item)
{
switch (item.getItemId())
{
case R.id.editItem:
Intent addEditContact =
new Intent(this, AddEditCountry.class);

addEditContact.putExtra(CountryList.ROW_ID, rowID);
addEditContact.putExtra("name", nameTv.getText());
addEditContact.putExtra("cap", capTv.getText());
addEditContact.putExtra("time", timeTv.getText());
addEditContact.putExtra("code", codeTv.getText());
startActivity(addEditContact);
return true;

case R.id.deleteItem:
deleteContact();
return true;

default:
return super.onOptionsItemSelected(item);
}
}

private void deleteContact()
{

AlertDialog.Builder alert = new AlertDialog.Builder(ViewCountry.this);

alert.setTitle(R.string.confirmTitle);
alert.setMessage(R.string.confirmMessage);

alert.setPositiveButton(R.string.delete_btn,
new DialogInterface.OnClickListener()
{
public void onClick(DialogInterface dialog, int button)
{
final DatabaseConnector dbConnector =
new DatabaseConnector(ViewCountry.this);

AsyncTask<Long, Object, Object> deleteTask =
new AsyncTask<Long, Object, Object>()
{
@Override
protected Object doInBackground(Long... params)
{
dbConnector.deleteContact(params[0]);
return null;
}

@Override
protected void onPostExecute(Object result)
{
finish();
}
};

deleteTask.execute(new Long[] { rowID });
}
}
);

alert.setNegativeButton(R.string.cancel_btn, null).show();
}
}

数据库连接器JAVA:

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;


public class DatabaseConnector {

private static final String DB_NAME = "WorldCountries";
private SQLiteDatabase database;
private DatabaseOpenHelper dbOpenHelper;

public DatabaseConnector(Context context) {
dbOpenHelper = new DatabaseOpenHelper(context, DB_NAME, null, 1);
}

public void open() throws SQLException
{
//open database in reading/writing mode
database = dbOpenHelper.getWritableDatabase();
}

public void close()
{
if (database != null)
database.close();
}

public void insertContact(String name, String cap, String code, String time)
{
ContentValues newCon = new ContentValues();
newCon.put("name", name);
newCon.put("cap", cap);
newCon.put("time", time);
newCon.put("code", code);

open();
database.insert("country", null, newCon);
close();
}


public void updateContact(long id, String name, String cap,String code, String time)
{
ContentValues editCon = new ContentValues();
editCon.put("name", name);
editCon.put("cap", cap);
editCon.put("time", time);
editCon.put("code", code);

open();
database.update("country", editCon, "_id=" + id, null);
close();
}


public Cursor getAllContacts()
{
return database.query("country", new String[] {"_id", "name"},
null, null, null, null, "name");
}

public Cursor getOneContact(long id)
{
return database.query("country", null, "_id=" + id, null, null, null, null);
}

public void deleteContact(long id)
{
open();
database.delete("country", "_id=" + id, null);
close();
}
}

数据库助手JAVA:

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;

public class DatabaseOpenHelper extends SQLiteOpenHelper {

public DatabaseOpenHelper(Context context, String name,
CursorFactory factory, int version) {
super(context, name, factory, version);
}

@Override
public void onCreate(SQLiteDatabase db) {
String createQuery = "CREATE TABLE country (_id integer primary key autoincrement,name, cap, code, time);";
db.execSQL(createQuery);
}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

}

}

LOGCAT 数据:

03-21 17:17:24.276: I/Adreno200-EGLSUB(8655): <ConfigWindowMatch:2165>: Format RGBA_8888.
03-21 17:17:24.276: D/memalloc(8655): ion: Mapped buffer base:0x5ca41000 size:614400 offset:0 fd:57
03-21 17:17:24.276: E/(8655): Can't open file for reading
03-21 17:17:24.276: E/(8655): Can't open file for reading
03-21 17:17:24.376: D/memalloc(8655): ion: Mapped buffer base:0x5d12e000 size:614400 offset:0 fd:61
03-21 17:17:26.188: D/Activity(8655): Activity.onPause(), editTextTapSensorList size: 0
03-21 17:17:26.268: I/Adreno200-EGLSUB(8655): <ConfigWindowMatch:2165>: Format RGBA_8888.
03-21 17:17:26.278: D/memalloc(8655): ion: Mapped buffer base:0x5d4ce000 size:614400 offset:0 fd:68
03-21 17:17:26.318: D/memalloc(8655): ion: Mapped buffer base:0x5d937000 size:614400 offset:0 fd:72
03-21 17:17:26.328: D/memalloc(8655): ion: Unmapping buffer base:0x5ca41000 size:614400
03-21 17:17:26.328: D/memalloc(8655): ion: Unmapping buffer base:0x5d12e000 size:614400
03-21 17:17:26.468: D/Activity(8655): Activity.onPause(), editTextTapSensorList size: 0
03-21 17:17:26.549: D/memalloc(8655): ion: Mapped buffer base:0x5c929000 size:614400 offset:0 fd:54
03-21 17:17:26.619: W/IInputConnectionWrapper(8655): getExtractedText on inactive InputConnection
03-21 17:17:26.639: W/IInputConnectionWrapper(8655): getExtractedText on inactive InputConnection
03-21 17:17:48.322: D/Activity(8655): Activity.onPause(), editTextTapSensorList size: 0
03-21 17:17:48.342: W/dalvikvm(8655): threadid=1: thread exiting with uncaught exception (group=0x410889d8)
03-21 17:17:48.352: E/AndroidRuntime(8655): FATAL EXCEPTION: main
03-21 17:17:48.352: E/AndroidRuntime(8655): java.lang.Error: Unresolved compilation problems:
03-21 17:17:48.352: E/AndroidRuntime(8655): TimePicker cannot be resolved to a type
03-21 17:17:48.352: E/AndroidRuntime(8655): TimePicker cannot be resolved to a type
03-21 17:17:48.352: E/AndroidRuntime(8655): TimePicker cannot be resolved to a type
03-21 17:17:48.352: E/AndroidRuntime(8655): timeEdit cannot be resolved or is not a field
03-21 17:17:48.352: E/AndroidRuntime(8655): TimePicker cannot be resolved to a type
03-21 17:17:48.352: E/AndroidRuntime(8655): TimePicker cannot be resolved to a type
03-21 17:17:48.352: E/AndroidRuntime(8655): TimePicker cannot be resolved to a type
03-21 17:17:48.352: E/AndroidRuntime(8655): at com.nfc.linkingmanager.AddEditCountry.<init>(AddEditCountry.java:19)
03-21 17:17:48.352: E/AndroidRuntime(8655): at java.lang.Class.newInstanceImpl(Native Method)
03-21 17:17:48.352: E/AndroidRuntime(8655): at java.lang.Class.newInstance(Class.java:1319)
03-21 17:17:48.352: E/AndroidRuntime(8655): at android.app.Instrumentation.newActivity(Instrumentation.java:1025)
03-21 17:17:48.352: E/AndroidRuntime(8655): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1875)
03-21 17:17:48.352: E/AndroidRuntime(8655): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1985)
03-21 17:17:48.352: E/AndroidRuntime(8655): at android.app.ActivityThread.access$600(ActivityThread.java:127)
03-21 17:17:48.352: E/AndroidRuntime(8655): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1151)
03-21 17:17:48.352: E/AndroidRuntime(8655): at android.os.Handler.dispatchMessage(Handler.java:99)
03-21 17:17:48.352: E/AndroidRuntime(8655): at android.os.Looper.loop(Looper.java:137)
03-21 17:17:48.352: E/AndroidRuntime(8655): at android.app.ActivityThread.main(ActivityThread.java:4477)
03-21 17:17:48.352: E/AndroidRuntime(8655): at java.lang.reflect.Method.invokeNative(Native Method)
03-21 17:17:48.352: E/AndroidRuntime(8655): at java.lang.reflect.Method.invoke(Method.java:511)
03-21 17:17:48.352: E/AndroidRuntime(8655): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:788)
03-21 17:17:48.352: E/AndroidRuntime(8655): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:555)
03-21 17:17:48.352: E/AndroidRuntime(8655): at dalvik.system.NativeStart.main(Native Method)

问题:

    Description Resource    Path    Location    Type
user3SettingsSave cannot be resolved or is not a field User3Settings.java /NFC Linking Manager/src/com/nfc/linkingmanager line 35 Java Problem
The import android.content.Context is never used AppActivity.java /NFC Linking Manager/src/com/nfc/linkingmanager line 5 Java Problem
The import android.view.View.OnClickListener is never used AppActivity.java /NFC Linking Manager/src/com/nfc/linkingmanager line 13 Java Problem
The value of the field AppActivity.button1 is not used AppActivity.java /NFC Linking Manager/src/com/nfc/linkingmanager line 18 Java Problem
The value of the field AppActivity.button2 is not used AppActivity.java /NFC Linking Manager/src/com/nfc/linkingmanager line 18 Java Problem
user3Tap cannot be resolved to a type User3Settings.java /NFC Linking Manager/src/com/nfc/linkingmanager line 40 Java Problem
The value of the field AppActivity.button3 is not used AppActivity.java /NFC Linking Manager/src/com/nfc/linkingmanager line 18 Java Problem
TimePicker cannot be resolved to a type AddEditCountry.java /NFC Linking Manager/src/com/nfc/linkingmanager line 19 Java Problem
TimePicker cannot be resolved to a type AddEditCountry.java /NFC Linking Manager/src/com/nfc/linkingmanager line 30 Java Problem
TimePicker cannot be resolved to a type AddEditCountry.java /NFC Linking Manager/src/com/nfc/linkingmanager line 30 Java Problem
The method deactivate() from the type Cursor is deprecated CountryList.java /NFC Linking Manager/src/com/nfc/linkingmanager line 52 Java Problem
The constructor SimpleCursorAdapter(Context, int, Cursor, String[], int[]) is deprecated CountryList.java /NFC Linking Manager/src/com/nfc/linkingmanager line 33 Java Problem
The import android.app.AlertDialog is never used User1.java /NFC Linking Manager/src/com/nfc/linkingmanager line 4 Java Problem
The import android.view.View.OnClickListener is never used User1.java /NFC Linking Manager/src/com/nfc/linkingmanager line 12 Java Problem
The method deactivate() from the type Cursor is deprecated NewCore.java /NFC Linking Manager/src/com/nfc/linkingmanager line 54 Java Problem
The constructor SimpleCursorAdapter(Context, int, Cursor, String[], int[]) is deprecated NewCore.java /NFC Linking Manager/src/com/nfc/linkingmanager line 35 Java Problem
The import android.content.DialogInterface is never used User1.java /NFC Linking Manager/src/com/nfc/linkingmanager line 6 Java Problem
The import android.widget.Button is never used Link.java /NFC Linking Manager/src/com/nfc/linkingmanager line 5 Java Problem
The import android.content.Intent is never used Link.java /NFC Linking Manager/src/com/nfc/linkingmanager line 6 Java Problem
The import android.view.View.OnClickListener is never used User1Settings.java /NFC Linking Manager/src/com/nfc/linkingmanager line 10 Java Problem
The import android.view.View is never used Link.java /NFC Linking Manager/src/com/nfc/linkingmanager line 7 Java Problem
The import android.view.View.OnClickListener is never used Link.java /NFC Linking Manager/src/com/nfc/linkingmanager line 8 Java Problem
TimePicker cannot be resolved to a type AddEditCountry.java /NFC Linking Manager/src/com/nfc/linkingmanager line 99 Java Problem
TimePicker cannot be resolved to a type AddEditCountry.java /NFC Linking Manager/src/com/nfc/linkingmanager line 91 Java Problem
TimePicker cannot be resolved to a type AddEditCountry.java /NFC Linking Manager/src/com/nfc/linkingmanager line 41 Java Problem
timeEdit cannot be resolved or is not a field AddEditCountry.java /NFC Linking Manager/src/com/nfc/linkingmanager line 30 Java Problem
The method showDialog(int) from the type Activity is deprecated User2Settings.java /NFC Linking Manager/src/com/nfc/linkingmanager line 37 Java Problem

最佳答案

timeEt 字段应该是一个 TimePicker。您收到 ClassCastException 是因为在您的 Activity 中您将其声明为 EditText。

替换

EditText timeEt

TimePicker timeEt

关于java - 如何在 SQLite 数据库中存储 DatePicker 时间?我的老是崩溃,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/15557209/

26 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com