I am pretty fair on java but not on database. Can someone tell me whereI can find url that can find more information on jdbc with mysql. Ineed to know how to read and write from mysql on java or (jdbc?). Itwould be nice to have some example code.
you need the mysql driver, go tohttp://sourceforge.net/projects/mmmysql/ and downloadthe MM.MySQL or MySQL connector/j. It's come withinstruction on how to install it.
I already have mysql driver on my machine. My computer has win2000. Iput classpath c:\jdbc\mysql-connector-java-2.0.14-bin-jarWhen I run small program to test it. I get some errorsSQLException: No suitable driverUnable to load driver.java.lang.NullPointerExceptionat 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 andpassword. Someone already download java and mysql on my computer beforeI got this computer. I was wonder if they set the username and passwordas same as my computer username and passsword. How can we find out?