Main Activity Class
ConnectionClass connectionClass;
EditText fname, lname, username, password;
Button btn_signup;
ProgressBar pbbar;
String firstname, lastname, userid, pw;
Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
connectionClass = new ConnectionClass();//the class file
fname = (EditText) findViewById(R.id.fname);
lname = (EditText) findViewById(R.id.lname);
username = (EditText) findViewById(R.id.username);
password = (EditText) findViewById(R.id.password);
btn_signup = (Button) findViewById(R.id.btn_signup);
pbbar = (ProgressBar) findViewById(R.id.progressBar);
pbbar.setVisibility(View.GONE);
btn_signup.setOnClickListener(new View.OnClickListener() {
Override
public void onClick(View v) {
firstname = fname.getText().toString();
lastname = lname.getText().toString();
userid = username.getText().toString();
pw = password.getText().toString();
DoSignUp doSignUp = new DoSignUp();
doSignUp.execute("");
}
});
}
public class DoSignUp extends AsyncTask<String,String,String>
{
String message = "";
Boolean isSuccess = false;
Override
protected void onPreExecute() {
pbbar.setVisibility(View.VISIBLE);
}
Override
protected void onPostExecute(String r) {
pbbar.setVisibility(View.GONE);
Toast.makeText(MainActivity.this, r, Toast.LENGTH_SHORT).show();
if(isSuccess) {
Toast.makeText(MainActivity.this, r, Toast.LENGTH_SHORT).show();
}
}
Override
protected String doInBackground(String... params) {
if(firstname.trim().equals("")) {
message = "Please enter First Name!";
}
else if(lastname.trim().equals("")){
message = "Please enter Last Name!";
}
else if(userid.trim().equals("")){
message = "Please enter Username!";
}
else if(pw.trim().equals("")){
message = "Please enter Password!";
}
else
{
try {
Connection con = connectionClass.CONN();
if (con == null) {
message = "Error in connection with SQL server";
} else {
String query = "select * from TBL_USER where username='" + userid + "'";
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(query);
if(rs.next())
{
message = "Username "+ userid +" Already Exists!";
isSuccess = false;
}
else
{
String query1 = "insert into TBL_USER (username,password,firstname,lastname) values('"+userid+"','"+pw+"','"+firstname+"','"+lastname+"')";
PreparedStatement stmt1 = con.prepareStatement(query1);
stmt1.executeUpdate();
message = "Sign Up Successfull " + firstname + " " + lastname;
isSuccess = true;
}
}
}
catch (Exception ex)
{
isSuccess = false;
message = "Exceptions";
}
}
return message;
}
}
}