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
| import java.sql.*;
import java.lang.*;
import java.awt.*;
import javax.swing.*;
import java.io.*;
import java.util.*;
import java.net.*;
class sql_server2
{public static void main(String arg[])throws Exception
{ //1er Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
JOptionPane.showMessageDialog(null,"Premiere etape ça marche");
try {
String url = "jdbc:microsoft:sqlserver://localhost;databaseName=famille_nadia";
String user = "nadia";
String passwd = "ok";
//2eme
java.sql.Connection con = java.sql.DriverManager.getConnection(url,user,passwd);
Statement s = con.createStatement();
JOptionPane.showMessageDialog(null,"Connection OK");
//3eme
con.close();
} catch(SQLException ex){
JOptionPane.showMessageDialog(null, "Ca marche pas");
ex.printStackTrace();
}}} |
