I have a form in android upon submit im inserting it into database using servlet i have to show to user that form was inserted successfully. this is my application import java.io.IOException; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.sql.Connection; import java.sql.DriverManager; import java.sql.Statement; import java.util.ArrayList; public class form extends HttpServlet { String name; String password; Connection con = null; Statement stmt = null; @Override protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { try { } catch(Exception ex) { } } @Override protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { try { Class.forName("com.mysql.jdbc.Driver"); con =DriverManager.getConnection ("jdbc:mysql://localhost:3306/Login","root", ""); String nn=request.getParameter("name"); String pass=request.getParameter("pass"); String email=request.getParameter("email"); stmt=con.createStatement(); String query="insert into users values('"+nn+"','"+pass+"','"+email+"');"; int v=stmt.executeUpdate(query); ArrayList<String> arr=new ArrayList<String>(); arr.add("inserted"); System.out.println("sent response back..."); } catch(Exception ex) { } } @Override public String getServletInfo() { return "Short description"; }
this is my android app.
package org.me.loginandroid; import java.io.BufferedReader; import java.io.InputStream; import java.io.InputStreamReader; import java.util.ArrayList; import java.io.*; import org.apache.http.HttpEntity; import org.apache.http.HttpResponse; import org.apache.http.NameValuePair; import org.apache.http.client.HttpClient; import org.apache.http.client.entity.UrlEncodedFormEntity; import org.apache.http.client.methods.HttpPost; import org.apache.http.impl.client.DefaultHttpClient; import org.apache.http.message.BasicNameValuePair; import org.json.JSONArray; import org.json.JSONObject; import android.app.Activity; import android.content.Intent; import android.os.Bundle; import android.util.Log; import android.view.View; import android.view.View.OnClickListener; import android.widget.Button; import android.widget.EditText; import android.widget.TextView; import org.apache.http.client.methods.HttpGet; public class MainActivity extends Activity { @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.main); Button btn1 = (Button) findViewById(R.id.submit); btn1.setOnClickListener(listener_login); } private OnClickListener listener_login = new OnClickListener() { boolean check = false; public void onClick(View v) { EditText emailText = (EditText) findViewById(R.id.email); EditText passText = (EditText) findViewById(R.id.password); EditText nameText = (EditText) findViewById(R.id.uname); String name = nameText.getText().toString(); String email = (emailText.getText().toString()); String pass = (passText.getText().toString()); String result = ""; ArrayList<NameValuePair> nameValuePairs = new ArrayList<NameValuePair>(); nameValuePairs.add(new BasicNameValuePair("name", name)); nameValuePairs.add(new BasicNameValuePair("pass", pass)); nameValuePairs.add(new BasicNameValuePair("email", email)); try { HttpClient httpclient = new DefaultHttpClient(); HttpPost httppost = new HttpPost("http://10.0.2.2:8084/Login/form"); httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs)); HttpResponse response = httpclient.execute(httppost); HttpEntity entity = response.getEntity(); InputStream is = entity.getContent(); BufferedReader reader = new BufferedReader(new InputStreamReader(is, "iso-8859-1"), 8); StringBuilder sb = new StringBuilder(); String line = null; while ((line = reader.readLine()) != null) { sb.append(line + "\n"); } is.close(); result = sb.toString(); TextView lbl = (TextView) findViewById(R.id.lbl); lbl.setText(result); } catch (Exception e) { TextView tv = (TextView) findViewById(R.id.err); tv.setText("Error parsing data " + e.toString()); System.out.println("Error parsing data " + e.toString()); }
source share