Do you have the mysql jdbc library installed? You need to add that to your
classpath using the -cp argument to javac.
--
Sent from my Android phone
Rajveer Singh <torajveersi...@gmail.com> wrote:
>Hello guys,
>
>I've written my very first program in JAVA for jdbc connection with mysql as
>below:-
>
>[root@base laxman]# cat database.java
>*import java.sql.*;*
>* class database
> {
> public static void main(String args[]) throws Exception
> {
> //register driver
> DriverManager.registerDriver(new com.mysql.jdbc.Driver());*
>* //Establish connection
> Connection
>con=DriverManager.getConnection("jdbc:mysql://localhost:3306/test?user=root&password=redhat");
>*
>* //Create a sql statement
> Statement stmt=con.createStatement();*
>* //Excecute the statement
> ResultSet rs= stmt.executeQuery("show databases");*
>* //retrieve from resultset and desplay data
> while(rs.next())
> {
> System.out.println(rs.getString(1));
> }*
>* //close connection
> con.close();
> }
>}*
>
>[root@base laxman]#
>but when I try to compile it, it's giving me following error:-
>[root@base laxman]# javac database.java
>database.java:8: package com.mysql.jdbc does not exist
> DriverManager.registerDriver(new com.mysql.jdbc.Driver());
> ^
>1 error
>[root@base laxman]#
>
>Please help me to compile it.
>
>Thanks in advance.
>
>Regards,
>Raj
>
>--
>To post to this group, send email to
>javaprogrammingwithpassion@googlegroups.com
>To unsubscribe from this group, send email to
>javaprogrammingwithpassion+unsubscr...@googlegroups.com
>For more options, visit this group at
>http://groups.google.com/group/javaprogrammingwithpassion?hl=en
--
To post to this group, send email to javaprogrammingwithpassion@googlegroups.com
To unsubscribe from this group, send email to
javaprogrammingwithpassion+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/javaprogrammingwithpassion?hl=en
