1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
|
import java.sql.*;
public class Connexion
{
public static void main(String[] args)throws SQLException
{
Connection conn = null;
try
{
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
conn=DriverManager.getConnection"jdbc:oracle:thin:@localhost:1521:mabase","user2","pass2");
Statement instruction = conn.createStatement();
//LA TABLE DOCUMENT
ResultSet resultat4=instruction.executeQuery("select reference,date,titre,code from document");
while(resultat4.next())
{
System.out.println("resultat4.getString("reference")");
System.out.println("resultat4.getDate("date")");
System.out.println("resultat4.getString("titre")");
System.out.println("resultat4.getInt("code")");
System.out.println("------------------------");
}
catch (Exception e){
System.out.println("Le problème est :"+e);
}
} |
Partager