'Android Java Cannot showing database table and cannot resolve method 'setText(java.sql.Date)'
I am new in android java world. Now, I'm trying to display data table from MSSQL in ArrayList to ListView in android. I'm trying to make the following code something like this in ScanResult Class;
public class FillList extends AsyncTask<String,String,String>{
String z ="";
List<Map<String,String>> prolist = new ArrayList<Map<String,String>>();
@Override
protected void onPreExecute() {
}
@Override
protected void onPostExecute(String s) {
Toast t = Toast.makeText(getApplicationContext(),s,Toast.LENGTH_SHORT);
t.show();
}
@Override
protected String doInBackground(String... strings) {
try{
ConnectionHelper connectionHelper = new ConnectionHelper();
connect = connectionHelper.connectionclass();
if(connect==null){
z ="Connection error";
} else {
String query = "SELECT LabelNo " +
", Qty " +
", Rmrks " +
", ScanDate " +
"FROM dbo.shikakarikensa " +
"WHERE CAST(ScanDate AS DATE) = CAST(GETDATE()-1 AS DATE) " +
"AND Type = 'I' " +
"ORDER BY ScanDate DESC";
PreparedStatement ps = connect.prepareStatement(query);
ResultSet rs = ps.executeQuery();
while (rs.next()){
CustomListViewValueArr.add(new ScanModel(rs.getString("LabelNo"),rs.getInt("Qty"),rs.getString("Rmrks"),rs.getString("ScanDate")));
}
z="Today's scan result list";
}
} catch (Exception ex){
z = ex.getMessage();
}
return z;
}
}
But I get an error Cannot resolve method 'setText(java.sql.Date)' in the CustomAdapter Class, which is in the line;
holder.txtscandate.setText(scanModel.getScanDate());
scanModel = null;
scanModel=(ScanModel) mList.get(position);
holder.txtlabelno.setText(scanModel.getLabelNo());
holder.txtqty.setText(scanModel.getQty());
holder.txtrmrks.setText(scanModel.getRmrks());
holder.txtscandate.setText(scanModel.getScanDate());
I tried also comment the ScanDate line but the data does not showing in the ListView. This is Model Class
public class ScanModel {
String LabelNo, Rmrks;
int Qty;
Date ScanDate;
public ScanModel(String labelno, int qty, String rmrks, Date scandate) {
LabelNo = labelno;
Qty = qty;
Rmrks = rmrks;
ScanDate = scandate;
}
public String getLabelNo() { return LabelNo; }
public int getQty() { return Qty; }
public String getRmrks() { return Rmrks; }
public Date getScanDate() { return ScanDate; }
}
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
