Package java.sql

Examples of java.sql.ResultSet.first()

480
481
482
483
484
485
486
487
488
489
490
        PreparedStatement prep2 = conn
                .prepareStatement("CALL TRIM(CHAR(0) FROM UTF8TOSTRING(DECRYPT('AES', RAWTOHEX(?), ?)))");
        prep2.setCharacterStream(1, new StringReader(key), -1);
        prep2.setCharacterStream(2, new StringReader(encrypted), -1);
        ResultSet rs2 = prep2.executeQuery();
        rs2.first();
        String decrypted = rs2.getString(1);
        prep2.close();
        assertEquals(value, decrypted);
        conn.close();
    }
View Full Code Here
203
204
205
206
207
208
209
210
211
212
213
        assertFalse(rs.next());
        assertFalse(rs.isBeforeFirst());
        assertTrue(rs.isAfterLast());
        assertEquals(0, rs.getRow());

        assertTrue(rs.first());
        assertEquals(1, rs.getInt(1));
        assertEquals(1, rs.getRow());

        assertTrue(rs.last());
        assertEquals(3, rs.getInt(1));
View Full Code Here
505
506
507
508
509
510
511
512
513
514
515
            if (!error) {
                throw e;
            }
        }
        try {
            boolean valid = rs.first();
            assertEquals(rows > 0, valid);
            if (valid) {
                assertState(rs, false, true, rows == 1, rows == 0);
            }
        } catch (SQLException e) {
View Full Code Here
648
649
650
651
652
653
654
655
656
657
658
  {
    int i = 0;
    ResultSet resultSet = null;
    try {
      resultSet = stmt.getGeneratedKeys();
      resultSet.first();
      i = resultSet.getInt(1);
    } catch (Exception e) {
      System.out.println("[Exception][CVDal.getAutoGeneratedKey] Exception Thrown: "+e);
      e.printStackTrace();
    } finally {
View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
  }

  public boolean load(Table obj) throws Exception {
    String query = "SELECT * FROM `"+obj.table+"` WHERE `"+obj.key+"` = ?"+obj.key;
    ResultSet rs = this.executeSelect(query, obj);
    if (rs.first())  {
      extendObject(rs, obj);
      rs.close();
      return true;
    }
    return false;
View Full Code Here
25
26
27
28
29
30
31
32
33
34
35
        String str2 = StringTokenizer.nextToken().trim();
        String str4 = StringTokenizer.nextToken().trim();
        PreparedStatement PreparedStatement = Connection.prepareStatement("SELECT * FROM users WHERE UPPER(user_id) = UPPER(?)");
        PreparedStatement.setString(1, str1);
        ResultSet ResultSet = PreparedStatement.executeQuery();
        if (ResultSet.first())
        {
          PreparedStatement.close();
          Connection.close();
          return;
        }
View Full Code Here
54
55
56
57
58
59
60
61
62
63
64
        if (str1.trim().equals("add"))
        {
          preparedstatement = Connection.prepareStatement("select user_id from users where user_id=?");
          preparedstatement.setString(1, str2);
          ResultSet resultset = preparedstatement.executeQuery();
          if (!resultset.first())
          {
            ErrorProcess.Error("The user( " + str2 + ") not existed", PrintWriter);
            preparedstatement.close();
            Connection.close();
            return;
View Full Code Here
65
66
67
68
69
70
71
72
73
74
75
          }
          preparedstatement.close();
          preparedstatement = Connection.prepareStatement("select * from privilege where user_id=? and rightstr='source_browser'");
          preparedstatement.setString(1, str2);
          resultset = preparedstatement.executeQuery();
          if (resultset.first())
          {
            ErrorProcess.Error("The user( " + str2 + ") existed", PrintWriter);
            preparedstatement.close();
            Connection.close();
            return;
View Full Code Here
84
85
86
87
88
89
90
91
92
93
94
        {
          preparedstatement = Connection.prepareStatement("select * from privilege where user_id=?" + (UserModel.isRoot(paramHttpServletRequest) ? "" : "and rightstr='source_browser'"));
          preparedstatement.setString(1, str2);
          ResultSet resultset = preparedstatement.executeQuery();

          if (!resultset.first())
          {
            ErrorProcess.Error("The user( " + str2 + ") not existed", PrintWriter);
            preparedstatement.close();
            Connection.close();
            return;
View Full Code Here
102
103
104
105
106
107
108
109
110
111
112
        } else
        {
          preparedstatement = Connection.prepareStatement("SELECT COUNT(*) AS total FROM privilege" + (UserModel.isRoot(paramHttpServletRequest) ? " order by rightstr" : " WHERE rightstr='source_browser'"));
        }
        ResultSet resultset = preparedstatement.executeQuery();
        resultset.first();
        resultset.close();
        preparedstatement.close();
        preparedstatement = Connection.prepareStatement("SELECT * FROM privilege" + (UserModel.isRoot(paramHttpServletRequest) ? " order by rightstr" : " WHERE rightstr='source_browser'"));
        resultset = preparedstatement.executeQuery();
        PrintWriter.println("<center><img src='./images/user.gif' alt='user'></center><br>");
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.