#resultset

[fortunatelycoldengineer]

What does the JDBC ResultSet interface? . . . . For more questions about Java https://bit.ly/465SkSw Check the above link

[facingissuesonit]

JDBC: ResultSet Interface

The object of ResultSet maintains a cursor pointing to a particular row of data. Initially, cursor points to before the first row. By default, ResultSet object can be moved forward only and it is not updatable.But we can make this object to move forward and backward direction by passing either TYPE_SCROLL_INSENSITIVE or TYPE_SCROLL_SENSITIVE in createStatement(int,int) method as well as we can…

View On WordPress

[goodanswerbiz]

Solution: How do I get the size of a java.sql.ResultSet? #it #fix #development

Solution: How do I get the size of a java.sql.ResultSet? #it #fix #development

How do I get the size of a java.sql.ResultSet?

Shouldn’t this be a pretty straightforward operation? However, I see there’s neither a size() nor length() method.

Answer [by JeeBee]: How do I get the size of a java.sql.ResultSet?

ResultSet rs = ps.executeQuery(); int rowcount = 0; if (rs.last()) { rowcount = rs.getRow(); rs.beforeFirst(); // not rs.first() because the rs.next() below will move…

View On WordPress

[sevennet-blog]

How to: How do I get the size of a java.sql.ResultSet?

How do I get the size of a java.sql.ResultSet?

Shouldn’t this be a pretty straightforward operation? However, I see there’s neither a size() nor length() method.

Answer: How do I get the size of a java.sql.ResultSet?

ResultSet rs = ps.executeQuery(); int rowcount = 0; if (rs.last()) { rowcount = rs.getRow(); rs.beforeFirst(); // not rs.first() because the rs.next() below will move on, missing…

View On WordPress

[coffee-mark]

JDBC ResultSet으로 select쿼리 결과값 가져오기

select쿼리 실행 시 executeQuery() 메서드를 사용하며, 실행 결과로 java.sql.ResultSet형으로 리턴한다.

  * ResultSet에서 자주사용하는 메서드 

 메서드 설명 next() 다음행으로 커스를 이동(다음행이 없으면 false리턴) getXxx(int columnIndex) columnIndex번째 컬럼의 값을 Xxx타입으로 가져온다 getXxx(String columnName) columnName 컬럼의 값을 Xxx타입으로 가져온다 close() ResultSet객체를 반환

  ResultSet과 관련된 더 많은 메서드는 다음을 참조. http://docs.oracle.com/javase/7/docs/api/java/sql/ResultSet.html

    /* 

- table schema -

  CREATE TABLE member{

    no number(2),

    name varchar2(10),

}

  */

  import java.sql.*;

  public class PSTMTInsert{

    public static void main(String[] args) {

        String driver = "oracle.jdbc.driver.OracleDriver";

        String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";

        String dbId = "scott";

        String dbPw = "tiger";

        Connection conn = null;

        PreparedStatement pstmt = null;

        ResultSet rs = null;

        try{       

            Class.forName(driver);

            conn = DriverManager.getConnection(url,dbId,dbPw);

            String sql = "SELECT no, name FROM member";   

            pstmt = conn.prepareStatement(sql);  

            rs = pstmt.executeQuery(); 

            while(rs.next()){

                 System.out.print(rs.getInt("no")); //System.out.print(rs.getInt(1));

                 System.out.print(" ");

                 System.out.print(rs.getString("name")); //System.out.print(rs.getString(1));

            }

        }catch(ClassNostFounException e){

            // driver로딩 실패...

        }catch(SQLException e){

            // sql 예외...

        }finally{

            if(rs != null){ try{ rs.close(); }catch(SQLException e){} }

            if(pstmt != null){ try{ pstmt.close(); }catch(SQLException e){} }

            if(conn != null){ try{ conn.close(); }catch(SQLException e){} }

        }

    } 

} 

  rs에 저장된 레코드의 값을 출력하기 위해서 while문을 이용한다. ResultSet의 next() 메서드로 커스를 이동시켜 다음행에 값이 있으면(리턴값이 true 이면) getXxx() 메서드를 이용해서 값을 가져온다.

  * ResultSet.next() 메서의 커스의 이동

[pure-essence-blog-blog]

Spring: check if a column exist using resultset

If you have a strange requirement in the rowMapper to check if a column exists or not, you could try to catch a SQLException of invalid column name or you could try:

public static boolean doesColumnExist(String columnName, ResultSet rs) throws SQLException{ ResultSetMetaData meta = rs.getMetaData(); int numCol = meta.getColumnCount(); for (int i = 1; i <= numCol; i++) { if(meta.getColumnName(i).equalsIgnoreCase(columnName)) { return true; } } return false; }