cnx sqlserver et eclipse

cnx sqlserver et eclipse - Java - Programmation

Marsh Posté le 30-05-2013 à 14:45:12    

bonjour,
 
j'ai pas réussie à faire la connexion de sqlserver express avec eclipse
 
voici mon essai sachant que Server name : HP\SQLEXPRESS
                                      Authentification : Windows Authentification
 

Code :
  1. private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) throws ClassNotFoundException {// GEN-FIRST:event_jButton3ActionPerformed
  3.  lb4.setText("" );
  5.  try {
  7.   Class.forName ("com.microsoft.jdbc.sqlserver.SQLServerDriver" );
  8.   Connection connection = DriverManager.getConnection("jdbc:sqlserver://localhost;databaseName=pfe;IntegratedSecurity=true;" );
  9.   Statement st = connection.createStatement();
  12.   String req = "select login , password from utilisateur";
  13.   ResultSet rs = st.executeQuery(req);
  15.   String log = tf1.getText();
  16.   char[] pass = tf2.getPassword();
  17.   while (rs.next()) {
  18.    if ((log.equals(rs.getString("login" )))
  19.      && (Arrays.equals(pass, rs.getString("password" )
  20.        .toCharArray()))) {
  22.     MainFrame mf = new MainFrame();
  23.            mf.setLocationRelativeTo(null);
  24.            mf.setVisible(true);
  25.            dispose();
  27.    } else {
  28.     lb4.setText("Authentification echouée !!" );
  29.     tf1.setText("" );
  30.     tf2.setText("" );
  31.    }
  32.   }
  33.   st.close();
  34.   connection.close();
  35.  } catch (SQLException sqle) {
  36.   JOptionPane.showMessageDialog(null, "Connexion à  la base echouée",
  37.     "Erreur", JOptionPane.ERROR_MESSAGE);
  39.  }
  42. }


 
voici le message d'erreur:
 
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
 at java.net.URLClassLoader$1.run(Unknown Source)
 at java.net.URLClassLoader$1.run(Unknown Source)
 at java.security.AccessController.doPrivileged(Native Method)
 at java.net.URLClassLoader.findClass(Unknown Source)
 at java.lang.ClassLoader.loadClass(Unknown Source)
 at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
 at java.lang.ClassLoader.loadClass(Unknown Source)
 at java.lang.Class.forName0(Native Method)
 at java.lang.Class.forName(Unknown Source)
 at GUI.Identification.jButton3ActionPerformed(Identification.java:173)
 at GUI.Identification.access$3(Identification.java:167)
 at GUI.Identification$4.actionPerformed(Identification.java:79)
 at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
 at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
 at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
 at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
 at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
 at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
 at java.awt.Component.processMouseEvent(Unknown Source)
 at javax.swing.JComponent.processMouseEvent(Unknown Source)
 at java.awt.Component.processEvent(Unknown Source)
 at java.awt.Container.processEvent(Unknown Source)
 at java.awt.Component.dispatchEventImpl(Unknown Source)
 at java.awt.Container.dispatchEventImpl(Unknown Source)
 at java.awt.Component.dispatchEvent(Unknown Source)
 at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
 at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
 at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
 at java.awt.Container.dispatchEventImpl(Unknown Source)
 at java.awt.Window.dispatchEventImpl(Unknown Source)
 at java.awt.Component.dispatchEvent(Unknown Source)
 at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
 at java.awt.EventQueue.access$200(Unknown Source)
 at java.awt.EventQueue$3.run(Unknown Source)
 at java.awt.EventQueue$3.run(Unknown Source)
 at java.security.AccessController.doPrivileged(Native Method)
 at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
 at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
 at java.awt.EventQueue$4.run(Unknown Source)
 at java.awt.EventQueue$4.run(Unknown Source)
 at java.security.AccessController.doPrivileged(Native Method)
 at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
 at java.awt.EventQueue.dispatchEvent(Unknown Source)
 at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
 at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
 at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
 at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
 at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
 at java.awt.EventDispatchThread.run(Unknown Source)
 
merci de m'aider SVP  :(


Message édité par chimo01 le 30-05-2013 à 19:55:26
Reply

Marsh Posté le 30-05-2013 à 14:45:12   

Reply

Marsh Posté le 31-05-2013 à 20:37:07    

:(

Reply

Sujets relatifs:

Leave a Replay

Make sure you enter the(*)required information where indicate.HTML code is not allowed