Java code for Android App inserting&uploading data to MYSQL

Question

How would you make a java code for an image like this?

That is from an Android emulator. I'm trying to input post data information into each slot and upload the information to a MySQL database.

This is the code so far:

public class Registration extends Activity {

    TextView Taccount,Tpassword,Tfirst,Tlast,Temail,Tlocation,Tdescription;
    EditText Eaccount,Epassword,Efirst,Elast,Eemail,Elocation,Edescription;
    Button btnCreate;
    String page="";
    /** Called when the activity is first created. */
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);

        setContentView(R.layout.activity_cappuccino);
        btnCreate = (Button) findViewById(R.id.btnGen);
        Taccount = (TextView) findViewById(R.id.txtAccountID);
        Eaccount = (EditText) findViewById(R.id.editAccountID);
        Tpassword = (TextView) findViewById(R.id.txtPassword);
        Epassword = (EditText) findViewById(R.id.editPassword);
        Tfirst = (TextView) findViewById(R.id.txtFirst);
        Efirst = (EditText) findViewById(R.id.editFirst);
        Tlast = (TextView) findViewById(R.id.txtLast);
        Elast = (EditText) findViewById(R.id.editLast);
        Temail = (TextView) findViewById(R.id.txtEmail);
        Eemail = (EditText) findViewById(R.id.editEmail);
        Tlocation = (TextView) findViewById(R.id.txtLocation);
        Elocation = (EditText) findViewById(R.id.editLocation);
        Tdescription = (TextView) findViewById(R.id.txtDescription);
        Edescription = (EditText) findViewById(R.id.editDescription);

        btnCreate.setOnClickListener(new Button.OnClickListener()
        {
            public void onClick(View v)
            {
                examineJSONFile();
            }
        });
    }
    public boolean onCreateOptionsMenu(Menu menu) {
        getMenuInflater().inflate(R.menu.activity_cappuccino, menu);
        return true;
    }

    void examineJSONFile()
    {
        try
        {
            JSONObject object=new JSONObject();
            object.put("Account ID", Eaccount.getText());
            object.put("Password", Epassword.getText());
            object.put("First Name", Efirst.getText());
            object.put("Last Name", Elast.getText());
            object.put("Email", Eemail.getText());
            object.put("Location", Elocation.getText());
            object.put("Description", Edescription.getText());
            String str=object.toString();
            executeHttpPost(str);
            Log.i("JsonString :", str);
            Toast.makeText(this, "Json Objects are : " + str,Toast.LENGTH_LONG).show();


        }
        catch (Exception je)
        {

        }
    }

    public  void executeHttpPost(String string) throws Exception 
    {
        //This method  for HttpConnection  
        try 
        {
            HttpClient client = new DefaultHttpClient();

            HttpPost request = new HttpPost("http://localhost:8080/example/database/Cappuccino.sql");

            List<NameValuePair> value=new ArrayList<NameValuePair>();

            value.add(new BasicNameValuePair("Account ID",string));

            UrlEncodedFormEntity entity=new UrlEncodedFormEntity(value);

            request.setEntity(entity);

            client.execute(request);

           System.out.println("after sending :"+request.toString());

        } 
     catch(Exception e)     {System.out.println("Exp="+e);
        }

    }


}

Thanks in advance!

So...What exactly are you asking? What have you tried? what research have you done? What is not working? — 0gravity
– 0gravity, Commented Aug 11, 2012 at 4:50
Hi, Ed. In order to get useful assistance it's usually better to provide a specific question or set of questions, the work that you've already performed to answer them, and a description of your roadblocks. If you're having trouble getting started try working through some of the Android development tutorials. developer.android.com/training/index.html — Carth
– Carth, Commented Aug 11, 2012 at 4:53

Rahmathullah M · Accepted Answer · 2012-08-11 05:28:30Z

0

One way to accomplish this through is using Webservice. You have to create webservice to access MySQL database. It can be created using php, jsp, etc.

We pass the values to webservice using internet connection.

webservice processes this data and gives back the response.

http://www.codeproject.com/Articles/112381/Step-by-Step-Method-to-Access-Webservice-from-Andr

This link can help you to learn how to do this..

edited Aug 11, 2012 at 5:28

answered Aug 11, 2012 at 4:54

Rahmathullah M

2,7162 gold badges29 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Rahmathullah M Over a year ago

Oh,well... thank you. should i remove the answer or delete the answer as whole?

Community · Accepted Answer · 2017-05-23 12:07:15Z

0

There are a variety of ways that you could do this.

One approach (probably the simplest) would be to use JDBC and a suitable JDBC driver to access the database directly from your Android app; e.g. as described in this question Using SQL (JDBC) database in Android. (This assumes that you understand how to use SQL and JDBC ... but these are standard technologies, and you need to understand them if you are going to do anything serious using a MySQL database from Java.)

Another approach would be to create some kind of wrapper service for the database, but this seems unnecessarily complicated to me if you just want to upload data without any additional validation or processing.

edited May 23, 2017 at 12:07

CommunityBot

11 silver badge

answered Aug 11, 2012 at 5:33

Stephen C

723k95 gold badges849 silver badges1.3k bronze badges

Collectives™ on Stack Overflow

Java code for Android App inserting&uploading data to MYSQL

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related