[ad_1]
\n<\/p>\n
If you wanna use the database as centralized then it should be a server but not Local DB.
\nLocal db can be accessible within the device as we all know and the below can help you to handle the server.<\/p>\n
Step 1:<\/strong> First buy a server in either GoDaddy or 000webhost.com(Free server will be available)<\/p>\n step 2:<\/strong> Create a database and make some tables which matches your requirement.<\/p>\n step 3:<\/strong> Remaining all coding and integrating part is in this Url This is the basic API for the starters, keep going.<\/p>\n Android API integration using Java servlet<\/p>\n Step 1:<\/strong> Download Eclipse EE(Express Edition) or Add Eclipse EE plugin to your Existing Eclipse<\/p>\n Step 2:<\/strong> In your Eclipse go to File > New > Project > Web > Dynamic Web Project > next. <\/p>\n Step 3:<\/strong> Name your Project and select Apache Tomcat v7.0 as the target runtime and click finish. <\/p>\n Step 4:<\/strong> Now right click on project > New > Other > Web > Servelt. Name the Servlet as your wish.<\/p>\n Step 5:<\/strong> As an Example I placed here two multiply the number with 2<\/p>\n Step 6:<\/strong> Right click on Servlet project > Run as > Run on Server. Run on Server Dialog should pop up. Select “Manually define a new server” and also Tomcat v7.0 under server type.” Before that make sure your tomcat server is up and running. Open your web browser and type http:\/\/localhost:8080<\/a>. You should see a default page displayed by tomcat server. <\/p>\n And below is the sample code, you should call your servlet file from your android app like this mentioned way<\/p>\n Refer the below link for complete reference
\nAndroid Php connect<\/a><\/p>\nimport java.io.IOException;\nimport java.io.OutputStreamWriter;\n\nimport javax.servlet.ServletException;\nimport javax.servlet.ServletInputStream;\nimport javax.servlet.annotation.WebServlet;\nimport javax.servlet.http.HttpServlet;\nimport javax.servlet.http.HttpServletRequest;\nimport javax.servlet.http.HttpServletResponse;\n\n@WebServlet(\"\/DoubleMeServlet\")\npublic class DoubleMeServlet extends HttpServlet {\n private static final long serialVersionUID = 1L;\n\n public DoubleMeServlet() {\n super();\n\n }\n\n protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {\n\n response.getOutputStream().println(\"Hurray !! This Servlet Works\");\n\n }\n\n protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {\n\n try {\n int length = request.getContentLength();\n byte[] input = new byte[length];\n ServletInputStream sin = request.getInputStream();\n int c, count = 0 ;\n while ((c = sin.read(input, count, input.length-count)) != -1) {\n count +=c;\n }\n sin.close();\n\n String recievedString = new String(input);\n response.setStatus(HttpServletResponse.SC_OK);\n OutputStreamWriter writer = new OutputStreamWriter(response.getOutputStream());\n\n Integer doubledValue = Integer.parseInt(recievedString) * 2;\n\n writer.write(doubledValue.toString());\n writer.flush();\n writer.close();\n\n\n\n } catch (IOException e) {\n try{\n response.setStatus(HttpServletResponse.SC_BAD_REQUEST);\n response.getWriter().print(e.getMessage());\n response.getWriter().close();\n } catch (IOException ioe) {\n }\n } \n }\n\n}\n<\/code><\/pre>\npackage com.app.myapp;\n\nimport java.io.BufferedReader;\nimport java.io.InputStreamReader;\nimport java.io.OutputStreamWriter;\nimport java.net.URL;\nimport java.net.URLConnection;\nimport android.app.Activity;\nimport android.os.Bundle;\nimport android.util.Log;\nimport android.view.View;\nimport android.view.View.OnClickListener;\nimport android.widget.Button;\nimport android.widget.EditText;\n\npublic class DoubleMeActivity extends Activity implements OnClickListener {\n\n EditText inputValue=null;\n Integer doubledValue =0;\n Button doubleMe;\n\n @Override\n public void onCreate(Bundle savedInstanceState) {\n super.onCreate(savedInstanceState);\n setContentView(R.layout.calculate);\n\n inputValue = (EditText) findViewById(R.id.inputNum);\n doubleMe = (Button) findViewById(R.id.doubleme);\n\n doubleMe.setOnClickListener(this);\n }\n\n @Override\n public void onClick(View v) {\n\n switch (v.getId()){\n case R.id.doubleme:\n\n new Thread(new Runnable() {\n public void run() {\n\n try{\n URL url = new URL(\"http:\/\/10.0.2.2:8080\/MyServletProject\/DoubleMeServlet\");\n URLConnection connection = url.openConnection();\n\n String inputString = inputValue.getText().toString();\n \/\/inputString = URLEncoder.encode(inputString, \"UTF-8\");\n\n Log.d(\"inputString\", inputString);\n\n connection.setDoOutput(true);\n OutputStreamWriter out = new OutputStreamWriter(connection.getOutputStream());\n out.write(inputString);\n out.close();\n\n BufferedReader in = new BufferedReader(new InputStreamReader(connection.getInputStream()));\n\n String returnString=\"\";\n doubledValue =0;\n\n while ((returnString = in.readLine()) != null) \n {\n doubledValue= Integer.parseInt(returnString);\n }\n in.close();\n\n\n runOnUiThread(new Runnable() {\n public void run() {\n inputValue.setText(doubledValue.toString());\n\n }\n });\n\n }catch(Exception e)\n {\n Log.d(\"Exception\",e.toString());\n }\n\n }\n }).start();\n\n break;\n }\n } \n }\n<\/code><\/pre>\n
\nConnect android app with servlet<\/a><\/p>\n<\/p><\/div>\n