Android環境下使用JCFXBL API介面操作資料庫

Android環境下使用JCFXBL API介面操作資料庫

 

文檔整理：王強

 

http://blog.csdn.net/ex_net/article/details/7833641

作者：張建波 郵箱： 281451020@qq.com 電話：13577062679 歡迎來電交流！

 

 

 

一、資料操作中涉及到的資料介面

 

發送請求的對象

AndroidFxBLClientAPI FxBL = new AndroidFxBLClientAPI(url);

其中url=”伺服器位址”+資料介面。

 

處理返回請求的對象

         FxBLResponse response = new FxBLResponse(res);

 

在相應資料庫中建立一張表（如）

測試資料

 

 

二、安卓GUI介面操作

2.1 把資料查詢到TextBox等控制項內

（1）查詢介面

（2）查詢時用的預存程序

ALTER proc [dbo].[ACT_TEST_GET_KHXX](@KHBH nvarchar(100),@return_msg nvarchar(100)output,@return_value int output)as beginselect * from T_AD_TEST where KHBH=@KHBHset @return_msg=''set @return_value=1end

（3）UI查詢事件掛接

findViewById(R.id.btnOK).setOnClickListener(new OnClickListener() {public void onClick(View v) {//查詢用的地址String url ="http://169.254.1.30:8088/";url=url+"GetDbStore.ashx?act=ACT_TEST_GET_KHXX¶ms=1&formId=F0102"//綁定到請求中的Handler對象，Handler handler = new Handler() {public void handleMessage(Message message) {switch (message.what) {case HttpConnection.DID_START: {break;}case HttpConnection.DID_SUCCEED: {doFxBLCallBack((String) message.obj);break;}case HttpConnection.DID_ERROR: {break;}}}};//發送請求的對象AndroidFxBLClientAPI FxBL = new AndroidFxBLClientAPI(url);//添加與預存程序中對應的參數FxBL.AddParam("KHBH", txtBH.getText().toString());//綁定Handler對象FxBL.BindHandler(handler);//發送請求FxBL.Request();}//串連成後的處理方法private void doFxBLCallBack(String res) {//處理返回請求的對象FxBLResponse response = new FxBLResponse(res);//存放返回的資料ArrayList<HashMap<String,String>> list=response.GetArrayList();if (list != null) {//賦值txtKHXM.setText(list.get(0).get("KHMC"));txtZJLX.setText(list.get(0).get("ZJLX"));txtZJH.setText(list.get(0).get("ZJH"));txtLXDH.setText(list.get(0).get("LXDH"));}}});

2.2 把資料查詢到ListView中

（1）查詢介面

（2）查詢用的預存程序

create proc [dbo].[ACT_AD__KHXX](@KHBH nvarchar(100),@limit int,@start int,@totalcount int output)as beginselect @totalcount=count(*) from T_AD_TEST where KHBH like '%'+@KHBHselect * from T_AD_TEST where KHBH like '%'+@KHBHend

（3）UI事件掛接

findViewById(R.id.btnJS).setOnClickListener(new OnClickListener() {public void onClick(View v) {// TODO Auto-generated method stubString url ="http://169.254.1.30:8088/";url=url+"GetDbStoreByPage.ashx?act=ACT_AD__KHXX¶ms=3&formId=F0201"Handler handler = new Handler() {public void handleMessage(Message msg) {switch (msg.what) {case HttpConnection.DID_START: {break;}case HttpConnection.DID_SUCCEED: {Log.i("DID_SUCCEED", ""+ HttpConnection.DID_SUCCEED);doFxBLCallBack((String) msg.obj);break;}case HttpConnection.DID_ERROR: {Log.i("tetst", "test");break;}}super.handleMessage(msg);}};AndroidFxBLClientAPI FxBL = new AndroidFxBLClientAPI(url);FxBL.AddParam("KHBH", txtBH.getText().toString());FxBL.AddParam("start", "0");FxBL.AddParam("limit", "20");FxBL.BindHandler(handler);FxBL.Request();}private void doFxBLCallBack(String res) {Log.i("click", "click");FxBLResponse response = new FxBLResponse(res);Log.i("GetSuccess", response.GetReturn_msg());ArrayList<HashMap<String,String>> arrayList=response.GetArrayList();SimpleAdapter adapter=new SimpleAdapter(FxBIActivity.this, arrayList, R.layout.listview,new String[]{"KHMC","LXDH"},new int[]{R.id.txt_list_KHMC,R.id.txt_list_lxdh});listView.setAdapter(adapter);// txt.setText(list.get(9).getValue());// txt.setText(response.GetRowString(1));}});

 

2.3 資料寫入

（1）資料寫入介面

（2）相關資料表

（3）資料寫入預存程序

 alter proc ACT_AD_HTXX_ADD(@KHBH nvarchar(100),@KHMC nvarchar(100),@ZJLX nvarchar(100),@ZJH nvarchar(100),@LXDH nvarchar(100),@return_msg nvarchar(100) output,@return_value int output,@result nvarchar(100) output)as begininsert T_AD_TEST(KHBH,KHMC,ZJLX,ZJH,LXDH) values(@KHBH,@KHMC,@ZJLX,@ZJH,@LXDH)set @return_msg=''set @return_value=1set @result=''end

（4）UI事件掛接

findViewById(R.id.btnADD).setOnClickListener(new OnClickListener() {public void onClick(View v) {// TODO Auto-generated method stubString url = "http://169.254.1.30:8088/Execute.ashx?act=ACT_AD_HTXX_ADD¶ms=7&formId=F0201";Handler handler = new Handler() {public void handleMessage(Message message) {switch (message.what) {case HttpConnection.DID_START: {break;}// 串連成功後的處理case HttpConnection.DID_SUCCEED: {Log.i("DID_SUCCEED", ""+ HttpConnection.DID_SUCCEED);doFxBLCallBack((String) message.obj);break;}case HttpConnection.DID_ERROR: {break;}}}};AndroidFxBLClientAPI FxBL = new AndroidFxBLClientAPI(url);Log.i("KHBH", "" + txtBH.getText().toString());//這個兩個參數是必須的，而且必須在其他參數前添加FxBL.AddParam("sys_username", "admin");FxBL.AddParam("sys_password", "123456");==============FxBL.AddParam("KHBH", txtBH.getText().toString());FxBL.AddParam("KHMC", txtKHXM.getText().toString());FxBL.AddParam("ZJLX", txtZJLX.getText().toString());FxBL.AddParam("ZJH", txtZJH.getText().toString());FxBL.AddParam("LXDH", txtLXDH.getText().toString());FxBL.BindHandler(handler);FxBL.Request();}private void doFxBLCallBack(String res) {Log.i("click", "click");FxBLResponse response = new FxBLResponse(res);Log.i("GetSuccess", response.GetReturn_msg());}});

2.4 小結

   資料刪除、修改和添加的操作類似。

 

三、總結

   通過JCFXBL平台API，Android下的應用程式可以很方便的訪問JCFXBL平台的資料庫（如MS SQL、Oracle、MySQL等等）