ResultSet: first() : ResultSet « java.sql « Java by API






ResultSet: first()

 


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Main {

  public static Connection getConnection() throws Exception {
    String driver = "org.gjt.mm.mysql.Driver";
    String url = "jdbc:mysql://localhost/octopus";
    String username = "root";
    String password = "root";
    Class.forName(driver);
    Connection conn = DriverManager.getConnection(url, username, password);
    return conn;
  }

  public static void main(String[] args) {
    Connection conn = null;
    Statement stmt = null;
    ResultSet rs = null;
    try {
      conn = getConnection();
      String query = "select id, name from employees";
      stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
      rs = stmt.executeQuery(query);
      while (rs.next()) {
        String id = rs.getString(1);
        String name = rs.getString(2);
        System.out.println("id=" + id + "  name=" + name);
      }
      rs.first();
      rs.deleteRow();
      rs.beforeFirst();
      while (rs.next()) {
        String id = rs.getString(1);
        String name = rs.getString(2);
        System.out.println("id=" + id + "  name=" + name);
      }
    } catch (Exception e) {
      e.printStackTrace();
      System.exit(1);
    } finally {
      try {
        rs.close();
        stmt.close();
        conn.close();

      } catch (SQLException e) {
        e.printStackTrace();
      }
    }
  }
}
   

   
  








Related examples in the same category

1.ResultSet.CLOSE_CURSORS_AT_COMMIT
2.ResultSet.CONCUR_READ_ONLY
3.ResultSet.CONCUR_UPDATABLE
4.ResultSet.HOLD_CURSORS_OVER_COMMIT
5.ResultSet.TYPE_SCROLL_INSENSITIVE
6.ResultSet.TYPE_SCROLL_SENSITIVE
7.ResultSet: TYPE_FORWARD_ONLY
8.ResultSet: absolute(int row)
9.ResultSet: beforeFirst()
10.ResultSet: cancelRowUpdates()
11.ResultSet: close()
12.ResultSet: deleteRow()
13.ResultSet.getAsciiStream(int columnIndex)
14.ResultSet: getBinaryStream(int columnIndex)
15.ResultSet: getBigDecimal(int columnIndex)
16.ResultSet: getBlob(int columnIndex)
17.ResultSet: getBlob(String colName)
18.ResultSet: getBytes(int columnIndex)
19.ResultSet: getClob(int columnIndex)
20.ResultSet: getConcurrency()
21.ResultSet: getDate(int columnIndex)
22.ResultSet: getDouble(String columnLabel)
23.ResultSet: getInt(int columnIndex)
24.ResultSet: getInt(String columnName)
25.ResultSet: getMetaData()
26.ResultSet: getObject(int columnIndex)
27.ResultSet: getObject(String columnLabel)
28.ResultSet: getRef(int columnIndex)
29.ResultSet: getRow()
30.ResultSet: getShort(String columnLabel)
31.ResultSet: getString(int columnIndex)
32.ResultSet: getString(String columnLabel)
33.ResultSet: getTime(int columnIndex)
34.ResultSet: getTimestamp(int columnIndex)
35.ResultSet: getType()
36.ResultSet: getWarnings()
37.ResultSet: insertRow()
38.ResultSet: isAfterLast()
39.ResultSet: isBeforeFirst()
40.ResultSet: isFirst()
41.ResultSet: last()
42.ResultSet: moveToInsertRow()
43.ResultSet: next()
44.ResultSet: previous()
45.ResultSet: refreshRow()
46.ResultSet: relative(int rows)
47.ResultSet: setFetchSize(int rows)
48.ResultSet: updateInt(String columnLabel, int x)
49.ResultSet: updateRow()
50.ResultSet: updateDouble(int columnIndex, double x)
51.ResultSet: updateString(String columnName, String x)
52.ResultSet: wasNull()