Connection à oracle par un code java

je développe un application graphique en java qui doit se connecter à une base de données Oracle et y executer des requettes de lecture (select) voila mes codes
Code:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 Connection con = null; DatabaseConnection conn = new DatabaseConnection(); conn.getConnection(); //sql request query = "select" + jTextField2.getText() + "from" + jTextField1.getText() + ";"; try { Statement stmt = con.createStatement(); rs = stmt.executeQuery(query); } catch (SQLException ex) { Logger.getLogger(Guiapplet.class.getName()).log(Level.SEVERE, null, ex); System.out.println("exception due a la requete"); }
Code:

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 31 32 33 /* * To change this template, choose Tools | Templates * and open the template in the editor. */ package my.guifordatabase.pkg; import java.sql.*; public class DatabaseConnection { private Connection connection = null; private String log; private String pass; public Connection getConnection() { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //login and password log = "hr"; pass = "hr"; //connection string connection = DriverManager.getConnection("jdbc:odbc//xe",log,pass); } catch (Exception ex) { ex.printStackTrace(); } return connection; } }
et voila l'erreur que j'ai

Citation:

java.sql.SQLException: [Microsoft][Gestionnaire de pilotes ODBC] Source de données introuvable et nom de pilote non spécifié
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3073)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:323)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at my.guifordatabase.pkg.DatabaseConnection.getConnection(DatabaseConnection.java:28)
at my.guifordatabase.pkg.Guiapplet.jButton1MouseClicked(Guiapplet.java:206)
at my.guifordatabase.pkg.Guiapplet.access$100(Guiapplet.java:18)
at my.guifordatabase.pkg.Guiapplet$2.mouseClicked(Guiapplet.java:82)
at java.awt.AWTEventMulticaster.mouseClicked(AWTEventMulticaster.java:253)
at java.awt.Component.processMouseEvent(Component.java:6044)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
at java.awt.Component.processEvent(Component.java:5806)
at java.awt.Container.processEvent(Container.java:2058)
at java.awt.Component.dispatchEventImpl(Component.java:4413)
at java.awt.Container.dispatchEventImpl(Container.java:2116)
at java.awt.Component.dispatchEvent(Component.java:4243)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3995)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
at java.awt.Container.dispatchEventImpl(Container.java:2102)
at java.awt.Component.dispatchEvent(Component.java:4243)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
Exception in thread "AWT-EventQueue-1" java.lang.NullPointerException
at my.guifordatabase.pkg.Guiapplet.jButton1MouseClicked(Guiapplet.java:212)
at my.guifordatabase.pkg.Guiapplet.access$100(Guiapplet.java:18)
at my.guifordatabase.pkg.Guiapplet$2.mouseClicked(Guiapplet.java:82)
at java.awt.AWTEventMulticaster.mouseClicked(AWTEventMulticaster.java:253)
at java.awt.Component.processMouseEvent(Component.java:6044)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
at java.awt.Component.processEvent(Component.java:5806)
at java.awt.Container.processEvent(Container.java:2058)
at java.awt.Component.dispatchEventImpl(Component.java:4413)
at java.awt.Container.dispatchEventImpl(Container.java:2116)
at java.awt.Component.dispatchEvent(Component.java:4243)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3995)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
at java.awt.Container.dispatchEventImpl(Container.java:2102)
at java.awt.Component.dispatchEvent(Component.java:4243)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)

Vas lire ça : http://java.developpez.com/faq/jdbc/?page=connection

je suis sous vista je voudrais savoir comment activer les pilotes odbc et jdbc?
merci

rien à voir à avec des pilotes à activer. tu dois juste utiliser les packages dans ton projet

j'ai reussi à me connecter à la base de données mais je n'arrive pas à faire afficher le resultat de mon select. voila mon code

Code:

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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
private void store() {
            String urldb = "jdbc:oracle:thin:@localhost";
            String logindb = "hr";
            String pwddb = "hr";
            Connection conn = null;
            Statement stmt = null;
            String nomDriver = "oracle.jdbc.OracleDriver";
            String query = "select * from departments";
            ResultSet results = null;
 
            try {
                Class.forName(nomDriver);
                conn = DriverManager.getConnection(urldb,logindb,pwddb);
                stmt = conn.createStatement();
                results = stmt.executeQuery(query);
            }
            catch(ClassNotFoundException cnfe) {
                System.out.println("La classe "+nomDriver+" n'a pas été trouvée");
                cnfe.printStackTrace();
            }
            catch(SQLException sqle) {
                System.out.println(sqle);
            }
            catch(Exception e) {
                System.out.println("exception du a la requete");
            }
            finally {
                if (stmt != null){
                    try {
                        stmt.close();
                        System.out.println("Close statement");
                    }
                    catch(Exception e) {
                        System.out.println(e);
                        e.printStackTrace();
                    }
                }
                if (conn != null){
                    try {
                        conn.close();
                        System.out.println("Close connection");
                    }
                    catch(Exception e) {
                        System.out.println("e");
                        e.printStackTrace();
                    }
                }
            }

cherche un peu. t'as ton resultset qui est rempli. à toi de voir comment le lire et l'afficher de la facon dont tu souhaites mais tous les tutos sur odbc/jdbc l'expliquent ;)

:faq: Comment parcourir un ResultSet ?