AIR版的通讯簿(八)

关注

原创最新推荐文章于 2026-07-05 11:07:34 发布 342 阅读 AI 写同款· GEO 优化 ›

值得苦练的100道Python经典练手题（全网最全，附详细答案，建议收藏）这100道Python练习题涵盖了从基础语法到高级算法、从数据库操作到Web开发的各个方面，是备考数据库系统工程师的绝佳素材。建议按照章节顺序逐一练习，遇到难点可反复钻研，真正掌握每一道题背后的知识点。通过这些练习，不仅能提升Python编程能力，还能加深对数据库系统原理的理解，为考试和实际工作打下坚实基础。阅读详情

脚本(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);
   }