Connection base de donnee avec jcreator
Fermé
saykou
Messages postés
1
Date d'inscription
samedi 31 mai 2008
Statut
Membre
Dernière intervention
31 mai 2008
-
31 mai 2008 à 16:18
saykou - 2 juin 2008 à 20:01
saykou - 2 juin 2008 à 20:01
A voir également:
- Connection base de donnee avec jcreator
- Formules excel de base - Guide
- Gmail connection - Guide
- Hotmail connection - Guide
- Tnt base de données vide - Forum TNT / Satellite / Réception
- Facebook connection - Guide
2 réponses
import java.net.*;
import java.sql.*;
import java.awt.*;
import java.awt.event.*;
import java.applet.*;
public class JdbcConn extends Applet
{
Choice raid;
Choice customerid;
Connection connection;
Statement statement;
public void init()
{
raid = new Choice();
customerid = new Choice();
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver" );
DriverManager.registerDriver (new sun.jdbc.odbc.JdbcOdbcDriver());
connection = DriverManager.getConnection("jdbc:odbc:le_nom_de_ma_dsn","mon_login","mon_password" );
statement = connection.createStatement();
String SQL = "select ...";
ResultSet resultset = statement.executeQuery(SQL);
while(resultset.next())
{
raid.addItem(resultset.getString("toto" ));
customerid.addItem(resultset.getString("tata" ));
System.out.println(resultset.getString("toto" ));
System.out.println(resultset.getString("tata" ));
}
add(toto);
add(tata);
}
catch(Exception e)
{
System.out.println(e);
}
}
public void paint(Graphics g)
{
}
}
import java.sql.*;
import java.awt.*;
import java.awt.event.*;
import java.applet.*;
public class JdbcConn extends Applet
{
Choice raid;
Choice customerid;
Connection connection;
Statement statement;
public void init()
{
raid = new Choice();
customerid = new Choice();
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver" );
DriverManager.registerDriver (new sun.jdbc.odbc.JdbcOdbcDriver());
connection = DriverManager.getConnection("jdbc:odbc:le_nom_de_ma_dsn","mon_login","mon_password" );
statement = connection.createStatement();
String SQL = "select ...";
ResultSet resultset = statement.executeQuery(SQL);
while(resultset.next())
{
raid.addItem(resultset.getString("toto" ));
customerid.addItem(resultset.getString("tata" ));
System.out.println(resultset.getString("toto" ));
System.out.println(resultset.getString("tata" ));
}
add(toto);
add(tata);
}
catch(Exception e)
{
System.out.println(e);
}
}
public void paint(Graphics g)
{
}
}