android.database.sqlite.SQLiteException附近DATABASE_TABLE_NAME语法错误（code：1）在编译organizationSetup
问题描述：
我正在开发中，我创建了一个活动的Android应用程序，在活动二textviews我一直表示只是Activity.java行//会话select_category页面如下：
I am developing an android app in which i created one activity, in that activity two textviews i have kept shown just below the line //Session For select_category page in Activity.java :
previously我已成立这个TextView的日期和时间，但现在我取的数据库值，是从getMandaliName（）方法曼达的名称，试图保持，在这个TextView的，那也仍然是显示日期和时间我设置before.I不知道为什么它显示previously组数据上，而不是TextView中显示的TextView的上所取得的数据。
我Activity.java是在这里：
Previously i had set on this textview the date and time, but now i am fetching value from database that is name of mandali from getMandaliName() method and trying to keep that on this textview, then also it is still showing the date and time that i set before.I don't know why it is showing previously set data on the textview instead of showing the fetched data on textview. My Activity.java is here:
package com.bis.localsale;
import java.security.PublicKey;
import com.bis.localsale.util.CommonUtil;
import com.bis.localsale.R;
import android.annotation.SuppressLint;
import android.app.Activity;
import android.app.AlertDialog;
import android.content.Context;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.text.Editable;
import android.text.InputFilter;
import android.text.InputType;
import android.text.TextWatcher;
import android.util.DisplayMetrics;
import android.view.Display;
import android.view.Menu;
import android.view.MenuInflater;
import android.view.MenuItem;
import android.view.View;
import android.view.WindowManager;
import android.widget.Button;
import android.widget.EditText;
import android.widget.RadioButton;
import android.widget.RadioGroup;
import android.widget.TextView;
import android.widget.Toast;
public class SelectCategory extends Activity {
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.select_category);
DBHelper db = new DBHelper(this);
Button btnMandaliName = (Button) findViewById(R.id.mandali_name);
final String mandali = db.getMandaliName();
System.out.println(mandali);
Toast.makeText(getApplicationContext(),mandali,
Toast.LENGTH_SHORT).show();
btnMandaliName.setText(mandali);
//Session For select_category page
TextView txtSession = (TextView) findViewById(R.id.txtSession);
txtSession.setText(mandali);
TextView textTime = (TextView) findViewById(R.id.txtTime);
textTime.setText(mandali);
DisplayMetrics dmAdmin =new DisplayMetrics();
WindowManager windowManager = (WindowManager) this.getSystemService(this.WINDOW_SERVICE);
Display display = windowManager.getDefaultDisplay();
int width = display.getWidth();
int height = display.getHeight();
final EditText editTextLitre = (EditText) findViewById(R.id.edit_text_litre);
editTextLitre.setInputType(InputType.TYPE_CLASS_NUMBER);
final TextView tvwAmount = (TextView)findViewById(R.id.amount);
editTextLitre.addTextChangedListener(new TextWatcher() {
@Override
public void onTextChanged(CharSequence s, int start, int before, int count) {
// TODO Auto-generated method stub
if(s.length()>0){
if(s.length()<5){
String text = String.valueOf(Float.valueOf(s.toString())*10);
tvwAmount.setText(text);
Toast.makeText(getApplicationContext(),
mandali,
Toast.LENGTH_SHORT).show();
}
else{
InputFilter[] FilterArray = new InputFilter[0];
FilterArray[0] = new InputFilter.LengthFilter(4);
editTextLitre.setFilters(FilterArray);
/*editTextLitre.setText(s.subSequence(0, 4));*/
}
}
else{
tvwAmount.setText("0");
}
}
@Override
public void beforeTextChanged(CharSequence s, int start, int count,
int after) {
// TODO Auto-generated method stub
}
@Override
public void afterTextChanged(Editable s) {
// TODO Auto-generated method stub
}
});
Button btnSaveDetails = (Button) findViewById(R.id.btnSave);
}
@Override
public boolean onCreateOptionsMenu(Menu menu) {
MenuInflater menuInflater = getMenuInflater();
menuInflater.inflate(R.menu.select_category_menu, menu);
return true;
}
@Override
public boolean onOptionsItemSelected(MenuItem item) {
switch (item.getItemId()) {
case R.id.admin:
Intent intent1 = new Intent("com.example.localsale.Admin");
startActivity(intent1);
return true;
default:
return super.onOptionsItemSelected(item);
}
}
}
我的数据库辅助类显示为code以下结果
我DBHelper.java是在这里：
My database helper class is shown with code below
My DBHelper.java is here:
package com.bis.localsale;
import java.io.IOException;
import android.annotation.SuppressLint;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;
public class DBHelper extends SQLiteOpenHelper
{
private SQLiteDatabase db;
public static final String KEY_ROWID = "_id";
public static final String KEY_CREATED_USER = "createdUser";
public static final String KEY_CREATED_DATE = "createdDate";
public static final String KEY_LAST_MODIFIED_USER= "lastModifiedUser";
public static final String KEY_LAST_MODIFIED_DATE= "lastModifiedDate";
public static final String KEY_RECORD_STATUS = "recordStatus";
public static final String KEY_NAMEOFMANDALI = "nameOfMandali";
public static final String KEY_RATEOFCOW = "rateOfCow";
public static final String KEY_RATEOFBUFFALO = "rateOfBuffalo";
DBHelper DB = null;
private static final String DATABASE_NAME = "localsale.db";
private static final int DATABASE_VERSION = 1;
public static final String DATABASE_TABLE_NAME = "organizationSetup";
private static final String DATABASE_TABLE_CREATE = "CREATE TABLE "
+ DATABASE_TABLE_NAME
+ "("
+ "_id INTEGER PRIMARY KEY AUTOINCREMENT,"
+ "nameOfMandali TEXT NOT NULL, rateOfCow TEXT NOT NULL, rateOfBuffalo TEXT NOT NULL, createdUser TEXT NOT NULL, createdDate TEXT NOT NULL, lastModifiedUser TEXT NOT NULL, lastModifiedDate TEXT NOT NULL, recordStatus TEXT NOT NULL);";
public DBHelper(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
try {
db.execSQL(DATABASE_TABLE_CREATE);
} catch (Exception e) {
e.printStackTrace();
}
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
// Drop older table if existed
db.execSQL("DROP TABLE IF EXISTS " + DATABASE_TABLE_CREATE);
// Create tables again
onCreate(db);
}
public void onDowngrade(SQLiteDatabase db, int oldVersion, int newVersion) {
onUpgrade(db, oldVersion, newVersion);
}
public Cursor rawQuery(String string, String[] strings) {
// TODO Auto-generated method stub
return null;
}
public SQLiteDatabase open() {
SQLiteDatabase db = this.getWritableDatabase();
return db;
}
public Cursor getDetails(String text) throws SQLException {
Cursor mCursor = db.query(DATABASE_TABLE_NAME, new String[] {
KEY_ROWID, KEY_CREATED_USER, KEY_CREATED_DATE, KEY_LAST_MODIFIED_USER, KEY_LAST_MODIFIED_DATE,
KEY_RECORD_STATUS }, null, null, null, null,
null);
if (mCursor != null) {
mCursor.moveToFirst();
}
return mCursor;
}
public void insert(String DATABASE_TABLE_NAME, Object object,
ContentValues values) {
// TODO Auto-generated method stub
}
@SuppressLint("NewApi")
public String getMandaliName(){
SQLiteDatabase db = this.getReadableDatabase();
Cursor cursor = db.rawQuery(DATABASE_TABLE_NAME, new String[]
{ KEY_NAMEOFMANDALI}, null);
if (cursor != null)
cursor.moveToLast();
String mandaliName = cursor.getString(cursor.getColumnIndex(KEY_NAMEOFMANDALI));
Log.e("test", mandaliName);
return mandaliName;
}
}
} }
我没有得到什么是，它（提取的数据）是没有得到在TextView中显示的code中的错误。通过尽快提供答案可能请帮我这一点。
I am not getting that what is the error in the code that it(fetched data) is not getting displayed on the textview. Please help me with this by providing answer as soon as possible.
答
无法告诉你问题是什么作为你的descrption是混乱的，但如果你的错误是
Can't tell what your question is as your descrption is confusing but if your error is
android.database.sqlite.SQLiteException附近DATABASE_TABLE_NAME语法错误（code：1）在编译organizationSetup
尝试把一个空格表名之后。您的支架都在触摸表名。
Try putting a space after the table name. Your brackets are touching the table name.