Java Forum

Ask Question   UnAnswered
Home » Forum » Java       RSS Feeds

Database on mysql

  Asked By: Boell    Date: Mar 08    Category: Java    Views: 1428

I am pretty fair on java but not on database. Can someone tell me where
I can find url that can find more information on jdbc with mysql. I
need to know how to read and write from mysql on java or (jdbc?). It
would be nice to have some example code.



2 Answers Found

Answer #1    Answered By: Ella Brown     Answered On: Mar 08

you need the mysql  driver, go to
http://sourceforge.net/projects/mmmysql/ and download
the MM.MySQL or MySQL connector/j. It's come with
instruction on how to install it.

Answer #2    Answered By: Liam Bouchard     Answered On: Mar 08

I already have mysql  driver on my machine. My computer has win2000. I
put classpath c:\jdbc\mysql-connector-java-2.0.14-bin-jar

When I run small program to test it. I get some errors

SQLException: No suitable driver
Unable to load driver.
at DBTest.drop(DBTest.java:100)
at DBTest.main(DBTest.java:115)
Exception in thread "main" 

I could not figure it out. I don't think mysql use username and
password. Someone already download java  and mysql on my computer before
I got this computer. I was wonder if they set the username and password
as same as my computer username and passsword. How can we find  out?

Didn't find what you were looking for? Find more on Database on mysql Or get search suggestion and latest updates.