/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package testingConnection;

import java.sql.Connection;
import java.sql.Statement;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
/**
 *
 * @author namko
 */
public class DisplayAuthors {
    static final String DATABASE_URL="jdbc:mysql://localhost/books";
    public static void main(String args[]){
        Connection connection = null;
        Statement statement = null;
        ResultSet resultSet = null;
        try
        {
            connection = DriverManager.getConnection(DATABASE_URL,"root","");
            statement = connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
            resultSet = statement.executeQuery("SELECT * FROM authors");

            while(resultSet.next()){
                resultSet.updateString("lastname","Karki");
                resultSet.updateRow();
            }
            resultSet.beforeFirst();
            ResultSetMetaData metaData = resultSet.getMetaData();
            int numberOfColumns = metaData.getColumnCount();
            System.out.println("Authors Table:");

            for(int i=1; i<=numberOfColumns; i++)
                System.out.printf( "%-8s\t",metaData.getColumnName(i));
                System.out.println();

            while(resultSet.next())
            {
            for ( int i=1; i<= numberOfColumns; i++ )
                System.out.printf( "%-8s\t",resultSet.getObject(i));
                System.out.println();

            }
        }
        catch(SQLException sqlException)
        {
            sqlException.printStackTrace();
        }
        finally
        {
            try
            {
                resultSet.close();
                statement.close();
                connection.close();
            }
            catch (Exception exception)
            {
                exception.printStackTrace();
            }
        }
    }
}