Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public class App {
- private JButton button_msg;
- private JPanel panelName;
- private JButton btnLoadData;
- private JTable JTable_Articles;
- public App() {
- button_msg.addActionListener(new ActionListener() {
- @Override
- public void actionPerformed(ActionEvent e) {
- JOptionPane.showConfirmDialog(null, "Hello");
- }
- });
- btnLoadData.addActionListener(new ActionListener() {
- @Override
- public void actionPerformed(ActionEvent e) {
- try {
- DefaultTableModel model = (DefaultTableModel)JTable_Articles.getModel();
- String[] columnNames = { "Nummer", "Vater"};
- ArrayList<Artikel> list= GetArtikelList();
- Object[] data = new Object[2];
- model.addColumn("Col1");
- model.addColumn("Col2");
- for (Artikel st : list) {
- data[0] = st.nummer;
- data[1] = st.vater;
- model.addRow(data);
- }
- } catch (Exception f) {
- JOptionPane.showMessageDialog(null,f);
- }
- }
- });
- }
- public static void main(String[] args) {
- JFrame jf = new JFrame("App");
- jf.setContentPane(new App().panelName);
- jf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
- jf.pack();
- jf.setVisible(true);
- }
- public ArrayList<Artikel> GetArtikelList() {
- ArrayList<Artikel> ArtikelList = new ArrayList<>();
- try {
- Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
- String url="jdbc:sqlserver://localhost:1433;databaseName=MyDb;user=sa;password=XXX";
- Connection con = DriverManager.getConnection(url);
- String query = "SELECT * FROM MyTable";
- Statement st = con.createStatement();
- ResultSet rs = st.executeQuery(query);
- Artikel art;
- while(rs.next()){
- art = new Artikel(rs.getString("Nummer"), rs.getString("Vater"));
- ArtikelList.add(art);
- }
- } catch (Exception e) {
- JOptionPane.showMessageDialog(null,e);
- }
- return ArtikelList;
- }
- }
Add Comment
Please, Sign In to add comment