Netbeans application connecting to SQL failure

[starter05]

guys, im very new to java and using databases in netbeans and sql, so im here for help. this is my code to connect my sql database with my java application. and every time i call method connect(), it fails(displaying Offline in remark 1).

i think my driver and DB URL also my username and password are all correct. and aso i connect the databes using Services -> Databases - > MySQL Server at localhost:3306[root], but this method still fails.

anyway, i use wamp, and i use phpmyadmin

i do appreciate all the help guys. pardon me for asking something that is basic. .thanks

[Rick Fincher]

Hi David,

One of the cool things about NetBeans is the code help in the editor.
Inside your catch clause below type "ex" that's the error object that
was thrown. Now type a period to get "ex." After a second a list of
all the methods of the Exception Object pop up. If you don't see it
type "control-space" and it will pop up.

One of the methods you'll see is "getMessage()" it returns a string of
the error message. The "printStackTrace()" method will give you the
full trace of the exception.

Instead of "Exception" in your catch clause you an use "SQLException".

Then when you type "ex." you'll see a few more methods with SQL specific
stuff.

Usually it's best to use the most restrictive exception class rather
than the catch all "Exception", no pun intended! It's easier to isolate
the exception that way.

Also only put the code in the try clause that will generate the errors,
in this case:

con = DriverManager.getConnection(db,u,p);
st = con.createStatement();

because they can both throw SQLException.

If you can't figure it out from there, show us the error messages and we might be able to help.

Rick



On 6/7/2012 6:14 AM, starter05 wrote:

[Gregg Wonderly]

The best choice you can make about Exception processing in Java, is to start
using logging right away. Don't get into the ex.printStackTrace() path at all.

To make the use of logging easy, there are a few code completion templates
already defined in netbeans. These are visible under the Tools->Options dialog
on the Editor pane, "Code Templates" tab.

Try typing 'loge' in netbeans, in a Java file and hit return. At the top of
your class, type 'logr' and hit return. Fix imports if you need to, and then
you've now got logging. The important thing to understand about
java.util.logging, is that it is customizable and configurable from a text file.
Read the javadocs for the Logger class, for more information on that.

Gregg Wonderly

On 6/7/2012 6:25 PM, Rick Fincher wrote:

[netero]

Hello,

I tried your sample in my config, and changed only the catch clause as suggested by Rick. For me your code is OK. So now I have 2 questions:

(1) Can you show us your imports? For instance, did you use these: