API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 20th, 2016
97
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 26.46 KB | None | 0 0
raw download clone embed print report
  1. import java.awt.BorderLayout;
  2. import java.awt.EventQueue;
  3.  
  4. import javax.swing.JFrame;
  5. import javax.swing.JPanel;
  6. import javax.swing.border.EmptyBorder;
  7. import javax.swing.JTabbedPane;
  8. import javax.swing.JTable;
  9. import javax.swing.plaf.FileChooserUI;
  10. import javax.swing.plaf.TabbedPaneUI;
  11. import javax.swing.table.DefaultTableModel;
  12. import javax.swing.JButton;
  13. import java.awt.event.ActionListener;
  14. import java.awt.event.ActionEvent;
  15. import java.beans.Statement;
  16. import java.io.File;
  17. import java.sql.Connection;
  18. import java.sql.Date;
  19. import java.sql.DriverManager;
  20. import java.sql.PreparedStatement;
  21. import java.sql.ResultSet;
  22. import java.sql.SQLException;
  23. import java.util.Calendar;
  24.  
  25. import javax.swing.JComboBox;
  26. import javax.swing.JComponent;
  27. import javax.swing.JFileChooser;
  28. import javax.swing.JOptionPane;
  29. import javax.swing.JTextField;
  30. import javax.swing.JLabel;
  31. import javax.swing.JScrollPane;
  32. import javax.swing.GroupLayout;
  33. import javax.swing.GroupLayout.Alignment;
  34. import javax.swing.SpinnerDateModel;
  35. import javax.swing.UIManager;
  36. import javax.swing.UnsupportedLookAndFeelException;
  37. import javax.swing.event.ChangeListener;
  38. import javax.swing.event.ChangeEvent;
  39. import java.awt.event.InputMethodListener;
  40. import java.awt.event.InputMethodEvent;
  41. import javax.swing.LayoutStyle.ComponentPlacement;
  42. import java.awt.event.KeyAdapter;
  43. import java.awt.event.KeyEvent;
  44.  
  45.  
  46. public class verwa extends JFrame {
  47.  
  48. private JPanel contentPane;
  49. private JPanel panel;
  50. private JButton btnSuche;
  51. private JTable table;
  52. private static String Dateipfad = "/home/lukas/Downloads/";
  53. private static String Dateiname = "Bibliothek.mdb";
  54. public DefaultTableModel md;
  55. private JButton btnHinzufgen;
  56. private JPanel panel_1;
  57. private JButton btnSuche_1;
  58. private JButton btnLschen_1;
  59. private JButton btnHinzufgen_1;
  60. private String lastcom="";
  61. private JButton btnNewButton;
  62. private String pfad=Dateipfad+Dateiname;
  63. private int ext=0;
  64. final JTabbedPane tabbedPane;
  65. // final JFileChooser fc = new JFileChooser();
  66. /**
  67. * Launch the application.
  68. */
  69. public static void main(String[] args) {
  70. try {
  71. UIManager.setLookAndFeel(
  72. UIManager.getSystemLookAndFeelClassName());
  73. } catch (ClassNotFoundException | InstantiationException
  74. | IllegalAccessException | UnsupportedLookAndFeelException e1) {
  75. e1.printStackTrace();
  76. }
  77. EventQueue.invokeLater(new Runnable() {
  78. public void run() {
  79. try {
  80. verwa frame = new verwa();
  81. frame.setVisible(true);
  82. } catch (Exception e) {
  83. e.printStackTrace();
  84. }
  85. }
  86. });
  87. }
  88.  
  89. /**
  90. * Create the frame.
  91. */
  92.  
  93.  
  94. public int getlastid(){
  95. String sql ="SELECT ID FROM Medium;";
  96. Connection dp;
  97. java.sql.Statement stmt;
  98. int id=0;
  99. try {
  100. dp=DriverManager.getConnection( "jdbc:ucanaccess://" + pfad);
  101. stmt = dp.createStatement();
  102. ResultSet result = stmt.executeQuery(sql);
  103. //int i=0;
  104.  
  105. while(result.next()){
  106. id=result.getInt("ID");
  107.  
  108. }
  109. } catch (SQLException e) {
  110. e.printStackTrace();
  111. }
  112. return id;
  113. }
  114.  
  115. public int getlastidkunde(){
  116. String sql ="SELECT ID FROM Kunde;";
  117. Connection dp;
  118. java.sql.Statement stmt;
  119. int id=0;
  120. try {
  121. dp=DriverManager.getConnection( "jdbc:ucanaccess://" + pfad);
  122. stmt = dp.createStatement();
  123. ResultSet result = stmt.executeQuery(sql);
  124. //int i=0;
  125.  
  126. while(result.next()){
  127. id=result.getInt("ID");
  128.  
  129. }
  130. } catch (SQLException e) {
  131. e.printStackTrace();
  132. }
  133. return id;
  134. }
  135.  
  136.  
  137. public void del(String com3){
  138. Connection dp;
  139. java.sql.Statement stmt;
  140. try {
  141. dp=DriverManager.getConnection( "jdbc:ucanaccess://" + pfad);
  142. stmt = dp.createStatement();
  143. stmt.executeUpdate(com3);
  144. //int i=0;
  145.  
  146.  
  147. } catch (SQLException e) {
  148. e.printStackTrace();
  149. }
  150. }
  151.  
  152. public void mediaref(String com2){
  153. md.setRowCount(0);
  154. Connection dp;
  155. java.sql.Statement stmt;
  156. try {
  157. dp=DriverManager.getConnection( "jdbc:ucanaccess://" + pfad);
  158. stmt = dp.createStatement();
  159. ResultSet result = stmt.executeQuery(com2);
  160. //int i=0;
  161.  
  162. while(result.next()){
  163. //System.out.println("Test");
  164. //md.addRow(new Object[]{"","","","",""});
  165.  
  166. md.addRow(new Object[] { result.getString("Titel"), result.getString("Autor"), result.getInt("Erscheinungsjahr"),result.getString("Genre"), ""});
  167. }
  168. } catch (SQLException e) {
  169. e.printStackTrace();
  170. }
  171. }
  172.  
  173. public void kunderef(String coms){
  174. md.setRowCount(0);
  175. table.setModel(new DefaultTableModel(
  176. new Object[][] {
  177. },
  178. new String[] {
  179. "Vorname", "Nachname", "Straße", "Ort", "PLZ", "Geburtsdatum"
  180. }
  181. ));
  182. md =(DefaultTableModel) table.getModel();
  183. table.setModel(md);
  184.  
  185.  
  186. Connection dp;
  187. java.sql.Statement stmt;
  188. try {
  189. dp=DriverManager.getConnection( "jdbc:ucanaccess://" + pfad);
  190. stmt = dp.createStatement();
  191. ResultSet result = stmt.executeQuery(coms);
  192. //int i=0;
  193.  
  194. while(result.next()){
  195. //System.out.println("Test");
  196. //md.addRow(new Object[]{"","","","",""});
  197.  
  198. md.addRow(new Object[] { result.getString("Vorname"), result.getString("Nachname"), result.getString("Straße"),result.getString("Ort"), result.getString("PLZ"), result.getString("Geburtsdatum")});
  199. }
  200. } catch (SQLException e) {
  201. e.printStackTrace();
  202. }
  203. }
  204.  
  205.  
  206.  
  207. public void mediaall(){
  208. table.setModel(new DefaultTableModel(
  209. new Object[][] {
  210. },
  211. new String[] {
  212. "Titel", "Autor", "Erscheinungsjahr", "Genre", "Status"
  213. }
  214. ));
  215. md =(DefaultTableModel) table.getModel();
  216. table.setModel(md);
  217. String coms="SELECT Titel, Autor, Erscheinungsjahr, Genre FROM Medium WHERE Erscheinungsjahr > 1 ";
  218. lastcom=coms;
  219. mediaref(coms);
  220. }
  221. public void kundeall(){
  222. table.setModel(new DefaultTableModel(
  223. new Object[][] {
  224. },
  225. new String[] {
  226. "Vorname", "Nachname", "Straße", "Ort", "PLZ", "Geburtsdatum"
  227. }
  228. ));
  229. md =(DefaultTableModel) table.getModel();
  230. table.setModel(md);
  231. String com ="SELECT Vorname, Nachname, Straße, Ort, PLZ, Geburtsdatum FROM Kunde;";
  232. lastcom=com;
  233. kunderef(com);
  234. }
  235.  
  236. public verwa() {
  237.  
  238.  
  239.  
  240. setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
  241. setBounds(100, 100, 794, 587);
  242. contentPane = new JPanel();
  243. contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
  244. setContentPane(contentPane);
  245. table = new JTable();
  246. table.addKeyListener(new KeyAdapter() {
  247. @Override
  248. public void keyReleased(KeyEvent e) {
  249. String cms="UPDATE ";
  250. //if (tabbedpane.get)
  251. if (tabbedPane.getSelectedIndex()==0){
  252. cms+="Medium SET ";
  253. int c=table.getSelectedColumn();
  254. int r=table.getSelectedRow();
  255. int ez=0;
  256. if (table.getSelectedColumn()==0){
  257. cms+="Titel='"+table.getValueAt(table.getSelectedRow(),0)+"'";
  258. ez=1;
  259. }
  260. if (table.getSelectedColumn()==1){
  261. if (ez==1){
  262. cms+=", ";
  263. }
  264. ez=1;
  265. cms+="Autor='"+table.getValueAt(table.getSelectedRow(),1)+"'";
  266.  
  267. }
  268. if (table.getSelectedColumn()==2){
  269. if (ez==1){
  270. cms+=", ";
  271. }
  272. ez=1;
  273. cms+="Erscheinungsjahr="+table.getValueAt(table.getSelectedRow(),2)+"";
  274.  
  275. }
  276. if (table.getSelectedColumn()==3){
  277. if (ez==1){
  278. cms+=", ";
  279. }
  280. ez=1;
  281. cms+="Genre='"+table.getValueAt(table.getSelectedRow(),3)+"'";
  282.  
  283. }
  284. cms+=" WHERE ";
  285. ez=0;
  286.  
  287. if (table.getSelectedColumn()!=0){
  288. if (ez==1){
  289. cms+=" AND ";
  290. }
  291. ez=1;
  292. cms+="Titel='"+table.getValueAt(table.getSelectedRow(),0)+"'";
  293.  
  294. }
  295.  
  296. if (table.getSelectedColumn()!=1){
  297. if (ez==1){
  298. cms+=" AND ";
  299. }
  300. ez=1;
  301. cms+="Autor='"+table.getValueAt(table.getSelectedRow(),1)+"'";
  302.  
  303. }
  304.  
  305. if (table.getSelectedColumn()!=2){
  306. if (ez==1){
  307. cms+=" AND ";
  308. }
  309. ez=1;
  310. cms+="Erscheinungsjahr="+table.getValueAt(table.getSelectedRow(),2)+"";
  311.  
  312. }
  313.  
  314. if (table.getSelectedColumn()!=3){
  315. if (ez==1){
  316. cms+=" AND ";
  317. }
  318. ez=1;
  319. cms+="Genre='"+table.getValueAt(table.getSelectedRow(),3)+"'";
  320.  
  321. }}
  322.  
  323.  
  324.  
  325.  
  326. System.out.println(cms);
  327. cms+=";";
  328. del(cms);
  329. //mediaref(lastcom);
  330.  
  331.  
  332. // TODO UPDATE FÜR KUNDE
  333.  
  334.  
  335.  
  336.  
  337. }
  338. });
  339. table.addInputMethodListener(new InputMethodListener() {
  340. public void caretPositionChanged(InputMethodEvent arg0) {
  341. }
  342. public void inputMethodTextChanged(InputMethodEvent arg0) {
  343. // DONE IN KEY_RELEASE
  344. }
  345. });
  346. table.setModel(new DefaultTableModel(
  347. new Object[][] {
  348. },
  349. new String[] {
  350. "Titel", "Autor", "Erscheinungsjahr", "Genre", "Status"
  351. }
  352. ));
  353. md = (DefaultTableModel) table.getModel();
  354. table.setModel(md);
  355. tabbedPane = new JTabbedPane(JTabbedPane.TOP);
  356. tabbedPane.addChangeListener(new ChangeListener() {
  357. public void stateChanged(ChangeEvent arg0) {
  358. if (tabbedPane.getSelectedIndex()==0 && ext==1){
  359. mediaall();
  360. }
  361. else if (tabbedPane.getSelectedIndex()==1 && ext==1){
  362. kundeall();
  363. }
  364. }
  365. });
  366. tabbedPane.setVisible(false);
  367.  
  368. panel = new JPanel();
  369. tabbedPane.addTab("Medien", null, panel, null);
  370. //mediaall();
  371.  
  372. btnSuche = new JButton("Suche");
  373. btnSuche.addActionListener(new ActionListener() {
  374. public void actionPerformed(ActionEvent e) {
  375.  
  376. JTextField titele = new JTextField();
  377. JTextField autore = new JTextField();
  378. JTextField jahre = new JTextField();
  379. JTextField genree = new JTextField();
  380.  
  381. final JComponent[] inputs = new JComponent[] {
  382. new JLabel("Titel"),
  383. titele,
  384. new JLabel("Autor"),
  385. autore,
  386. new JLabel("Erscheinungsjahr"),
  387. jahre,
  388. new JLabel("Genre"),
  389. genree
  390. };
  391. try
  392. {
  393. int re = JOptionPane.showConfirmDialog(null, inputs, "Suche Medium", JOptionPane.OK_CANCEL_OPTION);
  394. if(re != JOptionPane.OK_OPTION) return;
  395. String com="SELECT Titel, Autor, Erscheinungsjahr, Genre FROM Medium WHERE Erscheinungsjahr > 1 ";
  396. if (titele.getText().length()>0){
  397. com+="AND Titel LIKE '%"+titele.getText()+"%' ";
  398. }
  399. else if (autore.getText().length()>0){
  400. com+="AND Autor LIKE '%"+autore.getText()+"%' ";
  401. }
  402. else if (jahre.getText().length()>0){
  403. com+="AND Erscheinungsjahr LIKE '%"+jahre.getText()+"%' ";
  404. }
  405. else if (genree.getText().length()>0){
  406. com+="AND Genre LIKE '%"+genree.getText()+"%' ";
  407. }
  408. com+=";";
  409. lastcom=com;
  410. System.out.println(com);
  411. md.setRowCount(0);
  412. mediaref(com);
  413. /*
  414. Connection dp;
  415. java.sql.Statement stmt;
  416. dp=DriverManager.getConnection( "jdbc:ucanaccess://" + pfad);
  417. stmt = dp.createStatement();
  418. ResultSet result = stmt.executeQuery(com);
  419. //int i=0;
  420. System.out.println(com);
  421. while (result.next()){
  422.  
  423. }
  424. */
  425. /*while(result.next()){
  426. System.out.println("Test");
  427. //md.addRow(new Object[]{"","","","",""});
  428.  
  429. //md.addRow(new Object[] { result.getString("Titel"), result.getString("Autor"), result.getString("Genre"), result.getInt("Erscheinungsjahr"), ""});
  430. }*/
  431. System.out.println(com);
  432.  
  433.  
  434.  
  435.  
  436. }
  437. catch (Exception e1)
  438. {
  439. JOptionPane.showMessageDialog(null, "Fehlerhafte Eingabe", "Warning.", JOptionPane.ERROR_MESSAGE);
  440. e1.printStackTrace();
  441. }
  442.  
  443. }
  444. });
  445. panel.add(btnSuche);
  446.  
  447. JButton btnLschen = new JButton("Löschen");
  448. btnLschen.addActionListener(new ActionListener() {
  449. public void actionPerformed(ActionEvent e) {
  450.  
  451. int row=table.getSelectedRow();
  452. String deltitel = (String) table.getValueAt(row, 0);
  453. String delautor = (String) table.getValueAt(row, 1);
  454. String delgenre = (String) table.getValueAt(row, 3);
  455. int deljahr = (int) table.getValueAt(row, 2);
  456. //System.out.println(deltitel);}
  457. String sql="DELETE FROM Buch WHERE ID IN (SELECT ID FROM Medium "+
  458. "WHERE Titel='"+deltitel+"' AND Autor='"+delautor+"' AND Genre='"+delgenre+"' AND Erscheinungsjahr="+String.valueOf(deljahr)
  459. +");";
  460.  
  461. String sql2="DELETE FROM CD WHERE ID IN (SELECT ID FROM Medium "+
  462. "WHERE Titel='"+deltitel+"' AND Autor='"+delautor+"' AND Genre='"+delgenre+"' AND Erscheinungsjahr="+String.valueOf(deljahr)
  463. +");";
  464.  
  465. String sql3="DELETE FROM DVD WHERE ID IN (SELECT ID FROM Medium "+
  466. "WHERE Titel='"+deltitel+"' AND Autor='"+delautor+"' AND Genre='"+delgenre+"' AND Erscheinungsjahr="+String.valueOf(deljahr)
  467. +");";
  468. String sql4="DELETE FROM Medium WHERE Titel='"+deltitel+"' AND Autor='"+delautor+"' AND Genre='"+delgenre+"' AND Erscheinungsjahr="+String.valueOf(deljahr)+";";
  469.  
  470.  
  471.  
  472.  
  473.  
  474.  
  475. /*String sql2="DELETE FROM CD WHERE Medium.ID = Buch.ID AND Titel='"+deltitel+"' AND Autor='"+delautor+"' AND Genre='"+delgenre+"' AND Erscheinungsjahr="+String.valueOf(deljahr)+";";
  476. String sql3="DELETE FROM DVD WHERE Medium.ID = Buch.ID AND Titel='"+deltitel+"' AND Autor='"+delautor+"' AND Genre='"+delgenre+"' AND Erscheinungsjahr="+String.valueOf(deljahr)+";";
  477. String sql4="DELETE FROM Medium WHERE Titel='"+deltitel+"' AND Autor='"+delautor+"' AND Genre='"+delgenre+"' AND Erscheinungsjahr="+String.valueOf(deljahr)+";";*/
  478. System.out.println(sql);
  479.  
  480. System.out.println(sql2);
  481. System.out.println(sql3);
  482. System.out.println(sql4);
  483.  
  484. del(sql);
  485. del(sql2);
  486.  
  487. del(sql3);
  488. del(sql4);
  489.  
  490. mediaref(lastcom);
  491.  
  492.  
  493. }
  494.  
  495.  
  496.  
  497.  
  498. });
  499. panel.add(btnLschen);
  500.  
  501. btnHinzufgen = new JButton("Hinzufügen");
  502. btnHinzufgen.addActionListener(new ActionListener() {
  503. public void actionPerformed(ActionEvent e) {
  504.  
  505. JTextField titele = new JTextField();
  506. JTextField autore = new JTextField();
  507. JTextField jahre = new JTextField();
  508. JTextField genree = new JTextField();
  509. JTextField laengee = new JTextField();
  510. JTextField FSK = new JTextField();
  511. JLabel fskl = new JLabel("FSK (DVD)");
  512. String [] sels= {"Buch","CD","DVD"};
  513. JComboBox select = new JComboBox(sels);
  514. select.setSelectedIndex(0);
  515.  
  516.  
  517.  
  518. final JComponent[] inputs = new JComponent[] {
  519. new JLabel("Titel"),
  520. titele,
  521. new JLabel("Autor"),
  522. autore,
  523. new JLabel("Erscheinungsjahr"),
  524. jahre,
  525. new JLabel("Genre"),
  526. genree,
  527. new JLabel("Art"),
  528. select,
  529. new JLabel("Länge"),
  530. laengee,
  531. fskl,
  532. FSK
  533.  
  534. };
  535. /*if (select.getSelectedIndex()!=2){
  536. fskl.setVisible(false);
  537. FSK.setVisible(false);}*/
  538. System.out.println(1);
  539. int re = JOptionPane.showConfirmDialog(null, inputs, "Suche Medium", JOptionPane.OK_CANCEL_OPTION);
  540. if(re != JOptionPane.OK_OPTION) return;
  541. String blubb="','";
  542. String blb="',";
  543. int i=getlastid();
  544. i++;
  545. int err=0;
  546. String com ="INSERT INTO Medium (ID,Titel,Autor,Genre,Erscheinungsjahr) VALUES("
  547. +i+",'"
  548. +titele.getText()+blubb
  549. +autore.getText()+blubb
  550. +genree.getText()+blb
  551. +jahre.getText()+");";
  552. String com2="";
  553. if (titele.getText().length()<1 | autore.getText().length()<1 | genree.getText().length()<1 | jahre.getText().length()<1 | laengee.getText().length()<1){
  554. JOptionPane.showMessageDialog(null, "Fehlerhafte Eingabe", "Warning.", JOptionPane.ERROR_MESSAGE);
  555. System.out.println(2);
  556.  
  557. err=1;
  558.  
  559. }
  560. else if (select.getSelectedIndex()==2 && FSK.getText().length()<1){
  561. JOptionPane.showMessageDialog(null, "Fehlerhafte Eingabe", "Warning.", JOptionPane.ERROR_MESSAGE);
  562. System.out.println(3);
  563.  
  564.  
  565. }
  566. try {
  567. int z = Integer.parseInt(jahre.getText());
  568. }
  569. catch(Exception f){
  570. if (err!=1){
  571. JOptionPane.showMessageDialog(null, "Fehlerhafte Eingabe", "Warning.", JOptionPane.ERROR_MESSAGE);}
  572. System.out.println(4);
  573.  
  574.  
  575. }
  576.  
  577. try {
  578. if (select.getSelectedIndex()==2){
  579. int z = Integer.parseInt(FSK.getText());}
  580. }
  581. catch(Exception g){
  582. if (err!=1){
  583. JOptionPane.showMessageDialog(null, "Fehlerhafte Eingabe", "Warning.", JOptionPane.ERROR_MESSAGE);}
  584. System.out.println(5);
  585.  
  586.  
  587. }
  588.  
  589. try {
  590. int z = Integer.parseInt(laengee.getText());
  591. }
  592. catch(Exception f){
  593. if (err!=1){
  594. JOptionPane.showMessageDialog(null, "Fehlerhafte Eingabe", "Warning.", JOptionPane.ERROR_MESSAGE);}
  595. System.out.println(6);
  596.  
  597.  
  598. }
  599.  
  600. if (select.getSelectedIndex()==0){
  601. com2="INSERT INTO Buch (ID,Seitenzahl) VALUES("+i+","+laengee.getText()+");";
  602. }
  603. else if (select.getSelectedIndex()==1){
  604. com2="INSERT INTO CD (ID,Lauflänge) VALUES("+i+","+laengee.getText()+");";
  605. }
  606. else if (select.getSelectedIndex()==2){
  607. com2="INSERT INTO DVD (ID,Lauflänge,FSK) VALUES("+i+","+laengee.getText()+",'"+FSK.getText()+"');";
  608. }
  609. System.out.println(com);
  610. System.out.println(com2);
  611.  
  612. try
  613. {
  614. del(com);
  615. del(com2);
  616.  
  617. /*
  618. Connection dp;
  619. java.sql.Statement stmt;
  620. dp=DriverManager.getConnection( "jdbc:ucanaccess://" + pfad);
  621. stmt = dp.createStatement();
  622. ResultSet result = stmt.executeQuery(com);
  623. //int i=0;
  624. System.out.println(com);
  625. while (result.next()){
  626.  
  627. }
  628. */
  629. /*while(result.next()){
  630. System.out.println("Test");
  631. //md.addRow(new Object[]{"","","","",""});
  632.  
  633. //md.addRow(new Object[] { result.getString("Titel"), result.getString("Autor"), result.getString("Genre"), result.getInt("Erscheinungsjahr"), ""});
  634. }*/
  635. //System.out.println(com);
  636.  
  637.  
  638.  
  639.  
  640. }
  641. catch (Exception e1)
  642. {
  643. //System.out.println("resr")
  644. ; JOptionPane.showMessageDialog(null, "Fehlerhafte Eingabe", "Warning.", JOptionPane.ERROR_MESSAGE);
  645. System.out.println(7);
  646.  
  647. e1.printStackTrace();
  648. }
  649.  
  650.  
  651.  
  652. mediaref(lastcom);
  653. }
  654. });
  655. panel.add(btnHinzufgen);
  656.  
  657. JScrollPane scrollPane = new JScrollPane();
  658.  
  659. btnNewButton = new JButton("Datenbank wählen");
  660. btnNewButton.addActionListener(new ActionListener() {
  661. public void actionPerformed(ActionEvent e) {
  662. JFileChooser fileChooser = new JFileChooser();
  663. final JComponent[] choose = new JComponent[] {
  664. fileChooser
  665. };
  666. int returnVal = fileChooser.showOpenDialog(verwa.this);
  667.  
  668. if (returnVal == JFileChooser.APPROVE_OPTION) {
  669. pfad = fileChooser.getSelectedFile().getAbsolutePath();
  670. tabbedPane.setVisible(true);
  671.  
  672. ext=1;
  673. if (tabbedPane.getSelectedIndex()==0){
  674. mediaall();
  675. }
  676. else if (tabbedPane.getSelectedIndex()==1){
  677. kundeall();
  678. }
  679. //This is where a real application would open the file.
  680. //log.append("Opening: " + file.getName() + "." + newline);
  681. } else {
  682. //log.append("Open command cancelled by user." + newline);
  683. }
  684.  
  685.  
  686.  
  687. }
  688. });
  689. GroupLayout gl_contentPane = new GroupLayout(contentPane);
  690. gl_contentPane.setHorizontalGroup(
  691. gl_contentPane.createParallelGroup(Alignment.LEADING)
  692. .addGroup(gl_contentPane.createSequentialGroup()
  693. .addGroup(gl_contentPane.createParallelGroup(Alignment.LEADING)
  694. .addComponent(tabbedPane, GroupLayout.PREFERRED_SIZE, 782, GroupLayout.PREFERRED_SIZE)
  695. .addGroup(gl_contentPane.createSequentialGroup()
  696. .addGap(12)
  697. .addComponent(scrollPane, GroupLayout.PREFERRED_SIZE, 758, GroupLayout.PREFERRED_SIZE))
  698. .addGroup(gl_contentPane.createSequentialGroup()
  699. .addContainerGap()
  700. .addComponent(btnNewButton)))
  701. .addContainerGap(GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  702. );
  703. gl_contentPane.setVerticalGroup(
  704. gl_contentPane.createParallelGroup(Alignment.LEADING)
  705. .addGroup(gl_contentPane.createSequentialGroup()
  706. .addComponent(tabbedPane, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
  707. .addGap(18)
  708. .addComponent(scrollPane, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
  709. .addGap(18)
  710. .addComponent(btnNewButton)
  711. .addContainerGap(GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  712. );
  713.  
  714. panel_1 = new JPanel();
  715. tabbedPane.addTab("Kunden", null, panel_1, null);
  716.  
  717. btnSuche_1 = new JButton("Suche");
  718. btnSuche_1.addActionListener(new ActionListener() {
  719. public void actionPerformed(ActionEvent e) {
  720. JTextField vornamee = new JTextField();
  721. JTextField nachnamee = new JTextField();
  722. JTextField strassee = new JTextField();
  723. JTextField orte = new JTextField();
  724. JTextField plze = new JTextField();
  725. JTextField gebe = new JTextField();
  726.  
  727.  
  728. /*java.util.Date datenow = Calendar.getInstance().getTime();
  729. SpinnerDateModel smb = new SpinnerDateModel(datenow, null, null, Calendar.HOUR_OF_DAY);
  730. SPIN_DATE.setModel(smb);
  731. JSpinner.DateEditor d = new JSpinner.DateEditor(SPIN_DATE, "dd-MMM-yyyy");
  732. SPIN_DATE.setEditor(d);*/
  733.  
  734.  
  735.  
  736. final JComponent[] inputs = new JComponent[] {
  737. new JLabel("Vorname"),
  738. vornamee,
  739. new JLabel("Nachname"),
  740. nachnamee,
  741. new JLabel("Straße"),
  742. strassee,
  743. new JLabel("Ort"),
  744. orte,
  745. new JLabel("PLZ"),
  746. plze,
  747. new JLabel("Geburtsdatum"),
  748. gebe
  749. //TODO geburtsdatum jSpinner
  750.  
  751. };
  752. /*if (select.getSelectedIndex()!=2){
  753. fskl.setVisible(false);
  754. FSK.setVisible(false);}*/
  755. System.out.println(1);
  756. int re = JOptionPane.showConfirmDialog(null, inputs, "Kundensuche", JOptionPane.OK_CANCEL_OPTION);
  757. if(re != JOptionPane.OK_OPTION) return;
  758.  
  759. String ka ="SELECT Vorname, Nachname, Straße, Ort, PLZ, Geburtsdatum FROM Kunde WHERE Vorname!='XXX'";
  760. if (vornamee.getText().length()>0){
  761. ka+=" AND Vorname LIKE '%"+vornamee.getText()+"%' ";
  762. }
  763. else if (nachnamee.getText().length()>0){
  764. ka+=" AND Nachname LIKE '%"+nachnamee.getText()+"%' ";
  765. }
  766. else if (strassee.getText().length()>0){
  767. ka+=" AND Straße LIKE '%"+strassee.getText()+"%' ";
  768. }
  769. else if (orte.getText().length()>0){
  770. ka+=" AND Ort LIKE '%"+orte.getText()+"%' ";
  771. }
  772. else if (plze.getText().length()>0){
  773. ka+=" AND PLZ LIKE '%"+plze.getText()+"%' ";
  774. }
  775. //TODO Nach Geburtsdatum suchen
  776. ka+=";";
  777. lastcom=ka;
  778. System.out.println(ka);
  779. md.setRowCount(0);
  780. kunderef(ka);
  781.  
  782.  
  783.  
  784.  
  785. }
  786. });
  787. panel_1.add(btnSuche_1);
  788.  
  789. btnLschen_1 = new JButton("Löschen");
  790. btnLschen_1.addActionListener(new ActionListener() {
  791. public void actionPerformed(ActionEvent e) {
  792.  
  793. int row=table.getSelectedRow();
  794. String delvorname = (String) table.getValueAt(row, 0);
  795. String delnachname = (String) table.getValueAt(row, 1);
  796. String delstrasse = (String) table.getValueAt(row, 2);
  797. String delort = (String) table.getValueAt(row, 3);
  798. String delplz = (String) table.getValueAt(row, 4);
  799.  
  800. //System.out.println(deltitel);}
  801. String sql="DELETE FROM Kunde WHERE Vorname ='"
  802. +delvorname+"' AND Nachname='"
  803. +delnachname+"' AND Straße='"
  804. +delstrasse+"' AND Ort='"
  805. +delort+"' AND PLZ='"
  806. +delplz+"';"
  807. ;
  808.  
  809. /* String sql2="DELETE FROM CD WHERE ID IN (SELECT ID FROM Medium "+
  810. "WHERE Titel='"+deltitel+"' AND Autor='"+delautor+"' AND Genre='"+delgenre+"' AND Erscheinungsjahr="+String.valueOf(deljahr)
  811. +");";
  812.  
  813. String sql3="DELETE FROM DVD WHERE ID IN (SELECT ID FROM Medium "+
  814. "WHERE Titel='"+deltitel+"' AND Autor='"+delautor+"' AND Genre='"+delgenre+"' AND Erscheinungsjahr="+String.valueOf(deljahr)
  815. +");";
  816. String sql4="DELETE FROM Medium WHERE Titel='"+deltitel+"' AND Autor='"+delautor+"' AND Genre='"+delgenre+"' AND Erscheinungsjahr="+String.valueOf(deljahr)+";";
  817. */
  818.  
  819.  
  820.  
  821.  
  822.  
  823. /*String sql2="DELETE FROM CD WHERE Medium.ID = Buch.ID AND Titel='"+deltitel+"' AND Autor='"+delautor+"' AND Genre='"+delgenre+"' AND Erscheinungsjahr="+String.valueOf(deljahr)+";";
  824. String sql3="DELETE FROM DVD WHERE Medium.ID = Buch.ID AND Titel='"+deltitel+"' AND Autor='"+delautor+"' AND Genre='"+delgenre+"' AND Erscheinungsjahr="+String.valueOf(deljahr)+";";
  825. String sql4="DELETE FROM Medium WHERE Titel='"+deltitel+"' AND Autor='"+delautor+"' AND Genre='"+delgenre+"' AND Erscheinungsjahr="+String.valueOf(deljahr)+";";*/
  826. System.out.println(sql);
  827.  
  828. // System.out.println(sql2);
  829. //System.out.println(sql3);
  830. //System.out.println(sql4);
  831.  
  832. del(sql);
  833. //mediadel(sql2);
  834.  
  835. //mediadel(sql3);
  836. //mediadel(sql4);
  837. System.out.println(lastcom);
  838. kunderef(lastcom);
  839.  
  840.  
  841. }
  842. });
  843. panel_1.add(btnLschen_1);
  844.  
  845. btnHinzufgen_1 = new JButton("Hinzufügen");
  846. btnHinzufgen_1.addActionListener(new ActionListener() {
  847. public void actionPerformed(ActionEvent arg0) {
  848. //TODO Input dialog for Kunden
  849.  
  850.  
  851. //TODO Make SQL COMMAND
  852. }
  853. });
  854. panel_1.add(btnHinzufgen_1);
  855.  
  856.  
  857. scrollPane.setViewportView(table);
  858. contentPane.setLayout(gl_contentPane);
  859. }
  860. }
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!