//This is only an example program on displaying data from database using java and mysql
//important information should be considered.
import java.sql.*;
public class DisplaySubject {
    static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
    static final String DATABASE_URL = "jdbc:mysql://localhost/doscstschedule";
    public static void main(String[] args) {
        Connection connection = null; // manages connection
        Statement statement = null; // query statement
        // connect to database books and query database
        try {
            Class.forName(JDBC_DRIVER); // load database driver class
            // establish connection to database
            connection =
                    DriverManager.getConnection(DATABASE_URL, "root","");
            // create Statement for querying database
            statement = connection.createStatement();
            // query database
            ResultSet resultSet = statement.executeQuery(
                    "SELECT subjCode,subjDesc, lecUnits, labUnits FROM subject");
            // process query results
            ResultSetMetaData metaData = resultSet.getMetaData();
            int numberOfColumns = metaData.getColumnCount();
            System.out.println("Subject Table of DOSCST Class Schedule Database:");
            for (int i = 1; i <= numberOfColumns; i++) {
                System.out.printf("%-30s\t", metaData.getColumnName(i));
            }
            System.out.println();
            while (resultSet.next()) {
                for (int i = 1; i <= numberOfColumns; i++) {
                    System.out.printf("%-30s\t", resultSet.getObject(i));
                }
                System.out.println();
            } // end while
        } // end try
        catch (SQLException sqlException) {
            sqlException.printStackTrace();
            System.exit(1);
        } // end catch
        catch (ClassNotFoundException classNotFound) {
            classNotFound.printStackTrace();
            System.exit(1);
        } // end catch
        finally // ensure statement and connection are closed properly
        {
            try {
                statement.close();
                connection.close();
            } // end try
            catch (Exception exception) {
                exception.printStackTrace();
                System.exit(1);
            } // end catch
        } // end finall
    }
}
 
No comments:
Post a Comment