API tools faq
paste
Guest User

Untitled

a guest
Oct 15th, 2017
65
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 26.05 KB | None | 0 0
raw download clone embed print report
  1. package view;
  2.  
  3. import java.awt.ScrollPane;
  4. import java.util.Observable;
  5. import java.util.Set;
  6.  
  7. import javax.swing.JOptionPane;
  8.  
  9. import javax.swing.JPanel;
  10.  
  11. import controller.Main;
  12. import javafx.application.Application;
  13. import javafx.beans.value.ObservableValue;
  14. import javafx.collections.FXCollections;
  15. import javafx.collections.ListChangeListener;
  16. import javafx.collections.ObservableList;
  17. import javafx.event.EventHandler;
  18. import javafx.geometry.Insets;
  19. import javafx.geometry.Orientation;
  20. import javafx.scene.Node;
  21. import javafx.scene.Scene;
  22. import javafx.scene.control.Button;
  23. import javafx.scene.control.ChoiceBox;
  24. import javafx.scene.control.Label;
  25. import javafx.scene.control.ListView;
  26. import javafx.scene.control.ScrollBar;
  27. import javafx.scene.control.SelectionMode;
  28. import javafx.scene.control.TableColumn;
  29. import javafx.scene.control.TableView;
  30. import javafx.scene.control.TextField;
  31. import javafx.scene.control.TableColumn.CellEditEvent;
  32. import javafx.scene.control.cell.PropertyValueFactory;
  33. import javafx.scene.control.cell.TextFieldTableCell;
  34. import javafx.scene.layout.AnchorPane;
  35. import javafx.scene.layout.Border;
  36. import javafx.scene.layout.BorderPane;
  37. import javafx.scene.layout.VBox;
  38. import javafx.scene.text.Font;
  39. import javafx.stage.Stage;
  40. import model.Aluno;
  41. import model.Agenda;
  42. import model.DAO.AgendaDAO;
  43. import model.DAO.AlunoDAO;
  44.  
  45. public class TelaAgenda extends Application {
  46.  
  47. private static ListView<String> listView;
  48. private static TableView<Agenda> table;
  49. private static Button buttonNovo;
  50. private static Button buttonSalvar;
  51. private static TableColumn tableColuna1;
  52. private static TableColumn tableColuna2;
  53. private static TableColumn tableColuna3;
  54. private static TableColumn tableColuna4;
  55. private static TableColumn tableColuna5;
  56. private static TableColumn tableColuna6;
  57. private static Label labelreferencia;
  58. private static Label labeldescricao;
  59. private static TextField textFielddescricao;
  60. private static Label labelvalor;
  61. private static TextField textFieldvalor;
  62.  
  63. private ChoiceBox<String> choiceBox0;
  64. private ChoiceBox<String> choiceBox1;
  65. private ChoiceBox<String> choiceBox2;
  66. private ChoiceBox<String> choiceBox3;
  67. private ChoiceBox<String> choiceBox4;
  68. private ChoiceBox<String> choiceBox5;
  69. private ChoiceBox<String> choiceBox6;
  70. private ChoiceBox<String> choiceBox7;
  71. private ChoiceBox<String> choiceBox8;
  72. private ChoiceBox<String> choiceBox9;
  73. private ChoiceBox<String> choiceBox10;
  74. private ChoiceBox<String> choiceBox11;
  75. private ChoiceBox<String> choiceBox12;
  76. private ChoiceBox<String> choiceBox13;
  77.  
  78. public static void main(String[] args) {
  79. launch(args);
  80. }
  81.  
  82. // private String nome;
  83. // private String descricao;
  84. // private String valor;
  85. // private String diasaulas;
  86. // private String tiposaulas;
  87.  
  88. private static AgendaDAO agendadao;
  89. private static Agenda agenda = new Agenda();
  90. private static Aluno aluno;
  91.  
  92. @Override
  93. public void start(Stage primaryStage) {
  94.  
  95. VBox vbox = new VBox();
  96. AnchorPane root = new AnchorPane(vbox);
  97.  
  98. primaryStage.setTitle("Agendamento");
  99.  
  100. tableColuna1 = new TableColumn<>("Matricula");
  101. tableColuna1.setMinWidth(50);
  102. tableColuna1.setCellValueFactory(new PropertyValueFactory<Agenda, Integer>("matricula"));
  103. tableColuna1.setCellFactory(TextFieldTableCell.forTableColumn());
  104. tableColuna1.setOnEditCommit(new EventHandler<TableColumn.CellEditEvent<Agenda, Integer>>() {
  105.  
  106. @Override
  107. public void handle(CellEditEvent<Agenda, Integer> event) {
  108. ((Agenda) event.getTableView().getItems().get(event.getTablePosition().getRow()))
  109. .setMatricula(event.getNewValue());
  110.  
  111. }
  112.  
  113. });
  114.  
  115. tableColuna2 = new TableColumn<>("Nome");
  116. tableColuna2.setMinWidth(200);
  117. tableColuna2.setCellValueFactory(new PropertyValueFactory<Agenda, String>("nome"));
  118. tableColuna2.setCellFactory(TextFieldTableCell.forTableColumn());
  119. tableColuna2.setOnEditCommit(new EventHandler<TableColumn.CellEditEvent<Agenda, String>>() {
  120.  
  121. @Override
  122. public void handle(CellEditEvent<Agenda, String> event) {
  123. ((Agenda) event.getTableView().getItems().get(event.getTablePosition().getRow()))
  124. .setNome(event.getNewValue());
  125.  
  126. }
  127.  
  128. });
  129.  
  130. tableColuna3 = new TableColumn<>("Descrição");
  131. tableColuna3.setMinWidth(200);
  132. tableColuna3.setCellValueFactory(new PropertyValueFactory<Agenda, String>("descricao"));
  133. tableColuna3.setCellFactory(TextFieldTableCell.forTableColumn());
  134. tableColuna3.setOnEditCommit(new EventHandler<TableColumn.CellEditEvent<Agenda, String>>() {
  135.  
  136. @Override
  137. public void handle(CellEditEvent<Agenda, String> event) {
  138. ((Agenda) event.getTableView().getItems().get(event.getTablePosition().getRow()))
  139. .setDescricao(event.getNewValue());
  140.  
  141. }
  142.  
  143. });
  144.  
  145. tableColuna4 = new TableColumn<>("Valor");
  146. tableColuna4.setMinWidth(200);
  147. tableColuna4.setCellValueFactory(new PropertyValueFactory<Agenda, String>("valor"));
  148. tableColuna4.setCellFactory(TextFieldTableCell.forTableColumn());
  149. tableColuna4.setOnEditCommit(new EventHandler<TableColumn.CellEditEvent<Agenda, String>>() {
  150.  
  151. @Override
  152. public void handle(CellEditEvent<Agenda, String> event) {
  153. ((Agenda) event.getTableView().getItems().get(event.getTablePosition().getRow()))
  154. .setValor(event.getNewValue());
  155.  
  156. }
  157.  
  158. });
  159.  
  160. tableColuna5 = new TableColumn<>("DiasAulas");
  161. tableColuna5.setMinWidth(200);
  162. tableColuna5.setCellValueFactory(new PropertyValueFactory<Agenda, String>("diasaulas"));
  163. tableColuna5.setCellFactory(TextFieldTableCell.forTableColumn());
  164. tableColuna5.setOnEditCommit(new EventHandler<TableColumn.CellEditEvent<Agenda, String>>() {
  165.  
  166. @Override
  167. public void handle(CellEditEvent<Agenda, String> event) {
  168. ((Agenda) event.getTableView().getItems().get(event.getTablePosition().getRow()))
  169. .setDiasaulas(event.getNewValue());
  170.  
  171. }
  172.  
  173. });
  174.  
  175. tableColuna6 = new TableColumn<>("TiposAulas");
  176. tableColuna6.setMinWidth(200);
  177. tableColuna6.setCellValueFactory(new PropertyValueFactory<Agenda, String>("tiposaulas"));
  178. tableColuna6.setCellFactory(TextFieldTableCell.forTableColumn());
  179. tableColuna6.setOnEditCommit(new EventHandler<TableColumn.CellEditEvent<Agenda, String>>() {
  180.  
  181. @Override
  182. public void handle(CellEditEvent<Agenda, String> event) {
  183. ((Agenda) event.getTableView().getItems().get(event.getTablePosition().getRow()))
  184. .setTiposaulas(event.getNewValue());
  185.  
  186. }
  187.  
  188. });
  189.  
  190. table = new TableView<Agenda>();
  191. table.setItems(agenda.atualizarTabela());
  192. table.setPrefSize(740, 280);
  193.  
  194. table.setEditable(true);
  195.  
  196. table.getColumns().addAll(tableColuna1, tableColuna2, tableColuna3, tableColuna4, tableColuna5, tableColuna6);
  197.  
  198. vbox.getChildren().addAll(table);
  199.  
  200. labelreferencia = new Label("Pressione Ctrl e clique sobre o dia da semana para marcar ou desmarcar");
  201. labelreferencia.setFont(new Font(16));
  202. labelreferencia.setPrefSize(530, 30);
  203. labelreferencia.setLayoutX(5);
  204. labelreferencia.setLayoutY(523);
  205.  
  206. labeldescricao = new Label("Descrição");
  207. labeldescricao.setFont(new Font(16));
  208. labeldescricao.setPrefSize(100, 35);
  209. labeldescricao.setLayoutX(5);
  210. labeldescricao.setLayoutY(280);
  211.  
  212. textFielddescricao = new TextField();
  213. textFielddescricao.setPromptText("Descrição:");
  214. textFielddescricao.setPrefSize(300, 20);
  215. textFielddescricao.setLayoutX(5);
  216. textFielddescricao.setLayoutY(308);
  217.  
  218. labelvalor = new Label("Valor");
  219. labelvalor.setFont(new Font(16));
  220. labelvalor.setPrefSize(80, 35);
  221. labelvalor.setLayoutX(320);
  222. labelvalor.setLayoutY(280);
  223.  
  224. textFieldvalor = new TextField();
  225. textFieldvalor.setPromptText("Valor:");
  226. textFieldvalor.setPrefSize(100, 20);
  227. textFieldvalor.setLayoutX(320);
  228. textFieldvalor.setLayoutY(308);
  229.  
  230. buttonNovo = new Button("Novo");
  231. buttonNovo.setPrefSize(60, 10);
  232. buttonNovo.setLayoutX(580);
  233. buttonNovo.setLayoutY(525);
  234.  
  235. buttonSalvar = new Button("Salvar");
  236. buttonSalvar.setPrefSize(60, 10);
  237. buttonSalvar.setLayoutX(645);
  238. buttonSalvar.setLayoutY(525);
  239.  
  240. buttonSalvar.setOnAction(e -> {
  241.  
  242. String message = "";
  243. ObservableList<String> movies;
  244. movies = listView.getSelectionModel().getSelectedItems();
  245.  
  246. for (String m : movies) {
  247. message += m + "n";
  248. }
  249. System.out.println(message);
  250.  
  251. String nome = tableColuna1.getText();
  252. String descricao = textFielddescricao.getText();
  253. String valor = textFieldvalor.getText();
  254. String diasaulas = tableColuna4.getText();
  255. String tiposaulas = tableColuna4.getText();
  256.  
  257. agenda = agendadao.insert(nome, descricao, valor, diasaulas, tiposaulas);
  258.  
  259. Main.fazerAgendamento(agenda);
  260.  
  261. });
  262.  
  263. choiceBox0 = new ChoiceBox<>();
  264. choiceBox0.setDisable(true);
  265. choiceBox0.setLayoutX(580);
  266. choiceBox0.setLayoutY(310);
  267. choiceBox0.getItems().add("06:00");
  268. choiceBox0.getItems().add("06:30");
  269. choiceBox0.getItems().add("07:00");
  270. choiceBox0.getItems().add("07:30");
  271. choiceBox0.getItems().add("08:00");
  272. choiceBox0.getItems().add("08:30");
  273. choiceBox0.getItems().add("09:00");
  274. choiceBox0.setValue("06:00");
  275.  
  276. choiceBox1 = new ChoiceBox<>();
  277. choiceBox1.setDisable(true);
  278. choiceBox1.setLayoutX(580);
  279. choiceBox1.setLayoutY(340);
  280. choiceBox1.getItems().add("06:00");
  281. choiceBox1.getItems().add("06:30");
  282. choiceBox1.getItems().add("07:00");
  283. choiceBox1.getItems().add("07:30");
  284. choiceBox1.getItems().add("08:00");
  285. choiceBox1.getItems().add("08:30");
  286. choiceBox1.getItems().add("09:00");
  287. choiceBox1.setValue("06:00");
  288.  
  289. choiceBox2 = new ChoiceBox<>();
  290. choiceBox2.setDisable(true);
  291. choiceBox2.setLayoutX(650);
  292. choiceBox2.setLayoutY(310);
  293. choiceBox2.getItems().add("06:00");
  294. choiceBox2.getItems().add("06:30");
  295. choiceBox2.getItems().add("07:00");
  296. choiceBox2.getItems().add("07:30");
  297. choiceBox2.getItems().add("08:00");
  298. choiceBox2.getItems().add("08:30");
  299. choiceBox2.getItems().add("09:00");
  300. choiceBox2.setValue("06:00");
  301.  
  302. choiceBox3 = new ChoiceBox<>();
  303. choiceBox3.setDisable(true);
  304. choiceBox3.setLayoutX(650);
  305. choiceBox3.setLayoutY(340);
  306. choiceBox3.getItems().add("06:00");
  307. choiceBox3.getItems().add("06:30");
  308. choiceBox3.getItems().add("07:00");
  309. choiceBox3.getItems().add("07:30");
  310. choiceBox3.getItems().add("08:00");
  311. choiceBox3.getItems().add("08:30");
  312. choiceBox3.getItems().add("09:00");
  313. choiceBox3.setValue("06:00");
  314.  
  315. choiceBox4 = new ChoiceBox<>();
  316. choiceBox4.setDisable(true);
  317. choiceBox4.setLayoutX(580);
  318. choiceBox4.setLayoutY(370);
  319. choiceBox4.getItems().add("06:00");
  320. choiceBox4.getItems().add("06:30");
  321. choiceBox4.getItems().add("07:00");
  322. choiceBox4.getItems().add("07:30");
  323. choiceBox4.getItems().add("08:00");
  324. choiceBox4.getItems().add("08:30");
  325. choiceBox4.getItems().add("09:00");
  326. choiceBox4.setValue("06:00");
  327.  
  328. choiceBox5 = new ChoiceBox<>();
  329. choiceBox5.setDisable(true);
  330. choiceBox5.setLayoutX(650);
  331. choiceBox5.setLayoutY(370);
  332. choiceBox5.getItems().add("06:00");
  333. choiceBox5.getItems().add("06:30");
  334. choiceBox5.getItems().add("07:00");
  335. choiceBox5.getItems().add("07:30");
  336. choiceBox5.getItems().add("08:00");
  337. choiceBox5.getItems().add("08:30");
  338. choiceBox5.getItems().add("09:00");
  339. choiceBox5.setValue("06:00");
  340.  
  341. choiceBox6 = new ChoiceBox<>();
  342. choiceBox6.setDisable(true);
  343. choiceBox6.setLayoutX(580);
  344. choiceBox6.setLayoutY(400);
  345. choiceBox6.getItems().add("06:00");
  346. choiceBox6.getItems().add("06:30");
  347. choiceBox6.getItems().add("07:00");
  348. choiceBox6.getItems().add("07:30");
  349. choiceBox6.getItems().add("08:00");
  350. choiceBox6.getItems().add("08:30");
  351. choiceBox6.getItems().add("09:00");
  352. choiceBox6.setValue("06:00");
  353.  
  354. choiceBox7 = new ChoiceBox<>();
  355. choiceBox7.setDisable(true);
  356. choiceBox7.setLayoutX(650);
  357. choiceBox7.setLayoutY(400);
  358. choiceBox7.getItems().add("06:00");
  359. choiceBox7.getItems().add("06:30");
  360. choiceBox7.getItems().add("07:00");
  361. choiceBox7.getItems().add("07:30");
  362. choiceBox7.getItems().add("08:00");
  363. choiceBox7.getItems().add("08:30");
  364. choiceBox7.getItems().add("09:00");
  365. choiceBox7.setValue("06:00");
  366.  
  367. choiceBox8 = new ChoiceBox<>();
  368. choiceBox8.setDisable(true);
  369. choiceBox8.setLayoutX(580);
  370. choiceBox8.setLayoutY(430);
  371. choiceBox8.getItems().add("06:00");
  372. choiceBox8.getItems().add("06:30");
  373. choiceBox8.getItems().add("07:00");
  374. choiceBox8.getItems().add("07:30");
  375. choiceBox8.getItems().add("08:00");
  376. choiceBox8.getItems().add("08:30");
  377. choiceBox8.getItems().add("09:00");
  378. choiceBox8.setValue("06:00");
  379.  
  380. choiceBox9 = new ChoiceBox<>();
  381. choiceBox9.setDisable(true);
  382. choiceBox9.setLayoutX(650);
  383. choiceBox9.setLayoutY(430);
  384. choiceBox9.getItems().add("06:00");
  385. choiceBox9.getItems().add("06:30");
  386. choiceBox9.getItems().add("07:00");
  387. choiceBox9.getItems().add("07:30");
  388. choiceBox9.getItems().add("08:00");
  389. choiceBox9.getItems().add("08:30");
  390. choiceBox9.getItems().add("09:00");
  391. choiceBox9.setValue("06:00");
  392.  
  393. choiceBox10 = new ChoiceBox<>();
  394. choiceBox10.setDisable(true);
  395. choiceBox10.setLayoutX(580);
  396. choiceBox10.setLayoutY(460);
  397. choiceBox10.getItems().add("06:00");
  398. choiceBox10.getItems().add("06:30");
  399. choiceBox10.getItems().add("07:00");
  400. choiceBox10.getItems().add("07:30");
  401. choiceBox10.getItems().add("08:00");
  402. choiceBox10.getItems().add("08:30");
  403. choiceBox10.getItems().add("09:00");
  404. choiceBox10.setValue("06:00");
  405.  
  406. choiceBox11 = new ChoiceBox<>();
  407. choiceBox11.setDisable(true);
  408. choiceBox11.setLayoutX(650);
  409. choiceBox11.setLayoutY(460);
  410. choiceBox11.getItems().add("06:00");
  411. choiceBox11.getItems().add("06:30");
  412. choiceBox11.getItems().add("07:00");
  413. choiceBox11.getItems().add("07:30");
  414. choiceBox11.getItems().add("08:00");
  415. choiceBox11.getItems().add("08:30");
  416. choiceBox11.getItems().add("09:00");
  417. choiceBox11.setValue("06:00");
  418.  
  419. choiceBox12 = new ChoiceBox<>();
  420. choiceBox12.setDisable(true);
  421. choiceBox12.setLayoutX(580);
  422. choiceBox12.setLayoutY(490);
  423. choiceBox12.getItems().add("06:00");
  424. choiceBox12.getItems().add("06:30");
  425. choiceBox12.getItems().add("07:00");
  426. choiceBox12.getItems().add("07:30");
  427. choiceBox12.getItems().add("08:00");
  428. choiceBox12.getItems().add("08:30");
  429. choiceBox12.getItems().add("09:00");
  430. choiceBox12.setValue("06:00");
  431.  
  432. choiceBox13 = new ChoiceBox<>();
  433. choiceBox13.setDisable(true);
  434. choiceBox13.setLayoutX(650);
  435. choiceBox13.setLayoutY(490);
  436. // choiceBox13.setPrefSize(60,5);
  437. choiceBox13.getItems().add("06:00");
  438. choiceBox13.getItems().add("06:30");
  439. choiceBox13.getItems().add("07:00");
  440. choiceBox13.getItems().add("07:30");
  441. choiceBox13.getItems().add("08:00");
  442. choiceBox13.getItems().add("08:30");
  443. choiceBox13.getItems().add("09:00");
  444. choiceBox13.setValue("06:00");
  445.  
  446. listView = new ListView<>();
  447. // listView.setPrefSize(200, 200);
  448. // root.setLeftAnchor(listView, 10.0);
  449. listView.setLayoutX(440);
  450. listView.setLayoutY(310);
  451. listView.setMaxSize(130, 200);
  452. listView.getItems().addAll("Domingo", "Segunda", "Terça", "Quarta", "Quinta", "Sexta", "Sabado");
  453. listView.getSelectionModel().setSelectionMode(SelectionMode.MULTIPLE);
  454.  
  455. table.getSelectionModel().selectedItemProperty().addListener((obs, oldSelection, newSelection) -> {
  456.  
  457. if (table != null) {
  458. ObservableList<Agenda> agenda = table.getSelectionModel().getSelectedItems();
  459. // table.getSelectionModel().clearSelection();
  460. System.out.println(agenda);
  461. }
  462. });
  463.  
  464. listView.getSelectionModel().selectedItemProperty().addListener(Event -> {
  465.  
  466. listView.setOnMouseReleased(e -> {
  467.  
  468. String message = "";
  469. ObservableList<String> movies;
  470. movies = listView.getSelectionModel().getSelectedItems();
  471.  
  472. for (String m : movies) {
  473. message += m;
  474. }
  475.  
  476. if (message.equals("Domingo")) {
  477. choiceBox0.setDisable(false);
  478. choiceBox2.setDisable(false);
  479.  
  480. } else {
  481. choiceBox0.setDisable(true);
  482. choiceBox2.setDisable(true);
  483.  
  484. }
  485.  
  486. if (message.equals("Segunda")) {
  487. choiceBox1.setDisable(false);
  488. choiceBox3.setDisable(false);
  489.  
  490. } else {
  491. choiceBox1.setDisable(true);
  492. choiceBox3.setDisable(true);
  493. }
  494.  
  495. if (message.equals("Terça")) {
  496. choiceBox4.setDisable(false);
  497. choiceBox5.setDisable(false);
  498.  
  499. } else {
  500. choiceBox4.setDisable(true);
  501. choiceBox5.setDisable(true);
  502. }
  503.  
  504. if (message.equals("Quarta")) {
  505. choiceBox6.setDisable(false);
  506. choiceBox7.setDisable(false);
  507.  
  508. } else {
  509. choiceBox6.setDisable(true);
  510. choiceBox7.setDisable(true);
  511. }
  512.  
  513. if (message.equals("Quinta")) {
  514. choiceBox8.setDisable(false);
  515. choiceBox9.setDisable(false);
  516.  
  517. } else {
  518. choiceBox8.setDisable(true);
  519. choiceBox9.setDisable(true);
  520. }
  521.  
  522. if (message.equals("Sexta")) {
  523. choiceBox10.setDisable(false);
  524. choiceBox11.setDisable(false);
  525.  
  526. } else {
  527. choiceBox10.setDisable(true);
  528. choiceBox11.setDisable(true);
  529. }
  530.  
  531. if (message.equals("Sabado")) {
  532. choiceBox12.setDisable(false);
  533. choiceBox13.setDisable(false);
  534.  
  535. } else {
  536. choiceBox12.setDisable(true);
  537. choiceBox13.setDisable(true);
  538. }
  539.  
  540. });
  541.  
  542. });
  543.  
  544. root.getChildren().addAll(listView, choiceBox0, choiceBox1, choiceBox2, choiceBox3, choiceBox4, choiceBox5,
  545. choiceBox6, choiceBox7, choiceBox8, choiceBox9, choiceBox10, choiceBox11, choiceBox12, choiceBox13,
  546. labeldescricao, textFielddescricao, labelvalor, textFieldvalor, labelreferencia, buttonNovo,
  547. buttonSalvar);
  548.  
  549. // root.setStyle("-fx-background-color: #006400");
  550.  
  551. Scene scene = new Scene(root, 730, 550);
  552. scene.getStylesheets().add("view/application.css");
  553. primaryStage.setScene(scene);
  554. primaryStage.show();
  555. primaryStage.setResizable(false);
  556.  
  557. }
  558.  
  559. /*
  560. *
  561. * public void buttonClicked() { ObservableList<String> movies; String
  562. * message = ""; movies = listView.getSelectionModel().getSelectedItems();
  563. *
  564. * for (String m : movies) { message += m + "n"; }
  565. * System.out.println("Numero 1" + message); //
  566. * JOptionPane.showMessageDialog(null, message);
  567. *
  568. * }
  569. *
  570. */
  571.  
  572. package model;
  573.  
  574. import javafx.beans.property.SimpleDoubleProperty;
  575. import javafx.beans.property.SimpleIntegerProperty;
  576. import javafx.beans.property.SimpleStringProperty;
  577. import javafx.collections.FXCollections;
  578. import javafx.collections.ObservableList;
  579. import model.DAO.AgendaDAO;
  580.  
  581. public class Agenda {
  582.  
  583. private SimpleIntegerProperty matricula;
  584. private SimpleStringProperty nome;
  585. private SimpleStringProperty valor;
  586. private SimpleStringProperty descricao;
  587. private SimpleStringProperty diasaulas;
  588. private SimpleStringProperty tiposaulas;
  589.  
  590. public int getMatricula() {
  591.  
  592. return matricula.get();
  593. }
  594.  
  595. public void setMatricula(int matricula1) {
  596. matricula.set(matricula1);
  597. }
  598.  
  599. public String getNome() {
  600. return nome.get();
  601. }
  602.  
  603. public void setNome(String nome1) {
  604. nome.set(nome1);
  605. }
  606.  
  607. public String getValor() {
  608. return valor.get();
  609. }
  610.  
  611. public void setValor(String valor1) {
  612. valor.set(valor1);
  613. }
  614.  
  615. public String getDescricao() {
  616. return descricao.get();
  617. }
  618.  
  619. public void setDescricao(String descricao1) {
  620. descricao.set(descricao1);
  621. }
  622.  
  623. public String getDiasaulas() {
  624. return diasaulas.get();
  625. }
  626.  
  627. public void setDiasaulas(String diasaulas1) {
  628. diasaulas.set(diasaulas1);
  629. }
  630.  
  631. public String getTiposaulas() {
  632. return tiposaulas.get();
  633. }
  634.  
  635. public void setTiposaulas(String tiposaulas1) {
  636. tiposaulas.set(tiposaulas1);
  637. }
  638.  
  639. // public Agenda() {
  640. // this.nome = "";
  641. // this.valor1 = "";
  642. // this.descricao = "";
  643. // this.diasaulas = "";
  644. // this.tiposaulas = "";
  645. // }
  646.  
  647. public Agenda(String matricula1, String nome1, String valor1, String descricao1, String diasaulas1,
  648. String tiposaulas1) {
  649.  
  650. this.nome = new SimpleStringProperty(nome1);
  651. this.valor = new SimpleStringProperty(valor1);
  652. this.descricao = new SimpleStringProperty(descricao1);
  653. this.diasaulas = new SimpleStringProperty(diasaulas1);
  654. this.tiposaulas = new SimpleStringProperty(tiposaulas1);
  655. }
  656.  
  657. public Agenda() {
  658. super();
  659. }
  660.  
  661. public ObservableList<Agenda> atualizarTabela() {
  662.  
  663. return FXCollections.observableArrayList(AgendaDAO.select());
  664.  
  665. }
  666.  
  667. }``
  668.  
  669. package model.DAO;
  670.  
  671. import java.sql.Connection;
  672. import java.sql.DriverManager;
  673. import java.sql.PreparedStatement;
  674. import java.sql.ResultSet;
  675. import java.sql.SQLException;
  676. import java.sql.Statement;
  677. import java.util.LinkedList;
  678. import java.util.List;
  679.  
  680. import javax.swing.JOptionPane;
  681.  
  682. import javafx.beans.property.SimpleStringProperty;
  683. import model.Aluno;
  684. import view.TelaAgenda;
  685. import model.Agenda;
  686.  
  687. public class AgendaDAO {
  688.  
  689. private static String dbURL = "jdbc:derby://localhost:1527/personalTuxaua;create=true;user=personal;password=1234";
  690. private static String tableName = "aluno";
  691. // jdbc Connection
  692. private static Connection conn = null;
  693. private static Statement stmt = null;
  694.  
  695. public static void createConnection() {
  696. try {
  697. Class.forName("org.apache.derby.jdbc.ClientDriver").newInstance();
  698. // Get a connection
  699. conn = DriverManager.getConnection(dbURL);
  700. } catch (Exception except) {
  701. except.printStackTrace();
  702. }
  703. }
  704.  
  705. public static Agenda insert(String nome, String descricao, String valor, String diasaulas, String tiposaulas) {
  706. createConnection();
  707.  
  708. Agenda tabela = null;
  709. try {
  710.  
  711. PreparedStatement user = conn
  712. .prepareStatement("insert into aluno(nome,descricao,valor,diasaulas,tiposaulas)values(?,?,?,?,?)");
  713. user.setString(1, nome);
  714. user.setString(2, descricao);
  715. user.setString(3, valor);
  716. user.setString(4, diasaulas);
  717. user.setString(5, tiposaulas);
  718. user.executeUpdate();
  719.  
  720. JOptionPane.showMessageDialog(null, "Seu cadastro foi concluido com sucesso");
  721.  
  722. } catch (SQLException sqlExcept) {
  723. sqlExcept.printStackTrace();
  724. }
  725.  
  726. // shutdown(); Desliga conex�o com o banco
  727. // tabela = new Agenda(nome, descricao, valor, diasaulas, tiposaulas);
  728. return tabela;
  729.  
  730. }
  731.  
  732. public static List<Agenda> select() {
  733.  
  734. createConnection();
  735. List<Agenda> agendas = new LinkedList<Agenda>();
  736.  
  737. try {
  738.  
  739. String sql = "select * from agenda";
  740. PreparedStatement stmt = conn.prepareStatement(sql);
  741. // stmt = conn.createStatement();
  742. // stmt.setString(1, nome+"%%");
  743.  
  744. ResultSet results = stmt.executeQuery();
  745.  
  746. while (results.next()) {
  747. Agenda agenda = new Agenda();
  748. agenda.setMatricula(results.getInt(1));
  749. agenda.setNome(results.getString(2));
  750. agenda.setDescricao(results.getString(3));
  751. agenda.setValor(results.getString(4));
  752. agenda.setDiasaulas(results.getString(5));
  753. agenda.setTiposaulas(results.getString(6));
  754.  
  755. agendas.add(agenda);
  756.  
  757. }
  758. results.close();
  759. stmt.close();
  760. } catch (SQLException sqlExcept) {
  761. sqlExcept.printStackTrace();
  762. System.out.println(sqlExcept.getMessage());
  763. }
  764. System.out.println(agendas);
  765.  
  766. return agendas;
  767. }
  768.  
  769. public static void shutdown() {
  770. try {
  771. if (stmt != null) {
  772. stmt.close();
  773. }
  774. if (conn != null) {
  775. DriverManager.getConnection(dbURL + ";shutdown=true");
  776. conn.close();
  777. }
  778. } catch (SQLException sqlExcept) {
  779.  
  780. }
  781.  
  782. }
  783.  
  784. }
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!