Why data show one row.I want show all row.Please helpme
<pre><code>    Connection conn = null;
    String url = "jdbc:jtds:sqlserver://192.168.1.11:1433/";
    String dbName = "koh;Instance=MSSQLSERVER;";
    String userName = "bit"; 
    String password = "1234";
    String driver = "net.sourceforge.jtds.jdbc.Driver";
    try {
        Class.forName(driver).newInstance();
        conn = DriverManager.getConnection(url+dbName,userName,password);
        Log.w("connect","Connect Success");
        Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery("SELECT LocalDesc FROM StaffPosition WHERE LocalDesc IN ('XXX','Administrator','Trainner')");
        String[] items44 = new String[] {};
        while (rs.next())   {  
            items44 =  new String[]{rs.getString("LocalDesc")};
        } 

        Spinner spinner = (Spinner) findViewById(R.id.spinner1);
        ArrayAdapter&lt;String&gt; adapter = new ArrayAdapter&lt;String(
                     this,android.R.layout.simple_spinner_item, items44);
            adapter.setDropDownViewResource(
                     android.R.layout.simple_spinner_dropdown_item);
        spinner.setAdapter(adapter);          
        conn.close();      
    }catch (Exception e) {       
            Log.w("can't connect",e.toString()); 
    }
}
</code></pre>

<p>data is show one row . Show XXX but not show Administrator and Trainner.
Do you like this.Pleast example to me.</p>
