我获取数据库并在预先执行的value.spinner中显示值。在doinbackground线程中,我要将那个Spinner值插入sqlite表中,我知道我不能在doinbackground中使用ui组件。期待您的帮助。这是我的执行前价值
try {
statement = connect.prepareStatement("exec dbo.getSalesIdtest;");
} catch (SQLException e) {
Log.e("Error 1 here: ", e.getMessage());
}
try {
rs = statement.executeQuery();
} catch (SQLException ex) {
Log.e("error 2 here: ", ex.getMessage());
}
try {
while(rs.next()) {
TextView generateData = (TextView) findViewById(R.id.getOrderid);
pab = rs.getString("CurrentNo");
generateData.setText(pab);
Log.e(pab,"Message here is");
boolean isInserted = orderDB.insertorderData(rs.getString("CurrentNo"));
if (isInserted == true)
Toast.makeText(orderChalan.this, "Data save successfully", Toast.LENGTH_LONG).show();
else
Toast.makeText(orderChalan.this, "Data not Inserted", Toast.LENGTH_LONG).show();
这是我的doinbackground中的代码
if (con == null) {
z = "Check Your Internet Access!";
} else {
String query = "insert into dbo.slsOrderD(osdSalesID,osdProductID,osdQty)values('joy','" + getRata.getString(1).toString() + "','" + getRata.getString(2).toString() + "');";
PreparedStatement preparedStatement = con.prepareStatement(query);
preparedStatement.executeUpdate();
z = "New client's data added successfully";
isSuccess = true;
}
} catch (Exception ex) {
isSuccess = false;
z = "Exceptions";
Log.e("ERRO", ex.getMessage());
}
在插入语句中,我必须从预执行微调器元素访问数据,如何解决此问题?
如果您声明要在onPreExecute()中更新的变量作为继承的Asynctask版本的类成员,那么您应该能够从doInBackground()访问它们。
据我所知,您在OnPreExecute()中将它们声明为局部变量
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句