CellulaS's Profile User Rating: -----

Reputation: 0 Apprentice
Group:
Active Members
Active Posts:
67 (0.06 per day)
Joined:
19-June 12
Profile Views:
642
Last Active:
User is offline Apr 23 2015 08:05 PM
Currently:
Offline

Previous Fields

Dream Kudos:
0
Icon   CellulaS has not set their status

Posts I've Made

  1. In Topic: how to view pdf in php ?

    Posted 22 Apr 2015

    thanks kindly closed my database was just broken silly me
  2. In Topic: confuse on how to delete two table?

    Posted 11 Apr 2015

    thanks alot but im still confused on how to delete two table what im trying to say its im trying to delete. im trying to delete admin here tbl_admin. while im trying to delete the position of the admin here.tbl_user im seems i cant really tell on how to delete the two table?
  3. In Topic: got question how to use validation if user exists?

    Posted 6 Apr 2015

    here are my query my problem is whenever i put them in my code save button they all pop up even if the user does not exists need of help



    private void validatetransaction()
    {   String sql = "";
         String trans_id = txt_transaction.getText();
         String lastname =txt_lastname.getText();     
        try{
    
            sql += "select * FROM tbl_loan WHERE  trans_id='"+trans_id+"'";
            prst = conn.prepareStatement(sql);
            rs = prst.executeQuery();            
    
           if(rs.next()){
               JOptionPane.showMessageDialog(this, "Username already in exist!", "Exist", JOptionPane.ERROR_MESSAGE);
    
           } else {
    
    
           }
            
        }catch(Exception e){
                
            }finally{
                try{
                    rs.close();
                    prst.close();
                }catch(Exception e){
    
                }
             }
    }
    
     private void validatelastname(){
         String sql = "";
         String lastname =txt_lastname.getText();   
         
         try{
    
            sql += "select * FROM tbl_loan WHERE  lastname='"+lastname+"'";
            prst = conn.prepareStatement(sql);
            rs = prst.executeQuery();            
    
           if(rs.next()){
               JOptionPane.showMessageDialog(this, "Username already in exist!", "Exist", JOptionPane.ERROR_MESSAGE);
    
           } else {
    
    
           }
            
        }catch(Exception e){
                
            }finally{
                try{
                    rs.close();
                    prst.close();
                }catch(Exception e){
    
                }
             }
     }
        
     private void validatefirstname(){
         String sql = "";
         String firstname =txt_firstname.getText();
         
         try{
    
            sql += "select * FROM tbl_loan WHERE  firstname='"+firstname+"'";
            prst = conn.prepareStatement(sql);
            rs = prst.executeQuery();            
    
           if(rs.next()){
               JOptionPane.showMessageDialog(this, "Username already in exist!", "Exist", JOptionPane.ERROR_MESSAGE);
    
           } else {
    
    
           }
            
        }catch(Exception e){
                
            }finally{
                try{
                    rs.close();
                    prst.close();
                }catch(Exception e){
    
                }
             }
     }
     
    }
    
    
  4. In Topic: how to limit registration only 5 user

    Posted 11 Dec 2014

    Thanks i finally got it working thanks really i appreciate what you did

    was wondering is also possible doing it do while loop?
  5. In Topic: how to limit registration only 5 user

    Posted 10 Dec 2014

    how to do disable insert option im barely learning the count function

My Information

Member Title:
D.I.C Head
Age:
Age Unknown
Birthday:
Birthday Unknown
Gender:

Contact Information

E-mail:
Private

Friends

CellulaS hasn't added any friends yet.

Comments

CellulaS has no profile comments yet. Why not say hello?