I have 3 errors after compiling

[coco]

Hi, I have this code:

Code:

package mysql; 
import java.sql.*; 

public class Hello {
	Connection connection; 
	
	private void displaySQLErrors(SQLException e) {
		System.out.println("SQLException: " + e.getMessage()); 
		System.out.println("SQLState: " + e.getSQLState()); 
		System.out.println("VendorError: " + e.getErrorCode()); 
	}
	
	public Hello() {
		try {
			Class.forName("com.mysql.jdbc.Driver").newInstance(); 
		}
		catch(SQLException e) {
			System.err.println("Unable to find and load driver"); 
			System.exit(1); 
		}
	}
	
	public void connectToDB() {
		try {
			connection = DriverManager.getConnection("jdbc:mysql://localhost/accounts?user=&password="); 
		}
		catch(SQLException e) {
			displaySQLErrors(e); 
		}
	}
	
	public void executeSQL() {
		try {
			Statement statement = connection.createStatement(); 
			
			ResultSet rs = statement.executeQuery("SELECT * FROM acc_acc"); 
			
			while(rs.next()) {
				System.out.println(rs.getString(1)); 
			}
			
			rs.close(); 
			statement.close(); 
			connection.close(); 
		}
		catch(SQLException e) {
			displaySQLErrors(e); 
		}
	}
	
	public static void main(String[] args) {
		Hello hello = new Hello(); 
		
		hello.connectToDB(); 
		hello.executeSQL(); 
	}
}

I have 3 errors after compiling:

Code:

C:\Program Files\Xinox Software\JCreator LE\MyProjects\Hello.java:15: unreported exception java.lang.ClassNotFoundException; must be caught or declared to be thrown
the second:
C:\Program Files\Xinox Software\JCreator LE\MyProjects\Hello.java:15: unreported exception java.lang.ClassNotFoundException; must be caught or declared to be thrown
the third:
C:\Program Files\Xinox Software\JCreator LE\MyProjects\Hello.java:17: exception java.sql.SQLException is never thrown in body of corresponding try statement.

How can i solve it?
Thanks.

[toby]

Class.forName() doesn't throw an SQLException, but it might throw a ClassNotFoundException if the class doesn't exist in it's classpath. So instead of catching an SQLException you should be catching a ClassNotFoundException (or something above it in the hierarchy like Exception).

[varunthecool]

catch(SQLException e)
use catch(Exception e)