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
Partager