Re: How to use jdbc to connect to database?

[jonas]

Weng (or is it Zhiyi),

It seems like you've got a space character to much in your first code snippet (which appears in the error message as well). It'd probably function allright if you change it to this:

...getConnection( "jdbc:mysql://localhost/books?user=<user>&password=<password>" );

Don't even bother try to get your other statement effort to work. It won't.

Another thing. If you find it difficult to manage your database with scripts, usa a GUI tool, like SQLyog. I use it myself, cause I'm not very fond of hacking into my DBMS just to get my web site goin'. SQLyog is free, get it at download.com.

Good luck

/Jonas