API tools faq
paste
Guest User

Untitled

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