Package com.almworks.sqlite4java

Examples of com.almworks.sqlite4java.SQLiteStatement.columnString()

74
75
76
77
78
79
80
81
82
83
84
        );
       
        st.bind(1, login);
       
        if (st.step()) {
          return new User(st.columnLong(0), login, st.columnString(2), st.columnString(1));
        } else {
          return null;
        }
      }
    }).complete();
View Full Code Here
74
75
76
77
78
79
80
81
82
83
84
        );
       
        st.bind(1, login);
       
        if (st.step()) {
          return new User(st.columnLong(0), login, st.columnString(2), st.columnString(1));
        } else {
          return null;
        }
      }
    }).complete();
View Full Code Here
154
155
156
157
158
159
160
161
162
163
164
        while (st.step()) {
          resList.add(new Message(
              st.columnLong(0),
              st.columnLong(1),
              st.columnLong(2),
              st.columnString(3)
            )
          );
        }
        Message[] res = resList.toArray(new Message[] {});
        return res;
View Full Code Here
188
189
190
191
192
193
194
195
196
197
198
        LinkedList<User> resList = new LinkedList<>();

        while (st.step()) {
          resList.add(new User(
              st.columnLong(0),
              st.columnString(1),
              st.columnString(2),
              st.columnString(3)
            )
          );
        }
View Full Code Here
189
190
191
192
193
194
195
196
197
198
199
        while (st.step()) {
          resList.add(new User(
              st.columnLong(0),
              st.columnString(1),
              st.columnString(2),
              st.columnString(3)
            )
          );
        }
        User[] res = resList.toArray(new User[] {});
View Full Code Here
190
191
192
193
194
195
196
197
198
199
200
        while (st.step()) {
          resList.add(new User(
              st.columnLong(0),
              st.columnString(1),
              st.columnString(2),
              st.columnString(3)
            )
          );
        }
        User[] res = resList.toArray(new User[] {});
        return res;
View Full Code Here
114
115
116
117
118
119
120
121
122
123
124
      // other than recompiling SQLite or modifying the environment.
      conn.open(true);
      conn.exec("PRAGMA temp_store_directory = '" + new File(".").getAbsolutePath() + "'");
      SQLiteStatement st = conn.prepare("PRAGMA temp_store_directory");
      st.step();
      LOG.info("Changed temp_store_directory to: " + st.columnString(0));
      // journal_mode=OFF speeds up insertions
      conn.exec("PRAGMA journal_mode=OFF");
      /*
       * page_size is one of of the most important parameters for speed up indexation. SQLite performs a merge sort for
       * sorting data before inserting it in an index. The buffer SQLites uses for sorting has a size equals to
View Full Code Here
167
168
169
170
171
172
173
174
175
176
177
        currStatement = connection.prepare(request,false);
        String name = "";
        if (currStatement.step())
          if (currStatement.hasRow())
          {
            name = currStatement.columnString(2);
           
          }
        currStatement.dispose();
        return name;
      }
View Full Code Here
512
513
514
515
516
517
518
519
520
521
522
          request = "select *" +
                    "from subgraph s1 " +
                    "where s1.db_id = " + Integer.valueOf(id_subgraph).toString() + ";";
          subgraphStatement = connection.prepare(request,false);         
          if(subgraphStatement.step()) {
            String buf = subgraphStatement.columnString(3);
            if(buf != null && buf.equals("true")) {
              directed = true;
            } else {
              directed = false;
            }
View Full Code Here
518
519
520
521
522
523
524
525
526
527
528
            if(buf != null && buf.equals("true")) {
              directed = true;
            } else {
              directed = false;
            }
            id = subgraphStatement.columnString(1);
            name = subgraphStatement.columnString(2);
          }
          subgraphStatement.dispose();

          //vertexes-----------------------
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.