need help to use java to connect to MYSQL DB 2007-11-29 - By Eman Hossny
Back
Hi all,
i need to use Eclipse(java SDK) to connect to MYSQL DB,
& i write the following code for connection, but when i run it no thing
happen, no output appear, & when i debug it, i found that the debuger was
stopped @ the line
conn=DriverManager.getConnection(connectionURL,"Eman","Eman");
-- ---- ---- ---- ---- ---- ---- ---- --my code for connection
String driver ="com.mysql.jdbc.Driver";
String dbName="travel";
String connectionURL = "jdbc:mysql://localhost/" + dbName;
try{
//load the driver
Class.forName(driver).newInstance();
conn=DriverManager.getConnection(connectionURL,"Eman","Eman");
System.out.println("Successfully connected to " +
"MySQL server using TCP/IP...");
}
catch(Exception e)
{
e.printStackTrace();
System.out.println("Error "+e.getMessage());
}
-- ---- ---- ---- ---- ---- ---- ---- ---
-note: i added the connector/j.jar to the classpath environment variable
-Is the connector/J version must be consistent with the jdk version?
-i consume more time to solve this problem but till now didn't reach to any
thing.any help please,
waitting for reply
--
Eman Hossny,
Teacher Assistant,
Computer Science Department,
Faculty of Computers and Information
Cairo University, Egypt
???? ????? ?? ????? ?? ????????
|
|
