RehaSql/src/rehaSql/RehaSql.java

   1 package rehaSql;
   2
   3 import java.awt.Cursor;
   4 import java.awt.event.WindowEvent;
   5 import java.awt.event.WindowListener;
   6 import java.sql.Connection;
   7 import java.sql.DriverManager;
   8 import java.sql.SQLException;
   9 import java.util.HashMap;
  10 import java.util.Map;
  11 import java.util.Properties;
  12
  13 import javax.swing.JFrame;
  14 import javax.swing.JOptionPane;
  15 import javax.swing.UIManager;
  16 import javax.swing.UnsupportedLookAndFeelException;
  17
  18 import org.jdesktop.swingworker.SwingWorker;
  19
  20
  21
  22
  23
  24 import CommonTools.INIFile;
  25 import CommonTools.INITool;
  26 import CommonTools.SqlInfo;
  27 import CommonTools.StartOOApplication;
  28 import CommonTools.Verschluesseln;
  29 import RehaIO.RehaIOMessages;
  30 import RehaIO.RehaReverseServer;
  31 import RehaIO.SocketClient;
  32 import ag.ion.bion.officelayer.application.ILazyApplicationInfo;
  33 import ag.ion.bion.officelayer.application.IOfficeApplication;
  34 import ag.ion.bion.officelayer.application.OfficeApplicationException;
  35 import ag.ion.bion.officelayer.application.OfficeApplicationRuntime;
  36 import ag.ion.bion.officelayer.document.DocumentException;
  37 import ag.ion.bion.officelayer.document.IDocument;
  38 import ag.ion.bion.officelayer.event.ITerminateEvent;
  39 import ag.ion.bion.officelayer.event.VetoTerminateListener;
  40
  41 public class RehaSql implements WindowListener {
  42
  43         /**
  44          * @param args
  45          */
  46         /**
  47          * @param args
  48          */
  49         public static boolean DbOk;
  50         JFrame jFrame;
  51         public static JFrame thisFrame = null;
  52         public Connection conn;
  53         public static RehaSql thisClass;
  54
  55         public static IOfficeApplication officeapplication;
  56
  57         public String dieseMaschine = null;
  58         /*
  59         public static String dbIpAndName = null;
  60         public static String dbUser = null;
  61         public static String dbPassword = null;
  62
  63
  64 */
  65         public final Cursor wartenCursor = new Cursor(Cursor.WAIT_CURSOR);
  66         public final Cursor normalCursor = new Cursor(Cursor.DEFAULT_CURSOR);
  67
  68         public static String dbIpAndName = "jdbc:mysql://192.168.2.3:3306/rtadaten";
  69         public static String dbUser = "rtauser";
  70         public static String dbPassword = "rtacurie";
  71         public static String officeProgrammPfad = "C:/Programme/OpenOffice.org 3";
  72         public static String officeNativePfad = "C:/RehaVerwaltung/Libraries/lib/openofficeorg/";
  73         public static String progHome = "C:/RehaVerwaltung/";
  74         public static String aktIK = "510841109";
  75         public static String hmRechnungPrivat = "C:/RehaVerwaltung/vorlagen/HMRechnungPrivatKopie.ott";
  76         public static String hmRechnungKasse = "C:/RehaVerwaltung/vorlagen/HMRechnungPrivatKopie.ott";
  77         public static String rhRechnungPrivat = "C:/RehaVerwaltung/vorlagen/HMRechnungPrivatKopie.ott";
  78         public static String rhRechnungKasse = "C:/RehaVerwaltung/vorlagen/HMRechnungPrivatKopie.ott";
  79         /*
  80         public static String dbIpAndName = "jdbc:mysql://192.168.2.2:3306/rtadaten";
  81         public static String dbUser = "rtauser";
  82         public static String dbPassword = "rtacurie";
  83         public static String officeProgrammPfad = "C:/Programme/OpenOffice.org 3";
  84         public static String officeNativePfad = "C:/RehaVerwaltung/Libraries/lib/openofficeorg/";
  85         public static String progHome = "C:/RehaVerwaltung/";
  86         public static String aktIK = "510841109";
  87         public static String hmRechnungPrivat = "C:/RehaVerwaltung/vorlagen/HMRechnungPrivatKopie.ott";
  88         public static String hmRechnungKasse = "C:/RehaVerwaltung/vorlagen/HMRechnungPrivatKopie.ott";
  89         public static String rhRechnungPrivat = "C:/RehaVerwaltung/vorlagen/HMRechnungPrivatKopie.ott";
  90         public static String rhRechnungKasse = "C:/RehaVerwaltung/vorlagen/HMRechnungPrivatKopie.ott";
  91         */
  92         public static boolean testcase = false;
  93
  94         public static int xport = -1;
  95         public static boolean xportOk = false;
  96         public RehaReverseServer rehaReverseServer = null;
  97         public static int rehaReversePort = -1;
  98         public boolean isLibreOffice;
  99         SqlInfo sqlInfo = null;
 100
 101         public static void main(String[] args) {
 102                 RehaSql application = new RehaSql();
 103                 application.getInstance();
 104                 application.getInstance().sqlInfo = new SqlInfo();
 105                 if(args.length > 0 || testcase){
 106                         if(!testcase){
 107                                 System.out.println("hole daten aus INI-Datei "+args[0]);
 108                                 INIFile inif = new INIFile(args[0]+"ini/"+args[1]+"/rehajava.ini");
 109                                 dbIpAndName = inif.getStringProperty("DatenBank","DBKontakt1");
 110                                 dbUser = inif.getStringProperty("DatenBank","DBBenutzer1");
 111                                 String pw = inif.getStringProperty("DatenBank","DBPasswort1");
 112                                 String decrypted = null;
 113                                 if(pw != null){
 114                                         Verschluesseln man = Verschluesseln.getInstance();
 115                                         man.init(Verschluesseln.getPassword().toCharArray(), man.getSalt(), man.getIterations());
 116                                         decrypted = man.decrypt (pw);
 117                                 }else{
 118                                         decrypted = new String("");
 119                                 }
 120                                 dbPassword = decrypted.toString();
 121                                 inif = new INIFile(args[0]+"ini/"+args[1]+"/rehajava.ini");
 122                                 officeProgrammPfad = inif.getStringProperty("OpenOffice.org","OfficePfad");
 123                                 officeNativePfad = inif.getStringProperty("OpenOffice.org","OfficeNativePfad");
 124                                 progHome = args[0];
 125                                 aktIK = args[1];
 126                                 INITool.init(progHome+"ini/"+aktIK+"/");
 127                                 if(args.length >= 3){
 128                                         rehaReversePort = Integer.parseInt(args[2]);
 129                                 }
 130                         }
 131
 132                         final RehaSql xapplication = application;
 133                         new SwingWorker<Void,Void>(){
 134                                 @Override
 135                                 protected Void doInBackground() throws java.lang.Exception {
 136                                         xapplication.starteDB();
 137                                         long zeit = System.currentTimeMillis();
 138                                         while(! DbOk){
 139                                                 try {
 140                                                         Thread.sleep(20);
 141                                                         if(System.currentTimeMillis()-zeit > 10000){
 142                                                                 System.exit(0);
 143                                                         }
 144                                                 } catch (InterruptedException e) {
 145                                                         e.printStackTrace();
 146                                                 }
 147                                         }
 148                                         if(!DbOk){
 149                                                 JOptionPane.showMessageDialog(null, "Datenbank konnte nicht geöffnet werden!\nReha-Sql kann nicht gestartet werden");
 150                                         }
 151                                         RehaSql.starteOfficeApplication();
 152                                         return null;
 153                                 }
 154
 155                         }.execute();
 156                         application.getJFrame();
 157                 }else{
 158                         /*
 159                         final RehaSql xapplication = application;
 160                         new SwingWorker<Void,Void>(){
 161                                 @Override
 162                                 protected Void doInBackground() throws java.lang.Exception {
 163                                         xapplication.starteDB();
 164                                         long zeit = System.currentTimeMillis();
 165                                         while(! DbOk){
 166                                                 try {
 167                                                         Thread.sleep(20);
 168                                                         if(System.currentTimeMillis()-zeit > 5000){
 169                                                                 System.exit(0);
 170                                                         }
 171                                                 } catch (InterruptedException e) {
 172                                                         e.printStackTrace();
 173                                                 }
 174                                         }
 175                                         if(!DbOk){
 176                                                 JOptionPane.showMessageDialog(null, "Datenbank konnte nicht geöffnet werden!\nReha-Sql kann nicht gestartet werden");
 177                                         }
 178                                         RehaSql.starteOfficeApplication();
 179                                         return null;
 180                                 }
 181
 182                         }.execute();
 183                         application.getJFrame();
 184                         */
 185
 186                         JOptionPane.showMessageDialog(null, "Keine Datenbankparameter übergeben!\nReha-Sql kann nicht gestartet werden");
 187                         System.exit(0);
 188
 189                 }
 190
 191         }
 192         /********************/
 193
 194         public JFrame getJFrame(){
 195                 try {
 196                         UIManager.setLookAndFeel("com.jgoodies.looks.plastic.PlasticXPLookAndFeel");
 197                 } catch (ClassNotFoundException e) {
 198                         e.printStackTrace();
 199                 } catch (InstantiationException e) {
 200                         e.printStackTrace();
 201                 } catch (IllegalAccessException e) {
 202                         e.printStackTrace();
 203                 } catch (UnsupportedLookAndFeelException e) {
 204                         e.printStackTrace();
 205                 }
 206                 thisClass = this;
 207                 jFrame = new JFrame(){
 208
 209                         /**
 210                          *
 211                          */
 212                         private static final long serialVersionUID = 1L;
 213
 214                         @Override
 215                         public void setVisible(final boolean visible) {
 216
 217                                 if(getState()!=JFrame.NORMAL) { setState(JFrame.NORMAL); }
 218
 219                                   if (visible) {
 220                                       //setDisposed(false);
 221                                   }
 222                                   if (!visible || !isVisible()) {
 223                                       super.setVisible(visible);
 224                                   }
 225
 226                                   if (visible) {
 227                                       int state = super.getExtendedState();
 228                                       state &= ~JFrame.ICONIFIED;
 229                                       super.setExtendedState(state);
 230                                       super.setAlwaysOnTop(true);
 231                                       super.toFront();
 232                                       super.requestFocus();
 233                                       super.setAlwaysOnTop(false);
 234                                   }
 235                         }
 236
 237                         @Override
 238                         public void toFront() {
 239                                   super.setVisible(true);
 240                                   int state = super.getExtendedState();
 241                                   state &= ~JFrame.ICONIFIED;
 242                                   super.setExtendedState(state);
 243                                   super.setAlwaysOnTop(true);
 244                                   super.toFront();
 245                                   super.requestFocus();
 246                                   super.setAlwaysOnTop(false);
 247                         }
 248                 };
 249                 try{
 250                         rehaReverseServer = new RehaReverseServer(7000);
 251                 }catch(Exception ex){
 252                         rehaReverseServer = null;
 253                 }
 254                 sqlInfo.setFrame(jFrame);
 255                 jFrame.addWindowListener(this);
 256                 jFrame.setSize(1000,700);
 257                 jFrame.setTitle("Thera-Pi  Sql-Modul  [IK: "+aktIK+"] "+"[Server-IP: "+dbIpAndName+"] - Äußerste Vorsicht ist geboten!!!");
 258                 jFrame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
 259                 jFrame.setLocationRelativeTo(null);
 260                 jFrame.getContentPane().add (new RehaSqlTab());
 261                 jFrame.setVisible(true);
 262                 thisFrame = jFrame;
 263                 try{
 264                         new SocketClient().setzeRehaNachricht(RehaSql.rehaReversePort,"AppName#RehaSql#"+Integer.toString(RehaSql.xport));
 265                         new SocketClient().setzeRehaNachricht(RehaSql.rehaReversePort,"RehaSql#"+RehaIOMessages.IS_STARTET);
 266                 }catch(Exception ex){
 267                         JOptionPane.showMessageDialog(null, "Fehler in der Socketkommunikation");
 268                 }
 269
 270                 return jFrame;
 271         }
 272
 273
 274         /********************/
 275
 276         public RehaSql getInstance(){
 277                 thisClass = this;
 278                 return this;
 279         }
 280
 281         /*******************/
 282
 283         public void starteDB(){
 284
 285                 //piHelpDatenbankStarten dbstart = new piHelpDatenbankStarten();
 286                 //dbstart.run();
 287
 288                 DatenbankStarten dbstart = new DatenbankStarten();
 289                 dbstart.run();
 290
 291         }
 292
 293         /*******************/
 294
 295         public static void stoppeDB(){
 296                 try {
 297                         RehaSql.thisClass.conn.close();
 298                         RehaSql.thisClass.conn = null;
 299                 } catch (SQLException e) {
 300                         e.printStackTrace();
 301                 }
 302         }
 303
 304         /**********************************************************
 305          *
 306          */
 307         final class DatenbankStarten implements Runnable{
 308                 private void StarteDB(){
 309                         final RehaSql obj = RehaSql.thisClass;
 310
 311                         final String sDB = "SQL";
 312                         if (obj.conn != null){
 313                                 try{
 314                                 obj.conn.close();}
 315                                 catch(final SQLException e){}
 316                         }
 317                         try{
 318                                 Class.forName("com.mysql.jdbc.Driver").newInstance();
 319                 } catch (InstantiationException e) {
 320                                 e.printStackTrace();
 321                         System.out.println(sDB+"Treiberfehler: " + e.getMessage());
 322                         RehaSql.DbOk = false;
 323                         return ;
 324                         } catch (IllegalAccessException e) {
 325                                 e.printStackTrace();
 326                         System.out.println(sDB+"Treiberfehler: " + e.getMessage());
 327                         RehaSql.DbOk = false;
 328                         return ;
 329                         } catch (ClassNotFoundException e) {
 330                                 e.printStackTrace();
 331                         System.out.println(sDB+"Treiberfehler: " + e.getMessage());
 332                         RehaSql.DbOk = false;
 333                         return ;
 334                         }
 335                 try {
 336                                 obj.conn = (Connection) DriverManager.getConnection(dbIpAndName+"?jdbcCompliantTruncation=false&zeroDateTimeBehavior=convertToNull",dbUser,dbPassword);
 337                         RehaSql.thisClass.sqlInfo.setConnection(obj.conn);
 338                                 RehaSql.DbOk = true;
 339                         System.out.println("Datenbankkontakt hergestellt");
 340                 }
 341                 catch (final SQLException ex) {
 342                         System.out.println("SQLException: " + ex.getMessage());
 343                         System.out.println("SQLState: " + ex.getSQLState());
 344                         System.out.println("VendorError: " + ex.getErrorCode());
 345                         RehaSql.DbOk = false;
 346
 347                 }
 348                 return;
 349                 }
 350                 public void run() {
 351                         StarteDB();
 352                 }
 353
 354
 355         }
 356         /*****************************************************************
 357          *
 358          */
 359         /**********************************************************
 360          *
 361          */
 362         final class piHelpDatenbankStarten implements Runnable{
 363                 String user;
 364                 String password;
 365                 String host;
 366                 private void StarteDB(){
 367                         final RehaSql obj = RehaSql.thisClass;
 368
 369                         final String sDB = "SQL";
 370                         if (obj.conn != null){
 371                                 try{
 372                                 obj.conn.close();}
 373                                 catch(final SQLException e){}
 374                         }
 375                         try{
 376                                 Class.forName("de.root1.jpmdbc.Driver");
 377                                 //Class.forName("com.mysql.jdbc.Driver").newInstance();
 378
 379                         } catch (ClassNotFoundException e) {
 380                                 e.printStackTrace();
 381                                 JOptionPane.showMessageDialog(null, "Kein Kontakt zu MySql bei 1 & 1");
 382                         System.out.println(sDB+"Treiberfehler: " + e.getMessage());
 383                         RehaSql.DbOk = false;
 384                         return ;
 385                         }
 386                 try {
 387                         System.out.println("Starte de.root1.jpmdbc.Drive");
 388                         //System.out.println("Starte Serveradresse:192.168.2.2");
 389                         //obj.connMySql = (Connection) DriverManager.getConnection("jdbc:mysql://192.168.2.2:3306/dbf","entwickler","entwickler");
 390                         Properties connProperties = new Properties();
 391                         connProperties.setProperty("user", "dbo336243054");
 392                         connProperties.setProperty("password", "allepreise");
 393                         //connProperties.setProperty("host", "localhost");
 394                         connProperties.setProperty("host", "db2614.1und1.de");
 395                         //connProperties.setProperty("host", "db2614.1und1.de");
 396                         connProperties.setProperty("port", "3306");
 397                         connProperties.setProperty("compression","false");
 398                         connProperties.setProperty("NO_DRIVER_INFO", "1");
 399
 400                         obj.conn = (Connection) DriverManager.getConnection("jdbc:jpmdbc:http://www.thera-pi.org/jpmdbc.php?db336243054",connProperties);
 401
 402                                 //obj.conn = (Connection) DriverManager.getConnection(dbIpAndName,dbUser,dbPassword);
 403
 404                                 RehaSql.DbOk = true;
 405                         System.out.println("Datenbankkontakt hergestellt");
 406                 }
 407                 catch (final SQLException ex) {
 408                                 JOptionPane.showMessageDialog(null, "Kein Kontakt zu MySql bei 1 & 1");
 409                         System.out.println("SQLException: " + ex.getMessage());
 410                         System.out.println("SQLState: " + ex.getSQLState());
 411                         System.out.println("VendorError: " + ex.getErrorCode());
 412                         RehaSql.DbOk = false;
 413                 }
 414                 return;
 415                 }
 416                 public void run() {
 417                         StarteDB();
 418                 }
 419
 420
 421         }
 422
 423         @Override
 424         public void windowActivated(WindowEvent arg0) {
 425         }
 426         @Override
 427         public void windowClosed(WindowEvent arg0) {
 428                 if(RehaSql.thisClass.conn != null){
 429                         try {
 430                                 RehaSql.thisClass.conn.close();
 431                                 System.out.println("Datenbankverbindung wurde geschlossen");
 432                         } catch (SQLException e) {
 433                                 e.printStackTrace();
 434                         }
 435                 }
 436                 System.exit(0);
 437         }
 438         @Override
 439         public void windowClosing(WindowEvent arg0) {
 440                 if(RehaSql.thisClass.conn != null){
 441                         try {
 442                                 RehaSql.thisClass.conn.close();
 443                                 System.out.println("Datenbankverbindung wurde geschlossen");
 444                         } catch (SQLException e) {
 445                                 e.printStackTrace();
 446                         }
 447                 }
 448                 if(RehaSql.thisClass.rehaReverseServer != null){
 449                         try{
 450                                 new SocketClient().setzeRehaNachricht(RehaSql.rehaReversePort,"RehaSql#"+RehaIOMessages.IS_FINISHED);
 451                                 rehaReverseServer.serv.close();
 452                         }catch(Exception ex){
 453                                 ex.printStackTrace();
 454                         }
 455
 456                 }
 457                 System.exit(0);
 458         }
 459         @Override
 460         public void windowDeactivated(WindowEvent arg0) {
 461         }
 462         @Override
 463         public void windowDeiconified(WindowEvent arg0) {
 464         }
 465         @Override
 466         public void windowIconified(WindowEvent arg0) {
 467         }
 468         @Override
 469         public void windowOpened(WindowEvent arg0) {
 470         }
 471
 472         /***************************/
 473
 474     public static void starteOfficeApplication(){
 475         try {
 476                         officeapplication = (IOfficeApplication)new StartOOApplication(RehaSql.officeProgrammPfad,RehaSql.officeNativePfad).start(false);
 477                          System.out.println("OpenOffice ist gestartet und Active ="+officeapplication.isActive());
 478                 } catch (OfficeApplicationException e1) {
 479                         e1.printStackTrace();
 480                 }
 481     }
 482
 483
 484 }