因此，我正在Android Studio中制作一个应用程序，它是一个非常简单的MYSQL应用程序，它具有一个在其中放置信息的窗口，并将其保存到数据库中。但是，每当我按完成按钮时，都不会发生任何事情。谁能观察到我可能在哪里出问题？
这是主要的活动课
public class MainActivity extends AppCompatActivity {
DatabaseHelper myDb;
EditText edittime, editdesc, editiniti;
Button buttonadd;
@Override
protected void onCreate(Bundle savedInstanceState) {
DatabaseHelper myDb;
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
myDb = new DatabaseHelper(this);
edittime = (EditText)findViewById(R.id.editText_time);
editdesc = (EditText)findViewById(R.id.editText_desc);
editiniti = (EditText)findViewById(R.id.editText_initi);
buttonadd = (Button) findViewById(R.id.buttonadddata);
}
public void AddData(){
buttonadd.setOnClickListener(
new View.OnClickListener() {
@Override
public void onClick(View v) {
boolean isInserted = myDb.insertData (editdesc.getText().toString(),
editiniti.getText().toString());
if (isInserted = true)
Toast.makeText(MainActivity.this, "Data is inserted", Toast.LENGTH_LONG).show();
else
Toast.makeText(MainActivity.this, "Data not inserted", Toast.LENGTH_LONG).show();
}
}
);
}
@Override
public boolean onCreateOptionsMenu(Menu menu) {
// Inflate the menu; this adds items to the action bar if it is present.
getMenuInflater().inflate(R.menu.menu_main, menu);
return true;
}
@Override
public boolean onOptionsItemSelected(MenuItem item) {
Handle action bar item clicks here. The action bar will
automatically handle clicks on the Home/Up button, so long
as you specify a parent activity in AndroidManifest.xml.
int id = item.getItemId();
//noinspection SimplifiableIfStatement
if (id == R.id.action_settings) {
return true;
}
return super.onOptionsItemSelected(item);
}
}
这是数据库助手类
public class DatabaseHelper extends SQLiteOpenHelper {
public static final String DATABASE_NAME = "Tasks.db";
public static final String TABLE_NAME = "Tasks_table";
public static final String COL_1 = "ID";
public static final String COL_2 = "TIME";
public static final String COL_3 = "Desc";
public static final String COL_4 = "initi";
public boolean insertData;
public DatabaseHelper(Context context) {
super(context, DATABASE_NAME, null, 1);
SQLiteDatabase db = this.getWritableDatabase();
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("create table " + TABLE_NAME + "(ID INTEGER PRIMARY KEY AUTOINCREMENT, TIME TIME, Desc TEXT, initi TEXT)");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("DROP TABLE IF EXISTS" + TABLE_NAME);
onCreate(db);
}
public boolean insertData(String Desc, String initi) {
SQLiteDatabase db = this.getWritableDatabase();
ContentValues contentValues = new ContentValues();
contentValues.put(COL_3, Desc);
contentValues.put(COL_4, initi);
long result = db.insert(TABLE_NAME, null, contentValues);
if (result == -1)
return false;
else
return true;
}
}
我认为XML文件不是必需的，但是如果有必要，我将在此处发布。
最佳答案
我的朋友。 SQLiteOpenHelper和MySQL是两件事。
如果要使用SQLIte，我建议您http://greendao-orm.com/
如果要使用MYSQL，则必须在“服务器”部分执行此操作，并通过API进行服务...