android与mysql_android+eclipse+mysql+servlet(Android与mysql建立链接)

packagezhu.com.printitem;importandroid.content.Intent;importandroid.support.v7.app.AppCompatActivity;importandroid.os.Bundle;importandroid.util.Log;importandroid.view.View;importandroid.widget.Button;importandroid.widget.EditText;importandroid.widget.Toast;importcom.loopj.android.http.AsyncHttpClient;importcom.loopj.android.http.JsonHttpResponseHandler;importcom.loopj.android.http.RequestParams;importorg.json.JSONException;importorg.json.JSONObject;importcz.msebera.android.httpclient.Header;importzhu.com.printitem.util.HttpUtil;public class LoginActivity extends AppCompatActivity implementsView.OnClickListener {

Button btn_login,btn_register;

EditText et_accountnumber,et_passwrod;

AsyncHttpClient m_HttpClient;

@Overrideprotected voidonCreate(Bundle savedInstanceState) {super.onCreate(savedInstanceState);

setContentView(R.layout.a_login);

m_HttpClient= newAsyncHttpClient();

btn_login=(Button) findViewById(R.id.kj_login_btn);

btn_register=(Button) findViewById(R.id.kj_register_btn);

et_accountnumber=(EditText) findViewById(R.id.kj_accountnumber_edittext);

et_passwrod=(EditText) findViewById(R.id.kj_password_edittext);

btn_login.setOnClickListener(this);

btn_register.setOnClickListener(this);

}public voidconnectionURL(String id, String pw){/*这里192.168.191.2==》表示你当前使用的网络ip，还有如果是真机运行那么手机必须要链接你自个的电脑的wifi，这样才能保证在同一个网络ID地址

* 171023_printting==》你在eclipse创建的项目名称

* zhu/LoginServlet==》表示在eclipse的web.xml配置servlet的地址

**/String url="http://192.168.191.2:8080/171023_printting/zhu/LoginServlet";

RequestParams params= new RequestParams(); //绑定参数

params.put("ID",id);

params.put("PW",pw);

HttpUtil.get(url,params,newJsonHttpResponseHandler(){

@Overridepublic void onSuccess(intstatusCode, Header[] headers, JSONObject response) {if (statusCode==200){try{if(response.getBoolean("msg")==true){

Toast.makeText(LoginActivity.this, "登录成功", Toast.LENGTH_SHORT).show();

}else{

Toast.makeText(LoginActivity.this, "登录失败！", Toast.LENGTH_SHORT).show();

}

}catch(JSONException e) {

e.printStackTrace();

}

}

}

});

}

@Overridepublic voidonClick(View v) {switch(v.getId()) {//登陆

caseR.id.kj_login_btn:

Intent it0=newIntent();

it0.setClass(LoginActivity.this,MainInterfaceActivity.class);

String uid=et_accountnumber.getText().toString().trim();

String pw=et_passwrod.getText().toString().trim();

connectionURL(uid,pw);//startActivity(it0);

break;caseR.id.kj_register_btn:

Intent it=newIntent();

it.setClass(LoginActivity.this,RegisterActivity.class);

startActivity(it);break;

} ;

}

}//子进程

/*new Thread(new Runnable() {

@Override

public void run() {

}

}).start();*/

/*HttpUtil.get(url,params, new AsyncHttpResponseHandler(){

@Override

public void onSuccess(int statusCode, Header[] headers, byte[] responseBody) {

try {

JSONObject jsonObject = new JSONObject(new String(responseBody));

JSONArray jsonArray = jsonObject.getJSONArray("msg");

Log.v("Code",jsonArray+"");

} catch (JSONException e) {

e.printStackTrace();

}

}

@Override

public void onFailure(int statusCode, Header[] headers, byte[] responseBody, Throwable error) {

Toast.makeText(LoginActivity.this, "链接eclipse失败", Toast.LENGTH_SHORT).show();

}

});

**/