TypeScript index.SQLite类代码示例

OStack程序员社区-中国程序员成长平台 › 门户 › 编程› TypeScript›TypeScript教程

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了TypeScript中ionic-native/dist/index.SQLite类的典型用法代码示例。如果您正苦于以下问题：TypeScript SQLite类的具体用法？TypeScript SQLite怎么用？TypeScript SQLite使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。

在下文中一共展示了SQLite类的4个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的TypeScript代码示例。

示例1: constructor

  constructor(private nav: NavController, private menu: MenuController) {
    // this.trololo = "url('data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAACgAAAAoCAYAAACM/rhtAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAA4VSURBVFhHnVlZbJxXGT3/7ItntT22YzuOndhu3CxOWpwuNKUlLS1NqUClBYRaISFe+oJQJd4rJN6RQICEEC+UByi0VTd1SxeXtikJNInjLI3t2B6PZ2zPeMazb5xzJw4pTbp9yZ+Z+ee/9557vu8733cnVpOGL2HVahWbQwuFAtbX11EsFs1nv9+PUCgEt9ttPttsNjidTvP+i9oXAliv15HNZmFZFlKpFCrlCmKxTnTGYpee+J816jUsLCwivrSEaDSK9vZ2c1/vNf7z2ucGGI/HzWuZoNqjYQRDYSKuYW4piWRmA7lSFdUG2UITHocNkTYv+mIRhMN8jra4sIBiqWTeBwIBdHV1mfefZZ8JsFar4dy5c2bnbpcT4UgY52Yu4s0Ts/h3PI183Y5CpYFKrY46n7cI0GHZ4HHZ4XNaiHltODjSg6/uGYavrQ1L8YTxxCI3fODAgdYin2KfCjCTyRhXhhlPHdEQ5haX8Zvn38OpNYJxuFBvWHASiMNuJ3MWiIu+5aY4ZaXeQJ1x2uCrm4y2NQt4cF8/vn1wP5o2O5aTqwyBBYyP74XP52steBW7JsBEIoEMA39LTzeqlQp+99wk/nYiiWhXN7xOO1x2G+x2C3bGk43vTVRxJk3X5nFioCMIG7+bSa4jvl5Eo9HEyvoGOpHD4/dP4IbhfhTLVczMzWFg69ZruvyqAJeXl5FMJtHf14uPyNpvX/oXTm240BkOwmlvmoXtZIG4yB6B2giSmaqp/G4nfnBgGAe2txacW8niiaePIlesoM6VigyHleU4Hrt9BHeN72B2OzAzS5ADA1cF+QmAcus8qe9hZp64sIDfHzmNFfgR9LvhIBAX3RULtWFrexvBOJCv1LCcLSFbqpClBoY6Q3j8G3s5U5OAuQA38+tXT+Cd80vmc63WQJluz6TT+OZIBA/dvBMuStCFmRlMTExclqZN+xhALTA1NYUIE2FuaQW/euUk0lYAfq/LxFHQ58KdY324ZUcPInzvIGuKtTTZObm4hsmPEhjuiuBHNw9f1kgB/MNb0wQYN/cqtSZBVk1iFXI53LMjhAdvGkWN88zOzuLQoUNm3KZ9DKDAWWLJ7sATT01iCWG0+dz8bIfXbcfduwfw/Ykdl56WaeimpjUxn84jtVHG3i1hxqfd3E0XSvjlCx/StXQxQZSrdVSpDOVKnSDr2Mik8eMDvTh4/SDWMlmUSsWPZfdlgIq51MoKAl4PM/VdTKbddKXfaJqNiw3FAvj5vfvgY4xpCInRcF4cvrlF3ixTbl48HafLy+b+zEqOyVAz3qnyuwoBVqifuiewRTK6nljALx4YR3ckiPVsDkNDg5eFXcJgFsyR7hplYWZxCa/Ol9AR9MHpsOBwskwxWwVW4BRIApdjBi7niljNl1GoEoDZZ5OhYMddowwBvwfxXImbo0dcDiNHijUXFcDpcJhXF5/1kGh3pAt/OnLChFG5XMYcM3vTDEAlRpJ65+VEf37nLKIdsVZCkDmnLoIMMQ6NEd0FsvLSdBzPnFrAWzMpxmAVWQLeICsyH+e5Y0cX9myJmKTpCXtNdmseuV666WT8CqCDoAKUpVM5B6Zn5hEMBljbS1hbWzNzGYDSOenZmdlFzFU98HB30jgNNgC5Y+qvsXShjPcuruAitU1wYgEPekNexBl7k/MU32zBPOdn1bl1Www39kfx3fFteGRiOw7v7seu3gjj2WG0085L8xMnQpEo/nFsBm7eS6+tGtJkNpWd2fl5Uu7A0dlVwN6SEycfNK8EqZ3KjbLkBndHxtxkKRb0YD9ZKjOOUoUK1ik5x5czOLea45NNBL1O9AS8eJsbyrNQHyDgR5nhP/369djRpRotTeWSZFPunSu5sZhMoT3WQRbzJm5t+ieZWEaOwTmzQZ7EmCqE2aGY3ARYx1q+xABv8p5Flm3Y3xPlqwOLjMV8s44ApcfOz9OZAk6lsiZrAx4XBsN+vHAmjqdPziNfrqM76MfP7tqDb+0fZM3mGEMIkbr9OE6pUi2fmpo2LR0ZbBgXLqxlUAaDme9tHCCXa6B2J0BlAlugW/2UG7Ed8boxGPGbrE2TXTcTwM9YUiJ56MJ5Mnouk1dOYXdXCCOdAZwns/+Jr6HJsie7m5q6b2sH36kSWabZWMyzz2SW5/MbLYCi0s1dpjcqZEeA6HeCkx7qVQMlyFppkcwocYIEMsoFZXkCLHE9JZiXcadXn8lYO2bJ7Gw2z7ls2NMdMePm1/Oo0Wuaz00ydvdFzRgJOv8iXW5SI8skxYEKc8OmhqDC1M5TNE0/p5ZEwLQvM6h1CWxio4gi2eqlBG0Nes0iWbreIsMKfC/Z02Jyu0qigE2vbqDA7O7l89vbWZX4/WVtp4UZFj6OtbhJm2VHha/ZXJ4bdFG0KVO1aoWIq6iQdi5ldqHgrdKlijeVIOaAYXSDzyWpe73MXD9dWifAHAFuSpJAKnlajYSYBxds4Hhq3Wx6pDOI/b1RIzEtJ7Pn1bokxvCi+5bDVB0b494wSNk1At1gNtusBgWXHQofvHGwEz85eB0evGEQPZQRgWk2LUyncpyEu+WErPvIUP9kTQqRFmsVpgY/t2jilrHI2D3DrqaPLEojNdcmiTOcL88u3dKkpFH9o2p1tVYxm7C5mUUyW50ByVs1Ah2hBDx2xy4TwDcPdeFhZpuNkyp2/IyvgNzEJQoqXbxXI9MqWyUuJHequ64SvbwglYhQ5IW7ap4leK1MRi+wVzx2MWWqkPA1+LzVqDKLLRQp1qo8tghb+ToHOim7dgKskoXreiJmArGhq6PNwywl5Vw4wPjy871MGSxgZcalautGqUaA6lTqxiNhbmRntA23MBGGmPElPit9bdDtc8zoZz68iAQTT2wqs/XH2awaBVHyejyeFoOqwz6S4iR6jmV/1zo+8jleLWccYn3d1RMmG05T0goUZdVjFX91JhV2KBYZCDMWB9g77iGwvR0BjEaVGKq7lCvO1cY4fXc2hb988BHOk0GBUljpsnHxoF1NRKu58LA3ZCPcyto27tZZL5CxOo5eWMYb04uCaB5+k81mD+Pn8Fg/bmE1iHjcDHTLJMsd/e24jYF/a1cUE+x4ro/6Mchn26mTXrJtdsl5tJmTBFSmVGzwBHiR2a362UoSXvIW9S9qlU1Z1WnQSfIsIm2+/dYkzp49g1OJdUw5tsHj85pzR4Cx4yRwKbufzPWxi755MIYBukuL61yicNo0sSGrMs7yZDZHptkQ4c2ZZSSYKGLwofEBA/CPk2ewxm5HLViR6lCgVFQSs3hwwGJcW7hh/z72hROSNwuDQ9uMi/p8nC2fId2WCdwy79XoSmWoglvxIhhRtlJ1umO1WMbL5xP4++kFPMtS9gyvp6YW8dcpfma3k2LdLjFZFtIF04bdN9aLXpa9UYr2D3luUUYrjhX3xXIDAzbKESWqQqGORpkHNOmxOUjr3Otxu9BbTxoxVgmsSwc5uMbdiRUlSZHxJmujKMcItMPnxNJ6gVUmjyRjN6W6TIZG5Gpe780lTYx2M9FGYiEzVpvc1dtOtQiZGK6RsXI6jtGIk2NL6ONhbfMAZQDqd5Tt7GKLrCg7I3ZUV+ZRJYsCJGYrBGzadBb6DGus0bpLvh3josNMiCoXyrPLcTE2b+prxw0EcHxhldnK0iZPSDSvjAc6S7IlKcrlCxjGKvtFJ5Ojid4tW9gXBs1jBqBsZGQEW/iF4mi3K410OmN2pol1MBKAEsVzdmWdwkpxZmhoPfV9d41swffY831nTz8epbDvI0A1BWrfytJFJoYy9kwyyxGtpJmOp/HBTJKVxoIvs4ChNgtZAm3ngW3Xrl2CZOxjh6aTJ0/hhRdfRKlYxLm8HUuhYfj9PngYF252MToDa5cPTwzhjtFeM0bDtWQrW/W5gdfOJPAyVUBVQbFcI0DFM79EP9kWS8cpNUXer63OY9yRYsfuoCfDuPNrt2NsbMzMJfvEufj114/g9SNvGB06U/EjGxqC18/Dk4sNLDXOwcYgSAl56Mbt+AozWgIu0/Pqtl9hcrxPZgRCU8uN8oIqlKqLxNqEDfFW0wnsqC2iR30HG4X9+8Zx+PB9Zr5N+wRA2ZNPPonp6bPcIQ9RtQDWQtvMr1kOOlUdNsPM9H8HtsewjR2K2vZVNrPTiQwWefQUmUaACVLJplKoVyWaYk69ZTk5h6F6At0eaQQwPLQdjzz6SAvAFXZVgDoPPP3Ms9TGsyZBElUXLga2IxiNMQnYUROAGll1OCpder+pgQKvpkKfTOEXSLJoADIYNool2JMzGLFSCDr5HDV2bGwU9x8+bFz8/3ZVgDL9Yvrc88/j2LHjxn2FpgPnm1E0u0bgo5BzbjJFsHxWTa0KEu/oH5rKF7VUwFQteF+tW35lCZ3Z8+hzVzmeY9iUXr9zFA888IBRkqvZNQFu2muvvYa3J/+JVZ607EyANQpq3BlDM9IPhz9oejgbk8jiJYyaTE5rEpB+ZW00GG9rCQRyc9jqqFBrnSYO+/v7sGfXGO65516zzrXsMwHKpqenMfnue5g6NYU6G9wmm4osO5esPYCKO4S6y0+fs24yLlX1m9UyRY7tUiUHd3kdnQ62UC433UlJ8foxNDSAg7cdxOjo6KUVrm2fC6CsQOk5eeIETp+extTp00a4izzYSDpU6FUKG8xERZ8iUrEpOp3sSHS+8Ho92HnddRil3u7es/tTf7S80j43wE3TL/rLiQSWk0m8f/QDLC8nDHjFm9KRoWeA6WAuDe3t2YK943vRw9LV1d1t/gfgi9gXBnil6dCvo6F+T9EBR/8NoenEjn7n0+XSuZcy9OUM+C9FLnFDrTwRLQAAAABJRU5ErkJggg==') no-repeat left top";
    this.database = new SQLite();
    this.database.openDatabase({name: "data.db", location: "default"}).then(() => {
      this.refresh();




    }, (error) => {
      console.log("ERROR: ", error);
    });
  }

开发者ID:MadinaS，项目名称:firstApp，代码行数:13，代码来源:nachrichten.ts

示例2: constructor

  constructor(public nav: NavController, private navParams: NavParams, private viewCtrl: ViewController) {
    let messageId = navParams.get('id');
    this.database = new SQLite();
    this.database.openDatabase({name: "data.db", location: "default"}).then(() => {

      this.database.executeSql("SELECT * FROM nachrichten WHERE id=?", [messageId]).then((data) => {

        if(data.rows.length > 0) {
          let d = new Date(data.rows.item(0).mTime*1000);
          let day;
          let month;

          if ( d.getDay() < 10 )
            day = '0'+d.getDay();
          else
            day = d.getDay();

          if ( d.getDay() < 10 )
            month = '0'+d.getMonth();
          else
            month = d.getMonth();

          this.messageInfo.push({id: data.rows.item(0).id,
            sender: data.rows.item(0).sender,
            titel: data.rows.item(0).titel,
            message: data.rows.item(0).message,
            mTime: day + '.' + month + '.' + d.getFullYear(),
            // gelesenColor: gelesenColor,
            // iconName: iconName,
            componentId: data.rows.item(0).id});

          this.database.executeSql("UPDATE nachrichten SET gelesen=1  WHERE id=?", [messageId]).then((data) => {
            console.log("Nachricht ist jetzt gelesen.");
          }, (error) => {
            console.log("Es ist eine Fehler aufgetrofen: diesen Nachricht kann nicht wie 'gelesen' markiert werden.");
          });

        }
      }, (error) => {
        // alert("6 ERROR: " + JSON.stringify(error));
      });



    }, (error) => {
      console.log("ERROR: ", error);
    });
  }

开发者ID:MadinaS，项目名称:firstApp，代码行数:48，代码来源:nachricht.ts

示例3: Date

      this.database.executeSql("SELECT * FROM nachrichten WHERE id=?", [messageId]).then((data) => {

        if(data.rows.length > 0) {
          let d = new Date(data.rows.item(0).mTime*1000);
          let day;
          let month;

          if ( d.getDay() < 10 )
            day = '0'+d.getDay();
          else
            day = d.getDay();

          if ( d.getDay() < 10 )
            month = '0'+d.getMonth();
          else
            month = d.getMonth();

          this.messageInfo.push({id: data.rows.item(0).id,
            sender: data.rows.item(0).sender,
            titel: data.rows.item(0).titel,
            message: data.rows.item(0).message,
            mTime: day + '.' + month + '.' + d.getFullYear(),
            // gelesenColor: gelesenColor,
            // iconName: iconName,
            componentId: data.rows.item(0).id});

          this.database.executeSql("UPDATE nachrichten SET gelesen=1  WHERE id=?", [messageId]).then((data) => {
            console.log("Nachricht ist jetzt gelesen.");
          }, (error) => {
            console.log("Es ist eine Fehler aufgetrofen: diesen Nachricht kann nicht wie 'gelesen' markiert werden.");
          });

        }
      }, (error) => {

开发者ID:MadinaS，项目名称:firstApp，代码行数:34，代码来源:nachricht.ts

示例4: refresh

  public refresh() {
    // this.trololo = 'red';
    this.database.executeSql("SELECT * FROM nachrichten ORDER BY mTime DESC ", []).then((data) => {
      this.people = [];

      if(data.rows.length > 0) {
        let gelesenColor;
        let iconName;
        let bgColor = 0;
        let day;
        let d;
        let dateComp;
        let todayD;

        for(var i = 0; i < data.rows.length; i++) {
          d = new Date(data.rows.item(i).mTime*1000);//*1000

          dateComp = new Date(data.rows.item(i).mTime*1000);//*1000
          dateComp.setHours(0,0,0,0);
          todayD = new Date();
          todayD.setHours(0,0,0,0);
          gelesenColor = '#bababa';
          iconName = 'ios-radio-button-off';

          if ( todayD.getTime() == dateComp.getTime() )
            day = this.oneMoreNull( d.getHours() ) + ':' + this.oneMoreNull( d.getMinutes() );
          else
            day = this.oneMoreNull( d.getDate() ) + '.' + this.oneMoreNull( d.getMonth() + 1 ) + '.' + d.getFullYear();

          if ( data.rows.item(i).gelesen > 0 ) {
            gelesenColor = "#f36f21";
            iconName = 'ios-radio-button-on';
          }

          this.people.push({sender: data.rows.item(i).sender,
                            titel: data.rows.item(i).titel,
                            message: data.rows.item(i).message,
                            mTime: day,
                            gelesenColor: gelesenColor,
                            iconName: iconName,
                            componentId: data.rows.item(i).id,
                            bgColor: bgColor});

          (bgColor === 0) ? bgColor=1 : bgColor=0;
        }
      }
    }, (error) => {
      // alert("6 ERROR: " + JSON.stringify(error));
    });
  }

开发者ID:MadinaS，项目名称:firstApp，代码行数:50，代码来源:nachrichten.ts

注：本文中的ionic-native/dist/index.SQLite类示例由纯净天空整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。