Friday, January 15, 2010

Displaying data in database using java and mySQL

//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