Revize 7e0b699a

re #7894

Přidán layout pro data potřebná k vytvoření spojení s DB. Dále přidány knihovny pro MySQL a ORACLE.

project/Deserializer/src/Deserializer.java

@@ -1 +1 @@
 import java.io.File;
 
+import io.Database.DB_Messenger;
 import io.FileWorker;
 import javafx.application.Application;
 import javafx.application.Platform;
+import javafx.collections.FXCollections;
 import javafx.geometry.Insets;
 import javafx.geometry.Pos;
 import javafx.scene.Node;
@@ -14 +16 @@
 import javafx.scene.control.Menu;
 import javafx.scene.control.MenuBar;
 import javafx.scene.control.MenuItem;
+import javafx.scene.control.PasswordField;
 import javafx.scene.control.Separator;
 import javafx.scene.control.SeparatorMenuItem;
 import javafx.scene.control.Tab;
 import javafx.scene.control.TabPane;
 import javafx.scene.control.TabPane.TabClosingPolicy;
+import javafx.scene.control.TextField;
 import javafx.scene.image.Image;
 import javafx.scene.image.ImageView;
 import javafx.scene.input.KeyCode;
@@ -95 +99 @@
 		TabPane header = new TabPane();
         header.setTabClosingPolicy(TabClosingPolicy.UNAVAILABLE);
         header.getTabs().add(createInputFileTab());
+        header.getTabs().add(createQueryTab());
         
         
         editor = new Editor();
@@ -178 +183 @@
 		return layout;
 	}
 	
+	private Tab createQueryTab() {
+		String promptTexts[] = new String[] { "jdbc:mysql://server/nazevDB", "jdbc:oracle:thin:@server:port:nazevDB" };
+		
+		Label rdbmsLabel = new Label("Typ DB");
+		Label urlLabel = new Label("URL");
+		ComboBox<String> rdbms = new ComboBox<String>(FXCollections.observableArrayList(new String[] { "MySQL", "ORACLE" }));
+		TextField url = new TextField();
+		
+		rdbms.setOnAction(event -> {
+			url.setPromptText(promptTexts[rdbms.getSelectionModel().getSelectedIndex()]);
+		});
+		
+		rdbms.getSelectionModel().selectFirst();
+		url.setPromptText(promptTexts[0]);
+
+		
+		Label userLabel = new Label("Uživatel");
+		Label passwordLabel = new Label("Heslo");
+		TextField user = new TextField();
+		PasswordField password = new PasswordField();
+		
+		VBox rdbmsLayout = new VBox();
+		rdbmsLayout.getChildren().addAll(rdbmsLabel, rdbms);
+		VBox urlLayout = new VBox();
+		urlLayout.getChildren().addAll(urlLabel, url);
+		VBox userLayout = new VBox();
+		userLayout.getChildren().addAll(userLabel, user);
+		VBox passwordLayout = new VBox();
+		passwordLayout.getChildren().addAll(passwordLabel, password);
+		
+		rdbmsLabel.setStyle("-fx-font-weight: bold;");
+		urlLabel.setStyle("-fx-font-weight: bold;");
+		userLabel.setStyle("-fx-font-weight: bold;");
+		passwordLabel.setStyle("-fx-font-weight: bold;");
+		
+		url.setMinWidth(400);
+		user.setMinWidth(100);
+		user.setPrefWidth(200);
+		user.setMaxWidth(300);
+		password.setMinWidth(100);
+		password.setPrefWidth(200);
+		password.setMaxWidth(300);
+	
+		HBox.setHgrow(urlLayout, Priority.ALWAYS);
+		
+		HBox connLayout = new HBox();
+		connLayout.setSpacing(10);
+		connLayout.getChildren().addAll(rdbmsLayout, urlLayout, userLayout, passwordLayout);
+		
+		
+		Label select = new Label("SELECT"), from = new Label("FROM"), where = new Label("WHERE"), queryEnd = new Label(";");
+		TextField column = new TextField(), table = new TextField(), cond = new TextField();
+		
+		select.setStyle("-fx-font-weight: bold;");
+		from.setStyle("-fx-font-weight: bold;");
+		where.setStyle("-fx-font-weight: bold;");
+		queryEnd.setStyle("-fx-font-weight: bold;");
+		
+		column.setPromptText("sloupec");
+		table.setPromptText("tabulka");
+		cond.setPromptText("podminka");
+		
+		HBox.setHgrow(column, Priority.ALWAYS);
+		HBox.setHgrow(table, Priority.ALWAYS);
+		HBox.setHgrow(cond, Priority.ALWAYS);
+		
+		HBox queryLayout = new HBox();
+		queryLayout.setAlignment(Pos.CENTER);
+		queryLayout.setSpacing(5.0);
+		queryLayout.getChildren().addAll(select, column, from, table, where, cond, queryEnd);
+		
+		Button setQuery = new Button("Spustit");
+		setQuery.setOnAction(event -> {
+			String driver = rdbms.getValue().equals("MySQL") ? "com.mysql.cj.jdbc.Driver" : "oracle.jdbc.driver.OracleDriver";
+			converter.setInput(null, new DB_Messenger(driver, url.getText().trim(), user.getText().trim(), password.getText().trim(),
+					table.getText().trim(), cond.getText().trim(), column.getText().trim()));
+		});
+		
+		HBox bIF = new HBox();
+		bIF.setAlignment(Pos.CENTER_RIGHT);
+		bIF.getChildren().add(setQuery);
+		
+		VBox forInput = new VBox();
+		forInput.setPadding(new Insets(10, 10, 0, 10));
+		forInput.setSpacing(5.0);
+		forInput.getChildren().addAll(connLayout, queryLayout, bIF);
+		
+		return new Tab("SQL", forInput);
+	}
+	
 	private Tab createInputFileTab() {
 		Label forInputFile = new Label("Soubor k deserializaci:");
 		Label inputFile = new Label("    Ještě nebyl vybrán žádný soubor...");
@@ -198 +293 @@
 				inputFile.setText(file.getAbsolutePath());
 				inputFile.setStyle("-fx-font-weight: bold;");
 				
-				converter.setInput(file);
+				converter.setInput(file, null);
 			}
 		});