Curtis Bridges

/*Thanks guys. We have this down to 1 error on line # 15 <identifier> expected.
I think it's something else though, but can't figure it out.
It's thowing an exception now.

java.lang.NoClassDefFoundError: JdbcRowSetTest
Exception in thread "main"

The compiler keeps wanting ";"on the last 2 lines
Please help.
Curt
*/
import javax.sql.rowset.JdbcRowSet; import com.sun.rowset.JdbcRowSetImpl; import java.sql.*; public class JdbcRowSetTest { //JDBC database URL, username and password static final String DRIVER = "com,mysql.jdbc.Driver"; static final String DATABASE_URL = "jdbc:mysql://localhost/db challenge.mdb"; static final String USERNAME = "jhtp7"; static final String PASSWORD = "jhtp7"; public JdbcRowSetTest { //connect and query database try { Class.forName(ACCESS); // specify properties JdbcRowset rowset = JdbcRowSetImpl(); rowset.setUrl (db challenge.mdb); rowset.setUserName(jhtp7); rowset.setPassword (jhtp7); rowset.setCommand ("SELECT * FROM authors"); rowset.set.execute(); // process query results ResultSetMetaData metaData = rowset.getMetaData(); int numberOfColumns = metaData.getColumnCount(); System.out.println(" Authors Table of db challenge Database:\n"); // display rowset header for ( int i = 1; i <= numberOfColumns; i++) System.out.printf("db challenge.mdb",metaData.getColumnName(i))); System.out.println() ; //display each row while( rowSet.next) { for ( int i = 1; i <= numberOfColumns i++) System.out.printf("hhh"rowSet.getObject(i)); System.out.println (); } //end while // close rowSet.close(); }//end try catch(SQL Exception sql Exception) { sql Exception.printStackTrace(); System.exit(1); }//end catch catch(ClassNotFoundException classNotFound) { classNotFound.printStackTrace(); System.exit(1); }//end catch } // end DisplayAuthors constructor // Launch public static void main( String args[] ) { JdbcRowSetTest appication = new JdbcRowSetTest(); };//end main };/*end class JdbcRowSetTest*/

Thank you, Rob,
I changed rowset as suggested. Inserted your code but am still getting errors on # 29
cannot find symbol variable DriverManager,cannot find symbol class Connection
# 31 cannot find symbol class Statement
# 35 cannot find symbol variable ResultSet
# 39 and # 42 cannot find symbol variable rs
Any ideas? New code below.


import java.sql.ResultSetMetaData; import java.sql.SQLException; import javax.sql.rowset.JdbcRowSet; import com.sun.rowset.JdbcRowSetImpl; public class JdbcRowSetTest { //JDBC database URL, username and password static final String DRIVER = "com.mysql.jdbc.Driver"; static final String DATABASE_URL = "jdbc:mysql://localhost/books"; static final String USERNAME = "jhtp7"; static final String PASSWORD = "jhtp7"; public JdbcRowSetTest() { //connect and query database try { // load the class Class.forName(DRIVER); // get a connection object Connection con = DriverManager.getConnection(DATABASE_URL, USERNAME, PASSWORD); // get a statement Statement stmt = con.createStatement(); // NOTE: also check out c.prepareStatement! // execute the statement ResultSet = stmt.executeQuery("SELECT * FROM authors"); // get meta data; optionally ResultSetMetaData md = rs.getMetaData(); // iterate over the results while (rs.next()) // with parentheses! { rs.close(); stmt.close(); } }//end try catch ( SQLException sqlException ) { sqlException.printStackTrace(); System.exit(1); }//end catch catch(ClassNotFoundException classNotFound) { classNotFound.printStackTrace(); System.exit(1); }//end catch } // end DisplayAuthors constructor // Launch public static void main( String args[] ) { JdbcRowSetTest appication = new JdbcRowSetTest(); };//end main }//end class JdbcRowSetTest

I need some help. I'm trying to connect to a database I created in MS ACCESS the file name is db challenge.mdb
would somebody heip me out ? Please.
I'm getting 3 errors on lines 44,47,52 saying cannot find symbol variable rowSet
1 error on line 26 that say's cannot find symbol method JdbcRowSetImpl()
1 error on line 28 that say's cannot find symbol method setUserName(java.lang.String)

import java.sql.ResultSetMetaData; import java.sql.SQLException; import javax.sql.rowset.JdbcRowSet; import com.sun.rowset.JdbcRowSetImpl; public class JdbcRowSetTest { //JDBC database URL, username and password static final String DRIVER = "com.mysql.jdbc.Driver"; static final String DATABASE_URL = "jdbc:mysql://localhost/books"; static final String USERNAME = "jhtp7"; static final String PASSWORD = "jhtp7"; public JdbcRowSetTest() { //connect and query database try { Class.forName(DRIVER); // specify properties JdbcRowSet rowset = JdbcRowSetImpl(); rowset.setUrl (DATABASE_URL); rowset.setUserName(USERNAME); rowset.setPassword (PASSWORD); rowset.setCommand ("SELECT * FROM authors"); rowset.execute(); // process query results ResultSetMetaData metaData = rowset.getMetaData(); int numberOfColumns = metaData.getColumnCount(); System.out.println(" Authors Table of Books Database"); // display rowset header for ( int i = 1; i <= numberOfColumns; i++) System.out.printf("hhh",metaData.getColumnName(i)); System.out.println (); //display each row while( rowSet.next) { for ( int i = 1; i <= numberOfColumns; i++) System.out.printf("hhh",rowSet.getObject(i)); System.out.println (); } //end while // close rowSet.close(); }//end try catch ( SQLException sqlException ) { sqlException.printStackTrace(); System.exit(1); }//end catch catch(ClassNotFoundException classNotFound) { classNotFound.printStackTrace(); System.exit(1); }//end catch } // end DisplayAuthors constructor // Launch public static void main( String args[] ) { JdbcRowSetTest appication = new JdbcRowSetTest(); };//end main }//end class JdbcRowSetTest

I need some help. I'm trying to connect to a database I created in MS ACCESS the file name is db challenge.mdb
would somebody heip me out ? Please.
I'm getting 3 errors on lines 44,47,52 saying cannot find symbol variable rowSet
1 error on line 26 that say's cannot find symbol method JdbcRowSetImpl()
1 error on line 28 that say's cannot find symbol method setUserName(java.lang.String)


import java.sql.ResultSetMetaData; import java.sql.SQLException; import javax.sql.rowset.JdbcRowSet; import com.sun.rowset.JdbcRowSetImpl; public class JdbcRowSetTest { //JDBC database URL, username and password static final String DRIVER = "com.mysql.jdbc.Driver"; static final String DATABASE_URL = "jdbc:mysql://localhost/books"; static final String USERNAME = "jhtp7"; static final String PASSWORD = "jhtp7"; public JdbcRowSetTest() { //connect and query database try { Class.forName(DRIVER); // specify properties JdbcRowSet rowset = JdbcRowSetImpl(); rowset.setUrl (DATABASE_URL); rowset.setUserName(USERNAME); rowset.setPassword (PASSWORD); rowset.setCommand ("SELECT * FROM authors"); rowset.execute(); // process query results ResultSetMetaData metaData = rowset.getMetaData(); int numberOfColumns = metaData.getColumnCount(); System.out.println(" Authors Table of Books Database"); // display rowset header for ( int i = 1; i <= numberOfColumns; i++) System.out.printf("hhh",metaData.getColumnName(i)); System.out.println (); //display each row while( rowSet.next) { for ( int i = 1; i <= numberOfColumns; i++) System.out.printf("hhh",rowSet.getObject(i)); System.out.println (); } //end while // close rowSet.close(); }//end try catch ( SQLException sqlException ) { sqlException.printStackTrace(); System.exit(1); }//end catch catch(ClassNotFoundException classNotFound) { classNotFound.printStackTrace(); System.exit(1); }//end catch } // end DisplayAuthors constructor // Launch public static void main( String args[] ) { JdbcRowSetTest appication = new JdbcRowSetTest(); };//end main }//end class JdbcRowSetTest

/*Please help. I'm trying to throw an IllegalArgumentException.
*If any test score in the array is negative or greater than 100
*using a try block, but am having little if any progress after many days of work.
* I am still getting an error mesage saying not a statement on line 74 and ";"expected on the same line
*The program will compute the average and display an Error invalid Score!message for an average over 100
and will compute a negative average and display an Error invalid Score!message for an average below 0 , but
It is not doing this using the try block. The way I am interpreting the instructions is that the try block is
to make this happen, if any testScore is entered that is neg. or > 100 before the average is calculated.
Would someone please make the corrections, so that I can see what I'm missing. I have read several tutorials
and can't find the answer. I have tore this down and built it back one line at a time.

*Instructions:
Write a class named TestScores.
The class constructor should accept an array of test scores as its argument.
The class should have a method that returns the average of the test scores.
If any test score in the array is negative or greater than 100, the class should throw an IllegalArgumentException.
Demonstrate the class in a program.

*/i[CODE]mport java.io.*; // For File class and FileNotFoundException import java.util.Scanner;// For Keyboard input public class TestScores { public static void main(String[] args){ //Variable Declarations Scanner keyboard = new Scanner(System.in); char testScore=userInput; int testScore1=0; int testScore2=0; int testScore3=0; int averageScore; int userInput; //User Prompts System.out.print("Please enter your 1st test score: "); testScore1 = keyboard.nextInt(); System.out.print("Please enter your 2nd test score: "); testScore2 = keyboard.nextInt(); System.out.print("Please enter your 3rd test score: "); testScore3 = keyboard.nextInt(); //Array to hold user input char[] userInput = new char[10] ; char max = 100 ; //To calculate Average Score averageScore = (testScore1 + testScore2 + testScore3)/3; ///////////////////////////////////////////////////////////////////////////////////////////////////////////////// // Try to assign a negative number to the testScore field. try { char [] = new char[10] ("testScore "-1); } catch(IllegalArgumentException e) { System.out.println(IllegalArgumentException); } /////////////////////////////////////////////////////////////////////////////////////////////////////////////////// //To display average score and letter grade if( testScore < 0) System.out.println("\nError invalid Score!" + "invalid Score!"); else if (averageScore < 60) System.out.println("\nYour average score is " + averageScore + " and your grade is an F"); else if(averageScore < 70) System.out.println("\nYour average score is " + averageScore + " and your grade is an D"); else if(averageScore < 80) System.out.println("\nYour average score is " + averageScore + " and your grade is an C"); else if(averageScore < 90) System.out.println("\nYour average score is " + averageScore + " and your grade is an B"); else if(averageScore < 100) System.out.println("\nYour average score is " + averageScore +" and your grade is an A"); else if( testScore > 100) System.out.println("\nError invalid Score!" + "invalid Score!"); } }
[/CODE]

/*Please help. I'm trying to throw an IllegalArgumentException.
*If any test score in the array is negative or greater than 100
*using a try block, but am having little if any progress after 9 hours of work.
* I am still getting an error mesage saying illegal start of expression and ) expected on line 48.
*The program will compute the average and display an Error invalid Score!message for average over 100
* but only calculates the - average without the Error invalid Score! message.
*Please help to make this work.
*
*
*Instructions:
Write a class named TestScores.
The class constructor should accept an array of test scores as its argument.
The class should have a method that returns the average of the test scores.
If any test score in the array is negative or greater than 100, the class should throw an IllegalArgumentException.
Demonstrate the class in a program.

*/import java.io.*; // For File class and FileNotFoundException import java.util.Scanner;// For Keyboard input public class TestScores { public static void main(String[] args){ //Variable Declarations Scanner keyboard = new Scanner(System.in); int TestScore =0; int testScore1=0; int testScore2=0; int testScore3=0; int averageScore; int userInput; //User Prompts System.out.print("Please enter your 1st test score: "); testScore1 = keyboard.nextInt(); System.out.print("Please enter your 2nd test score: "); testScore2 = keyboard.nextInt(); System.out.print("Please enter your 3rd test score: "); testScore3 = keyboard.nextInt(); //Array to hold user input int [0,1,2]TestScores = new int TestScores [0,1,2(testScore1,testScore2,testScore3)]]; int max = 100 ; /** * Constructor */ public TestScores(int testScore) { if ( testScore < 0 || testScore > 100) testScore = userInput; else TestScore = testScore ; } // Try to assign a negative number to the TestScores field. try { TestScores = new int ("testScores ",-1); catch (IllegalArgumentException e) } finally { System.out.println(IllegalArgumentException); //To calculate Average Score averageScore = (testScore1 + testScore2 + testScore3)/3; //To display average score and letter grade if(testScore < 0) System.out.println("\nError invalid Score!"); else if (averageScore < 60) System.out.println("\nYour average score is " + averageScore + " and your grade is an F"); else if(averageScore < 70) System.out.println("\nYour average score is " + averageScore + " and your grade is an D"); else if(averageScore <80) System.out.println("\nYour average score is " + averageScore + " and your grade is an C"); else if(averageScore<90) System.out.println("\nYour average score is " + averageScore + " and your grade is an B"); else if(averageScore <=100) System.out.println("\nYour average score is " + averageScore +" and your grade is an A"); else (testScore > 100) System.out.println("\nError invalid Score!"); } } }

/*Please help. I'm trying to throw an IllegalArgumentException.
*If any test score in the array is negative or greater than 100
*using a try block, but am having little if any progress after 9 hours of work.
* I am still getting an error mesage saying illegal start of expression and ) expected on line 48.
*The program will compute the average and display an Error invalid Score!message for average over 100
* but only calculates the - average without the Error invalid Score! message.
*Please help to make this work.
*
*
*Instructions:
Write a class named TestScores.
The class constructor should accept an array of test scores as its argument.
The class should have a method that returns the average of the test scores.
If any test score in the array is negative or greater than 100, the class should throw an IllegalArgumentException.
Demonstrate the class in a program.

*/import java.io.*; // For File class and FileNotFoundException import java.util.Scanner;// For Keyboard input public class TestScores { public static void main(String[] args){ //Variable Declarations Scanner keyboard = new Scanner(System.in); int TestScore =0; int testScore1=0; int testScore2=0; int testScore3=0; int averageScore; int userInput; //User Prompts System.out.print("Please enter your 1st test score: "); testScore1 = keyboard.nextInt(); System.out.print("Please enter your 2nd test score: "); testScore2 = keyboard.nextInt(); System.out.print("Please enter your 3rd test score: "); testScore3 = keyboard.nextInt(); //Array to hold user input int [0,1,2]TestScores = new int TestScores [0,1,2(testScore1,testScore2,testScore3)]]; int max = 100 ; /** * Constructor */ public TestScores(int testScore) { if ( testScore < 0 || testScore > 100) testScore = userInput; else TestScore = testScore ; } // Try to assign a negative number to the TestScores field. try { TestScores = new int ("testScores ",-1); catch (IllegalArgumentException e) } finally { System.out.println(IllegalArgumentException); //To calculate Average Score averageScore = (testScore1 + testScore2 + testScore3)/3; //To display average score and letter grade if(testScore < 0) System.out.println("\nError invalid Score!"); else if (averageScore < 60) System.out.println("\nYour average score is " + averageScore + " and your grade is an F"); else if(averageScore < 70) System.out.println("\nYour average score is " + averageScore + " and your grade is an D"); else if(averageScore <80) System.out.println("\nYour average score is " + averageScore + " and your grade is an C"); else if(averageScore<90) System.out.println("\nYour average score is " + averageScore + " and your grade is an B"); else if(averageScore <=100) System.out.println("\nYour average score is " + averageScore +" and your grade is an A"); else (testScore > 100) System.out.println("\nError invalid Score!"); } } }

It was supposd to be a construcor. hanks for taking the time to look at it.
Curt

--------------------------------------------------------------------------------

Hello,
I am once again askng for help. This is a homework assignment I am having rouble getting to compile. I keep getting this message "'{' expected" for line 13. As you can see there is an opening brace there. If I remove the brace and I get this message "'class' or 'interface' expected" for lines 21, 71, 74.
If someone could take a peek at it would be appreciated. I have included my code along with the instructions, and have marked the suspect code with .javascript: x()
censored Thank you.

Write a class named Employee that has the following fields:
* name. The name field is a ser�ng object that holds the employee's name.
* idlumber. The idRumber is an int variable that holds the employee's ID number. � department. The department field is a str�ng object that holds the name of the department where the employee works.
� position. The position field is a str�ng object that holds the employee's job title.
Write appropriate mutator methods that store values in these fields and accessor methods that return the values in these fields. Once you have the written the class, write a separate program that creates three Employee objects to hold the following data.
Name ID Number Department Position Susan Meyers 47899 Accounting Vice President Mark Jones 39119 IT Programmer Joy Rogers 81774 Manufacturing Engineer
The program should store this data in the three objects and then display the data for each employee on the screen.
*/

Code: public class Employee { public Employee() { } public static void main(String[] args) { } } public class Employee(){ javascript: x() censored String name, position, department; int idNumber; }javascript: x() censored//21 public Employee(String name, String position, String department, int idNumber) {:hair: name = name; idNumber = idNumber; position = position; department = department; } //Methods //Accessor Methods public String getName() { return name; } public int getId() { return idNumber; } public String getDept() { return department; } public double getPosition() { return position; } //Mutator Methods public void setName(String name) { name = name; } public void setId(int idNumber) { idNumber = idNumber; } public void setDept(String department) { department = department; } public void setPosition(String position) { position = position; }javascript: x() censored//71 } javascript: x() censored//74 I am using JCreator for a compiler