
I compiling my jdbcodbc progrm. D:\Java\jdk1.6.0\bin>javac JdbcExample.java JdbcExample.java:12: cannot find symbol symbol : method ClassforName(java.lang.String) location: class JDBCExample ClassforName("sun.jdbc.odbc.JdbcOdbcDriver"); ^ I got this error.can any one tell me,why this error?
this is my code:
import java.sql.*; import java.io.*; import java.lang.String; import java.sql.Connection; import java.sql.DriverManager;
public class JdbcExample{ public static void main(String args[]){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); } catch(Exception e){ System.out.println(e); }
try{ Connection con; con=DriverManager.getConnection("jdbc:odbc:student");
System.out.println("Getting All Rows from a table!");
Statement st = con.createStatement();
ResultSet res = st.executeQuery("SELECT * FROM Table1");
System.out.println("student_code: " + "\t" + "student_name: ");
while (res.next()) {
int i = res.getInt("stud_code");
String s = res.getString("stud_name");
System.out.println(i + "\t\t" + s);
con.close();
}
} catch(Exception e) { System.out.println(e); }
}
}