Package java.sql

Examples of java.sql.ResultSet.beforeFirst()

152
153
154
155
156
157
158
159
160
161
162
  public void save (Connection connection, PrintWriter out) {
    Statement statement = null;
    try {
      statement = connection.createStatement();
      ResultSet set = statement.executeQuery( "SELECT * FROM " + tableName);
      set.beforeFirst();
     
      Map<String, String> columns = this.getColumnData(set);

      int c = 0;
      out.println("VERSION:2");
View Full Code Here
57
58
59
60
61
62
63
64
65
66
67
      this.tables = new ArrayList<EncryptedTable>();
     
      try {
        Statement statement = connection.createStatement();
        ResultSet set = statement.executeQuery("SHOW TABLE STATUS");
        set.beforeFirst();
       
        while (set.next()) {
          String engine = set.getString(2);
          if ("memory".equalsIgnoreCase(engine)) {
            this.tables.add(new EncryptedTable(this, set.getString(1)));
View Full Code Here
93
94
95
96
97
98
99
100
101
102
103
            statement.setInt(1, sessionID);
            results = statement.executeQuery();
            results.last();
            headingsCount = results.getRow();
            headings = new String[headingsCount];
            results.beforeFirst();
            while (results.next()) {
                headings[results.getInt("position")] = results.getString("name");
            }
            results.close();
            statement.close();
View Full Code Here
38
39
40
41
42
43
44
45
46
47
48
      rs = pstmt.executeQuery();

      if (rs.next()) {
        rs.last();
        returnTypeList = new ArrayList<ReturnType>(rs.getRow());
        rs.beforeFirst();

        while (rs.next()) {
          returnTypeList.add(beanPopulator.populate(rs));
        }
      }
View Full Code Here
37
38
39
40
41
42
43
44
45
46
47
      // Send query to database and store results.
      rs = pstmt.executeQuery();

      if (rs.next()) {
        returnTypeMap = new HashMap<KeyType, ValueType>();
        rs.beforeFirst();

        while (rs.next()) {
          Entry<KeyType, ValueType> entry = beanPopulator.populate(rs);
          returnTypeMap.put(entry.getKey(), entry.getValue());
        }
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
    return false;
  }
 
  public ArrayList query(Table obj, String query) throws Exception {
    ResultSet rs = this.executeSelect(query, obj);
    rs.beforeFirst();
    Class<?> c = obj.getClass();
    ArrayList list = new ArrayList();
    while(rs.next())  {
      Object newObj = c.newInstance();
      extendObject(rs, newObj);
View Full Code Here
101
102
103
104
105
106
107
108
109
110
111
      query += " ORDER BY "+order;
    if (pageIndex >= 0 && pageSize > 0)
      query += " LIMIT "+pageIndex*pageSize+","+pageSize;
   
    ResultSet rs = this.executeSelect(query, obj);
    rs.beforeFirst();
    Class<?> c = obj.getClass();
    while(rs.next())  {
      Object newObj = c.newInstance();
      extendObject(rs, newObj);
      list.add(newObj);
View Full Code Here
255
256
257
258
259
260
261
262
263
264
265
    PreparedStatement statement = connection.prepareStatement(query);
    for(int i=0;i<param.size();i++)  {
      statement.setObject(i+1, param.get(i));
    }
    ResultSet rs = statement.executeQuery();
    rs.beforeFirst();
    if(returnClass == null) returnClass = primaryObj.getClass();
    while(rs.next())  {
      Object newObj = returnClass.newInstance();
      extendObject(rs, newObj);
      list.add(newObj);
View Full Code Here
705
706
707
708
709
710
711
712
713
714
715
    {
      System.out.println("expected to be on the 1st row");
      passed = false;
    }
    // move to before first
    rs.beforeFirst();
    if (! rs.isBeforeFirst())
    {
      System.out.println("expected to be before the 1st row");
      passed = false;
    }
View Full Code Here
828
829
830
831
832
833
834
835
836
837
838
    rs.afterLast();
    if (rs.isAfterLast()) {
      System.out.println("afterLast() on empty RS should be no-op");
    }
   
    rs.beforeFirst();
    if (rs.isBeforeFirst()) {
      System.out.println("beforeFirst() on empty RS should be no-op");
    }

    rs.close();
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.