Hi,
I am trying to connect with mysql through java program but i am getting error:
My code is:
import java.sql.*;
public class FirstExample {
// JDBC driver name and database URL
static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
static final String DB_URL = "jdbc:mysql://localhost/test";
// Database credentials
static final String USER = "root";
static final String PASS = "z";
public static void main(String[] args) {
Connection conn = null;
Statement stmt = null;
try{
//STEP 2: Register JDBC driver
Class.forName("com.mysql.jdbc.Driver");
//STEP 3: Open a connection
System.out.println("Connecting to database...");
conn = DriverManager.getConnection(DB_URL,USER,PASS);
//STEP 4: Execute a query
System.out.println("Creating statement...");
stmt = conn.createStatement();
String sql;
sql = "SELECT name, owner FROM pet";
ResultSet rs = stmt.executeQuery(sql);
//STEP 5: Extract data from result set
while(rs.next()){
//Retrieve by column name
String name = rs.getString("name");
String owner = rs.getString("owner");
//Display values
System.out.print("name: " + name);
System.out.print(", owner: " + owner);
}
//STEP 6: Clean-up environment
rs.close();
stmt.close();
conn.close();
}catch(SQLException se){
//Handle errors for JDBC
se.printStackTrace();
}catch(Exception e){
//Handle errors for Class.forName
e.printStackTrace();
}finally{
//finally block used to close resources
try{
if(stmt!=null)
stmt.close();
}catch(SQLException se2){
}// nothing we can do
try{
if(conn!=null)
conn.close();
}catch(SQLException se){
se.printStackTrace();
}//end finally try
}//end try
System.out.println("Goodbye!");
}//end main
}//end FirstExample
I am getting following error:
D:\Zulfi\java prog\2016\mysql>javac FirstExample.java
D:\Zulfi\java prog\2016\mysql>java FirstExample
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at FirstExample.main(FirstExample.java:16)
Goodbye!
My path variable is:
>echo %path%
C:\jdk1.8.0_45\bin;C:\ProgramData\Oracle\Java\javapath;C:\Program Files\Broadcom
\Broadcom 802.11\Driver;;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem
;C:\Windows\System32\WindowsPowerShell\v1.0\;c:\Program Files\WIDCOMM\Bluetooth
Software\;c:\Program Files\WIDCOMM\Bluetooth Software\syswow64;C:\Program Files\
Broadcom\WHL\;C:\Program Files\Broadcom\WHL\syswow64;C:\Program Files\Broadcom\W
HL\SysWow64\;C:\Program Files\Broadcom\WHL\SysWow64\syswow64;D:\download\mysql-c
onnector-java-5.0.8.zip\mysql-connector-java-5.0.8;D:\download
jar file is located in download folder
>
D:\download>dir *.jar
Volume in drive D has no label.
Volume Serial Number is B269-AF38
Directory of D:\download
03/24/2016 09:49 PM 540,852 mysql-connector-java-5.0.8-bin.jar
1 File(s) 540,852 bytes
0 Dir(s) 609,787,019,264 bytes free
D:\download>
Somebody please guide me. I am using Windows 7 & mysql version is:
mysql-5.1.68-win32
Zulfi.