Java RSS Java RSS

Registering system, Unwanted behavior

Please support our Java advertiser: Programming Forums - DaniWeb Sister Site
Reply

•
•
Join Date: Jul 2009
Posts: 36
Reputation: Silvershaft is an unknown quantity at this point 
Solved Threads: 0
Silvershaft Silvershaft is offline Offline
Light Poster

Registering system, Unwanted behavior

 
0
  #1
Aug 22nd, 2009
Hello, I've made registering system to my little test program, It works well until you try to create two accounts with same name, It shouldn't allow it but it still does it. I have tried to solve this problem all day now by trying diffrent methods but sadly nothing helped. So if any of you geniuses could help me out.

Java Syntax (Toggle Plain Text) 
  1. /*
  2.  * To change this template, choose Tools | Templates
  3.  * and open the template in the editor.
  4.  */
  5.  
  6. /*
  7.  * Regform.java
  8.  *
  9.  * Created on 21.8.2009, 14:29:46
  10.  */
  11.  
  12. /**
  13.  *
  14.  * @author Samuli
  15.  */
  16.  
  17. import java.sql.*;
  18. import java.util.logging.Level;
  19. import java.util.logging.Logger;
  20.  
  21. public class Regform extends javax.swing.JFrame {
  22.  
  23.     /** Creates new form Regform */
  24.     public Regform() {
  25.         initComponents();
  26.         this.setLocation(800, 400);
  27.         this.setTitle("Registeration");
  28.         this.setResizable(false);
  29.     }
  30.  
  31.  
  32.     /** This method is called from within the constructor to
  33.      * initialize the form.
  34.      * WARNING: Do NOT modify this code. The content of this method is
  35.      * always regenerated by the Form Editor.
  36.      */
  37.     @SuppressWarnings("unchecked")
  38.  
  39.     public static boolean Cancreate = true;
  40.  
  41.     // <editor-fold defaultstate="collapsed" desc="Generated Code">                          
  42.     private void initComponents() {
  43.  
  44.         jSeparator1 = new javax.swing.JSeparator();
  45.         jLabel1 = new javax.swing.JLabel();
  46.         jLabel2 = new javax.swing.JLabel();
  47.         jLabel3 = new javax.swing.JLabel();
  48.         jLabel4 = new javax.swing.JLabel();
  49.         jLabel5 = new javax.swing.JLabel();
  50.         Password = new javax.swing.JPasswordField();
  51.         Name = new javax.swing.JTextField();
  52.         Key = new javax.swing.JTextField();
  53.         Proceed = new javax.swing.JButton();
  54.         Cancel = new javax.swing.JButton();
  55.         Status = new javax.swing.JLabel();
  56.  
  57.         setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  58.  
  59.         jLabel1.setText("Registeration");
  60.  
  61.         jLabel2.setText("Welcome to registeration if you don't know what to do, go away");
  62.  
  63.         jLabel3.setText("Username:");
  64.  
  65.         jLabel4.setText("Password:");
  66.  
  67.         jLabel5.setText("Registeration Key:");
  68.  
  69.         Proceed.setText("Proceed");
  70.         Proceed.addActionListener(new java.awt.event.ActionListener() {
  71.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  72.                 ProceedActionPerformed(evt);
  73.             }
  74.         });
  75.  
  76.         Cancel.setText("Cancel");
  77.         Cancel.addActionListener(new java.awt.event.ActionListener() {
  78.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  79.                 CancelActionPerformed(evt);
  80.             }
  81.         });
  82.  
  83.         Status.setText("Status text");
  84.  
  85.         javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  86.         getContentPane().setLayout(layout);
  87.         layout.setHorizontalGroup(
  88.             layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  89.             .addGroup(layout.createSequentialGroup()
  90.                 .addGap(44, 44, 44)
  91.                 .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  92.                     .addGroup(layout.createSequentialGroup()
  93.                         .addComponent(jLabel5)
  94.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  95.                         .addComponent(Key, javax.swing.GroupLayout.PREFERRED_SIZE, 236, javax.swing.GroupLayout.PREFERRED_SIZE))
  96.                     .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
  97.                         .addGroup(javax.swing.GroupLayout.Alignment.LEADING, layout.createSequentialGroup()
  98.                             .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
  99.                                 .addGroup(javax.swing.GroupLayout.Alignment.LEADING, layout.createSequentialGroup()
  100.                                     .addComponent(jLabel3)
  101.                                     .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  102.                                     .addComponent(Name))
  103.                                 .addGroup(javax.swing.GroupLayout.Alignment.LEADING, layout.createSequentialGroup()
  104.                                     .addComponent(jLabel4)
  105.                                     .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  106.                                     .addComponent(Password, javax.swing.GroupLayout.PREFERRED_SIZE, 93, javax.swing.GroupLayout.PREFERRED_SIZE)))
  107.                             .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  108.                             .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
  109.                                 .addComponent(Cancel, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  110.                                 .addComponent(Proceed, javax.swing.GroupLayout.DEFAULT_SIZE, 91, Short.MAX_VALUE)))
  111.                         .addComponent(jLabel2, javax.swing.GroupLayout.Alignment.LEADING)))
  112.                 .addContainerGap(61, Short.MAX_VALUE))
  113.             .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
  114.                 .addContainerGap()
  115.                 .addComponent(jLabel1)
  116.                 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  117.                 .addComponent(jSeparator1, javax.swing.GroupLayout.PREFERRED_SIZE, 356, javax.swing.GroupLayout.PREFERRED_SIZE))
  118.             .addGroup(layout.createSequentialGroup()
  119.                 .addGap(104, 104, 104)
  120.                 .addComponent(Status, javax.swing.GroupLayout.DEFAULT_SIZE, 320, Short.MAX_VALUE)
  121.                 .addContainerGap())
  122.         );
  123.         layout.setVerticalGroup(
  124.             layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  125.             .addGroup(layout.createSequentialGroup()
  126.                 .addGap(16, 16, 16)
  127.                 .addComponent(Status)
  128.                 .addGap(2, 2, 2)
  129.                 .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
  130.                     .addComponent(jSeparator1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  131.                     .addComponent(jLabel1))
  132.                 .addGap(18, 18, 18)
  133.                 .addComponent(jLabel2)
  134.                 .addGap(27, 27, 27)
  135.                 .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  136.                     .addComponent(jLabel3)
  137.                     .addComponent(Name, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  138.                     .addComponent(Proceed))
  139.                 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  140.                 .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  141.                     .addComponent(jLabel4)
  142.                     .addComponent(Cancel)
  143.                     .addComponent(Password, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  144.                 .addGap(18, 18, 18)
  145.                 .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  146.                     .addComponent(jLabel5)
  147.                     .addComponent(Key, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  148.                 .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  149.         );
  150.  
  151.         pack();
  152.     }// </editor-fold>                        
  153.  
  154.     @SuppressWarnings("empty-statement")
  155.     private void ProceedActionPerformed(java.awt.event.ActionEvent evt) {                                        
  156.  
  157.  
  158.         Connection con = null;
  159.  
  160.         try {
  161.         Class.forName("com.mysql.jdbc.Driver");
  162.         } catch(Exception e) {
  163.             return;
  164.         }
  165.  
  166.         try {
  167.  
  168. 		 con = DriverManager.getConnection("jdbc:mysql://MY IP/breakpoint","root", "Secret");
  169.                  Statement st = con.createStatement ();
  170.                  Statement stm = con.createStatement();
  171.                  Statement st2 = con.createStatement();
  172.                  st.executeQuery("SELECT Users.Username,Users.Password,Avaimet.Avainrekisteriin FROM Users INNER JOIN Avaimet ");
  173.                  ResultSet rss = st.getResultSet();
  174.  
  175.                  String Accname = Name.getText();
  176.                  String Accpass = Password.getText();
  177.                  String Regkey = Key.getText();
  178.                  boolean Created = false;
  179.  
  180.                  while ( rss.next() )
  181.                  {
  182.                      String name = rss.getString("Username");
  183.                      String key = rss.getString("Avainrekisteriin");
  184.  
  185.  
  186.                      if (Accname.length() <= 3)
  187.                          Status.setText("Your account name has to be longer than 3 letters");
  188.  
  189.                      else if (Accpass.length() <= 3)
  190.                          Status.setText("Your account password has to be longer than 3 letters");
  191.  
  192.  
  193.  
  194.                          if ( Created == false && Accname.equalsIgnoreCase(name) && Regkey.equalsIgnoreCase(key)  )
  195.                          {
  196.                             String Deletekey = "DELETE FROM Avaimet WHERE Avainrekisteriin = '"+key+"'";
  197.                             String StrSQL = "INSERT INTO Users (Username,Password,Banned,Level,Admin) " +
  198.                                     "VALUES ('"+Accname+"','"+Accpass+"',"+0+",'3','0')";
  199.                             stm.executeUpdate(StrSQL);
  200.                             st2.executeUpdate(Deletekey);
  201.                             Created = true;
  202.                             System.out.print("ACC CREATED");
  203.                             Status.setText("Account created!");
  204.                             Form1.Status.setText("Account created!");
  205.                             this.dispose();
  206.  
  207.                          }
  208.                          else
  209.                          {
  210.                             Status.setText("Something failed!");
  211.                          }
  212.  
  213.                  }
  214.  
  215.  
  216.                  st.close();
  217.                  rss.close();
  218.  
  219.  
  220.  
  221.  
  222.  
  223. 	  } catch (SQLException e) {
  224. 	    System.out.println("Connection Failed! Check output console");
  225. 	    e.printStackTrace();
  226. 	    return;
  227. 	  }
  228.     }                                       
  229.  
  230.     private void CancelActionPerformed(java.awt.event.ActionEvent evt) {                                       
  231.         this.dispose();
  232.     }                                      
  233.  
  234.     /**
  235.     * @param args the command line arguments
  236.     */
  237.     public static void main(String args[]) {
  238.         java.awt.EventQueue.invokeLater(new Runnable() {
  239.             public void run() {
  240.                 new Regform().setVisible(true);
  241.             }
  242.         });
  243.     }
  244.  
  245.     // Variables declaration - do not modify                     
  246.     private javax.swing.JButton Cancel;
  247.     private javax.swing.JTextField Key;
  248.     private javax.swing.JTextField Name;
  249.     private javax.swing.JPasswordField Password;
  250.     private javax.swing.JButton Proceed;
  251.     private javax.swing.JLabel Status;
  252.     private javax.swing.JLabel jLabel1;
  253.     private javax.swing.JLabel jLabel2;
  254.     private javax.swing.JLabel jLabel3;
  255.     private javax.swing.JLabel jLabel4;
  256.     private javax.swing.JLabel jLabel5;
  257.     private javax.swing.JSeparator jSeparator1;
  258.     // End of variables declaration                   
  259.  
  260. }

I think that maybe that INNER JOIN affects it somehow, I tried with left and right but then it gives sql error. Im hopeless.
By the way if you need to test the program in it self add me in msn samppa.l@hotmail.com.
Last edited by Silvershaft; Aug 22nd, 2009 at 4:35 pm.
Reply With Quote Quick reply to this message  
•
•
Join Date: Jun 2008
Posts: 46
Reputation: zyaday is an unknown quantity at this point 
Solved Threads: 1
zyaday zyaday is offline Offline
Light Poster

Re: Registering system, Unwanted behavior

 
0
  #2
Aug 28th, 2009
hi, i could not test your program because it did not compile..but i think your problem could be in compairing objects rather than their values.
if ( Created == false && Accname.equalsIgnoreCase(name) && Regkey.equalsIgnoreCase(key) )

i think your problem could be in this line..here you are comparing if the two objects(in this case Accname and name) are the same object. You should try comparing the values. An '==' operator would do that.
Hope this helpss
Reply With Quote Quick reply to this message  
•
•
Join Date: Jul 2009
Posts: 36
Reputation: Silvershaft is an unknown quantity at this point 
Solved Threads: 0
Silvershaft Silvershaft is offline Offline
Light Poster

Re: Registering system, Unwanted behavior

 
0
  #3
Aug 28th, 2009
I will try it and it didn't compile because it takes values from other file I have.
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the Java Forum
Thread Tools Search this Thread



account android api applet application array arrays automation bidirectional binary birt bluetooth chat class classes client code columns component data database designadrawingapplicationusingjavajslider draw eclipse editor error errors event exception expand fractal game givemetehcodez graphics gui guidancer homework html ide image inetaddress inheritance input integer intellij j2me java javaprojects jlabel jme jni jpanel jtextfield julia linux list loop map method methods midlethttpconnection mobile mobiledevelopmentcreatejar monitoring myaggfun netbeans newbie nullpointerexception open-source plazmic print problem program programming project property recursion ria scanner screen search server set size sms smsspam sort sourcelabs splash sql sqlite static string subclass support swing testautomation threads tree windows
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC