Connecting to a Database with JDBC

// JDBC|Test – complete code
public class JDBCTest {

public static void main(String args[]){

RunDB runDB = new RunDB();

try{
runDB.loadDriver();
runDB.makeConnection();
runDB.buildStatement();
runDB.executeQuery();
}catch(Exception e){
e.printStackTrace();
}

}
}

//RunDB
import java.sql.*;

public class RunDB {

Connection connection;
Statement statement;

public void loadDriver() throws ClassNotFoundException{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}

public void makeConnection() throws SQLException {
connection=
DriverManager.getConnection("jdbc:odbc:purchaseOrder")
}

public void buildStatement() throws SQLException {
statement = connection.createStatement();
}

public void executeQuery() throws SQLException {

boolean foundResults =
statement.execute("SELECT * FROM Transaction");
if(foundResults){
ResultSet set = statement.getResultSet();
if(set!=null) displayResults(set);
}else {
connection.close();
}
}

void displayResults(ResultSet rs) throws SQLException {
ResultSetMetaData metaData = rs.getMetaData();
int columns=metaData.getColumnCount();
String text="";

while(rs.next()){
for(int i=1;i<=columns;++i) { text+="<"+metaData.getColumnName(i)+">";
text+=rs.getString(i);
text+="";
text+="n";
}
text+="n";
}

System.out.println(text);

}

}