fork download
copy 
  1. public boolean createTable() //tworzenie tabeli dla uzytkownika
  2.     {
  3.         String createUsers = "CREATE TABLE IF NOT EXISTS Users (id_user INTEGER PRIMARY KEY AUTOINCREMENT, login string, password string, money integer)";
  4.         try {
  5.             stat.execute(createUsers);
  6.  
  7.         } catch (SQLException e) {
  8.             System.err.println("Blad przy tworzeniu tabeli");
  9.             e.printStackTrace();
  10.             return false;
  11.         }
  12.         return true;
  13.     }
  14.  
  15.     public boolean insertUser(String login, String password,int money) // Dodawanie użytkowników do bazy
  16.     {
  17.         try {
  18.             PreparedStatement prepStmt = conn.prepareStatement(
  19.                     "insert into Users values (NULL, ?, ?, ?);");
  20.             prepStmt.setString(1, login);
  21.             prepStmt.setString(2, password);
  22.             prepStmt.setInt(3,money);
  23.  
  24.             prepStmt.execute();
  25.         } catch (SQLException e)
  26.         {
  27.             System.err.println("Blad przy wstawianiu uzytkownika");
  28.             e.printStackTrace();
  29.             return false;
  30.         }
  31.         return true;
  32.     }
  33.  
  34.  
  35.  
  36. public boolean editUser(int money, String login, String password) // "edytowanie użytkownika" a raczej pieniędzy
  37.     {
  38.         try
  39.         {
  40.             PreparedStatement prepStmt = conn.prepareStatement(
  41.                     "Update Users set money=? WHERE login='"+login+"' AND password='"+password+"'");
  42.  
  43.             prepStmt.setInt(3, money);
  44.  
  45.             prepStmt.execute();
  46.  
  47.  
  48.         } catch(SQLException e)
  49.         {
  50.             System.err.println("Blad przy edytowaniu użytkownika");
  51.             e.printStackTrace();
  52.             return false;
  53.         }
  54.         return true;
  55.     }
  56.  
  57.  
  58.     dodajKwoteButton.addActionListener(new ActionListener() //funkcja z GUI
  59.         {
  60.             public void actionPerformed(ActionEvent e)
  61.             {
  62.                 Users user=new Users();
  63.                 if(!textField1.getText().isEmpty() && !textField2.getText().isEmpty() )
  64.                 {
  65.                     int money=Integer.parseInt(textField1.getText());
  66.                     String login=textField2.getText();
  67.                     String password=textField3.getText();
  68.  
  69.  
  70.                     user.editUser(money,login,password);
  71.  
  72.                     JOptionPane.showMessageDialog(null, "Dodano kwote");
  73.                     new user_screen();
  74.                     dispose();
  75.                 }
  76.                 else
  77.                 {
  78.                     JOptionPane.showMessageDialog(null, "Musisz podać kwotę do wysyłki");
  79.                 }
  80.             }
  81.         });
  82.  
  83.  
  84.         // BŁĄD KOMPLACJI //
  85.     Exception in thread "AWT-EventQueue-0" java.lang.ArrayIndexOutOfBoundsException: 2
  86. 	at org.sqlite.core.CorePreparedStatement.batch(CorePreparedStatement.java:110)
  87. 	at org.sqlite.jdbc3.JDBC3PreparedStatement.setInt(JDBC3PreparedStatement.java:291)
  88. 	at Data_base_shop.Users.editUser(Users.java:108)
  89. 	at gui.add_moneyUser$2.actionPerformed(add_moneyUser.java:53)
  90. 	at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
  91. 	at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
  92. 	at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
  93. 	at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
  94. 	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
  95. 	at java.awt.Component.processMouseEvent(Component.java:6516)
  96. 	at javax.swing.JComponent.processMouseEvent(JComponent.java:3321)
  97. 	at java.awt.Component.processEvent(Component.java:6281)
  98. 	at java.awt.Container.processEvent(Container.java:2229)
  99. 	at java.awt.Component.dispatchEventImpl(Component.java:4872)
  100. 	at java.awt.Container.dispatchEventImpl(Container.java:2287)
  101. 	at java.awt.Component.dispatchEvent(Component.java:4698)
  102. 	at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
  103. 	at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
  104. 	at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
  105. 	at java.awt.Container.dispatchEventImpl(Container.java:2273)
  106. 	at java.awt.Window.dispatchEventImpl(Window.java:2719)
  107. 	at java.awt.Component.dispatchEvent(Component.java:4698)
  108. 	at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:747)
  109. 	at java.awt.EventQueue.access$300(EventQueue.java:103)
  110. 	at java.awt.EventQueue$3.run(EventQueue.java:706)
  111. 	at java.awt.EventQueue$3.run(EventQueue.java:704)
  112. 	at java.security.AccessController.doPrivileged(Native Method)
  113. 	at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
  114. 	at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
  115. 	at java.awt.EventQueue$4.run(EventQueue.java:720)
  116. 	at java.awt.EventQueue$4.run(EventQueue.java:718)
  117. 	at java.security.AccessController.doPrivileged(Native Method)
  118. 	at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
  119. 	at java.awt.EventQueue.dispatchEvent(EventQueue.java:717)
  120. 	at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)
  121. 	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)
  122. 	at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)
  123. 	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)
  124. 	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)
  125. 	at java.awt.EventDispatchThread.run(EventDispatchThread.java:91)
  126.  
Compilation error #stdin compilation error #stdout 0s 0KB
comments (?)
stdin
copy 
Standard input is empty
compilation info 
Main.java:1: error: class, interface, or enum expected
public boolean createTable() //tworzenie tabeli dla uzytkownika
       ^
Main.java:4: error: class, interface, or enum expected
        try {
        ^
Main.java:7: error: class, interface, or enum expected
        } catch (SQLException e) {
        ^
Main.java:9: error: class, interface, or enum expected
            e.printStackTrace();
            ^
Main.java:10: error: class, interface, or enum expected
            return false;
            ^
Main.java:11: error: class, interface, or enum expected
        }
        ^
Main.java:13: error: class, interface, or enum expected
    }
    ^
Main.java:15: error: class, interface, or enum expected
    public boolean insertUser(String login, String password,int money) // Dodawanie u?ytkownik?w do bazy
           ^
Main.java:20: error: class, interface, or enum expected
            prepStmt.setString(1, login);
            ^
Main.java:21: error: class, interface, or enum expected
            prepStmt.setString(2, password);
            ^
Main.java:22: error: class, interface, or enum expected
            prepStmt.setInt(3,money);
            ^
Main.java:24: error: class, interface, or enum expected
            prepStmt.execute();
            ^
Main.java:25: error: class, interface, or enum expected
        } catch (SQLException e)
        ^
Main.java:28: error: class, interface, or enum expected
            e.printStackTrace();
            ^
Main.java:29: error: class, interface, or enum expected
            return false;
            ^
Main.java:30: error: class, interface, or enum expected
        }
        ^
Main.java:32: error: class, interface, or enum expected
    }
    ^
Main.java:36: error: class, interface, or enum expected
public boolean editUser(int money, String login, String password) // "edytowanie u?ytkownika" a raczej pieni?dzy
       ^
Main.java:43: error: class, interface, or enum expected
            prepStmt.setInt(3, money);
            ^
Main.java:45: error: class, interface, or enum expected
            prepStmt.execute();
            ^
Main.java:48: error: class, interface, or enum expected
        } catch(SQLException e)
        ^
Main.java:51: error: class, interface, or enum expected
            e.printStackTrace();
            ^
Main.java:52: error: class, interface, or enum expected
            return false;
            ^
Main.java:53: error: class, interface, or enum expected
        }
        ^
Main.java:55: error: class, interface, or enum expected
    }
    ^
Main.java:60: error: class, interface, or enum expected
            public void actionPerformed(ActionEvent e)
                   ^
Main.java:63: error: class, interface, or enum expected
                if(!textField1.getText().isEmpty() && !textField2.getText().isEmpty() )
                ^
Main.java:66: error: class, interface, or enum expected
                    String login=textField2.getText();
                    ^
Main.java:67: error: class, interface, or enum expected
                    String password=textField3.getText();
                    ^
Main.java:70: error: class, interface, or enum expected
                    user.editUser(money,login,password);
                    ^
Main.java:72: error: class, interface, or enum expected
                    JOptionPane.showMessageDialog(null, "Dodano kwote");
                    ^
Main.java:73: error: class, interface, or enum expected
                    new user_screen();
                    ^
Main.java:74: error: class, interface, or enum expected
                    dispose();
                    ^
Main.java:75: error: class, interface, or enum expected
                }
                ^
Main.java:79: error: class, interface, or enum expected
                }
                ^
Main.java:85: error: class, interface, or enum expected
    Exception in thread "AWT-EventQueue-0" java.lang.ArrayIndexOutOfBoundsException: 2
    ^
36 errors
stdout
copy 
Standard output is empty
https://ideone.com/MTKLhO
language:
Java (HotSpot 12)
created:
8 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!