Hi
i m new in java trying to do a small form for creating rows..
i have a next button to scroll all my database
everytimes i run it i have the first record then it says null
please find my code for this issue

private void AfficherStagiaire(){   

    try {
        Class.forName("com.mysql.jdbc.Driver");
    } catch (ClassNotFoundException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
     try {
        conn = DriverManager.getConnection("jdbc:mysql://localhost/cabinet","root","root");
    } catch (SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
     Statement sqlState = null;
    try {
        sqlState = conn.createStatement();
    } catch (SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
     String selectStuff = "Select * from customer";
    // ResultSet rows = null;
    try {
        rows = sqlState.executeQuery(selectStuff);
    } catch (SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
    try {
          if(rows.next()){
                                 nombre=rows.getInt("custnum");
                                 trading=rows.getString("tradingname");
                                 over=rows.getString("overshop");
                                 cab=rows.getString("cabinet");
                                 addr=rows.getString("address");
                                 c1=rows.getString("contact1");
                                 c2=rows.getString("contact2"); 
                                 ph=rows.getString("phone");
                                 m=rows.getString("model");
                                 as=rows.getString("asset"); 
                                 cre=rows.getString("cr");
                                 mr=rows.getString("modelr");
                                 asr=rows.getString("assetr");
                                 mot=rows.getString("motif");

                               // num.setToolTipText(nombre).tostring();
                                num.setText(String.valueOf(nombre));//seatsTF.setText(String.valueOf(e.Age()));
                                name.setText(trading);
                                shop.setText(over);
                                address.setText(addr);
                                person1.setText(c1);
                                person2.setText(c2);
                                person3.setText(ph);
                                //cabine.setText(cab);
                                model.setText(m);
                                asset.setText(as);
                               // ((JComboBox) cr).setToolTipText(cre);
                                modelr.setText(mr);
                                assetr.setText(asr);
                                motif_1.setText(mot);


    }                       
    else {

            rows.previous();
           JOptionPane.showMessageDialog(null, "end of file" );  
        }

    }         catch(Exception ex)
                    {  
                    JOptionPane.showMessageDialog(null, "Error\n"+ex.getMessage() );  
                    }


    }
This article has been dead for over six months. Start a new discussion instead.