Guest User

Untitled

a guest
Nov 30th, 2018
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.30 KB | None | 0 0
  1. public class App {
  2. private JButton button_msg;
  3. private JPanel panelName;
  4. private JButton btnLoadData;
  5. private JTable JTable_Articles;
  6.  
  7. public App() {
  8. button_msg.addActionListener(new ActionListener() {
  9. @Override
  10. public void actionPerformed(ActionEvent e) {
  11. JOptionPane.showConfirmDialog(null, "Hello");
  12. }
  13. });
  14. btnLoadData.addActionListener(new ActionListener() {
  15. @Override
  16. public void actionPerformed(ActionEvent e) {
  17.  
  18. try {
  19. DefaultTableModel model = (DefaultTableModel)JTable_Articles.getModel();
  20. String[] columnNames = { "Nummer", "Vater"};
  21. ArrayList<Artikel> list= GetArtikelList();
  22. Object[] data = new Object[2];
  23. model.addColumn("Col1");
  24. model.addColumn("Col2");
  25.  
  26. for (Artikel st : list) {
  27. data[0] = st.nummer;
  28. data[1] = st.vater;
  29. model.addRow(data);
  30. }
  31.  
  32. } catch (Exception f) {
  33. JOptionPane.showMessageDialog(null,f);
  34. }
  35. }
  36. });
  37. }
  38.  
  39. public static void main(String[] args) {
  40. JFrame jf = new JFrame("App");
  41. jf.setContentPane(new App().panelName);
  42. jf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
  43. jf.pack();
  44. jf.setVisible(true);
  45. }
  46.  
  47. public ArrayList<Artikel> GetArtikelList() {
  48.  
  49. ArrayList<Artikel> ArtikelList = new ArrayList<>();
  50. try {
  51.  
  52. Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  53. String url="jdbc:sqlserver://localhost:1433;databaseName=MyDb;user=sa;password=XXX";
  54. Connection con = DriverManager.getConnection(url);
  55. String query = "SELECT * FROM MyTable";
  56. Statement st = con.createStatement();
  57. ResultSet rs = st.executeQuery(query);
  58. Artikel art;
  59. while(rs.next()){
  60. art = new Artikel(rs.getString("Nummer"), rs.getString("Vater"));
  61. ArtikelList.add(art);
  62. }
  63.  
  64. } catch (Exception e) {
  65. JOptionPane.showMessageDialog(null,e);
  66. }
  67.  
  68. return ArtikelList;
  69. }
  70. }
Add Comment
Please, Sign In to add comment