codice:import java.awt.EventQueue; import javax.swing.JFrame; import javax.swing.JPanel; import javax.swing.JTable; import javax.swing.table.DefaultTableModel; import javax.swing.JScrollPane; import javax.swing.JTextArea; import javax.swing.JButton; import javax.swing.JLabel; import java.io.BufferedReader; import java.io.DataOutputStream; import java.io.File; import java.io.IOException; import java.io.InputStreamReader; import java.net.ServerSocket; import java.net.Socket; import java.util.Date; import java.util.GregorianCalendar; import java.util.StringTokenizer; import jxl.Cell; import jxl.LabelCell; import jxl.Sheet; import jxl.Workbook; import jxl.read.biff.BiffException; import javax.swing.SwingConstants; import java.awt.Font; import java.awt.Color; public class LudecaLogInServer implements Runnable{ private JFrame frmLudecaLoginServer; private static JTable table = new JTable(); private JPanel panel_1; static JTextArea schermoLog = new JTextArea(); static BufferedReader in ; static DataOutputStream out; static ServerSocket serverSocket = null; static Socket clientSocket = null; static String[] nomiColonne = new String[] {"OPERATORE", "DATA LOG-IN", "TELEFONO", "PAUSA", "N\u00B0 PAUSE"}; static String[][] valoriCelle = new String[50][4]; static DefaultTableModel modelloTabella=null; /** * Launch the application. */ /** * Create the application. */ public LudecaLogInServer(final Socket clientSocket) { initialize(); //this.clientSocket=clientSocket; } /** * Initialize the contents of the frame. */ @SuppressWarnings("unused") private void initialize() { /* Set the Nimbus look and feel */ //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) "> /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel. * For details see http://download.oracle.com/javase/tu...feel/plaf.html */ try { for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) { if ("Nimbus".equals(info.getName())) { javax.swing.UIManager.setLookAndFeel(info.getClassName()); break; } } } catch (ClassNotFoundException ex) { java.util.logging.Logger.getLogger(LudecaLogInServer.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (InstantiationException ex) { java.util.logging.Logger.getLogger(LudecaLogInServer.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (IllegalAccessException ex) { java.util.logging.Logger.getLogger(LudecaLogInServer.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (javax.swing.UnsupportedLookAndFeelException ex) { java.util.logging.Logger.getLogger(LudecaLogInServer.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } frmLudecaLoginServer = new JFrame(); frmLudecaLoginServer.setTitle("Ludeca Log-In Server"); frmLudecaLoginServer.setResizable(false); frmLudecaLoginServer.setBounds(100, 100, 580, 601); frmLudecaLoginServer.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); frmLudecaLoginServer.getContentPane().setLayout(null); JScrollPane scrollPane = new JScrollPane(); scrollPane.setBounds(10, 63, 554, 361); frmLudecaLoginServer.getContentPane().add(scrollPane); for(String[] riga:valoriCelle) { for(String cella:riga) { cella="null"; } } modelloTabella = new DefaultTableModel(valoriCelle, nomiColonne); table.setCellSelectionEnabled(true); scrollPane.setViewportView(table); table.setModel(modelloTabella); table.getColumnModel().getColumn(0).setPreferredWidth(170); table.getColumnModel().getColumn(1).setPreferredWidth(200); table.getColumnModel().getColumn(2).setPreferredWidth(64); table.getColumnModel().getColumn(3).setPreferredWidth(43); table.getColumnModel().getColumn(4).setPreferredWidth(61); panel_1 = new JPanel(); panel_1.setBounds(0, 532, 574, 34); frmLudecaLoginServer.getContentPane().add(panel_1); panel_1.setLayout(null); JButton btnNewButton = new JButton("AGGIORNA SCHERMO"); btnNewButton.setBounds(10, 11, 139, 23); panel_1.add(btnNewButton); JButton btnNewButton_1 = new JButton("CREA LOG-IN"); btnNewButton_1.setBounds(440, 11, 124, 23); panel_1.add(btnNewButton_1); JButton btnNewButton_2 = new JButton("SALVA FILE"); btnNewButton_2.setBounds(245, 11, 89, 23); panel_1.add(btnNewButton_2); JPanel panel = new JPanel(); panel.setBounds(0, 0, 564, 52); frmLudecaLoginServer.getContentPane().add(panel); panel.setLayout(null); JLabel lblNewLabel = new JLabel("Ludeca Log-In Server"); lblNewLabel.setForeground(Color.BLUE); lblNewLabel.setFont(new Font("SansSerif", Font.BOLD, 30)); lblNewLabel.setHorizontalAlignment(SwingConstants.CENTER); lblNewLabel.setBounds(0, 0, 574, 52); panel.add(lblNewLabel); JScrollPane scrollPane_1 = new JScrollPane(); scrollPane_1.setBounds(10, 431, 554, 101); frmLudecaLoginServer.getContentPane().add(scrollPane_1); schermoLog.setText(""); scrollPane_1.setViewportView(schermoLog); } @Override public void run() { String esitoAccettazioneClient = new String(); esitoAccettazioneClient=null; try { //serverSocket.setReuseAddress(true); in= new BufferedReader(new InputStreamReader(clientSocket.getInputStream())); //Stream di output out=new DataOutputStream(clientSocket.getOutputStream()); while(true) { String loginOperatore = new String(); loginOperatore=in.readLine().toUpperCase(); if (loginOperatore == null || loginOperatore.equals("QUIT")) { break; } //out.writeBytes(loginOperatore + '\n'); System.out.println("Il Client ha scritto: " + loginOperatore); Cell cellaStringaLogIn; String stringaEstrattaDaCella = ""; LabelCell labelCellLogIn; //Apro il file di excel da leggere Workbook workbook = Workbook.getWorkbook(new File("C:\\Users\\tl2cwdr6hyyq2rvm6tv2\\Desktop\\listalogin.xls")); //Seleziono il foglio sul quale voglio operare (il primo foglio ha indice 0) Sheet sheet = workbook.getSheet(0); //Leggo tutte le righe int riga = 1;//indice riga, parto da 1 per saltare l'intestazione dei campi int numeroRighe = sheet.getRows();//calcolo quante righe ci sono nel foglio //Attento che c'è una riga in più per l'intestazione! while(riga<numeroRighe) { cellaStringaLogIn = sheet.getCell(0, riga); labelCellLogIn = (LabelCell)cellaStringaLogIn; stringaEstrattaDaCella = labelCellLogIn.getString(); System.out.println("Riga:" + riga + "nome:" + stringaEstrattaDaCella +"LOGIN="+loginOperatore); // Ora costruisco lo StringTokenizer; separatori: virgola e spazio StringTokenizer tokenizer = new StringTokenizer(loginOperatore.toString(), "."); // Ottengo tutte le parole String [] datiLogin = new String[tokenizer.countTokens()]; int j = 0; while (tokenizer.hasMoreTokens()) { datiLogin[j] = tokenizer.nextToken(); System.out.println("dati token "+j+" = "+datiLogin[j]); j++; } if(stringaEstrattaDaCella.equals(datiLogin[0]+"."+datiLogin[1]+".")) { esitoAccettazioneClient="OK"; Tempo tempo = new Tempo(); //final Date dataCompleta = tempo.dataCompleta; String dataEora= new String(); dataEora = Integer.toString(tempo.giorno)+"/"+tempo.mese+"/"+Integer.toString(tempo.anno)+" - "+Integer.toString(tempo.ore)+"."+Integer.toString(tempo.minuti)+"."+Integer.toString(tempo.secondi); Operatore op = new Operatore(datiLogin[0], datiLogin[2],dataEora); op.setDataLogIn(dataEora); table.setValueAt(op.getUsername(),0,0); table.setValueAt(op.getDataLogIn(),0,1); table.setValueAt(op.getTelefono(),0,2); table.setValueAt(op.getPausa(),0,3); table.setValueAt(op.getContatorePause(),0,4); //schermoLog.setText("L'Operatore: "+op.getUsername()+" si è connesso alla Postazione "+op.getTelefono()+" in Data "+dataEora); schermoLog.insert("[Accesso Log-In]: [Operatore: "+op.getUsername()+" Postazione: "+op.getTelefono()+" Data: " +dataEora+"]\n" , schermoLog.getColumns()); //RIVEDI COLONNE System.out.println("UTENTE CORRISPONDE!! "+riga+" op= "+op.getUsername()+" login= "+loginOperatore); break; } else { esitoAccettazioneClient="DATI_ERRATI"; Tempo tempo = new Tempo(); //final Date dataCompleta = tempo.dataCompleta; String dataEora= new String(); dataEora = Integer.toString(tempo.giorno)+"/"+Integer.toString(tempo.mese)+"/"+Integer.toString(tempo.mese)+"/"+Integer.toString(tempo.anno)+" - "+Integer.toString(tempo.ore)+"."+Integer.toString(tempo.minuti)+"."+Integer.toString(tempo.secondi); //schermoLog.setText("Fallito un Log-In! [Postazione: "+datiLogin[2]+" Data: " +dataEora+"] ...Conosci "+datiLogin[0]+"?" ); schermoLog.insert("[Negato Log-In]: [Postazione: "+datiLogin[2]+" Data: " +dataEora+"] ...Conosci "+datiLogin[0]+"?" , schermoLog.getColumns()); System.out.println("UTENTE NON CORRISPONDE"); } riga++; } out.writeBytes(esitoAccettazioneClient); out.flush(); } out.close(); in.close(); System.out.println("Ho ricevuto una chiamata di chiusura da:\n" + clientSocket + "\n"); clientSocket.close(); } catch (IOException e) { System.out.println(e); System.out.println("Errore di Accettare il Client: Errore di Accettazione o Comunicazione"); } catch (UnknownError e) { System.out.println(e); System.out.println("Errore di Accettare il Client: ERRORE SCONOSCIUTO"); } catch (BiffException e) { // TODO Auto-generated catch block e.printStackTrace(); } } }
Rispondi quotando