Bonjour,

Je travaille ds mon application avec les applets le probleme c'est que j'ai écrit un code qui me retourne rien et je ne sais ou est le probleme

Voici mon code

/**

* <p>Title: Scratch Info </p>

* <p>Description: </p>

* <p>Copyright: Copyright (c) 2007</p>

* <p>Company: </p>

* @author not attributable

* @version 1.0

*/

//chargement et instanciation de la classe du Driver

package cdrappli;

import java.sql.Connection;

import java.sql.Driver;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

class TestJDBC{

String sQuery;

TestJDBC(){

this.sQuery="select * from ODS.MV_USER_INFORMATION";

Statement sStat=null;

Connection cCon=null;

try{

Class cDriverOracle=Class.forName("oracle.jdbc.driver.OracleDriver");

Driver dDriverOracle=(java.sql.Driver)cDriverOracle.newInstance();

DriverManager.registerDriver(dDriverOracle);

cCon=DriverManager.getConnection("jdbc:oracle:thin:@10.11.100.193:1521:ORCL","user","mot de passe");

}

catch(Exception e){

System.out.println("--Pbm en chargeant le driver JDBC oracle--");

e.printStackTrace();

}

try{

sStat=cCon.createStatement();

ResultSet rs=sStat.executeQuery(sQuery);

rs.next();

System.out.println("Resultat requete: "+rs.getObject(1));

sStat.close();

}

catch(Exception sqlE){

System.out.println("La Requête n'a pas abouti");

sqlE.printStackTrace();

}

}

public static void main(String[] sArgs){
}

TestJDBC tj=new TestJDBC();

}
public class scratchinfo {
private static final String requete = null;
private static final Statement stmt = null;
public scratchinfo() {

}

{

}

// Execution de la requete

{

ResultSet rs = null;

try {
rs = stmt.executeQuery(requete);

} catch (SQLException e1) {

// TODO Auto-generated catch block

e1.printStackTrace();}
// On lit les données de la requete SELECT ligne par ligne

try {

while (rs.next())
{

try {

System.out.println("USERNAME : "+rs.getString(1));

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace(); }

try {

System.out.println("FULLNAME : "+rs.getString(2));

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

try {

System.out.println("GROUPNAME : "+rs.getString(3));

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace(); }

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}}}





et voici le code de l'applet correspondante

package cdrappli;



import java.applet.Applet;



/**

* <p>Title: </p>

* <p>Description: </p>

* <p>Copyright: Copyright (c) 2007</p>

* <p>Company: </p>

* @author not attributable

* @version 1.0

*/



public class Applet1 extends Applet {

/**

*

*/

private static final long serialVersionUID = 1L;

private boolean isStandalone = false;

String var0;

//Get a parameter value

public String getParameter(String key, String def) {

return isStandalone ? System.getProperty(key, def) :

(getParameter(key) != null ? getParameter(key) : def);

}



//Construct the applet

public Applet1() {

}

//Initialize the applet

public void init() {

try {

var0 = this.getParameter("param0", "");

}

catch(Exception e) {

e.printStackTrace();

}

try {

jbInit();

}

catch(Exception e) {

e.printStackTrace();

}

}

//Component initialization

private void jbInit() throws Exception {

}

//Get Applet information

public String getAppletInfo() {

return "Applet Information";

}

//Get parameter info

public String[][] getParameterInfo() {

String[][] pinfo =

{

{"param0", "String", ""},

};

return pinfo;

}

}

Merci pour votre aide