I am just familiar with Android development. I am currently performing the registration function in the Android client. Now I just want to pass the username and password to the JSP page. But when I tried in my application, it seems that it did not pass the value to JSP.
Android:
public class RegisterActivity extends Activity {
String url = "http://101.78.175.101:20281/test/useradd.jsp";
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
try {
setContentView(R.layout.registeractivity);
HttpClient client = new DefaultHttpClient();
HttpPost post = new HttpPost(url);
List<NameValuePair> pairs = new ArrayList<NameValuePair>();
pairs.add(new BasicNameValuePair("uid", "hardik"));
pairs.add(new BasicNameValuePair("pwd", "trivedi"));
post.setEntity(new UrlEncodedFormEntity(pairs));
client.execute(post);
TextView mail = (TextView) findViewById(R.id.Register_mail);
mail.setText("hello");
} catch (Exception e) {
e.printStackTrace();
}
}
}
JSP Code:
<%@ page import="java.sql.*" %>
<%
String connectionURL = "jdbc:mysql://localhost:3306/xxx";
Connection connection = null;
Statement statement = null;
int insert_flag = 0 ;
%>
<html>
<body>
<%
String insert_sql ;
String usermail, password;
usermail=request.getParameter("uid");
password=request.getParameter("pwd");
Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager.getConnection(connectionURL, "xxx", "xxx");
statement = connection.createStatement();
insert_sql = "insert into user ( usermail, userpassword ) values ( '" + usermail + "' , '" + password + "')" ;
insert_flag = statement.executeUpdate( insert_sql );
if ( insert_flag > 0 ) out.println("record inserted") ;
%>
</body>
</html>
source
share