jdbc

[Lebrun Jonathan]

Sorry for my English.

I would like use jdbc with MySQL.

I write this code but I've a running error.

Why ?

The code :

import java.sql.*;
import java.util.Properties;
import java.io.FileInputStream;
import java.io.IOException;

public class ConnectionDB {

private Connection con;

  public ConnectionDB()throws IOException,SQLException{
    Properties info = new Properties();
    FileInputStream in = new FileInputStream("d:\\jdbc\\ConnectDB.properties");
    info.load(in);
    String url="jdbc:mysql:link";
   try{
    org.gjt.mm.mysql.Driver d = new org.gjt.mm.mysql.Driver();
    con = d.connect(url,info);
    }catch (SQLException sqle){
      System.out.println("Connection Error");
     }
    Statement stat = con.createStatement();
    String s = "SELECT * FROM linkt";
    ResultSet rs = stat.executeQuery(s);
    ResultSetMetaData rsmd = rs.getMetaData();
    while (rs.next()){
      for (int i=1;i<=rsmd.getColumnCount();i++){
        System.out.println(rs.getString(i));
      }
    }
    rs.close();
  }
}

The Error :

C:\JBuilder4\jdk1.3\bin\javaw -classpath "D:\Java\Java 
Project\ConectionDB\classes;D:\JDBC\jdbc-3_0-pfd-classes.jar;D:\JDBC\mm.mysql.jdbc-1.0\mysql.jar;D:\JDBC;C:\JBuilder4\jdk1.3\demo\jfc\Java2D\Java2Demo.jar;C:\JBuilder4\jdk1.3\jre\lib\i18n.jar;C:\JBuilder4\jdk1.3\jre\lib\jaws.jar;C:\JBuilder4\jdk1.3\jre\lib\rt.jar;C:\JBuilder4\jdk1.3\jre\lib\sunrsasign.jar;C:\JBuilder4\jdk1.3\lib\dt.jar;C:\JBuilder4\jdk1.3\lib\tools.jar"
  conectiondb.COnnectDB 
java.lang.NullPointerException
 at conectiondb.ConnectionDB.<init>(ConnectionDB.java:32)
 at conectiondb.COnnectDB.main(COnnectDB.java:36)


Thanks for assistance.