API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 23rd, 2016
101
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 41.24 KB | None | 0 0
raw download clone embed print report
  1.  
  2. import java.awt.Color;
  3. import java.sql.Connection;
  4. import java.sql.DriverManager;
  5. import java.sql.PreparedStatement;
  6. import java.sql.ResultSet;
  7. import java.sql.SQLException;
  8. import javax.swing.JScrollPane;
  9. /*
  10. * To change this license header, choose License Headers in Project Properties.
  11. * To change this template file, choose Tools | Templates
  12. * and open the template in the editor.
  13. */
  14.  
  15. /**
  16. *
  17. * @author MartynasDarboPC
  18. */
  19. public class MM42Mf extends javax.swing.JFrame {
  20.  
  21.  
  22.  
  23. /**
  24. * Creates new form MM42nf
  25. */
  26. public MM42Mf() {
  27. initComponents();
  28. }
  29.  
  30. private Connection prisijungimas;
  31.  
  32. /**
  33. * This method is called from within the constructor to initialize the form.
  34. * WARNING: Do NOT modify this code. The content of this method is always
  35. * regenerated by the Form Editor.
  36. */
  37. // <editor-fold defaultstate="collapsed" desc="Generated Code">
  38. private void initComponents() {
  39.  
  40. jScrollPane1 = new javax.swing.JScrollPane();
  41. javax.swing.JTextArea jTextArea1 = new javax.swing.JTextArea();
  42. jLabel1 = new javax.swing.JLabel();
  43. jTextField2 = new javax.swing.JTextField();
  44. jButton12 = new javax.swing.JButton();
  45. jButton13 = new javax.swing.JButton();
  46. jButton14 = new javax.swing.JButton();
  47. jButton15 = new javax.swing.JButton();
  48. jButton16 = new javax.swing.JButton();
  49. jTextField4 = new javax.swing.JTextField();
  50. jTabbedPane1 = new javax.swing.JTabbedPane();
  51. jLayeredPane1 = new javax.swing.JLayeredPane();
  52. jTextField5 = new javax.swing.JTextField();
  53. jLabel2 = new javax.swing.JLabel();
  54. jTextField6 = new javax.swing.JTextField();
  55. jLabel3 = new javax.swing.JLabel();
  56. jButton1 = new javax.swing.JButton();
  57. jLayeredPane2 = new javax.swing.JLayeredPane();
  58. jTextField7 = new javax.swing.JTextField();
  59. jLabel4 = new javax.swing.JLabel();
  60. jLabel5 = new javax.swing.JLabel();
  61. jTextField8 = new javax.swing.JTextField();
  62. jButton2 = new javax.swing.JButton();
  63. jLayeredPane3 = new javax.swing.JLayeredPane();
  64. jTextField9 = new javax.swing.JTextField();
  65. jLabel6 = new javax.swing.JLabel();
  66. jLabel7 = new javax.swing.JLabel();
  67. jTextField10 = new javax.swing.JTextField();
  68. jButton3 = new javax.swing.JButton();
  69. jLayeredPane4 = new javax.swing.JLayeredPane();
  70. jLabel8 = new javax.swing.JLabel();
  71. jTextField11 = new javax.swing.JTextField();
  72. jButton4 = new javax.swing.JButton();
  73. jLayeredPane5 = new javax.swing.JLayeredPane();
  74. jLabel9 = new javax.swing.JLabel();
  75. jTextField12 = new javax.swing.JTextField();
  76. jButton5 = new javax.swing.JButton();
  77. jButton17 = new javax.swing.JButton();
  78. jButton6 = new javax.swing.JButton();
  79. jPasswordField1 = new javax.swing.JPasswordField();
  80. jLabel10 = new javax.swing.JLabel();
  81.  
  82. setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  83.  
  84. jTextArea1.setColumns(20);
  85. jTextArea1.setRows(5);
  86. jScrollPane1.setViewportView(jTextArea1);
  87.  
  88. jLabel1.setText("Prisijungimas");
  89.  
  90. jTextField2.setText("jTextField2");
  91. jTextField2.addActionListener(new java.awt.event.ActionListener() {
  92. public void actionPerformed(java.awt.event.ActionEvent evt) {
  93. jTextField2ActionPerformed(evt);
  94. }
  95. });
  96.  
  97. jButton12.setText("Prisijungti");
  98. jButton12.addActionListener(new java.awt.event.ActionListener() {
  99. public void actionPerformed(java.awt.event.ActionEvent evt) {
  100. jButton12ActionPerformed(evt);
  101. }
  102. });
  103.  
  104. jButton13.setText("Rodyti klientus");
  105. jButton13.addActionListener(new java.awt.event.ActionListener() {
  106. public void actionPerformed(java.awt.event.ActionEvent evt) {
  107. jButton13ActionPerformed(evt);
  108. }
  109. });
  110.  
  111. jButton14.setText("Rodyti visus trenerius");
  112. jButton14.addActionListener(new java.awt.event.ActionListener() {
  113. public void actionPerformed(java.awt.event.ActionEvent evt) {
  114. jButton14ActionPerformed(evt);
  115. }
  116. });
  117.  
  118. jButton15.setText("Rasti nemokius klientus");
  119. jButton15.addActionListener(new java.awt.event.ActionListener() {
  120. public void actionPerformed(java.awt.event.ActionEvent evt) {
  121. jButton15ActionPerformed(evt);
  122. }
  123. });
  124.  
  125. jButton16.setText("Rasti klienta");
  126. jButton16.addActionListener(new java.awt.event.ActionListener() {
  127. public void actionPerformed(java.awt.event.ActionEvent evt) {
  128. jButton16ActionPerformed(evt);
  129. }
  130. });
  131.  
  132. jTextField4.setText("jTextField4");
  133.  
  134. jTextField5.setText("jTextField5");
  135.  
  136. jLabel2.setText("Vardas ir pavarde");
  137.  
  138. jTextField6.setText("jTextField6");
  139. jTextField6.addActionListener(new java.awt.event.ActionListener() {
  140. public void actionPerformed(java.awt.event.ActionEvent evt) {
  141. jTextField6ActionPerformed(evt);
  142. }
  143. });
  144.  
  145. jLabel3.setText("Sporto saka");
  146.  
  147. jButton1.setText("Prideti");
  148. jButton1.addActionListener(new java.awt.event.ActionListener() {
  149. public void actionPerformed(java.awt.event.ActionEvent evt) {
  150. jButton1ActionPerformed(evt);
  151. }
  152. });
  153.  
  154. javax.swing.GroupLayout jLayeredPane1Layout = new javax.swing.GroupLayout(jLayeredPane1);
  155. jLayeredPane1.setLayout(jLayeredPane1Layout);
  156. jLayeredPane1Layout.setHorizontalGroup(
  157. jLayeredPane1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  158. .addGroup(jLayeredPane1Layout.createSequentialGroup()
  159. .addContainerGap()
  160. .addGroup(jLayeredPane1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  161. .addComponent(jTextField5, javax.swing.GroupLayout.PREFERRED_SIZE, 131, javax.swing.GroupLayout.PREFERRED_SIZE)
  162. .addComponent(jLabel2))
  163. .addGap(18, 18, 18)
  164. .addGroup(jLayeredPane1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  165. .addComponent(jLabel3)
  166. .addGroup(jLayeredPane1Layout.createSequentialGroup()
  167. .addComponent(jTextField6, javax.swing.GroupLayout.PREFERRED_SIZE, 112, javax.swing.GroupLayout.PREFERRED_SIZE)
  168. .addGap(18, 18, 18)
  169. .addComponent(jButton1)))
  170. .addContainerGap(204, Short.MAX_VALUE))
  171. );
  172. jLayeredPane1Layout.setVerticalGroup(
  173. jLayeredPane1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  174. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jLayeredPane1Layout.createSequentialGroup()
  175. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  176. .addGroup(jLayeredPane1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  177. .addComponent(jLabel2)
  178. .addComponent(jLabel3))
  179. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  180. .addGroup(jLayeredPane1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  181. .addComponent(jTextField5, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  182. .addComponent(jTextField6, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  183. .addComponent(jButton1))
  184. .addGap(68, 68, 68))
  185. );
  186. jLayeredPane1.setLayer(jTextField5, javax.swing.JLayeredPane.DEFAULT_LAYER);
  187. jLayeredPane1.setLayer(jLabel2, javax.swing.JLayeredPane.DEFAULT_LAYER);
  188. jLayeredPane1.setLayer(jTextField6, javax.swing.JLayeredPane.DEFAULT_LAYER);
  189. jLayeredPane1.setLayer(jLabel3, javax.swing.JLayeredPane.DEFAULT_LAYER);
  190. jLayeredPane1.setLayer(jButton1, javax.swing.JLayeredPane.DEFAULT_LAYER);
  191.  
  192. jTabbedPane1.addTab("Naujas klientas", jLayeredPane1);
  193.  
  194. jTextField7.setText("jTextField7");
  195.  
  196. jLabel4.setText("Vardas ir pavarde");
  197.  
  198. jLabel5.setText("Sporto saka");
  199.  
  200. jTextField8.setText("jTextField8");
  201.  
  202. jButton2.setText("Prideti");
  203. jButton2.addActionListener(new java.awt.event.ActionListener() {
  204. public void actionPerformed(java.awt.event.ActionEvent evt) {
  205. jButton2ActionPerformed(evt);
  206. }
  207. });
  208.  
  209. javax.swing.GroupLayout jLayeredPane2Layout = new javax.swing.GroupLayout(jLayeredPane2);
  210. jLayeredPane2.setLayout(jLayeredPane2Layout);
  211. jLayeredPane2Layout.setHorizontalGroup(
  212. jLayeredPane2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  213. .addGroup(jLayeredPane2Layout.createSequentialGroup()
  214. .addContainerGap()
  215. .addGroup(jLayeredPane2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  216. .addComponent(jLabel4)
  217. .addComponent(jTextField7, javax.swing.GroupLayout.PREFERRED_SIZE, 114, javax.swing.GroupLayout.PREFERRED_SIZE))
  218. .addGap(33, 33, 33)
  219. .addGroup(jLayeredPane2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  220. .addComponent(jTextField8, javax.swing.GroupLayout.PREFERRED_SIZE, 83, javax.swing.GroupLayout.PREFERRED_SIZE)
  221. .addComponent(jLabel5))
  222. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 34, Short.MAX_VALUE)
  223. .addComponent(jButton2)
  224. .addGap(219, 219, 219))
  225. );
  226. jLayeredPane2Layout.setVerticalGroup(
  227. jLayeredPane2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  228. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jLayeredPane2Layout.createSequentialGroup()
  229. .addContainerGap(13, Short.MAX_VALUE)
  230. .addGroup(jLayeredPane2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  231. .addComponent(jLabel4)
  232. .addComponent(jLabel5))
  233. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  234. .addGroup(jLayeredPane2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  235. .addComponent(jTextField7, javax.swing.GroupLayout.PREFERRED_SIZE, 20, javax.swing.GroupLayout.PREFERRED_SIZE)
  236. .addComponent(jTextField8, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  237. .addComponent(jButton2))
  238. .addContainerGap())
  239. );
  240. jLayeredPane2.setLayer(jTextField7, javax.swing.JLayeredPane.DEFAULT_LAYER);
  241. jLayeredPane2.setLayer(jLabel4, javax.swing.JLayeredPane.DEFAULT_LAYER);
  242. jLayeredPane2.setLayer(jLabel5, javax.swing.JLayeredPane.DEFAULT_LAYER);
  243. jLayeredPane2.setLayer(jTextField8, javax.swing.JLayeredPane.DEFAULT_LAYER);
  244. jLayeredPane2.setLayer(jButton2, javax.swing.JLayeredPane.DEFAULT_LAYER);
  245.  
  246. jTabbedPane1.addTab("Naujas treneris", jLayeredPane2);
  247.  
  248. jTextField9.setText("jTextField9");
  249. jTextField9.addActionListener(new java.awt.event.ActionListener() {
  250. public void actionPerformed(java.awt.event.ActionEvent evt) {
  251. jTextField9ActionPerformed(evt);
  252. }
  253. });
  254.  
  255. jLabel6.setText("Vardas ir pavarde");
  256.  
  257. jLabel7.setText("Pakeisti sporto sakos spec.");
  258.  
  259. jTextField10.setText("jTextField10");
  260.  
  261. jButton3.setText("Pakeisti");
  262. jButton3.addActionListener(new java.awt.event.ActionListener() {
  263. public void actionPerformed(java.awt.event.ActionEvent evt) {
  264. jButton3ActionPerformed(evt);
  265. }
  266. });
  267.  
  268. javax.swing.GroupLayout jLayeredPane3Layout = new javax.swing.GroupLayout(jLayeredPane3);
  269. jLayeredPane3.setLayout(jLayeredPane3Layout);
  270. jLayeredPane3Layout.setHorizontalGroup(
  271. jLayeredPane3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  272. .addGroup(jLayeredPane3Layout.createSequentialGroup()
  273. .addContainerGap()
  274. .addGroup(jLayeredPane3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
  275. .addComponent(jTextField9)
  276. .addComponent(jLabel6, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  277. .addGap(30, 30, 30)
  278. .addGroup(jLayeredPane3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
  279. .addComponent(jLabel7, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  280. .addComponent(jTextField10))
  281. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 190, Short.MAX_VALUE)
  282. .addComponent(jButton3)
  283. .addGap(43, 43, 43))
  284. );
  285. jLayeredPane3Layout.setVerticalGroup(
  286. jLayeredPane3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  287. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jLayeredPane3Layout.createSequentialGroup()
  288. .addContainerGap()
  289. .addGroup(jLayeredPane3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  290. .addComponent(jLabel6)
  291. .addComponent(jLabel7))
  292. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  293. .addGroup(jLayeredPane3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  294. .addComponent(jTextField9, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  295. .addComponent(jTextField10, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  296. .addComponent(jButton3))
  297. .addContainerGap(13, Short.MAX_VALUE))
  298. );
  299. jLayeredPane3.setLayer(jTextField9, javax.swing.JLayeredPane.DEFAULT_LAYER);
  300. jLayeredPane3.setLayer(jLabel6, javax.swing.JLayeredPane.DEFAULT_LAYER);
  301. jLayeredPane3.setLayer(jLabel7, javax.swing.JLayeredPane.DEFAULT_LAYER);
  302. jLayeredPane3.setLayer(jTextField10, javax.swing.JLayeredPane.DEFAULT_LAYER);
  303. jLayeredPane3.setLayer(jButton3, javax.swing.JLayeredPane.DEFAULT_LAYER);
  304.  
  305. jTabbedPane1.addTab("Treneriams", jLayeredPane3);
  306.  
  307. jLabel8.setText("Vardas pavarde");
  308.  
  309. jTextField11.setText("jTextField11");
  310.  
  311. jButton4.setText("Neaptarnauti");
  312. jButton4.addActionListener(new java.awt.event.ActionListener() {
  313. public void actionPerformed(java.awt.event.ActionEvent evt) {
  314. jButton4ActionPerformed(evt);
  315. }
  316. });
  317.  
  318. javax.swing.GroupLayout jLayeredPane4Layout = new javax.swing.GroupLayout(jLayeredPane4);
  319. jLayeredPane4.setLayout(jLayeredPane4Layout);
  320. jLayeredPane4Layout.setHorizontalGroup(
  321. jLayeredPane4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  322. .addGroup(jLayeredPane4Layout.createSequentialGroup()
  323. .addContainerGap()
  324. .addGroup(jLayeredPane4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  325. .addGroup(jLayeredPane4Layout.createSequentialGroup()
  326. .addComponent(jLabel8)
  327. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  328. .addGroup(jLayeredPane4Layout.createSequentialGroup()
  329. .addComponent(jTextField11, javax.swing.GroupLayout.PREFERRED_SIZE, 129, javax.swing.GroupLayout.PREFERRED_SIZE)
  330. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 282, Short.MAX_VALUE)
  331. .addComponent(jButton4)
  332. .addGap(40, 40, 40))))
  333. );
  334. jLayeredPane4Layout.setVerticalGroup(
  335. jLayeredPane4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  336. .addGroup(jLayeredPane4Layout.createSequentialGroup()
  337. .addContainerGap()
  338. .addComponent(jLabel8)
  339. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 13, Short.MAX_VALUE)
  340. .addGroup(jLayeredPane4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  341. .addComponent(jTextField11, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  342. .addComponent(jButton4))
  343. .addContainerGap())
  344. );
  345. jLayeredPane4.setLayer(jLabel8, javax.swing.JLayeredPane.DEFAULT_LAYER);
  346. jLayeredPane4.setLayer(jTextField11, javax.swing.JLayeredPane.DEFAULT_LAYER);
  347. jLayeredPane4.setLayer(jButton4, javax.swing.JLayeredPane.DEFAULT_LAYER);
  348.  
  349. jTabbedPane1.addTab("Istrinti klienta", jLayeredPane4);
  350.  
  351. jLabel9.setText("Vardas ir pavarde");
  352.  
  353. jTextField12.setText("jTextField12");
  354.  
  355. jButton5.setText("Atleisti");
  356. jButton5.addActionListener(new java.awt.event.ActionListener() {
  357. public void actionPerformed(java.awt.event.ActionEvent evt) {
  358. jButton5ActionPerformed(evt);
  359. }
  360. });
  361.  
  362. javax.swing.GroupLayout jLayeredPane5Layout = new javax.swing.GroupLayout(jLayeredPane5);
  363. jLayeredPane5.setLayout(jLayeredPane5Layout);
  364. jLayeredPane5Layout.setHorizontalGroup(
  365. jLayeredPane5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  366. .addGroup(jLayeredPane5Layout.createSequentialGroup()
  367. .addContainerGap()
  368. .addGroup(jLayeredPane5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  369. .addComponent(jLabel9)
  370. .addGroup(jLayeredPane5Layout.createSequentialGroup()
  371. .addComponent(jTextField12, javax.swing.GroupLayout.PREFERRED_SIZE, 169, javax.swing.GroupLayout.PREFERRED_SIZE)
  372. .addGap(117, 117, 117)
  373. .addComponent(jButton5)))
  374. .addContainerGap(195, Short.MAX_VALUE))
  375. );
  376. jLayeredPane5Layout.setVerticalGroup(
  377. jLayeredPane5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  378. .addGroup(jLayeredPane5Layout.createSequentialGroup()
  379. .addContainerGap()
  380. .addGroup(jLayeredPane5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
  381. .addComponent(jButton5)
  382. .addGroup(jLayeredPane5Layout.createSequentialGroup()
  383. .addComponent(jLabel9)
  384. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  385. .addComponent(jTextField12, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
  386. .addContainerGap(16, Short.MAX_VALUE))
  387. );
  388. jLayeredPane5.setLayer(jLabel9, javax.swing.JLayeredPane.DEFAULT_LAYER);
  389. jLayeredPane5.setLayer(jTextField12, javax.swing.JLayeredPane.DEFAULT_LAYER);
  390. jLayeredPane5.setLayer(jButton5, javax.swing.JLayeredPane.DEFAULT_LAYER);
  391.  
  392. jTabbedPane1.addTab("Istrinti treneri", jLayeredPane5);
  393.  
  394. jButton17.setText("Atsijungti");
  395. jButton17.addActionListener(new java.awt.event.ActionListener() {
  396. public void actionPerformed(java.awt.event.ActionEvent evt) {
  397. jButton17ActionPerformed(evt);
  398. }
  399. });
  400.  
  401. jButton6.setText("Atnaujinti lentele");
  402. jButton6.addActionListener(new java.awt.event.ActionListener() {
  403. public void actionPerformed(java.awt.event.ActionEvent evt) {
  404. jButton6ActionPerformed(evt);
  405. }
  406. });
  407.  
  408. jPasswordField1.setText("jPasswordField1");
  409. jPasswordField1.addActionListener(new java.awt.event.ActionListener() {
  410. public void actionPerformed(java.awt.event.ActionEvent evt) {
  411. jPasswordField1ActionPerformed(evt);
  412. }
  413. });
  414.  
  415. jLabel10.setText("Neprisijungta prie DB");
  416.  
  417. javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  418. getContentPane().setLayout(layout);
  419. layout.setHorizontalGroup(
  420. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  421. .addGroup(layout.createSequentialGroup()
  422. .addContainerGap()
  423. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  424. .addGroup(layout.createSequentialGroup()
  425. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  426. .addComponent(jButton13)
  427. .addComponent(jButton14)
  428. .addComponent(jButton15))
  429. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  430. .addGroup(layout.createSequentialGroup()
  431. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  432. .addComponent(jScrollPane1)
  433. .addGroup(layout.createSequentialGroup()
  434. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
  435. .addComponent(jLabel1)
  436. .addGroup(layout.createSequentialGroup()
  437. .addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, 110, javax.swing.GroupLayout.PREFERRED_SIZE)
  438. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  439. .addComponent(jButton12))
  440. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
  441. .addComponent(jPasswordField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  442. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  443. .addComponent(jButton17)))
  444. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  445. .addComponent(jTabbedPane1))
  446. .addGroup(layout.createSequentialGroup()
  447. .addComponent(jButton16)
  448. .addGap(46, 46, 46)
  449. .addComponent(jTextField4, javax.swing.GroupLayout.PREFERRED_SIZE, 95, javax.swing.GroupLayout.PREFERRED_SIZE)
  450. .addGap(0, 0, Short.MAX_VALUE)))
  451. .addContainerGap())))
  452. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
  453. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  454. .addComponent(jLabel10)
  455. .addGap(224, 224, 224)
  456. .addComponent(jButton6)
  457. .addContainerGap())
  458. );
  459. layout.setVerticalGroup(
  460. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  461. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
  462. .addContainerGap()
  463. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  464. .addGroup(layout.createSequentialGroup()
  465. .addComponent(jLabel1)
  466. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  467. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  468. .addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  469. .addComponent(jButton12))
  470. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  471. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  472. .addComponent(jButton17)
  473. .addComponent(jPasswordField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
  474. .addComponent(jTabbedPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 100, javax.swing.GroupLayout.PREFERRED_SIZE))
  475. .addGap(21, 21, 21)
  476. .addComponent(jButton13)
  477. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  478. .addComponent(jButton14)
  479. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  480. .addComponent(jButton15)
  481. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  482. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  483. .addComponent(jButton16)
  484. .addComponent(jTextField4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  485. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 11, Short.MAX_VALUE)
  486. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  487. .addComponent(jButton6)
  488. .addComponent(jLabel10))
  489. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  490. .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 200, javax.swing.GroupLayout.PREFERRED_SIZE)
  491. .addContainerGap())
  492. );
  493.  
  494. pack();
  495. }// </editor-fold>
  496.  
  497. private void jTextField2ActionPerformed(java.awt.event.ActionEvent evt) {
  498. // TODO add your handling code here:
  499. }
  500.  
  501. private void jButton12ActionPerformed(java.awt.event.ActionEvent evt) {
  502. // TODO add your handling code here:
  503. prisijungimas();
  504. }
  505.  
  506. private void jButton14ActionPerformed(java.awt.event.ActionEvent evt) {
  507. // TODO add your handling code here:
  508. treneriai();
  509. }
  510.  
  511. private void jTextField6ActionPerformed(java.awt.event.ActionEvent evt) {
  512. // TODO add your handling code here:
  513. }
  514.  
  515. private void jTextField9ActionPerformed(java.awt.event.ActionEvent evt) {
  516. // TODO add your handling code here:
  517. }
  518.  
  519. private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
  520. // TODO add your handling code here:
  521. TreneriamsUpdate();
  522. }
  523.  
  524. private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {
  525. // TODO add your handling code here:
  526. NeaptarnautiKliento();
  527. }
  528.  
  529. private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {
  530. // TODO add your handling code here:
  531. AtleistiTreneri();
  532. }
  533.  
  534. private void jButton16ActionPerformed(java.awt.event.ActionEvent evt) {
  535. // TODO add your handling code here:
  536. RastiKlienta();
  537. }
  538.  
  539. private void jButton17ActionPerformed(java.awt.event.ActionEvent evt) {
  540. // TODO add your handling code here:
  541. atsijungimas();
  542. }
  543.  
  544. private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
  545. // TODO add your handling code here:
  546. NaujasKlientas();
  547. }
  548.  
  549. private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
  550. // TODO add your handling code here:
  551. NaujasTreneris();
  552. }
  553.  
  554. private void jButton13ActionPerformed(java.awt.event.ActionEvent evt) {
  555. // TODO add your handling code here:
  556. RodytiKlientus();
  557. }
  558.  
  559. private void jButton15ActionPerformed(java.awt.event.ActionEvent evt) {
  560. // TODO add your handling code here:
  561. RodytiNemokius();
  562. }
  563.  
  564. private void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {
  565. // TODO add your handling code here:
  566. jTextArea1.setText("");
  567. }
  568.  
  569. private void jPasswordField1ActionPerformed(java.awt.event.ActionEvent evt) {
  570. // TODO add your handling code here:
  571. }
  572.  
  573.  
  574. //Prisijungimas
  575. Connection prisijungimas(){
  576. if (prisijungimas == null)
  577. {
  578. try
  579. {
  580. Class.forName("com.mysql.jdbc.Driver").newInstance();
  581. prisijungimas = DriverManager.getConnection("jdbc:mysql://127.0.0.1/duombaze2", jTextField2.getText(), String.valueOf(jPasswordField1.getPassword()));
  582. jLabel10.setText("Prisijungta prie DB");
  583. jLabel10.setForeground(Color.GREEN);
  584.  
  585. }
  586. catch (SQLException | ClassNotFoundException | InstantiationException | IllegalAccessException e)
  587. {
  588. jLabel10.setText("Įvyko klaida: " + e);
  589. jLabel10.setForeground(Color.RED);
  590. System.out.println(e);
  591. }
  592. }
  593. return prisijungimas;
  594. }
  595.  
  596. //Atsijungti
  597. void atsijungimas(){
  598. if (prisijungimas!=null){
  599. try {
  600. prisijungimas.close();
  601. prisijungimas=null;
  602. jLabel10.setText("Atsijungta Nuo DB");
  603. }catch(SQLException e){
  604. jTextArea1.append("Klaida atsijunginejant nuo DB");
  605.  
  606. }
  607. }
  608. }
  609.  
  610. //Rodyti klientus
  611.  
  612. void RodytiKlientus(){
  613.  
  614. String SQLStatement = "SELECT * FROM `Klientai`;";
  615. ResultSet result = null;
  616.  
  617. if(prisijungimas != null)
  618. {
  619. try
  620. {
  621. PreparedStatement statement = prisijungimas.prepareStatement(SQLStatement);
  622. result = statement.executeQuery();
  623.  
  624. jTextArea1.append("\n Klientai:\n \n \n");
  625. while(result.next())
  626. {
  627. String VardasPavarde = result.getString(1);
  628. String SportoSaka = result.getString(2);
  629. String Treneris = result.getString(3);
  630. String Saskaita = result.getString(4);
  631. String Suma = result.getString(5);
  632. String ArApmoketa = result.getString(6);
  633. String Data = result.getString(7);
  634.  
  635. String line = VardasPavarde + " \n Sporto saka \n " + " \n Treneris \n" + Treneris + " \n Saskaita uz paslaugas \n" + Saskaita + " \n Suma \n" + Suma + " \n Ar Apmoketa? \n" + ArApmoketa + " \n Data \n " + Data + " \n \n \n ";
  636. jTextArea1.append(line + "\n");
  637. }
  638. }
  639. catch(SQLException e)
  640. {
  641. System.out.println(e);
  642. jTextArea1.append("Nepavyko rodyti lenteles \n");
  643. }
  644. }
  645. else
  646. {
  647. jTextArea1.append("Prisijunkite prie DB \n");
  648. }
  649. }
  650.  
  651. //Treneriai
  652.  
  653. String SQLStatement = "SELECT * FROM `Treneriai`;";
  654. ResultSet result = null;
  655.  
  656. if(prisijungimas != null)
  657. {
  658. try
  659. {
  660. PreparedStatement statement = prisijungimas.prepareStatement(SQLStatement);
  661. result = statement.executeQuery();
  662.  
  663. jTextArea1.append("\n Treneriai:\n \n \n");
  664. while(result.next())
  665. {
  666. String Vardas = result.getString(1);
  667. String Uzduotis = result.getString(2);
  668. String Sanaudos = result.getString(3);
  669. String UzDarba = result.getString(4);
  670. String ArUzimtas = result.getString(5);
  671.  
  672.  
  673. String line = Vardas + " \n Automobilis \n " + Uzduotis + " \n Sanaudos \n" + Sanaudos + " \n Atlyginimas Uz Darba \n" + UzDarba + " \n Ar Uzimtas? \n" + ArUzimtas + " \n \n \n ";
  674. jTextArea1.append(line + "\n");
  675. }
  676. }
  677. catch(SQLException e)
  678. {
  679. System.out.println(e);
  680. jTextArea1.append("Nepavyko rodyti lenteles \n");
  681. }
  682. }
  683. else
  684. {
  685. jTextArea1.append("Prisijunkite prie DB \n");
  686. }
  687. }
  688.  
  689. //Rodyti nemokius
  690.  
  691. void RodytiNemokius(){
  692.  
  693. String SQLStatement = "SELECT `VardasPavarde` FROM `klientai` WHERE `ArApmoketa` = 'ne' ";
  694. ResultSet result = null;
  695.  
  696. if(prisijungimas != null)
  697. {
  698. try
  699. {
  700. PreparedStatement statement = prisijungimas.prepareStatement(SQLStatement);
  701. result = statement.executeQuery();
  702.  
  703. jTextArea1.append("\n Nemokus Klientai:\n \n");
  704. while(result.next())
  705. {
  706. String VardasPavarde = result.getString(1);
  707.  
  708.  
  709. String line = VardasPavarde;
  710. jTextArea1.append(line + "\n");
  711. }
  712. }
  713. catch(SQLException e)
  714. {
  715. System.out.println(e);
  716. jTextArea1.append("Nepavyko rodyti lenteles \n");
  717. }
  718. }
  719. else
  720. {
  721. jTextArea1.append("Prisijunkite prie DB \n");
  722. }
  723. }
  724.  
  725. //RastiKlienta
  726.  
  727. void RastiKlienta(){
  728.  
  729. String sql = jTextField2.getText();
  730. String sqlcombo = "SELECT * FROM `klientai` WHERE `VardasPavarde` = " + "'" + sql + "'";
  731.  
  732. String SQLStatement = sqlcombo;
  733. ResultSet result = null;
  734. if(prisijungimas != null)
  735. {
  736. try
  737. {
  738. PreparedStatement statement = prisijungimas.prepareStatement(SQLStatement);
  739. result = statement.executeQuery();
  740.  
  741. jTextArea1.append("\n Klientas:\n \n \n");
  742. while(result.next())
  743. {
  744. String VardasPavarde = result.getString(1);
  745. String Gedimas = result.getString(2);
  746. String Meistras = result.getString(3);
  747. String Saskaita = result.getString(4);
  748. String Suma = result.getString(5);
  749. String ArApmoketa = result.getString(6);
  750. String Data = result.getString(7);
  751.  
  752. String line = VardasPavarde + " \n Automobilis \n " + Gedimas + " \n Meistras \n" + Meistras + " \n Saskaita \n" + Saskaita + " \n Suma \n" + Suma + " \n Ar Apmoketa? \n" + ArApmoketa + " \n Data \n " + Data + " \n \n \n ";
  753. jTextArea1.append(line + "\n");
  754. }
  755. }
  756. catch(SQLException e)
  757. {
  758. System.out.println(e);
  759. jTextArea1.append("Nepavyko rodyti lenteles \n");
  760. }
  761. }
  762. else
  763. {
  764. jTextArea1.append("Prisijunkite prie DB \n");
  765. }
  766. }
  767.  
  768.  
  769.  
  770.  
  771.  
  772.  
  773.  
  774.  
  775.  
  776.  
  777.  
  778.  
  779.  
  780.  
  781.  
  782.  
  783. /**s
  784. * @param args the command line arguments
  785. */
  786. public static void main(String args[]) {
  787. /* Set the Nimbus look and feel */
  788. //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
  789. /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
  790. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
  791. */
  792. try {
  793. for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
  794. if ("Nimbus".equals(info.getName())) {
  795. javax.swing.UIManager.setLookAndFeel(info.getClassName());
  796. break;
  797. }
  798. }
  799. } catch (ClassNotFoundException ex) {
  800. java.util.logging.Logger.getLogger(MM42Mf.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  801. } catch (InstantiationException ex) {
  802. java.util.logging.Logger.getLogger(MM42Mf.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  803. } catch (IllegalAccessException ex) {
  804. java.util.logging.Logger.getLogger(MM42Mf.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  805. } catch (javax.swing.UnsupportedLookAndFeelException ex) {
  806. java.util.logging.Logger.getLogger(MM42Mf.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  807. }
  808. //</editor-fold>
  809. //</editor-fold>
  810.  
  811. /* Create and display the form */
  812. java.awt.EventQueue.invokeLater(new Runnable() {
  813. public void run() {
  814. new MM42Mf().setVisible(true);
  815. }
  816. });
  817. }
  818.  
  819. // Variables declaration - do not modify
  820. private javax.swing.JButton jButton1;
  821. private javax.swing.JButton jButton12;
  822. private javax.swing.JButton jButton13;
  823. private javax.swing.JButton jButton14;
  824. private javax.swing.JButton jButton15;
  825. private javax.swing.JButton jButton16;
  826. private javax.swing.JButton jButton17;
  827. private javax.swing.JButton jButton2;
  828. private javax.swing.JButton jButton3;
  829. private javax.swing.JButton jButton4;
  830. private javax.swing.JButton jButton5;
  831. private javax.swing.JButton jButton6;
  832. private javax.swing.JLabel jLabel1;
  833. private javax.swing.JLabel jLabel10;
  834. private javax.swing.JLabel jLabel2;
  835. private javax.swing.JLabel jLabel3;
  836. private javax.swing.JLabel jLabel4;
  837. private javax.swing.JLabel jLabel5;
  838. private javax.swing.JLabel jLabel6;
  839. private javax.swing.JLabel jLabel7;
  840. private javax.swing.JLabel jLabel8;
  841. private javax.swing.JLabel jLabel9;
  842. private javax.swing.JLayeredPane jLayeredPane1;
  843. private javax.swing.JLayeredPane jLayeredPane2;
  844. private javax.swing.JLayeredPane jLayeredPane3;
  845. private javax.swing.JLayeredPane jLayeredPane4;
  846. private javax.swing.JLayeredPane jLayeredPane5;
  847. private javax.swing.JPasswordField jPasswordField1;
  848. private javax.swing.JScrollPane jScrollPane1;
  849. private javax.swing.JTabbedPane jTabbedPane1;
  850. private javax.swing.JTextField jTextField10;
  851. private javax.swing.JTextField jTextField11;
  852. private javax.swing.JTextField jTextField12;
  853. private javax.swing.JTextField jTextField2;
  854. private javax.swing.JTextField jTextField4;
  855. private javax.swing.JTextField jTextField5;
  856. private javax.swing.JTextField jTextField6;
  857. private javax.swing.JTextField jTextField7;
  858. private javax.swing.JTextField jTextField8;
  859. private javax.swing.JTextField jTextField9;
  860. // End of variables declaration
  861. }
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!