帮我改进一下 public void onCreate(SQLiteDatabase sqLiteDatabase) { String sqlChenZiYang="CREATE TABLE "+tnChenZiYang+"(" +idChenZiYang+ " INTEGER primary key autoincrement," +nChenZiYang+ " text not null," +pChenZiYang+ " real,"//浮点型 +numberChenZiYang+ " INTEGER "+");"; sqLiteDatabase.execSQL(sqlChenZiYang); }
时间: 2024-03-26 08:35:04 浏览: 21
你可以将代码格式化并添加注释,以增强代码的可读性和可维护性。同时,建议将表名、列名等常量定义为静态变量,以方便修改和重用。
以下是改进后的代码:
```
public static final String TABLE_NAME = "chenziyang";
public static final String COLUMN_ID = "_id";
public static final String COLUMN_NAME = "name";
public static final String COLUMN_PRICE = "price";
public static final String COLUMN_NUMBER = "number";
public void onCreate(SQLiteDatabase db) {
// 定义创建表的 SQL 语句
String createTableSql = "CREATE TABLE " + TABLE_NAME + " (" +
COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
COLUMN_NAME + " TEXT NOT NULL, " +
COLUMN_PRICE + " REAL, " +
COLUMN_NUMBER + " INTEGER" +
");";
// 执行 SQL 语句创建表
db.execSQL(createTableSql);
}
```
这样,你可以更方便地修改表名和列名,同时也可以更快捷地使用这些常量。