关于数据库的问题
完整代码如下:
package com.ex05_02;
import android.os.Bundle;
import android.app.Activity;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
public class MainActivity extends Activity {
Button creatBtn,deleteBtn;
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
creatBtn=(Button)findViewById(R.id.creat1);
creatBtn.setOnClickListener(new mClick());
deleteBtn=(Button)findViewById(R.id.delete1);
deleteBtn.setOnClickListener(new mClick());
}
class mClick implements OnClickListener
{
public void onClick(View arg0)
{
if(arg0 == creatBtn)
{
DBCreate db= new DBCreate();
}
else if(arg0 == deleteBtn)
{
deleteDatabase(DBCreate.Database_name);
}
}
}
class DBCreate
{
static final String Database_name = "PhoneBook.db";
private DBCreate()
{
SQLiteDatabase db;
String TABLE_NAME ="Users";
String ID = "_id";
String USER_NAME = "user_name";
String ADDRESS = "address";
String TELEPHONE = "telephone";
String MALL_ADDRESS = "mail_address";
String DATABASE_CREATE =
"CREAT TABLE" +TABLE_NAME + "("
+ ID + "INTEGER primary key autoincrement,"
+ USER_NAME + "text not null, "
+TELEPHONE+ "text not null, "
+ADDRESS+ "text not null, "
+MALL_ADDRESS + " text not null"+ ");";
int mode = Context.MODE_PRIVATE;
db = openOrCreateDatabase(Database_name, mode, null);
db.execSQL(DATABASE_CREATE);
}
}
}
粗体字哪里说db没被使用,这是怎么回事?
package com.ex05_02;
import android.os.Bundle;
import android.app.Activity;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
public class MainActivity extends Activity {
Button creatBtn,deleteBtn;
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
creatBtn=(Button)findViewById(R.id.creat1);
creatBtn.setOnClickListener(new mClick());
deleteBtn=(Button)findViewById(R.id.delete1);
deleteBtn.setOnClickListener(new mClick());
}
class mClick implements OnClickListener
{
public void onClick(View arg0)
{
if(arg0 == creatBtn)
{
DBCreate db= new DBCreate();
}
else if(arg0 == deleteBtn)
{
deleteDatabase(DBCreate.Database_name);
}
}
}
class DBCreate
{
static final String Database_name = "PhoneBook.db";
private DBCreate()
{
SQLiteDatabase db;
String TABLE_NAME ="Users";
String ID = "_id";
String USER_NAME = "user_name";
String ADDRESS = "address";
String TELEPHONE = "telephone";
String MALL_ADDRESS = "mail_address";
String DATABASE_CREATE =
"CREAT TABLE" +TABLE_NAME + "("
+ ID + "INTEGER primary key autoincrement,"
+ USER_NAME + "text not null, "
+TELEPHONE+ "text not null, "
+ADDRESS+ "text not null, "
+MALL_ADDRESS + " text not null"+ ");";
int mode = Context.MODE_PRIVATE;
db = openOrCreateDatabase(Database_name, mode, null);
db.execSQL(DATABASE_CREATE);
}
}
}
粗体字哪里说db没被使用,这是怎么回事?
...全文
相关推荐
在数据库‘master’中拒绝CREATE DATABASE权限问题的解决方法
### 在数据库‘master’中拒绝CREATE DATABASE权限问题的解决方法#### 背景与问题描述在使用Linq To SQL进行数据库操作时,我们常常需要检查目标数据库是否存在,并在不存在的情况下自动创建它
idea中database不显示问题的解决
**问题描述**通常,Database面板应该位于IDEA界面的右侧,方便开发者查看和管理数据库连接。
VB5DB-DLL问题
VB5DB-DLL问题主要涉及到的是Visual Basic 5.0中的数据库访问组件。在VB5中,开发者可以利用VB5DB.DLL这个动态链接库来实现对数据库的连接和操作,比如读取、写入数据等。
解决mysql创建数据库后出现:Access denied for user 'root'@'%' to database 'xxx'的问题
"解决mysql创建数据库后出现:Access denied for user 'root'@'%' to database 'xxx'的问题"在MySQL数据库管理系统中,"Access den
解决mysql创建数据库后出现:Access denied for user ‘root’@’%’ to database ‘xxx’的问题
总结一下,遇到“Access denied for user ‘root’@’%’ to database ‘xxx’”的问题主要是因为缺少必要的权限。通过创建数据库后立即进行授权,可以避免这种问题。


