package com.example.text01;
import static android.provider.BaseColumns._ID; //存取的id
import java.text.DecimalFormat;
import org.ksoap2.SoapEnvelope;
import org.ksoap2.serialization.SoapObject;
import org.ksoap2.serialization.SoapPrimitive;
import org.ksoap2.serialization.SoapSerializationEnvelope;
import org.ksoap2.transport.HttpTransportSE;
import static com.example.text01.DbConstants.TIME;
import static com.example.text01.DbConstants.NUMBER;
import static com.example.text01.DbConstants.WEIGHT;
import static com.example.text01.DbConstants.TABLE_NAME;
import static com.example.text01.DbConstants.SPORTNAME;
import static com.example.text01.DbConstants.URL;
import static com.example.text01.DbConstants.KOCAL;
import static com.example.text01.DbConstants.LEVE;
import static com.example.text01.DbConstants.SYS_TIME;
import android.app.Activity;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.view.Window;
import android.view.WindowManager;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.ListView;
import android.widget.SimpleCursorAdapter;
import android.widget.TextView;
public class Fragment2_1 extends Activity {
private DBHelper dbhelper = null;
private TextView result = null, listview;
private Button btnAdd = null;
private TextView number, weight, time;
String c, d;
private Long e, f;
private Button bt;
private static final String NAMESPACE = "http://tempuri.org/";
private static final String URL = "http://140.131.7.18/WebService.asmx";
private static final String SOAP_ACTION = "http://tempuri.org/up";
private static final String METHOD_NAME = "up";
String s_id = "ddddddddddddddddddddd", s_name = "0", s_time = "0",
sy_system = "0", s_karlo = "0", s_leavel = "1", flag;
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
requestWindowFeature(Window.FEATURE_NO_TITLE);
getWindow().setFlags(WindowManager.LayoutParams.FLAG_FULLSCREEN,
WindowManager.LayoutParams.FLAG_FULLSCREEN);
setContentView(R.layout.fragment2_1);
initView(); // 顯示螢幕上的東西
openDatabase(); // 開起sql
// show(); // 呼叫下面的程式,小框框
result.setText("歷史紀錄:");
bt = (Button) findViewById(R.id.bttt);
bt.setOnClickListener(new View.OnClickListener() {
public void onClick(View v) {
}});
}
@Override
protected void onDestroy() {
super.onDestroy();
closeDatabase();
}
private void openDatabase() {
dbhelper = new DBHelper(this);
}
private void closeDatabase() {
dbhelper.close();
}
private void initView() {
result = (TextView) findViewById(R.id.txtResult);
listview = (TextView) findViewById(R.id.listview);
}
private Cursor getCursor() { //
SQLiteDatabase db = dbhelper.getReadableDatabase(); // 開啟資料庫寫入資料
String[] columns = { _ID, SPORTNAME, WEIGHT, NUMBER, TIME, URL, KOCAL,
LEVE, SYS_TIME }; // 宣告columns放入以下的值
// id,name,tel,email
Cursor cursor = db.query(TABLE_NAME, columns, null, null, null, null,
null); // table
// name這是這個table的欄位,columns是對上面的string,不知道後面null是做甚麼的
startManagingCursor(cursor); // 開始執行
return cursor;
}
private void show() {
Cursor cursor = getCursor(); // 這是排序的sql的 函數
StringBuilder resultData = new StringBuilder(""); // 以下resultdata來顯示id,name,tel,email的值
while (cursor.moveToNext()) {
String id = cursor.getString(0); // 陣列1號
String sportname = cursor.getString(1); // 陣列1號
String weight = cursor.getString(2); // 陣列2號
String number = cursor.getString(3); // 陣列3號
String time = cursor.getString(4); // 陣列4號
// String url = cursor.getString(5);
String sys_time = cursor.getString(8);
String kocal = cursor.getString(6);
String leve = cursor.getString(7);
if (sys_time == null) {
} else if (weight == null || time == null) {
} else {
}
}
listview.setText(resultData); // 讓result來顯示文字(值為resultData)
}
public void SN(){
Thread networkThread = new Thread() {
@Override
public void run() {
SoapObject request = new SoapObject(NAMESPACE,
METHOD_NAME);
request.addProperty("s_id", s_id);
request.addProperty("s_name", s_name);
request.addProperty("s_time", s_time);
request.addProperty("sy_system", sy_system);
request.addProperty("s_karlo", s_karlo);
request.addProperty("s_name", s_name);
request.addProperty("s_leavel", s_leavel);
SoapSerializationEnvelope envelope = new SoapSerializationEnvelope(
SoapEnvelope.VER11);
envelope.dotNet = true;
envelope.setOutputSoapObject(request);
HttpTransportSE androidHttpTransport = new HttpTransportSE(
URL);
Log.i("myApp", "!!!!!!!!!!!!!!!!!!!!!");
try {
/** 開始呼叫 Web Service */
androidHttpTransport.call(SOAP_ACTION, envelope);
SoapPrimitive response = (SoapPrimitive) envelope
.getResponse();
flag = response.toString();
Log.i("myApp", response.toString());
} catch (Exception e) {
e.printStackTrace();
}
}
};
networkThread.start();
}
}
這是我的程式碼。 如果show()斜線弄掉後運行就會錯誤??
但是如果不加sn(),show()斜線弄掉就不會錯...
不知道錯在哪...
請幫幫我> < |