public List<Cocinero> getAllCocinero() {
List ll = new LinkedList();
Statement st;
ResultSet rs;
String url = "jdbc:mysql://localhost:3306/food";
String user = "******";
String pass = "******";
String driver = "com.mysql.jdbc.Driver";
try (Connection connection = DriverManager.getConnection(url, user, pass)) {
Class.forName(driver);
st = connection.createStatement();
String recordQuery = ("Select * from cocinero");
rs = st.executeQuery(recordQuery);
while (rs.next()) {
Integer idcoc = rs.getInt("idCocinero");
String years = rs.getString("AñosServicio");
String idemp = rs.getString("Empleados_idEmpleados");
Integer idepp = Integer.parseInt(idemp);
ll.add(new Cocinero(idcoc, years, idepp));
}
} catch (ClassNotFoundException | SQLException ex) {
Logger.getLogger(MenuEmpleados.class.getName()).log(Level.SEVERE, null, ex);
}
return ll;
}
public boolean connectToDB() {
boolean estCon = false;
try {
dbCon =
DriverManager.getConnection(
"jdbc:mysql://192.168.1.6:3306/ale", "Root", "oqu#$XQgHFzDj@1MGg1G8");
estCon = true;
} catch (Exception e) {
e.printStackTrace();
System.out.println("Could not connect to db");
}
return estCon;
}
// Method for establishing a DB connection
public void connect() {
// Relative path to Access database, project can be run from anywhere.
File dbfile = new File("Icooköp_v8.accdb");
String relativepath = dbfile.getAbsolutePath();
// Local Access DB static variables
String URL = "jdbc:ucanaccess://" + relativepath;
String driver = "net.ucanaccess.jdbc.UcanaccessDriver";
try {
// Register the driver with DriverManager
Class.forName(driver);
// Create a connection to the database
con = DriverManager.getConnection(URL);
// Set the auto commit of the connection to false.
// An explicit commit will be required in order to accept
// any changes done to the DB through this connection.
con.setAutoCommit(false);
// Some logging
} catch (Exception e) {
e.printStackTrace();
}
}
@Override
public void start(Stage primaryStage) throws Exception {
try {
screenSize = Screen.getPrimary().getVisualBounds();
width = screenSize.getWidth(); // gd.getDisplayMode().getWidth();
height = screenSize.getHeight(); // gd.getDisplayMode().getHeight();
} catch (Exception excep) {
System.out.println("<----- Exception in Get Screen Size ----->");
excep.printStackTrace();
System.out.println("<---------->\n");
}
try {
dbCon =
DriverManager.getConnection(
"jdbc:mysql://192.168.1.6:3306/ale", "Root", "oqu#$XQgHFzDj@1MGg1G8");
estCon = true;
} catch (SQLException sqlExcep) {
System.out.println("<----- SQL Exception in Establishing Database Connection ----->");
sqlExcep.printStackTrace();
System.out.println("<---------->\n");
}
xmlParser.generateUserInfo();
superUser = xmlParser.getSuperUser();
// ----------------------------------------------------------------------------------------------------> Top Panel Start
closeBtn = new Button("");
closeBtn.getStyleClass().add("systemBtn");
closeBtn.setOnAction(
e -> {
systemClose();
});
minimizeBtn = new Button("");
minimizeBtn.getStyleClass().add("systemBtn");
minimizeBtn.setOnAction(
e -> {
primaryStage.setIconified(true);
});
miscContainer = new HBox();
calcBtn = new Button();
calcBtn.getStyleClass().addAll("calcBtn");
calcBtn.setOnAction(
e -> {
calculator calculator = new calculator();
scientificCalculator scientificCalculator = new scientificCalculator();
calculator.start(calculatorName);
});
miscContainer.getChildren().add(calcBtn);
topPanel = new HBox(1);
topPanel.getStyleClass().add("topPanel");
topPanel.setPrefWidth(width);
topPanel.setAlignment(Pos.CENTER_RIGHT);
topPanel.setPadding(new Insets(0, 0, 0, 0));
topPanel.getChildren().addAll(miscContainer, minimizeBtn, closeBtn);
// ------------------------------------------------------------------------------------------------------> Top Panel End
// ----------------------------------------------------------------------------------------------> Navigation Panel Start
Line initDivider = new Line();
initDivider.setStartX(0.0f);
initDivider.setEndX(205.0f);
initDivider.setStroke(Color.GRAY);
// <----- Dashboard ----->
dashboardToolTip = new Tooltip("Dashboard");
dashboardBtn = new Button("");
dashboardBtn.getStyleClass().add("dashboardBtn");
dashboardBtn.setTooltip(dashboardToolTip);
dashboardBtn.setOnAction(
e -> {
resetBtns();
rootPane.setCenter(dashBoardBase);
});
// <----- Profile ----->
profileToolTip = new Tooltip("Profile");
profileBtn = new Button();
profileBtn.getStyleClass().add("profileBtn");
profileBtn.setTooltip(profileToolTip);
profileBtn.setOnAction(
e -> {
resetBtns();
rootPane.setCenter(profilePanel);
});
// <----- Courses ----->
courseToolTip = new Tooltip("Courses");
coursesBtn = new Button("");
coursesBtn.getStyleClass().add("coursesBtn");
coursesBtn.setTooltip(courseToolTip);
coursesBtn.setOnAction(
e -> {
resetBtns();
rootPane.setCenter(coursesPanel);
// miscContainer.getChildren().addAll(watchVidBtn);
coursesPanel.setContent(coursesGridPanel);
});
Line mainDivider = new Line();
mainDivider.setStartX(0.0f);
mainDivider.setEndX(205.0f);
mainDivider.setStroke(Color.GRAY);
// <----- Simulations ----->
simsToolTip = new Tooltip("Simulations");
simsBtn = new Button();
simsBtn.getStyleClass().add("simsBtn");
simsBtn.setTooltip(simsToolTip);
simsBtn.setOnAction(
e -> {
resetBtns();
rootPane.setCenter(simsPanel);
simsPanel.setContent(simsGridPanel);
});
// <----- Text Editor ----->
textEditorToolTip = new Tooltip("Text Editor");
textEditorBtn = new Button();
textEditorBtn.getStyleClass().add("textEditorBtn");
textEditorBtn.setTooltip(textEditorToolTip);
textEditorBtn.setOnAction(
e -> {
resetBtns();
rootPane.setCenter(textEditorPanel);
miscContainer.getChildren().addAll(saveDocBtn);
});
Line toolsDivider = new Line();
toolsDivider.setStartX(0.0f);
toolsDivider.setEndX(205.0f);
toolsDivider.setStroke(Color.GRAY);
// <----- Wolfram Alpha ----->
wolframToolTip = new Tooltip("Wolfram Alpha");
wolframBtn = new Button();
wolframBtn.getStyleClass().add("wolframBtn");
wolframBtn.setTooltip(wolframToolTip);
wolframBtn.setOnAction(
e -> {
resetBtns();
rootPane.setCenter(wolframPanel);
});
// <----- Wikipedia ----->
wikipediaToolTip = new Tooltip();
wikipediaBtn = new Button();
wikipediaBtn.getStyleClass().add("wikipediaBtn");
wikipediaBtn.setTooltip(wikipediaToolTip);
wikipediaBtn.setOnAction(
e -> {
resetBtns();
rootPane.setCenter(wikipediaPanel);
});
Line sitesDivider = new Line();
sitesDivider.setStartX(0.0f);
sitesDivider.setEndX(205.0f);
sitesDivider.setStroke(Color.GRAY);
// <----- Settings ----->
settingsToolTip = new Tooltip("Settings");
settingsBtn = new Button();
settingsBtn.getStyleClass().add("settingsBtn");
settingsBtn.setTooltip(settingsToolTip);
settingsBtn.setOnAction(
e -> {
resetBtns();
rootPane.setCenter(settingsPanel);
});
leftPanel = new VBox(0);
// leftPanel.setPrefWidth(1);
leftPanel.getStyleClass().add("leftPane");
leftPanel
.getChildren()
.addAll(
initDivider,
dashboardBtn,
profileBtn,
coursesBtn,
mainDivider,
simsBtn,
textEditorBtn,
toolsDivider,
wolframBtn,
wikipediaBtn,
sitesDivider,
settingsBtn);
topPanel = new HBox(1);
topPanel.getStyleClass().add("topPanel");
topPanel.setPrefWidth(width);
topPanel.setAlignment(Pos.CENTER_RIGHT);
topPanel.setPadding(new Insets(0, 0, 0, 0));
topPanel.getChildren().addAll(miscContainer, minimizeBtn, closeBtn);
// ------------------------------------------------------------------------------------------------> Navigation Panel End
// -----------------------------------------------------------------------------------------------> Dashboard Pane Start
final WebView webVid = new WebView();
final WebEngine webVidEngine = webVid.getEngine();
webVid.setPrefHeight(860);
webVid.setPrefWidth(width - 118);
webVidEngine.loadContent("");
final NumberAxis xAxis = new NumberAxis();
final NumberAxis yAxis = new NumberAxis();
xAxis.setLabel("Day");
yAxis.setLabel("Score");
final LineChart<Number, Number> lineChart = new LineChart<Number, Number>(xAxis, yAxis);
lineChart.setTitle("Line Chart");
XYChart.Series<Number, Number> series = new XYChart.Series<Number, Number>();
series.setName("My Data");
// populating the series with data
series.getData().add(new XYChart.Data<Number, Number>(0.25, 36));
series.getData().add(new XYChart.Data<Number, Number>(1, 23));
series.getData().add(new XYChart.Data<Number, Number>(2, 114));
series.getData().add(new XYChart.Data<Number, Number>(3, 15));
series.getData().add(new XYChart.Data<Number, Number>(4, 124));
lineChart.getData().add(series);
lineChart.setPrefWidth(400);
lineChart.setPrefHeight(300);
lineChart.setLegendVisible(false);
chatRoomField = new TextField();
chatRoomField.getStyleClass().add("textField");
chatRoomField.setPromptText("Enter Chat Room");
chatRoomField.setOnKeyPressed(
new EventHandler<KeyEvent>() {
@Override
public void handle(KeyEvent event) {
if (event.getCode() == KeyCode.ENTER) {
chatRoom = chatRoomField.getText();
client.connect(messageArea, messageInputArea, superUser, chatRoom);
}
}
});
messageArea = new TextArea();
messageArea.getStyleClass().add("textArea");
messageArea.setWrapText(true);
messageArea.setPrefHeight(740);
messageArea.setEditable(false);
messageInputArea = new TextArea();
messageInputArea.getStyleClass().add("textArea");
messageInputArea.setWrapText(true);
messageInputArea.setPrefHeight(100);
messageInputArea.setPromptText("Enter Message");
messageInputArea.setOnKeyPressed(
new EventHandler<KeyEvent>() {
@Override
public void handle(KeyEvent event) {
if (event.getCode() == KeyCode.ENTER) {
client.send(messageArea, messageInputArea, superUser, chatRoom);
event.consume();
}
}
});
chatBox = new VBox();
chatBox.setPrefWidth(250);
chatBox.setMaxWidth(250);
chatBox.getStyleClass().add("chatBox");
chatBox.getChildren().addAll(chatRoomField, messageArea, messageInputArea);
// client.test(messageArea, messageInputArea);
dashboardGridPanel = new GridPane();
dashboardGridPanel.getStyleClass().add("gridPane");
dashboardGridPanel.setVgap(5);
dashboardGridPanel.setHgap(5);
dashboardGridPanel.setGridLinesVisible(false);
dashboardGridPanel.setPrefWidth(width - 430);
dashboardGridPanel.setPrefHeight(860);
dashboardGridPanel.setColumnIndex(lineChart, 0);
dashboardGridPanel.setRowIndex(lineChart, 0);
dashboardGridPanel.getChildren().addAll(lineChart);
dashboardPanel = new ScrollPane();
dashboardPanel.getStyleClass().add("scrollPane");
dashboardPanel.setPrefWidth(width - 400);
dashboardPanel.setPrefHeight(860);
dashboardPanel.setContent(dashboardGridPanel);
dashBoardBase = new HBox();
dashBoardBase.setPrefWidth(width - (leftPanel.getWidth() + chatBox.getWidth()));
dashBoardBase.setPrefHeight(860);
dashBoardBase.getChildren().addAll(dashboardPanel, chatBox);
// -------------------------------------------------------------------------------------------------> Dashboard Pane End
// -------------------------------------------------------------------------------------------------> Profile Pane Start
profilePictureBtn = new Button();
profilePictureBtn.getStyleClass().addAll("profilePictureBtn");
String profileUserName = xmlParser.getSuperUser();
String profileEmail = xmlParser.getEmail();
String profileAge = xmlParser.getAge();
String profileSchool = xmlParser.getSchool();
String profileCountry = "";
String profileCity = "";
userNameLbl = new Label(profileUserName);
userNameLbl.getStyleClass().add("profileLbl");
userNameLbl.setAlignment(Pos.CENTER);
emailLbl = new Label(profileEmail);
emailLbl.getStyleClass().add("profileLbl");
ageLbl = new Label(profileAge);
ageLbl.getStyleClass().add("profileLbl");
schoolLbl = new Label(profileSchool);
schoolLbl.getStyleClass().add("profileLbl");
profileGridPanel = new GridPane();
profileGridPanel.getStyleClass().add("gridPane");
profileGridPanel.setVgap(5);
profileGridPanel.setHgap(5);
profileGridPanel.setGridLinesVisible(false);
profileGridPanel.setPrefWidth(width - 208);
profileGridPanel.setPrefHeight(860);
profileGridPanel.setAlignment(Pos.TOP_CENTER);
profileGridPanel.setRowIndex(profilePictureBtn, 0);
profileGridPanel.setColumnIndex(profilePictureBtn, 0);
profileGridPanel.setRowIndex(userNameLbl, 1);
profileGridPanel.setColumnIndex(userNameLbl, 0);
profileGridPanel.setRowIndex(emailLbl, 2);
profileGridPanel.setColumnIndex(emailLbl, 0);
profileGridPanel.setRowIndex(ageLbl, 3);
profileGridPanel.setColumnIndex(ageLbl, 0);
profileGridPanel.setRowIndex(schoolLbl, 4);
profileGridPanel.setColumnIndex(schoolLbl, 0);
profileGridPanel
.getChildren()
.addAll(profilePictureBtn, userNameLbl, emailLbl, ageLbl, schoolLbl);
profilePanel = new ScrollPane();
profilePanel.getStyleClass().add("scrollPane");
profilePanel.setContent(profileGridPanel);
// ---------------------------------------------------------------------------------------------------> Profile Pane End
// -------------------------------------------------------------------------------------------------> Courses Pane Start
String course = "";
// Media media = new Media("media.mp4");
// mediaPlayer = new MediaPlayer(media);
// mediaPlayer.setAutoPlay(true);
// mediaView = new MediaView(mediaPlayer);
watchVidBtn = new Button("Watch Video");
watchVidBtn.getStyleClass().add("btn");
watchVidBtn.setOnAction(
e -> {
// coursesPanel.setContent(mediaView);
});
chemistryBtn = new Button();
chemistryBtn.getStyleClass().add("chemistryBtn");
chemistryBtn.setOnAction(
e -> {
displayCourse("chemistry");
});
physicsBtn = new Button();
physicsBtn.getStyleClass().add("physicsBtn");
physicsBtn.setOnAction(
e -> {
displayCourse("physics");
});
mathsBtn = new Button();
mathsBtn.getStyleClass().add("mathsBtn");
bioBtn = new Button();
bioBtn.getStyleClass().add("bioBtn");
bioBtn.setOnAction(
e -> {
rootPane.setCenter(biologyCourse.biologyPane());
});
// Course Web View
try {
courseView = new WebView();
courseWebEngine = courseView.getEngine();
courseView.setPrefHeight(860);
courseView.setPrefWidth(width - 208);
} catch (Exception excep) {
System.out.println("<----- Exception in Course Web ----->");
excep.printStackTrace();
System.out.println("<---------->\n");
}
coursesGridPanel = new GridPane();
coursesGridPanel.getStyleClass().add("gridPane");
coursesGridPanel.setVgap(5);
coursesGridPanel.setHgap(5);
coursesGridPanel.setGridLinesVisible(false);
coursesGridPanel.setPrefWidth(width - 208);
coursesGridPanel.setPrefHeight(860);
coursesGridPanel.setRowIndex(chemistryBtn, 1);
coursesGridPanel.setColumnIndex(chemistryBtn, 1);
coursesGridPanel.setRowIndex(physicsBtn, 1);
coursesGridPanel.setColumnIndex(physicsBtn, 2);
coursesGridPanel.setRowIndex(mathsBtn, 1);
coursesGridPanel.setColumnIndex(mathsBtn, 3);
coursesGridPanel.setRowIndex(bioBtn, 1);
coursesGridPanel.setColumnIndex(bioBtn, 4);
coursesGridPanel.getChildren().addAll(chemistryBtn, physicsBtn, mathsBtn, bioBtn);
coursesPanel = new ScrollPane();
coursesPanel.getStyleClass().add("scrollPane");
coursesPanel.setPrefWidth(width - 118);
coursesPanel.setPrefHeight(860);
coursesPanel.setContent(coursesGridPanel);
// ---------------------------------------------------------------------------------------------------> Courses Pane End
// ---------------------------------------------------------------------------------------------> Simulations Pane Start
final WebView browser = new WebView();
final WebEngine webEngine = browser.getEngine();
browser.setPrefHeight(860);
browser.setPrefWidth(width - 208);
/*
File phetImageFile = new File("img/styleDark/poweredByPHET.png");
String phetImageURL = phetImageFile.toURI().toURL().toString();
Image phetImage = new Image(phetImageURL, false);
*/
final ImageView phetImageView = new ImageView();
final Image phetImage =
new Image(Main.class.getResourceAsStream("img/styleDark/poweredByPHET.png"));
phetImageView.setImage(phetImage);
Label motionLbl = new Label("Motion");
motionLbl.getStyleClass().add("lbl");
forcesAndMotionBtn = new Button();
forcesAndMotionBtn.getStyleClass().add("forcesAndMotionBtn");
forcesAndMotionBtn.setOnAction(
e -> {
webEngine.load(
"https://phet.colorado.edu/sims/html/balancing-act/latest/balancing-act_en.html");
simsPanel.setContent(browser);
});
balancingActBtn = new Button();
balancingActBtn.getStyleClass().add("balancingActBtn");
balancingActBtn.setOnAction(
e -> {
webEngine.load(
"https://phet.colorado.edu/sims/html/balancing-act/latest/balancing-act_en.html");
simsPanel.setContent(browser);
});
energySkateParkBtn = new Button();
energySkateParkBtn.getStyleClass().add("energySkateParkBtn");
energySkateParkBtn.setOnAction(
e -> {
webEngine.load(
"https://phet.colorado.edu/sims/html/energy-skate-park-basics/latest/"
+ "energy-skate-park-basics_en.html");
simsPanel.setContent(browser);
});
balloonsAndStaticElectricityBtn = new Button();
balloonsAndStaticElectricityBtn.getStyleClass().add("balloonsAndStaticElectricityBtn");
balloonsAndStaticElectricityBtn.setOnAction(
e -> {
webEngine.load(
"https://phet.colorado.edu/sims/html/balloons-and-static-electricity/latest/"
+ "balloons-and-static-electricity_en.html");
simsPanel.setContent(browser);
});
buildAnAtomBtn = new Button();
buildAnAtomBtn.getStyleClass().add("buildAnAtomBtn");
buildAnAtomBtn.setOnAction(
e -> {
webEngine.load(
"https://phet.colorado.edu/sims/html/build-an-atom/latest/build-an-atom_en.html");
simsPanel.setContent(browser);
});
colorVisionBtn = new Button();
colorVisionBtn.getStyleClass().add("colorVisionBtn");
colorVisionBtn.setOnAction(
e -> {
webEngine.load(
"https://phet.colorado.edu/sims/html/color-vision/latest/color-vision_en.html");
simsPanel.setContent(browser);
});
Label soundAndWavesLbl = new Label("Sound and Waves");
soundAndWavesLbl.getStyleClass().add("lbl");
wavesOnAStringBtn = new Button();
wavesOnAStringBtn.getStyleClass().add("wavesOnAStringBtn");
wavesOnAStringBtn.setOnAction(
e -> {
webEngine.load(
"https://phet.colorado.edu/sims/html/wave-on-a-string/latest/wave-on-a-string_en.html");
simsPanel.setContent(browser);
});
/*
motionSimsFlowPane = new FlowPane();
motionSimsFlowPane.getStyleClass().add("flowPane");
motionSimsFlowPane.setVgap(5);
motionSimsFlowPane.setHgap(5);
motionSimsFlowPane.setAlignment(Pos.TOP_LEFT);
motionSimsFlowPane.getChildren().addAll(forcesAndMotionBtn, balancingActBtn, energySkateParkBtn,
buildAnAtomBtn, colorVisionBtn, wavesOnAStringBtn);
soundAndWavesFlowPane = new FlowPane();
soundAndWavesFlowPane.getStyleClass().add("flowPane");
soundAndWavesFlowPane.setVgap(5);
soundAndWavesFlowPane.setHgap(5);
soundAndWavesFlowPane.setAlignment(Pos.TOP_LEFT);
soundAndWavesFlowPane.getChildren().addAll(wavesOnAStringBtn);
simsBox = new VBox();
simsBox.getStyleClass().add("vbox");
simsBox.setPrefHeight(height);
simsBox.setPrefWidth(width);
simsBox.getChildren().addAll(motionLbl, motionSimsFlowPane, soundAndWavesLbl, soundAndWavesFlowPane);
*/
simsGridPanel = new GridPane();
simsGridPanel.getStyleClass().add("gridPane");
simsGridPanel.setVgap(5);
simsGridPanel.setHgap(5);
simsGridPanel.setGridLinesVisible(false);
simsGridPanel.setPrefWidth(width - 208);
simsGridPanel.setPrefHeight(860);
simsGridPanel.setRowIndex(phetImageView, 0);
simsGridPanel.setColumnIndex(phetImageView, 4);
simsGridPanel.setRowIndex(motionLbl, 0);
simsGridPanel.setColumnIndex(motionLbl, 0);
simsGridPanel.setRowIndex(forcesAndMotionBtn, 1);
simsGridPanel.setColumnIndex(forcesAndMotionBtn, 0);
simsGridPanel.setRowIndex(balancingActBtn, 1);
simsGridPanel.setColumnIndex(balancingActBtn, 1);
simsGridPanel.setRowIndex(energySkateParkBtn, 1);
simsGridPanel.setColumnIndex(energySkateParkBtn, 2);
simsGridPanel.setRowIndex(buildAnAtomBtn, 1);
simsGridPanel.setColumnIndex(buildAnAtomBtn, 3);
simsGridPanel.setRowIndex(colorVisionBtn, 1);
simsGridPanel.setColumnIndex(colorVisionBtn, 4);
simsGridPanel.setRowIndex(soundAndWavesLbl, 2);
simsGridPanel.setColumnIndex(soundAndWavesLbl, 0);
simsGridPanel.setColumnSpan(soundAndWavesLbl, 4);
simsGridPanel.setRowIndex(wavesOnAStringBtn, 3);
simsGridPanel.setColumnIndex(wavesOnAStringBtn, 0);
simsGridPanel
.getChildren()
.addAll(
phetImageView,
motionLbl,
forcesAndMotionBtn,
balancingActBtn,
energySkateParkBtn,
buildAnAtomBtn,
colorVisionBtn,
soundAndWavesLbl,
wavesOnAStringBtn);
simsPanel = new ScrollPane();
simsPanel.getStyleClass().add("scrollPane");
simsPanel.setContent(simsGridPanel);
// -----------------------------------------------------------------------------------------------> Simulations Pane End
// ---------------------------------------------------------------------------------------------> Text Editor Pane Start
htmlEditor = new HTMLEditor();
htmlEditor.setPrefHeight(860);
htmlEditor.setPrefWidth(width - 208);
// Prevents Scroll on Space Pressed
htmlEditor.addEventFilter(
KeyEvent.KEY_PRESSED,
new EventHandler<KeyEvent>() {
@Override
public void handle(KeyEvent event) {
if (event.getEventType() == KeyEvent.KEY_PRESSED) {
if (event.getCode() == KeyCode.SPACE) {
event.consume();
}
}
}
});
XWPFDocument document = new XWPFDocument();
XWPFParagraph tmpParagraph = document.createParagraph();
XWPFRun tmpRun = tmpParagraph.createRun();
saveDocBtn = new Button();
saveDocBtn.getStyleClass().add("btn");
saveDocBtn.setText("Save");
saveDocBtn.setOnAction(
e -> {
tmpRun.setText(tools.stripHTMLTags(htmlEditor.getHtmlText()));
tmpRun.setFontSize(12);
saveDocument(document, primaryStage);
});
textEditorPanel = new ScrollPane();
textEditorPanel.getStyleClass().add("scrollPane");
textEditorPanel.setContent(htmlEditor);
// -----------------------------------------------------------------------------------------------> Text Editor Pane End
// -------------------------------------------------------------------------------------------------> Wolfram Pane Start
Boolean wolframActive = false;
try {
final WebView wolframWeb = new WebView();
wolframWeb.getStyleClass().add("webView");
final WebEngine wolframWebEngine = wolframWeb.getEngine();
wolframWeb.setPrefHeight(860);
wolframWeb.setPrefWidth(width - 208);
if (wolframActive == false) {
wolframWebEngine.load("http://www.wolframalpha.com/");
wolframActive = true;
}
wolframPanel = new ScrollPane();
wolframPanel.setContent(wolframWeb);
} catch (Exception excep) {
System.out.println("<----- Exception in Wolfram Alpha Web ----->");
excep.printStackTrace();
System.out.println("<---------->\n");
}
// ---------------------------------------------------------------------------------------------------> Wolfram Pane End
// ------------------------------------------------------------------------------------------------> Wikipedia Pane Start
Boolean wikipediaActive = false;
try {
final WebView wikipediaWeb = new WebView();
wikipediaWeb.getStyleClass().add("scrollPane");
wikipediaWebEngine = wikipediaWeb.getEngine();
wikipediaWeb.setPrefHeight(860);
wikipediaWeb.setPrefWidth(width - 208);
if (wikipediaActive == false) {
wikipediaWebEngine.load("https://en.wikipedia.org/wiki/Main_Page");
wikipediaActive = true;
}
wikipediaPanel = new ScrollPane();
wikipediaPanel.setContent(wikipediaWeb);
} catch (Exception e) {
e.printStackTrace();
}
// --------------------------------------------------------------------------------------------------> Wikipedia Pane End
// -------------------------------------------------------------------------------------------------> Settings Pane Start
settingsGridPanel = new GridPane();
settingsGridPanel.getStyleClass().add("gridPane");
settingsGridPanel.setPrefWidth(width - 208);
settingsGridPanel.setPrefHeight(height);
settingsGridPanel.setVgap(5);
settingsGridPanel.setHgap(5);
settingsPanel = new ScrollPane();
settingsPanel.getStyleClass().add("scrollPane");
settingsPanel.setContent(settingsGridPanel);
// ---------------------------------------------------------------------------------------------------> Settings Pane End
rootPane = new BorderPane();
rootPane.setLeft(leftPanel);
rootPane.setTop(topPanel);
rootPane.setCenter(dashBoardBase);
rootPane.getStyleClass().add("rootPane");
rootPane.getStylesheets().add(Main.class.getResource("css/styleDark.css").toExternalForm());
programWidth = primaryStage.getWidth();
programHeight = primaryStage.getHeight();
primaryStage.setTitle("ALE");
primaryStage.initStyle(StageStyle.UNDECORATED);
primaryStage
.getIcons()
.add(new javafx.scene.image.Image(Main.class.getResourceAsStream("img/aleIcon.png")));
primaryStage.setScene(new Scene(rootPane, width, height));
primaryStage.show();
}
public List<Empleado> getAllEmpleados() {
List ll = new LinkedList();
Statement st;
ResultSet rs;
String url = "jdbc:mysql://localhost:3306/food";
String user = "******";
String pass = "******";
String driver = "com.mysql.jdbc.Driver";
try (Connection connection = DriverManager.getConnection(url, user, pass)) {
Class.forName(driver);
st = connection.createStatement();
String recordQuery = ("Select * from empleados");
rs = st.executeQuery(recordQuery);
while (rs.next()) {
Integer id = rs.getInt("idEmpleados");
String name = rs.getString("Nombre");
String telf = rs.getString("Telefono");
ll.add(new Empleado(id, name, telf));
/// System.out.println(id +","+ name +","+ apellido +","+ cedula +","+ telf +"
// "+direccion+"");
}
} catch (ClassNotFoundException | SQLException ex) {
Logger.getLogger(MenuEmpleados.class.getName()).log(Level.SEVERE, null, ex);
}
return ll;
}