API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 7th, 2017
124
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.13 KB | None | 0 0
raw download clone embed print report
  1. package GUIAdm;
  2.  
  3. import java.sql.Connection;
  4. import java.sql.DriverManager;
  5. import java.sql.ResultSet;
  6. import java.sql.Statement;
  7.  
  8. import javafx.geometry.Insets;
  9. import javafx.scene.control.Button;
  10. import javafx.scene.control.Label;
  11. import javafx.scene.control.TextField;
  12. import javafx.scene.layout.GridPane;
  13. import javafx.scene.text.Font;
  14.  
  15. public class HoldPane extends GridPane {
  16.  
  17. private Button btnOpdaterHold, btnOpretHold, btnHentHold;
  18.  
  19. private final Label lblTextOpret, lblIdOpret, lblNavnOpret, lblDagOpret, lblUgeOpret;
  20. private final Label lblStartTidOpret, lblStatusOpret, lblVaringhedOpret, lblMaxAntalOpret, lblSalNrOpret,
  21. lblInsOpret;
  22.  
  23. private final Label lblTextOpdater, lblIdOpdater, lblNavnOpdater, lblDagOpdater, lblUgeOpdater;
  24. private final Label lblStartTidOpdater, lblStatusOpdater, lblVaringhedOpdater, lblMaxAntalOpdater, lblSalNrOpdater,
  25. lblInsOpdater;
  26.  
  27. private TextField txfIdOpret, txfNavnOpret, txfDagOpret, txfUgeOpret;
  28. private final TextField txfStartTidOpret, txfStatusOpret, txfVaringhedOpret, txfMaxAntalOpret, txfSalNrOpret,
  29. txfInsOpret;
  30.  
  31. private TextField txfIdOpdater, txfNavnOpdater, txfDagOpdater, txfUgeOpdater;
  32. private final TextField txfStartTidOpdater, txfStatusOpdater, txfVaringhedOpdater, txfMaxAntalOpdater,
  33. txfSalNrOpdater, txfInsOpdater;
  34.  
  35. public HoldPane() {
  36.  
  37. setPadding(new Insets(20));
  38. setHgap(20);
  39. setVgap(10);
  40. setGridLinesVisible(false);
  41.  
  42. lblTextOpret = new Label("Opret nyt hold - indtast data");
  43. lblTextOpret.setFont(Font.font("Verdana", 14));
  44. this.add(lblTextOpret, 0, 0, 2, 1);
  45.  
  46. lblIdOpret = new Label("Id:");
  47. this.add(lblIdOpret, 0, 1);
  48.  
  49. lblNavnOpret = new Label("Navn:");
  50. lblNavnOpret.setPrefWidth(100);
  51. this.add(lblNavnOpret, 0, 2);
  52.  
  53. lblDagOpret = new Label("Dag:");
  54. this.add(lblDagOpret, 0, 3);
  55.  
  56. lblUgeOpret = new Label("Uge:");
  57. this.add(lblUgeOpret, 0, 4);
  58.  
  59. lblStartTidOpret = new Label("StartTid:");
  60. this.add(lblStartTidOpret, 0, 5);
  61.  
  62. lblStatusOpret = new Label("Status:");
  63. this.add(lblStatusOpret, 0, 6);
  64.  
  65. lblVaringhedOpret = new Label("Varinhed:");
  66. this.add(lblVaringhedOpret, 0, 7);
  67.  
  68. lblMaxAntalOpret = new Label("Max Antal:");
  69. this.add(lblMaxAntalOpret, 0, 8);
  70.  
  71. lblSalNrOpret = new Label("Sal Nr:");
  72. this.add(lblSalNrOpret, 0, 9);
  73.  
  74. lblInsOpret = new Label("Instruktør:");
  75. this.add(lblInsOpret, 0, 10);
  76.  
  77. btnOpretHold = new Button("Opret");
  78. this.add(btnOpretHold, 0, 11);
  79. btnOpretHold.setOnAction(event -> OpretHold());
  80.  
  81. txfIdOpret = new TextField();
  82. txfIdOpret.setPrefWidth(150);
  83. txfIdOpret.setEditable(true);
  84. this.add(txfIdOpret, 1, 1);
  85.  
  86. txfNavnOpret = new TextField();
  87. txfNavnOpret.setPrefWidth(150);
  88. txfNavnOpret.setEditable(true);
  89. this.add(txfNavnOpret, 1, 2);
  90.  
  91. txfDagOpret = new TextField();
  92. txfDagOpret.setPrefWidth(150);
  93. txfDagOpret.setEditable(true);
  94. this.add(txfDagOpret, 1, 3);
  95.  
  96. txfUgeOpret = new TextField();
  97. txfUgeOpret.setPrefWidth(150);
  98. txfUgeOpret.setEditable(true);
  99. this.add(txfUgeOpret, 1, 4);
  100.  
  101. txfStartTidOpret = new TextField();
  102. txfStartTidOpret.setPrefWidth(150);
  103. txfStartTidOpret.setEditable(true);
  104. this.add(txfStartTidOpret, 1, 5);
  105.  
  106. txfStatusOpret = new TextField();
  107. txfStatusOpret.setPrefWidth(150);
  108. txfStatusOpret.setEditable(true);
  109. this.add(txfStatusOpret, 1, 6);
  110.  
  111. txfVaringhedOpret = new TextField();
  112. txfVaringhedOpret.setPrefWidth(150);
  113. txfVaringhedOpret.setEditable(true);
  114. this.add(txfVaringhedOpret, 1, 7);
  115.  
  116. txfMaxAntalOpret = new TextField();
  117. txfMaxAntalOpret.setPrefWidth(150);
  118. txfMaxAntalOpret.setEditable(true);
  119. this.add(txfMaxAntalOpret, 1, 8);
  120.  
  121. txfSalNrOpret = new TextField();
  122. txfSalNrOpret.setPrefWidth(150);
  123. txfSalNrOpret.setEditable(true);
  124. this.add(txfSalNrOpret, 1, 9);
  125.  
  126. txfInsOpret = new TextField();
  127. txfInsOpret.setPrefWidth(150);
  128. txfInsOpret.setEditable(true);
  129. this.add(txfInsOpret, 1, 10);
  130.  
  131. lblTextOpdater = new Label("Opdater Hold - indtast id og tryk hent");
  132. lblTextOpdater.setFont(Font.font("Verdana", 14));
  133. this.add(lblTextOpdater, 3, 0, 2, 1);
  134.  
  135. lblIdOpdater = new Label("Id:");
  136. this.add(lblIdOpdater, 3, 1);
  137.  
  138. lblNavnOpdater = new Label("Navn:");
  139. lblNavnOpdater.setPrefWidth(100);
  140. this.add(lblNavnOpdater, 3, 2);
  141.  
  142. lblDagOpdater = new Label("Dag:");
  143. this.add(lblDagOpdater, 3, 3);
  144.  
  145. lblUgeOpdater = new Label("Uge:");
  146. this.add(lblUgeOpdater, 3, 4);
  147.  
  148. lblStartTidOpdater = new Label("StartTid:");
  149. this.add(lblStartTidOpdater, 3, 5);
  150.  
  151. lblStatusOpdater = new Label("Status:");
  152. this.add(lblStatusOpdater, 3, 6);
  153.  
  154. lblVaringhedOpdater = new Label("Varighed:");
  155. this.add(lblVaringhedOpdater, 3, 7);
  156.  
  157. lblMaxAntalOpdater = new Label("Max Antal:");
  158. this.add(lblMaxAntalOpdater, 3, 8);
  159.  
  160. lblSalNrOpdater = new Label("Sal Nr:");
  161. this.add(lblSalNrOpdater, 3, 9);
  162.  
  163. lblInsOpdater = new Label("Instruktør:");
  164. this.add(lblInsOpdater, 3, 10);
  165.  
  166. // Knap
  167. btnHentHold = new Button("Hent");
  168. this.add(btnHentHold, 3, 11);
  169. btnHentHold.setOnAction(event -> hentHold());
  170.  
  171. btnOpdaterHold = new Button("Opdater");
  172. this.add(btnOpdaterHold, 3, 12);
  173. btnOpdaterHold.setOnAction(event -> OpdaterHold());
  174.  
  175. txfIdOpdater = new TextField();
  176. txfIdOpdater.setPrefWidth(150);
  177. txfIdOpdater.setEditable(true);
  178. this.add(txfIdOpdater, 4, 1);
  179.  
  180. txfNavnOpdater = new TextField();
  181. txfNavnOpdater.setPrefWidth(150);
  182. txfNavnOpdater.setEditable(true);
  183. this.add(txfNavnOpdater, 4, 2);
  184.  
  185. txfDagOpdater = new TextField();
  186. txfDagOpdater.setPrefWidth(150);
  187. txfDagOpdater.setEditable(true);
  188. this.add(txfDagOpdater, 4, 3);
  189.  
  190. txfUgeOpdater = new TextField();
  191. txfUgeOpdater.setPrefWidth(150);
  192. txfUgeOpdater.setEditable(true);
  193. this.add(txfUgeOpdater, 4, 4);
  194.  
  195. txfStartTidOpdater = new TextField();
  196. txfStartTidOpdater.setPrefWidth(150);
  197. txfStartTidOpdater.setEditable(true);
  198. this.add(txfStartTidOpdater, 4, 5);
  199.  
  200. txfStatusOpdater = new TextField();
  201. txfStatusOpdater.setPrefWidth(150);
  202. txfStatusOpdater.setEditable(true);
  203. this.add(txfStatusOpdater, 4, 6);
  204.  
  205. txfVaringhedOpdater = new TextField();
  206. txfVaringhedOpdater.setPrefWidth(150);
  207. txfVaringhedOpdater.setEditable(true);
  208. this.add(txfVaringhedOpdater, 4, 7);
  209.  
  210. txfMaxAntalOpdater = new TextField();
  211. txfMaxAntalOpdater.setPrefWidth(150);
  212. txfMaxAntalOpdater.setEditable(true);
  213. this.add(txfMaxAntalOpdater, 4, 8);
  214.  
  215. txfSalNrOpdater = new TextField();
  216. txfSalNrOpdater.setPrefWidth(150);
  217. txfSalNrOpdater.setEditable(true);
  218. this.add(txfSalNrOpdater, 4, 9);
  219.  
  220. txfInsOpdater = new TextField();
  221. txfInsOpdater.setPrefWidth(150);
  222. txfInsOpdater.setEditable(true);
  223. this.add(txfInsOpdater, 4, 10);
  224.  
  225. }
  226.  
  227. public void updateControls() {
  228.  
  229. }
  230.  
  231. public void OpretHold() {
  232. try {
  233. Connection minConnection;
  234. minConnection = DriverManager.getConnection(
  235. "jdbc:sqlserver://NIELS\\SQLEXPRESS;databaseName=YodaFitness;user=sa;password=rejser;");
  236.  
  237. Statement stmt = minConnection.createStatement();
  238.  
  239. int id = Integer.parseInt(txfIdOpret.getText().trim());
  240. String navn = txfNavnOpret.getText();
  241. String dag = txfDagOpret.getText();
  242. String uge = txfUgeOpret.getText();
  243. String start = txfStartTidOpret.getText();
  244. String status = txfStatusOpret.getText();
  245. String varighed = txfVaringhedOpret.getText();
  246. String maxAntal = txfMaxAntalOpret.getText();
  247. String sal = txfSalNrOpret.getText();
  248. String instruktør = txfInsOpret.getText();
  249.  
  250. String sql = "exec opretHold" + " " + id + ", '" + navn + "', " + "'" + dag + "', '" + uge + "', '" + start
  251. + "', '" + status + "', " + varighed + ", '" + maxAntal + "', '" + sal + "', '" + instruktør + "'";
  252.  
  253. stmt.execute(sql);
  254.  
  255. if (stmt != null) {
  256. stmt.close();
  257. }
  258. if (minConnection != null) {
  259. minConnection.close();
  260. }
  261.  
  262. } catch (Exception e) {
  263. System.out.println("fejl: " + e.getMessage());
  264. }
  265. }
  266.  
  267. public void OpdaterHold() {
  268. try {
  269. Connection minConnection;
  270. minConnection = DriverManager.getConnection(
  271. "jdbc:sqlserver://NIELS\\SQLEXPRESS;databaseName=YodaFitness;user=sa;password=rejser;");
  272.  
  273. Statement stmt = minConnection.createStatement();
  274.  
  275. int id = Integer.parseInt(txfIdOpdater.getText());
  276. String navn = txfNavnOpdater.getText();
  277. String dag = txfDagOpdater.getText();
  278. String uge = txfUgeOpdater.getText();
  279. String start = txfStartTidOpdater.getText();
  280. String status = txfStatusOpdater.getText();
  281. String varighed = txfVaringhedOpdater.getText();
  282. String maxAntal = txfMaxAntalOpdater.getText();
  283. String sal = txfSalNrOpdater.getText();
  284. String insID = txfInsOpdater.getText();
  285.  
  286. String sql = "exec updateHold" + " " + id + ", '" + navn + "', " + "'" + dag + "', '" + uge + "', '" + start
  287. + "', '" + status + "', " + varighed + ", '" + maxAntal + "', '" + sal + "', '" + insID + "'";
  288.  
  289. stmt.executeUpdate(sql);
  290.  
  291. if (stmt != null) {
  292. stmt.close();
  293. }
  294. if (minConnection != null) {
  295. minConnection.close();
  296. }
  297.  
  298. } catch (Exception e) {
  299. System.out.println("fejl: " + e.getMessage());
  300. }
  301. }
  302.  
  303. public void hentHold() {
  304. try {
  305. Connection minConnection;
  306. minConnection = DriverManager.getConnection(
  307. "jdbc:sqlserver://NIELS\\SQLEXPRESS;databaseName=YodaFitness;user=sa;password=rejser;");
  308.  
  309. Statement stmt = minConnection.createStatement();
  310.  
  311. int id = Integer.parseInt(txfIdOpdater.getText().trim());
  312.  
  313. ResultSet res = stmt.executeQuery("exec hentHold " + id);
  314. while (res.next()) {
  315.  
  316. txfNavnOpdater.setText(res.getString(2));
  317. txfDagOpdater.setText(res.getString(3));
  318. txfUgeOpdater.setText(res.getString(4));
  319. txfStartTidOpdater.setText(res.getString(5));
  320. txfStatusOpdater.setText(res.getString(6));
  321. txfVaringhedOpdater.setText(res.getString(7));
  322. txfMaxAntalOpdater.setText(res.getString(8));
  323. txfSalNrOpdater.setText(res.getString(9));
  324. txfInsOpdater.setText(res.getString(10));
  325.  
  326. }
  327.  
  328. if (res != null) {
  329. res.close();
  330. }
  331. if (stmt != null) {
  332. stmt.close();
  333. }
  334. if (minConnection != null) {
  335. minConnection.close();
  336. }
  337.  
  338. } catch (Exception e) {
  339. System.out.println("fejl: " + e.getMessage());
  340. }
  341.  
  342. }
  343.  
  344. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!