{{theTime}}

Search This Blog

Total Pageviews

JDBC4.1 try-with-resource statement

JDBC4.1 supports try-with-resource statement.
 - Try-with-resource Automatically close connection, statement and resultset regardless of sqlexception 


    public static void fetchData(Connection conn) throws SQLException {
        final String qry = "select rank from student" ;
        try(PreparedStatement stmt = conn.prepareStatement(qry)) {
            ResultSet rs = stmt.executeQuery() ;
            while(rs.next()){
                System.out.println(rs.getInt(1)) ;
            }
        }        
    }

No comments:

Generate Models from SQL Server using Entity Framework Core

To generate models from SQL Server database tables using Entity Framework (EF) in .NET, you can follow the Database-First approach with Ent...