Android : How do fetch multiple rows from calling store procedure in android app?

on Thursday, September 18, 2014


i am trying to fetch multiple records form calling store procedure in eclipse framework for android development but in resultset one record is showing if am using select query instead of store procedure its work properly



public void query1()
{
Log.i("Android"," MySQL Connect");
Connection conn = null;
try {
String driver = "net.sourceforge.jtds.jdbc.Driver";
StrictMode.ThreadPolicy policy =new StrictMode.ThreadPolicy.Builder().permitAll().build();
StrictMode.setThreadPolicy(policy);

Class.forName(driver).newInstance();

conn = DriverManager.getConnection(connString);

String PKey= getIntent().getExtras().getString("SearchText");

Log.d("Connection","open");
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);

//ResultSet reset = stmt.executeQuery("select varOrderNo +'-'+ varBuyerStyleNo as StyleNo from tmpStyleNo WHERE varvendorkey= '"+PKey+"'");
String procName = "{call USPW_TNAPendingForUpdationNEW(?)}";

CallableStatement cs = conn.prepareCall(procName);
cs.setString(1, PKey);
ResultSet reset = cs.executeQuery();**

Log.d("Connection","1");
int v=MainActivity.getRowCount(reset);


String[] a=new String[v];
int count=0;
while(reset.next()){

a[count]=reset.getString(1);
count++;
// Log.w("Data",reset.getString(2));
}

conn.close();
Log.d("Connection","2");
ArrayAdapter<String> adapter=new ArrayAdapter<String>(this,android.R.layout.simple_spinner_item,a);
sp.setAdapter(adapter);
sp.setOnItemSelectedListener(this);


} catch (Exception e)
{

Log.d("Error connection","" + e.getMessage());
}
}

0 comments:

Post a Comment