AIR版的通讯簿(八)

最新推荐文章于 2021-08-11 14:35:55 发布

原创最新推荐文章于 2021-08-11 14:35:55 发布 · 324 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#通讯 #air #integer #string #table #date

flex 专栏收录该内容

88 篇文章

订阅专栏

本文提供了一个使用SQL脚本创建数据库表的示例，包括客户、员工和资金日表的结构定义。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

脚本(4)

private function createSql():void{
    var csql:String="CREATE TABLE IF NOT EXISTS ql_customer (" +
     "    customer_id INTEGER PRIMARY KEY AUTOINCREMENT, " +
     "    customer_name VARCHAR(200), " +
     "    customer_address VARCHAR(200), " +
     "    customer_telephone VARCHAR(50)," +
     "    customer_mobile CHAR(11)," +
     "    customer_fax VARCHAR(50)," +
     "    img_url VARCHAR(100)," +
     "    customer_desc TEXT" +
     ")";
    sqlArray.push(csql);
    var esql:String="CREATE TABLE IF NOT EXISTS ql_employee (" +
     "    employee_id INTEGER PRIMARY KEY AUTOINCREMENT, " +
     "    employee_name VARCHAR(200), " +
     "    employee_address VARCHAR(200), " +
     "    employee_mobile CHAR(11)," +
     "    employee_sex CHAR(1)," +
     "    employee_birthday DATE," +
     "    employee_study,VARCHAR(20)," +
     "    employee_job,VARCHAR(50)," +
     "    employee_desc TEXT" +
     ")";
    sqlArray.push(esql);
    var msql:String="CREATE TABLE IF NOT EXISTS ql_money_day (" +
     "    id INTEGER PRIMARY KEY AUTOINCREMENT, " +
     "    create_date DATE," +
     "    used_money NUMERIC,"+
     "    used_way VARCHAR(20),"+
     "    desc TEXT"+
     ")";
    sqlArray.push(msql);
   }