API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 1st, 2016
75
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 41.40 KB | None | 0 0
raw download clone embed print report
  1. /*
  2. * To change this license header, choose License Headers in Project Properties.
  3. * To change this template file, choose Tools | Templates
  4. * and open the template in the editor.
  5. */
  6. package alt.kom.swing;
  7.  
  8. import alt.kom.przychodnia.Przychodnia;
  9. import static alt.kom.przychodnia.Przychodnia.password;
  10. import static alt.kom.przychodnia.Przychodnia.url;
  11. import static alt.kom.przychodnia.Przychodnia.user;
  12. import java.awt.GridLayout;
  13. import java.sql.Connection;
  14. import java.sql.DriverManager;
  15. import java.sql.ResultSet;
  16. import java.sql.SQLException;
  17. import java.sql.Statement;
  18. import javax.swing.JButton;
  19. import javax.swing.JFrame;
  20. import javax.swing.JLabel;
  21. import javax.swing.JOptionPane;
  22. import javax.swing.JTextField;
  23. import javax.swing.table.DefaultTableModel;
  24. import java.sql.PreparedStatement;
  25.  
  26. import alt.kom.swing.Przychodnia2JFrame;
  27. import static java.lang.Thread.sleep;
  28. import java.util.logging.Level;
  29. import java.util.logging.Logger;
  30.  
  31. import alt.kom.swing.MenuJFrame;
  32. import java.awt.Desktop;
  33. import java.awt.event.ActionEvent;
  34. import java.awt.event.ActionListener;
  35. import java.io.File;
  36. import java.io.FileInputStream;
  37. import java.io.FileNotFoundException;
  38. import java.io.FileOutputStream;
  39. import java.io.IOException;
  40. import java.io.InputStream;
  41. import java.io.OutputStream;
  42. import java.util.HashMap;
  43. import java.util.Map;
  44. import java.util.Properties;
  45. import java.util.Vector;
  46. import javax.swing.RowFilter;
  47. import javax.swing.table.TableCellRenderer;
  48. import javax.swing.table.TableModel;
  49. import javax.swing.table.TableRowSorter;
  50. import net.sf.jasperreports.engine.JREmptyDataSource;
  51. import net.sf.jasperreports.engine.JRException;
  52. import net.sf.jasperreports.engine.JRExporter;
  53. import net.sf.jasperreports.engine.JRExporterParameter;
  54. import net.sf.jasperreports.engine.JRResultSetDataSource;
  55. import net.sf.jasperreports.engine.JasperCompileManager;
  56. import net.sf.jasperreports.engine.JasperExportManager;
  57. import net.sf.jasperreports.engine.JasperFillManager;
  58. import net.sf.jasperreports.engine.JasperPrint;
  59. import net.sf.jasperreports.engine.JasperReport;
  60. import net.sf.jasperreports.engine.data.JRTableModelDataSource;
  61. import net.sf.jasperreports.engine.data.JRXmlDataSource;
  62. import net.sf.jasperreports.engine.design.JasperDesign;
  63. import net.sf.jasperreports.engine.export.JRPdfExporter;
  64. import net.sf.jasperreports.engine.xml.JRXmlLoader;
  65. import net.sf.jasperreports.view.JasperViewer;
  66. import org.apache.log4j.PropertyConfigurator;
  67.  
  68. /**
  69. *
  70. * @author Darek
  71. */
  72. public class PrzychodniaJFrame extends javax.swing.JFrame {
  73.  
  74. public static final String driver = "oracle.jdbc.OracleDriver";
  75. public static final String url = "jdbc:oracle:thin:@localhost:1521:xe";
  76. public static final String user = "chris";
  77. public static final String password = "hwds9176";
  78. Statement stmt = null;
  79. Connection con = null;
  80. ResultSet rs = null;
  81. int aktRzad = 0;
  82. private Iterable<Object> originalTableModel;
  83.  
  84. /**
  85. * Creates new form PrzychodniaJFrame
  86. */
  87. public PrzychodniaJFrame() {
  88. try {
  89. Class.forName(Przychodnia.driver);
  90. } catch (ClassNotFoundException e) {
  91. System.err.println("Brak sterownika JDBC");
  92. e.printStackTrace();
  93. }
  94.  
  95.  
  96.  
  97.  
  98. initComponents();
  99. Wczytaj();
  100.  
  101.  
  102. }
  103.  
  104. private void filter(String query)
  105. {
  106. DefaultTableModel model = (DefaultTableModel) jTable1.getModel();
  107. TableRowSorter<DefaultTableModel> tr = new TableRowSorter<DefaultTableModel>(model);
  108. jTable1.setRowSorter(tr);
  109.  
  110. tr.setRowFilter(RowFilter.regexFilter(query));
  111. }
  112.  
  113. public void Wczytaj()
  114. {
  115. DefaultTableModel model = (DefaultTableModel) jTable1.getModel();
  116. try{
  117. con = DriverManager.getConnection(url,user,password);
  118. stmt = con.createStatement();
  119.  
  120. String SQL = "SELECT * FROM Pacjent";
  121. ResultSet rs = stmt.executeQuery(SQL);
  122.  
  123. while(rs.next())
  124. {
  125. int id_kol = rs.getInt("ID_PACJENT");
  126. String id = Integer.toString(id_kol);
  127. String imie = rs.getString("Imie");
  128. String nazwisko = rs.getString("Nazwisko");
  129. String ulica = rs.getString("Ulica");
  130. String nr_domu_lokalu = rs.getString("Nr_Domu_Lokalu");
  131. String kod_pocztowy = rs.getString("Kod_Pocztowy");
  132. String miasto = rs.getString("Miasto");
  133. String wojewodztwo = rs.getString("Województwo");
  134. String numer_ubezpieczenia = rs.getString("Numer_Ubezpieczenia");
  135. String numer_telefonu = rs.getString("Numer_Telefonu");
  136. String pesel = rs.getString("PESEL");
  137.  
  138. model.addRow(new Object[] {id,imie,nazwisko,ulica,nr_domu_lokalu,kod_pocztowy,miasto,wojewodztwo,numer_ubezpieczenia,numer_telefonu,pesel});
  139. }
  140.  
  141.  
  142.  
  143. } catch (SQLException err) {
  144. JOptionPane.showMessageDialog(PrzychodniaJFrame.this, err.getMessage());
  145. }
  146.  
  147. }
  148.  
  149. /**
  150. * This method is called from within the constructor to initialize the form.
  151. * WARNING: Do NOT modify this code. The content of this method is always
  152. * regenerated by the Form Editor.
  153. */
  154. @SuppressWarnings("unchecked")
  155. // <editor-fold defaultstate="collapsed" desc="Generated Code">
  156. private void initComponents() {
  157.  
  158. LABELID = new javax.swing.JLabel();
  159. LABELIMIE = new javax.swing.JLabel();
  160. LABELNAZWISKO = new javax.swing.JLabel();
  161. LABELULICA = new javax.swing.JLabel();
  162. LABELDOM = new javax.swing.JLabel();
  163. LABELPOCZTA = new javax.swing.JLabel();
  164. LABELMIASTO = new javax.swing.JLabel();
  165. LABELWOJEWODZTWO = new javax.swing.JLabel();
  166. LABELUBEZPIECZENIE = new javax.swing.JLabel();
  167. LABELTELEFON = new javax.swing.JLabel();
  168. LABELPESEL = new javax.swing.JLabel();
  169. TextID = new javax.swing.JTextField();
  170. TextImie = new javax.swing.JTextField();
  171. TextNazwisko = new javax.swing.JTextField();
  172. TextUlica = new javax.swing.JTextField();
  173. TextDomu = new javax.swing.JTextField();
  174. TextPoczta = new javax.swing.JTextField();
  175. TextMiasto = new javax.swing.JTextField();
  176. TextWojewodztwo = new javax.swing.JTextField();
  177. TextUbezpieczenie = new javax.swing.JTextField();
  178. TextTelefon = new javax.swing.JTextField();
  179. TextPesel = new javax.swing.JTextField();
  180. jScrollPane1 = new javax.swing.JScrollPane();
  181. jTable1 = new javax.swing.JTable();
  182. Nowy = new javax.swing.JButton();
  183. Zapisz = new javax.swing.JButton();
  184. Usun = new javax.swing.JButton();
  185. Zapisz2 = new javax.swing.JButton();
  186. Zapisz3 = new javax.swing.JButton();
  187. Zmien = new javax.swing.JButton();
  188. Menu = new javax.swing.JButton();
  189. Zakoncz = new javax.swing.JButton();
  190. jLabel1 = new javax.swing.JLabel();
  191. TextSzukaj = new javax.swing.JTextField();
  192.  
  193. setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  194.  
  195. LABELID.setText("ID_PACJENT");
  196.  
  197. LABELIMIE.setText("Imie");
  198.  
  199. LABELNAZWISKO.setText("Nazwisko");
  200.  
  201. LABELULICA.setText("Ulica");
  202.  
  203. LABELDOM.setText("Nr_Domu_Lokalu");
  204.  
  205. LABELPOCZTA.setText("Kod_Pocztowy");
  206.  
  207. LABELMIASTO.setText("Miasto");
  208.  
  209. LABELWOJEWODZTWO.setText("Wojewodztwo");
  210.  
  211. LABELUBEZPIECZENIE.setText("Numer_Ubezpieczenia");
  212.  
  213. LABELTELEFON.setText("Numer_Telefonu");
  214.  
  215. LABELPESEL.setText("PESEL");
  216.  
  217. TextID.addActionListener(new java.awt.event.ActionListener() {
  218. public void actionPerformed(java.awt.event.ActionEvent evt) {
  219. TextIDActionPerformed(evt);
  220. }
  221. });
  222.  
  223. TextWojewodztwo.addActionListener(new java.awt.event.ActionListener() {
  224. public void actionPerformed(java.awt.event.ActionEvent evt) {
  225. TextWojewodztwoActionPerformed(evt);
  226. }
  227. });
  228.  
  229. jTable1.setModel(new javax.swing.table.DefaultTableModel(
  230. new Object [][] {
  231.  
  232. },
  233. new String [] {
  234. "ID_Pacjent", "Imie", "Nazwisko", "Ulica", "Nr_Domu_Lokalu", "Kod_Pocztowy", "Miasto", "Województwo", "Numer_Ubezpieczenia", "Numer_Telefonu", "Title 11"
  235. }
  236. ));
  237. jTable1.addMouseListener(new java.awt.event.MouseAdapter() {
  238. public void mouseClicked(java.awt.event.MouseEvent evt) {
  239. jTable1MouseClicked(evt);
  240. }
  241. });
  242. jScrollPane1.setViewportView(jTable1);
  243.  
  244. Nowy.setText("Nowy rekord");
  245. Nowy.addActionListener(new java.awt.event.ActionListener() {
  246. public void actionPerformed(java.awt.event.ActionEvent evt) {
  247. NowyActionPerformed(evt);
  248. }
  249. });
  250.  
  251. Zapisz.setText("Zapisz");
  252. Zapisz.setEnabled(false);
  253. Zapisz.addActionListener(new java.awt.event.ActionListener() {
  254. public void actionPerformed(java.awt.event.ActionEvent evt) {
  255. ZapiszActionPerformed(evt);
  256. }
  257. });
  258.  
  259. Usun.setText("Usun rekord");
  260. Usun.addActionListener(new java.awt.event.ActionListener() {
  261. public void actionPerformed(java.awt.event.ActionEvent evt) {
  262. UsunActionPerformed(evt);
  263. }
  264. });
  265.  
  266. Zapisz2.setText("Zapisz2");
  267. Zapisz2.setEnabled(false);
  268. Zapisz2.addActionListener(new java.awt.event.ActionListener() {
  269. public void actionPerformed(java.awt.event.ActionEvent evt) {
  270. Zapisz2ActionPerformed(evt);
  271. }
  272. });
  273.  
  274. Zapisz3.setText("Zapisz3");
  275. Zapisz3.setEnabled(false);
  276. Zapisz3.addActionListener(new java.awt.event.ActionListener() {
  277. public void actionPerformed(java.awt.event.ActionEvent evt) {
  278. Zapisz3ActionPerformed(evt);
  279. }
  280. });
  281.  
  282. Zmien.setText("Zmien rekord");
  283. Zmien.addActionListener(new java.awt.event.ActionListener() {
  284. public void actionPerformed(java.awt.event.ActionEvent evt) {
  285. ZmienActionPerformed(evt);
  286. }
  287. });
  288.  
  289. Menu.setText("Menu");
  290. Menu.addActionListener(new java.awt.event.ActionListener() {
  291. public void actionPerformed(java.awt.event.ActionEvent evt) {
  292. MenuActionPerformed(evt);
  293. }
  294. });
  295.  
  296. Zakoncz.setText("Zakoncz");
  297. Zakoncz.addActionListener(new java.awt.event.ActionListener() {
  298. public void actionPerformed(java.awt.event.ActionEvent evt) {
  299. ZakonczActionPerformed(evt);
  300. }
  301. });
  302.  
  303. jLabel1.setText("Szukaj");
  304.  
  305. TextSzukaj.addActionListener(new java.awt.event.ActionListener() {
  306. public void actionPerformed(java.awt.event.ActionEvent evt) {
  307. TextSzukajActionPerformed(evt);
  308. }
  309. });
  310. TextSzukaj.addKeyListener(new java.awt.event.KeyAdapter() {
  311. public void keyReleased(java.awt.event.KeyEvent evt) {
  312. TextSzukajKeyReleased(evt);
  313. }
  314. });
  315.  
  316. javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  317. getContentPane().setLayout(layout);
  318. layout.setHorizontalGroup(
  319. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  320. .addGroup(layout.createSequentialGroup()
  321. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  322. .addGroup(layout.createSequentialGroup()
  323. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
  324. .addComponent(LABELID, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  325. .addComponent(LABELNAZWISKO)
  326. .addComponent(LABELULICA)
  327. .addComponent(LABELDOM)
  328. .addComponent(LABELPOCZTA)
  329. .addComponent(LABELMIASTO)
  330. .addComponent(LABELWOJEWODZTWO)
  331. .addComponent(LABELUBEZPIECZENIE)
  332. .addComponent(LABELPESEL)
  333. .addComponent(LABELIMIE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  334. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  335. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  336. .addGroup(layout.createSequentialGroup()
  337. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
  338. .addComponent(TextMiasto, javax.swing.GroupLayout.DEFAULT_SIZE, 130, Short.MAX_VALUE)
  339. .addComponent(TextWojewodztwo)
  340. .addComponent(TextUbezpieczenie)
  341. .addComponent(TextTelefon)
  342. .addComponent(TextPesel)
  343. .addComponent(TextPoczta))
  344. .addGap(0, 0, Short.MAX_VALUE))
  345. .addGroup(layout.createSequentialGroup()
  346. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
  347. .addComponent(TextDomu, javax.swing.GroupLayout.Alignment.LEADING)
  348. .addComponent(TextUlica)
  349. .addComponent(TextNazwisko, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, 130, Short.MAX_VALUE)
  350. .addComponent(TextImie, javax.swing.GroupLayout.Alignment.LEADING)
  351. .addComponent(TextID, javax.swing.GroupLayout.Alignment.LEADING))
  352. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 27, Short.MAX_VALUE)
  353. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
  354. .addComponent(Zmien, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  355. .addComponent(Usun, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  356. .addComponent(Nowy, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))))
  357. .addGroup(layout.createSequentialGroup()
  358. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  359. .addGroup(layout.createSequentialGroup()
  360. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
  361. .addComponent(Menu)
  362. .addComponent(LABELTELEFON))
  363. .addGap(18, 18, 18)
  364. .addComponent(Zakoncz))
  365. .addGroup(layout.createSequentialGroup()
  366. .addContainerGap()
  367. .addComponent(jLabel1)
  368. .addGap(18, 18, 18)
  369. .addComponent(TextSzukaj, javax.swing.GroupLayout.PREFERRED_SIZE, 100, javax.swing.GroupLayout.PREFERRED_SIZE)))
  370. .addGap(0, 0, Short.MAX_VALUE)))
  371. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  372. .addGroup(layout.createSequentialGroup()
  373. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  374. .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  375. .addContainerGap())
  376. .addGroup(layout.createSequentialGroup()
  377. .addGap(18, 18, 18)
  378. .addComponent(Zapisz)
  379. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  380. .addComponent(Zapisz2)
  381. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  382. .addComponent(Zapisz3)
  383. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))))
  384. );
  385. layout.setVerticalGroup(
  386. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  387. .addGroup(layout.createSequentialGroup()
  388. .addContainerGap()
  389. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  390. .addComponent(LABELID)
  391. .addComponent(TextID, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  392. .addComponent(Zapisz)
  393. .addComponent(Zapisz2)
  394. .addComponent(Zapisz3))
  395. .addGap(7, 7, 7)
  396. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  397. .addGroup(layout.createSequentialGroup()
  398. .addComponent(Nowy)
  399. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  400. .addComponent(Usun)
  401. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  402. .addComponent(Zmien))
  403. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
  404. .addGroup(layout.createSequentialGroup()
  405. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  406. .addComponent(LABELIMIE)
  407. .addComponent(TextImie, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  408. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  409. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  410. .addComponent(LABELNAZWISKO)
  411. .addComponent(TextNazwisko, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  412. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  413. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  414. .addComponent(LABELULICA)
  415. .addComponent(TextUlica, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  416. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  417. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  418. .addComponent(LABELDOM)
  419. .addComponent(TextDomu, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  420. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  421. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  422. .addComponent(LABELPOCZTA)
  423. .addComponent(TextPoczta, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  424. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  425. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  426. .addComponent(LABELMIASTO)
  427. .addComponent(TextMiasto, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  428. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  429. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  430. .addComponent(LABELWOJEWODZTWO)
  431. .addComponent(TextWojewodztwo, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  432. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  433. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  434. .addComponent(LABELUBEZPIECZENIE)
  435. .addComponent(TextUbezpieczenie, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  436. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  437. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  438. .addComponent(LABELTELEFON)
  439. .addComponent(TextTelefon, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  440. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  441. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  442. .addComponent(LABELPESEL)
  443. .addComponent(TextPesel, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  444. .addGap(53, 53, 53)
  445. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  446. .addComponent(jLabel1)
  447. .addComponent(TextSzukaj, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  448. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  449. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  450. .addComponent(Menu)
  451. .addComponent(Zakoncz)))
  452. .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
  453. .addContainerGap(40, Short.MAX_VALUE))
  454. );
  455.  
  456. pack();
  457. }// </editor-fold>
  458.  
  459. private void TextIDActionPerformed(java.awt.event.ActionEvent evt) {
  460. // TODO add your handling code here:
  461. }
  462.  
  463. private void TextWojewodztwoActionPerformed(java.awt.event.ActionEvent evt) {
  464. // TODO add your handling code here:
  465. }
  466.  
  467. private void jTable1MouseClicked(java.awt.event.MouseEvent evt) {
  468. DefaultTableModel model = (DefaultTableModel) jTable1.getModel();
  469. TextID.setText(model.getValueAt(jTable1.getSelectedRow(), 0).toString());
  470. TextImie.setText(model.getValueAt(jTable1.getSelectedRow(),1).toString());
  471. TextNazwisko.setText(model.getValueAt(jTable1.getSelectedRow(),2).toString());
  472. TextUlica.setText(model.getValueAt(jTable1.getSelectedRow(),3).toString());
  473. TextDomu.setText(model.getValueAt(jTable1.getSelectedRow(),4).toString());
  474. TextPoczta.setText(model.getValueAt(jTable1.getSelectedRow(),5).toString());
  475. TextMiasto.setText(model.getValueAt(jTable1.getSelectedRow(),6).toString());
  476. TextWojewodztwo.setText(model.getValueAt(jTable1.getSelectedRow(),7).toString());
  477. TextUbezpieczenie.setText(model.getValueAt(jTable1.getSelectedRow(),8).toString());
  478. TextTelefon.setText(model.getValueAt(jTable1.getSelectedRow(),9).toString());
  479. TextPesel.setText(model.getValueAt(jTable1.getSelectedRow(),10).toString());
  480. }
  481.  
  482. private void NowyActionPerformed(java.awt.event.ActionEvent evt) {
  483. try
  484. {
  485.  
  486. con = DriverManager.getConnection(url,user,password);
  487. stmt = con.createStatement();
  488.  
  489. String SQL = "SELECT * FROM Pacjent";
  490. ResultSet rs = stmt.executeQuery(SQL);
  491.  
  492. aktRzad = rs.getRow();
  493.  
  494. TextID.setText("");
  495. TextImie.setText("");
  496. TextNazwisko.setText("");
  497. TextUlica.setText("");
  498. TextDomu.setText("");
  499. TextPoczta.setText("");
  500. TextMiasto.setText("");
  501. TextWojewodztwo.setText("");
  502. TextUbezpieczenie.setText("");
  503. TextTelefon.setText("");
  504. TextPesel.setText("");
  505.  
  506. Zapisz.setEnabled(true);
  507. Zapisz2.setEnabled(false);
  508. Zapisz3.setEnabled(false);
  509. Nowy.setEnabled(false);
  510. Usun.setEnabled(false);
  511. Zmien.setEnabled(false);
  512. } catch (SQLException err){
  513. System.out.println(err.getMessage());
  514. }
  515.  
  516. }
  517.  
  518. private void ZapiszActionPerformed(java.awt.event.ActionEvent evt) {
  519. String id = TextID.getText();
  520. String imie = TextImie.getText();
  521. String nazwisko = TextNazwisko.getText();
  522. String ulica = TextUlica.getText();
  523. String domu = TextDomu.getText();
  524. String poczta = TextPoczta.getText();
  525. String miasto = TextMiasto.getText();
  526. String wojewodztwo = TextWojewodztwo.getText();
  527. String ubezpieczenie = TextUbezpieczenie.getText();
  528. String telefon = TextTelefon.getText();
  529. String pesel = TextPesel.getText();
  530. int nowyID = Integer.parseInt(id);
  531.  
  532. String SQL = "INSERT INTO Pacjent"
  533. + "(ID_PACJENT,Imie,Nazwisko,Ulica,Nr_Domu_Lokalu,Kod_Pocztowy,Miasto,Województwo,Numer_Ubezpieczenia,Numer_Telefonu,PESEL) VALUES"
  534. + "(?,?,?,?,?,?,?,?,?,?,?)";
  535.  
  536. try{
  537. con = DriverManager.getConnection(url,user,password);
  538.  
  539.  
  540. PreparedStatement preparedStatement = con.prepareStatement(SQL);
  541.  
  542. preparedStatement.setInt(1,nowyID);
  543. preparedStatement.setString(2,imie);
  544. preparedStatement.setString(3,nazwisko);
  545. preparedStatement.setString(4,ulica);
  546. preparedStatement.setString(5,domu);
  547. preparedStatement.setString(6,poczta);
  548. preparedStatement.setString(7,miasto);
  549. preparedStatement.setString(8,wojewodztwo);
  550. preparedStatement.setString(9,ubezpieczenie);
  551. preparedStatement.setString(10,telefon);
  552. preparedStatement.setString(11,pesel);
  553.  
  554. preparedStatement.executeUpdate();
  555.  
  556. TextID.setText("");
  557. TextImie.setText("");
  558. TextNazwisko.setText("");
  559. TextUlica.setText("");
  560. TextDomu.setText("");
  561. TextPoczta.setText("");
  562. TextMiasto.setText("");
  563. TextWojewodztwo.setText("");
  564. TextUbezpieczenie.setText("");
  565. TextTelefon.setText("");
  566. TextPesel.setText("");
  567.  
  568. Zapisz.setEnabled(false);
  569. Zapisz2.setEnabled(false);
  570. Zapisz3.setEnabled(false);
  571. Nowy.setEnabled(true);
  572. Usun.setEnabled(true);
  573. Zmien.setEnabled(true);
  574.  
  575. } catch (SQLException err) {
  576. System.out.println(err.getMessage());
  577. }
  578.  
  579. try {
  580. new PrzychodniaJFrame().setVisible(false);
  581. dispose();
  582. sleep(200);
  583. new PrzychodniaJFrame().setVisible(true);
  584. } catch (InterruptedException ex) {
  585. Logger.getLogger(PrzychodniaJFrame.class.getName()).log(Level.SEVERE, null, ex);
  586. }
  587.  
  588. }
  589.  
  590. private void UsunActionPerformed(java.awt.event.ActionEvent evt) {
  591. try
  592. {
  593.  
  594. con = DriverManager.getConnection(url,user,password);
  595. stmt = con.createStatement();
  596.  
  597. String SQL = "SELECT * FROM Pacjent";
  598. ResultSet rs = stmt.executeQuery(SQL);
  599.  
  600. aktRzad = rs.getRow();
  601.  
  602. TextID.setText("");
  603. TextImie.setText("");
  604. TextNazwisko.setText("");
  605. TextUlica.setText("");
  606. TextDomu.setText("");
  607. TextPoczta.setText("");
  608. TextMiasto.setText("");
  609. TextWojewodztwo.setText("");
  610. TextUbezpieczenie.setText("");
  611. TextTelefon.setText("");
  612. TextPesel.setText("");
  613.  
  614. TextImie.setEnabled(false);
  615. TextNazwisko.setEnabled(false);
  616. TextUlica.setEnabled(false);
  617. TextDomu.setEnabled(false);
  618. TextPoczta.setEnabled(false);
  619. TextMiasto.setEnabled(false);
  620. TextWojewodztwo.setEnabled(false);
  621. TextUbezpieczenie.setEnabled(false);
  622. TextTelefon.setEnabled(false);
  623. TextPesel.setEnabled(false);
  624.  
  625. Zapisz.setEnabled(false);
  626. Zapisz2.setEnabled(true);
  627. Zapisz3.setEnabled(false);
  628. Nowy.setEnabled(false);
  629. Usun.setEnabled(false);
  630. Zmien.setEnabled(false);
  631. } catch (SQLException err){
  632. System.out.println(err.getMessage());
  633. }
  634. }
  635.  
  636. private void Zapisz2ActionPerformed(java.awt.event.ActionEvent evt) {
  637. String id = TextID.getText();
  638. int nowyID = Integer.parseInt(id);
  639. try{
  640. con = DriverManager.getConnection(url,user,password);
  641.  
  642. String SQL = "DELETE Pacjent WHERE ID_PACJENT = ?";
  643. PreparedStatement preparedStatement = con.prepareStatement(SQL);
  644.  
  645. preparedStatement.setInt(1, nowyID);
  646.  
  647. preparedStatement.executeQuery();
  648.  
  649. TextID.setText("");
  650. TextImie.setEnabled(true);
  651. TextNazwisko.setEnabled(true);
  652. TextUlica.setEnabled(true);
  653. TextDomu.setEnabled(true);
  654. TextPoczta.setEnabled(true);
  655. TextMiasto.setEnabled(true);
  656. TextWojewodztwo.setEnabled(true);
  657. TextUbezpieczenie.setEnabled(true);
  658. TextTelefon.setEnabled(true);
  659. TextPesel.setEnabled(true);
  660.  
  661. Zapisz.setEnabled(false);
  662. Zapisz2.setEnabled(false);
  663. Zapisz3.setEnabled(false);
  664. Nowy.setEnabled(true);
  665. Usun.setEnabled(true);
  666. Zmien.setEnabled(true);
  667.  
  668. } catch (SQLException err){
  669. System.out.println(err.getMessage());
  670. }
  671. try {
  672. new PrzychodniaJFrame().setVisible(false);
  673. dispose();
  674. sleep(200);
  675. new PrzychodniaJFrame().setVisible(true);
  676. } catch (InterruptedException ex) {
  677. Logger.getLogger(PrzychodniaJFrame.class.getName()).log(Level.SEVERE, null, ex);
  678. }
  679. }
  680.  
  681. private void Zapisz3ActionPerformed(java.awt.event.ActionEvent evt) {
  682. String id = TextID.getText();
  683. String imie = TextImie.getText();
  684. String nazwisko = TextNazwisko.getText();
  685. String ulica = TextUlica.getText();
  686. String domu = TextDomu.getText();
  687. String poczta = TextPoczta.getText();
  688. String miasto = TextMiasto.getText();
  689. String wojewodztwo = TextWojewodztwo.getText();
  690. String ubezpieczenie = TextUbezpieczenie.getText();
  691. String telefon = TextTelefon.getText();
  692. String pesel = TextPesel.getText();
  693. int nowyID = Integer.parseInt(id);
  694.  
  695. String SQL = "UPDATE Pacjent SET Imie = ?, Nazwisko = ?, Ulica = ?,"
  696. + "Nr_Domu_Lokalu = ?, Kod_Pocztowy = ?, Miasto = ?, Województwo = ?,"
  697. + "Numer_Ubezpieczenia = ?, Numer_Telefonu = ?, PESEL = ? WHERE ID_PACJENT = ?";
  698.  
  699. try{
  700. con = DriverManager.getConnection(url,user,password);
  701.  
  702.  
  703. PreparedStatement preparedStatement = con.prepareStatement(SQL);
  704.  
  705. preparedStatement.setString(1,imie);
  706. preparedStatement.setString(2,nazwisko);
  707. preparedStatement.setString(3,ulica);
  708. preparedStatement.setString(4,domu);
  709. preparedStatement.setString(5,poczta);
  710. preparedStatement.setString(6,miasto);
  711. preparedStatement.setString(7,wojewodztwo);
  712. preparedStatement.setString(8,ubezpieczenie);
  713. preparedStatement.setString(9,telefon);
  714. preparedStatement.setString(10,pesel);
  715. preparedStatement.setInt(11,nowyID);
  716.  
  717. preparedStatement.executeUpdate();
  718.  
  719. TextID.setText("");
  720. TextImie.setText("");
  721. TextNazwisko.setText("");
  722. TextUlica.setText("");
  723. TextDomu.setText("");
  724. TextPoczta.setText("");
  725. TextMiasto.setText("");
  726. TextWojewodztwo.setText("");
  727. TextUbezpieczenie.setText("");
  728. TextTelefon.setText("");
  729. TextPesel.setText("");
  730.  
  731. Zapisz.setEnabled(false);
  732. Zapisz2.setEnabled(false);
  733. Zapisz3.setEnabled(false);
  734. Nowy.setEnabled(true);
  735. Usun.setEnabled(true);
  736. Zmien.setEnabled(true);
  737.  
  738. } catch (SQLException err) {
  739. System.out.println(err.getMessage());
  740. }
  741. try {
  742. new PrzychodniaJFrame().setVisible(false);
  743. dispose();
  744. sleep(200);
  745. new PrzychodniaJFrame().setVisible(true);
  746. } catch (InterruptedException ex) {
  747. Logger.getLogger(PrzychodniaJFrame.class.getName()).log(Level.SEVERE, null, ex);
  748. }
  749. }
  750.  
  751. private void ZmienActionPerformed(java.awt.event.ActionEvent evt) {
  752. try
  753. {
  754.  
  755. con = DriverManager.getConnection(url,user,password);
  756. stmt = con.createStatement();
  757.  
  758. String SQL = "SELECT * FROM Pacjent";
  759. ResultSet rs = stmt.executeQuery(SQL);
  760.  
  761. aktRzad = rs.getRow();
  762.  
  763. TextID.setText("");
  764. TextImie.setText("");
  765. TextNazwisko.setText("");
  766. TextUlica.setText("");
  767. TextDomu.setText("");
  768. TextPoczta.setText("");
  769. TextMiasto.setText("");
  770. TextWojewodztwo.setText("");
  771. TextUbezpieczenie.setText("");
  772. TextTelefon.setText("");
  773. TextPesel.setText("");
  774.  
  775.  
  776. Zapisz.setEnabled(false);
  777. Zapisz2.setEnabled(false);
  778. Zapisz3.setEnabled(true);
  779. Nowy.setEnabled(false);
  780. Usun.setEnabled(false);
  781. Zmien.setEnabled(false);
  782.  
  783. } catch (SQLException err){
  784. System.out.println(err.getMessage());
  785. }
  786. }
  787.  
  788. private void MenuActionPerformed(java.awt.event.ActionEvent evt) {
  789. new MenuJFrame().setVisible(true);
  790. dispose();
  791. }
  792.  
  793. private void ZakonczActionPerformed(java.awt.event.ActionEvent evt) {
  794. System.exit(0);
  795. }
  796.  
  797. private void TextSzukajKeyReleased(java.awt.event.KeyEvent evt) {
  798. String query = TextSzukaj.getText();
  799. filter(query);
  800. }
  801.  
  802. private void TextSzukajActionPerformed(java.awt.event.ActionEvent evt) {
  803.  
  804. }
  805.  
  806.  
  807.  
  808.  
  809. public static void main(String args[]) {
  810.  
  811.  
  812.  
  813. /* Set the Nimbus look and feel */
  814. //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
  815. /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
  816. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
  817. */
  818. try {
  819. for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
  820. if ("Nimbus".equals(info.getName())) {
  821. javax.swing.UIManager.setLookAndFeel(info.getClassName());
  822. break;
  823. }
  824. }
  825. } catch (ClassNotFoundException ex) {
  826. java.util.logging.Logger.getLogger(PrzychodniaJFrame.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  827. } catch (InstantiationException ex) {
  828. java.util.logging.Logger.getLogger(PrzychodniaJFrame.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  829. } catch (IllegalAccessException ex) {
  830. java.util.logging.Logger.getLogger(PrzychodniaJFrame.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  831. } catch (javax.swing.UnsupportedLookAndFeelException ex) {
  832. java.util.logging.Logger.getLogger(PrzychodniaJFrame.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  833. }
  834. //</editor-fold>
  835.  
  836. /* Create and display the form */
  837. java.awt.EventQueue.invokeLater(new Runnable() {
  838. public void run() {
  839. new PrzychodniaJFrame().setVisible(false);
  840. }
  841. });
  842. }
  843.  
  844. // Variables declaration - do not modify
  845. private javax.swing.JLabel LABELDOM;
  846. private javax.swing.JLabel LABELID;
  847. private javax.swing.JLabel LABELIMIE;
  848. private javax.swing.JLabel LABELMIASTO;
  849. private javax.swing.JLabel LABELNAZWISKO;
  850. private javax.swing.JLabel LABELPESEL;
  851. private javax.swing.JLabel LABELPOCZTA;
  852. private javax.swing.JLabel LABELTELEFON;
  853. private javax.swing.JLabel LABELUBEZPIECZENIE;
  854. private javax.swing.JLabel LABELULICA;
  855. private javax.swing.JLabel LABELWOJEWODZTWO;
  856. private javax.swing.JButton Menu;
  857. private javax.swing.JButton Nowy;
  858. private javax.swing.JTextField TextDomu;
  859. private javax.swing.JTextField TextID;
  860. private javax.swing.JTextField TextImie;
  861. private javax.swing.JTextField TextMiasto;
  862. private javax.swing.JTextField TextNazwisko;
  863. private javax.swing.JTextField TextPesel;
  864. private javax.swing.JTextField TextPoczta;
  865. private javax.swing.JTextField TextSzukaj;
  866. private javax.swing.JTextField TextTelefon;
  867. private javax.swing.JTextField TextUbezpieczenie;
  868. private javax.swing.JTextField TextUlica;
  869. private javax.swing.JTextField TextWojewodztwo;
  870. private javax.swing.JButton Usun;
  871. private javax.swing.JButton Zakoncz;
  872. private javax.swing.JButton Zapisz;
  873. private javax.swing.JButton Zapisz2;
  874. private javax.swing.JButton Zapisz3;
  875. private javax.swing.JButton Zmien;
  876. private javax.swing.JLabel jLabel1;
  877. private javax.swing.JScrollPane jScrollPane1;
  878. private javax.swing.JTable jTable1;
  879. // End of variables declaration
  880.  
  881. private void fillTable() {
  882. throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
  883. }
  884. }
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!