This week's book giveaway is in the General Computing forum.
We're giving away four copies of Arduino in Action and have Martin Evans, Joshua Noble, and Jordan Hochenbaum on-line!
See this thread for details.
The moose likes JDBC and the fly likes connecting to mysql Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "connecting to mysql" Watch "connecting to mysql" New topic
Author

connecting to mysql

walid aly
Ranch Hand

Joined: Nov 06, 2002
Posts: 38
Dear friends
can anyone help me how to load and how ro connect to a database in mysql
i just need the 2 lines of loading driver and opnening connecection.i already downladed connectorj and set the classpath 4 it.
thanks
walid
Barry Gaunt
Ranch Hand

Joined: Aug 03, 2002
Posts: 7729
I did it by following the code in these instructions:
JavaRanch CattleDrive JDBC Assignments
I used Class.forName( "com.mysql.jdbc.Driver" ); to load the driver with connector/j.
And Connection con = DriverManager.getConnection( "jdbc:mysql://localhost/drain?user=bunghole&password=plug" ); gave me a connection.
[ January 25, 2003: Message edited by: Barry Gaunt ]

Ask a Meaningful Question and HowToAskQuestionsOnJavaRanch
Getting someone to think and try something out is much more useful than just telling them the answer.
 
I agree. Here's the link: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: connecting to mysql
 
Similar Threads
Mysql
Using datasource in netbeans to get connection
Advice of database type is needed
Tell me one (Handy) DataBase for Java ?
getting last row