Hi all,
i have developed a stand alone program that runs from the command line. this program connects to the mysql database but the results it returns are not right. i need your help on how best i can refactor the following code to provide the right results because this query should return all the firstnames in the database students.
private void prepareStatements( Connection dbConnection ) throws SQLException
{
System.out.println( "\nPreparing Statements.....");
changeFirstname = dbConnection.prepareStatement("SELECT firstname from students");
System.out.println( changeFirstname );
[ January 20, 2005: Message edited by: Bear Bibeault ]
i have developed a stand alone program that runs from the command line. this program connects to the mysql database but the results it returns are not right. i need your help on how best i can refactor the following code to provide the right results because this query should return all the firstnames in the database students.
private void prepareStatements( Connection dbConnection ) throws SQLException
{
System.out.println( "\nPreparing Statements.....");
changeFirstname = dbConnection.prepareStatement("SELECT firstname from students");
System.out.println( changeFirstname );
[ January 20, 2005: Message edited by: Bear Bibeault ]