Import java.sql.*;
public class TestAccess {
{
String nom;
String Prenom;
String Adresse;
String Tel ;
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:basededonne","Administrateur","haha");
Statement statement = con.createStatement();
String query = "select * from Table1 where N°=2";
ResultSet resultset = statement.executeQuery(query);
while(resultset.next())
{
nom = resultset.getString("Champ1");
Prenom = resultset.getString("Champ2");
Adresse = resultset.getString("Champ3");
Tel = resultset.getString("Champ4");
System.out.println(" "+nom);
System.out.println(" "+Prenom);
System.out.println(" "+Adresse);
System.out.println(" "+Tel);
}
resultset.close();
statement.close();
con.close();
}
catch( ClassNotFoundException e)
{
System.err.println("Erreur lors du chargement du pilote : " + e);
}
catch(SQLException sqle)
{
System.err.print("Erreur SQL : " + sqle);
}
}
}
public static void main(String[] args) {
String nom="";
TestAccess tel =new TestAccess();
System.out.println(""+tel.nom);}
}
Il m'affiche l'erreur suivant je ne sais pas pourquoi:
Exception in thread "main" java.lang.Error: Unresolved compilation problem:
tel.nom cannot be resolved or is not a field
at TestAccess.main(TestAccess.java:59)