//add user to authors

public static void main(String[] args){
    final String DATABASE_URL = "jdbc:mysql://localhost:3306/books";
    final String SELECT_QUERY = "SELECT authorid, firstName, lastName FROM authors";

        try{
            //  1. get connection
            Connection connection= DriverManager.getConnection(
                DATABASE_URL, "root", "Password123");

            //  2. create a statement
            Statement statement= connection.createStatement();

            //  3. execute sql query
            //ResultSet resultSet= statement.executeQuery(SELECT_QUERY) ;
            String sql= "insert into authors"
                        +"(authorid, firstName, lastName)"
                        +"values ('7', 'Jake', 'Paul')";
            statement.executeUpdate(sql);
            System.out.println("Added User...");


            //  4. process result set
            ResultSetMetaData metaData = resultSet.getMetaData();
            int numberOfColumns = metaData.getColumnCount();
            System.out.printf("Authors Table of Books Database:%n%n");

            // display the names of the columns in the ResultSet
            for (int i = 1; i <= numberOfColumns; i++)
                System.out.printf("%-8s\t", metaData.getColumnName(i) );
                System.out.println();


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

        }catch(Exception sqlExc){
            sqlExc.printStackTrace();
        }

    }//end of main
====================
//edit a user


public static void main(String[] args){
    final String DATABASE_URL = "jdbc:mysql://localhost:3306/books";
    final String SELECT_QUERY = "SELECT authorid, firstName, lastName FROM authors";

        try{
            //  1. get connection
            Connection connection= DriverManager.getConnection(
                DATABASE_URL, "root", "Password123");

            //  2. create a statement
            Statement statement= connection.createStatement();

            //  3. execute sql query
            ResultSet resultSet= statement.executeQuery(SELECT_QUERY) ;

            String sql= "update authors"
                        +"set firstName= 'Logan' "
                        +"where id= 7";
            statement.executeUpdate(sql);
            System.out.println("Update Complete...");


            //  4. process result set
            //ResultSetMetaData metaData = resultSet.getMetaData();
            int numberOfColumns = metaData.getColumnCount();
            System.out.printf("Authors Table of Books Database:%n%n");

            // display the names of the columns in the ResultSet
            for (int i = 1; i <= numberOfColumns; i++)
                System.out.printf("%-8s\t", metaData.getColumnName(i) );
                System.out.println();


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

        }catch(Exception sqlExc){
            sqlExc.printStackTrace();
        }

}//end of main(edited)
//delete a user


public static void main(String[] args){
    final String DATABASE_URL = "jdbc:mysql://localhost:3306/books";
    final String SELECT_QUERY = "SELECT authorid, firstName, lastName FROM authors";

        try{
            //  1. get connection
            Connection connection= DriverManager.getConnection(
                DATABASE_URL, "root", "Password123");

            //  2. create a statement
            Statement statement= connection.createStatement();

            //  3. execute sql query
            //ResultSet resultSet= statement.executeQuery(SELECT_QUERY) ;
            String sql= "delete from authors where lastName= 'Paul' ";

            int rowsAffected= statement.executeUpdate(sql);
            System.out.println("Rows affected: "+rowsAffected);
            System.out.println("Delete Complete...");



            //  4. process result set
            ResultSetMetaData metaData = resultSet.getMetaData();
            int numberOfColumns = metaData.getColumnCount();
            System.out.printf("Authors Table of Books Database:%n%n");

            // display the names of the columns in the ResultSet
            for (int i = 1; i <= numberOfColumns; i++)
                System.out.printf("%-8s\t", metaData.getColumnName(i) );
                System.out.println();


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

        }catch(Exception sqlExc){
            sqlExc.printStackTrace();
        }

}//end of main