My program is:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
class First
{
public static void main(
String args[]) throws Exception
{
Statement stmt = null;
ResultSet rs = null;
Connection con = null;
try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection("jdbc:mysql://localhost/plantshop?user=root & password = mad");
stmt = con.createStatement();
rs = stmt.executeQuery("select * from Plant");
while(rs.next())
{
System.out.println(rs.getInt(1));
}
}
catch(SQLException ex)
{
System.out.println(ex);
}
catch(Exception ex)
{
ex.printStackTrace();
}
}
}
Run Time Error:
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:164)
at First.main(First.java:16)
Please help me, what is the problem and how will solve?