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 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66
|
import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.util.ArrayList;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
import java.sql.*;
//import java.lang.*;
import java.net.*;
public class arp{
public static void main(String[] args) {
ArrayList physicalAddresses = new ArrayList();
String cmd = "cmd /c arp -a";
String res1= null;
Connection con = null;
ResultSet rs = null;
try {
Runtime r = Runtime.getRuntime();
Process process = r.exec(cmd);
String line = null;
BufferedReader reader = new BufferedReader(new InputStreamReader(process.getInputStream()));
Pattern p = Pattern.compile("([abcdef0-9]{2}-){5}[abcdef0-9]{2}");
while ((line = reader.readLine()) != null) {
Matcher m = p.matcher(line);
if(m.find()) {
physicalAddresses.add(m.group());
}
}
} catch (Exception e) {
System.out.println("erreur d'execution " + cmd + e.getMessage());
}
for (int i = 0; i < physicalAddresses.size(); i++) {
System.out.println((String) physicalAddresses.get(i));
res1= (String) physicalAddresses.get(i);
}
// faut ouvrir la base de donnees sql
// Charger le Driver de la base de Donnes de type : MySql
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection("jdbc:mysql://localhost/points_d'acces","root","");
// je veux recuperer la valeur du champs "salle"
PreparedStatement addr =con.prepareStatement("SELECT salle FROM `infos` WHERE adresse_mac = res1");
rs = addr.executeQuery(){
String s =rs.getString("salle") ;}
con.close();
}} |