终于有时间好好看看数据库了
今天下午自己封装了一个SQLite数据库
留着以后自己用吧
虽然还有许多要修改的地方
贴出代码先
mysql数据库有什么用。package com.example.testdatabase;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
mysql创建数据库表、import android.util.Log;
public class DatabaseManager {
private DatabaseHelper dbHelper;
private static final String tableName = "name_table";
public DatabaseManager(Context context){
dbHelper = new DatabaseHelper(context);
如何登录mysql数据库,}
public SQLiteDatabase getReadDatabase(){
return dbHelper.getReadableDatabase();
}
public void addData(String name, String num){
SQLiteDatabase db = dbHelper.getWritableDatabase();
mysql删除数据库?ContentValues cv = new ContentValues();
cv.put("name", name);
cv.put("num", num);
try{
db.insertOrThrow(tableName, null, cv);
db.close();
mysql app,}catch(Exception e){
e.printStackTrace();
}
}
public void deleteData(String strName){
String sql = "delete from " + tableName + " where name = '"+ strName +"'" ;
jdbc连接mysql数据库、SQLiteDatabase db = dbHelper.getWritableDatabase();
try{
db.execSQL(sql);
// db.delete(tableName, "name = '" + strName + "' ", null);
}catch(Exception e){
e.printStackTrace();
mysql查看数据库、}
}
//查找指定数据
public Cursor findData(String strNum){
String sql = "select * from " + tableName + " where num = " + strNum;
SQLiteDatabase db = dbHelper.getReadableDatabase();
mysql数据库界面?Cursor cursor = null;
cursor = db.rawQuery(sql, new String[]{});
return cursor;
}
//删除表
public void deleteTable(){
mysql怎么建立数据库?String sql = "drop table " + tableName;
SQLiteDatabase db = dbHelper.getWritableDatabase();
try{
db.execSQL(sql);
}catch(Exception e){
e.printStackTrace();
sql数据库?}
}
public Cursor viewData(){
SQLiteDatabase db = dbHelper.getReadableDatabase();
String sql = "select * from " + tableName;
Cursor cursor = null;
android连接mysql实例?try{
cursor = db.rawQuery(sql, new String[]{});
}catch(Exception e){
e.printStackTrace();
}
return cursor;
mysql数据库命令大全,}
private class DatabaseHelper extends SQLiteOpenHelper{
private static final String dbNameString = "database.db";
private static final int db_version = 1;
private static final String nameTableString = "create table " + tableName + "(" + "name VARCHAR(20)," + "num VARCHAR(20)" + ");";
public DatabaseHelper(Context context) {
android studio 数据库,super(context, dbNameString, null, db_version);
}
public void onCreate(SQLiteDatabase db) {
db.execSQL(nameTableString);
}
@Override
安卓sql、public void onUpgrade(SQLiteDatabase db, int arg1, int arg2) {
}
}
}
//在外部类中调用如下
//如添加数据
mysql数据库简介,DatabaseManager dm = null;
dm = new DatabaseManager(context);
dm.addData("张三", "123456");
版权声明:本站所有资料均为网友推荐收集整理而来,仅供学习和研究交流使用。
工作时间:8:00-18:00
客服电话
电子邮件
admin@qq.com
扫码二维码
获取最新动态