KeeSoft.DBHelper.Config 增删改查字符串

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace KeeSoft.DBHelper
{
    /// <summary>
    /// 数据库的基本配置文件
    /// </summary>
    public class Config
    {
        /// <summary>
        /// 数据库插入语句
        /// 参数分别为 Table Fields Values
        /// @Table
        /// @Fields
        /// @Values
        /// </summary>
        public static readonly string INSERT = "insert into {0}({1}) values({2}) select @@identity";

        /// <summary>
        /// 数据库更新语句
        /// 参数分别为 Table UpdateValue Where
        /// @Table
        /// @UpdateValue
        /// @Where
        /// </summary>
        public static readonly string UPDATE = "update {0} set {1} where 1=1 {2}";

        /// <summary>
        /// 数据库删除语句
        /// 参数分别为 Table Where
        /// @Table
        /// @Where
        /// </summary>
        public static readonly string DELETE = "delete from {0} where 1=1 {1}";

        /// <summary>
        /// 带Where条件的查询语句
        /// 参数分别为 Fields Table Where
        /// @Fields
        /// @Table
        /// @Where
        /// </summary>
        public static readonly string SELECT = "select {0} from {1} where 1=1 {2}";
    }
}

 

转载于:https://my.oschina.net/kee1986/blog/791890

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
DBHelper类通常用于数据库的操作,包括增删等。以下是一个简单的DBHelper类的示例代码,可以实现基本的增删操作。 ```java public class DBHelper extends SQLiteOpenHelper { private static final String DATABASE_NAME = "mydb.db"; private static final int DATABASE_VERSION = 1; public static final String TABLE_NAME = "mytable"; public static final String COL_ID = "id"; public static final String COL_NAME = "name"; public static final String COL_AGE = "age"; public DBHelper(Context context) { super(context, DATABASE_NAME, null, DATABASE_VERSION); } @Override public void onCreate(SQLiteDatabase db) { String sql = "CREATE TABLE " + TABLE_NAME + "(" + COL_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " + COL_NAME + " TEXT, " + COL_AGE + " INTEGER)"; db.execSQL(sql); } @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { String sql = "DROP TABLE IF EXISTS " + TABLE_NAME; db.execSQL(sql); onCreate(db); } public void insert(String name, int age) { SQLiteDatabase db = this.getWritableDatabase(); ContentValues values = new ContentValues(); values.put(COL_NAME, name); values.put(COL_AGE, age); db.insert(TABLE_NAME, null, values); db.close(); } public void delete(int id) { SQLiteDatabase db = this.getWritableDatabase(); String whereClause = COL_ID + " = ?"; String[] whereArgs = {String.valueOf(id)}; db.delete(TABLE_NAME, whereClause, whereArgs); db.close(); } public void update(int id, String name, int age) { SQLiteDatabase db = this.getWritableDatabase(); ContentValues values = new ContentValues(); values.put(COL_NAME, name); values.put(COL_AGE, age); String whereClause = COL_ID + " = ?"; String[] whereArgs = {String.valueOf(id)}; db.update(TABLE_NAME, values, whereClause, whereArgs); db.close(); } public List<Person> query() { List<Person> list = new ArrayList<>(); SQLiteDatabase db = this.getReadableDatabase(); String[] columns = {COL_ID, COL_NAME, COL_AGE}; Cursor cursor = db.query(TABLE_NAME, columns, null, null, null, null, null); while (cursor.moveToNext()) { int id = cursor.getInt(cursor.getColumnIndex(COL_ID)); String name = cursor.getString(cursor.getColumnIndex(COL_NAME)); int age = cursor.getInt(cursor.getColumnIndex(COL_AGE)); Person person = new Person(id, name, age); list.add(person); } cursor.close(); db.close(); return list; } } ``` 其中,Person是一个简单的Java类,用于保存询结果。 ```java public class Person { private int id; private String name; private int age; public Person(int id, String name, int age) { this.id = id; this.name = name; this.age = age; } public int getId() { return id; } public String getName() { return name; } public int getAge() { return age; } } ``` 使用DBHelper类进行增删操作的示例代码: ```java DBHelper dbHelper = new DBHelper(context); // 插入数据 dbHelper.insert("张三", 18); // 删除数据 dbHelper.delete(1); // 更新数据 dbHelper.update(2, "李四", 20); // 询数据 List<Person> list = dbHelper.query(); for (Person person : list) { Log.d("DBHelper", person.getId() + " " + person.getName() + " " + person.getAge()); } ```

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值