Closed Web service api connect to android studio

[aeganjoshua]

Baka my naka encounter na sa inyo . share your codes

 

[zach0104]

Bigyan nalang ktia ng idea boss. Yung web services created by other platform like visual studio WEB API or WCF. Then after creating your own web api. Connect mo sa android mo, using RESTful API. Search mo nalang yung RESTful for java.

 

[aeganjoshua]

nag try na ko gamit web service kapag sa browser pa lang sya nkaka input ng database pero kapag inilagay ko na yung webservice sa android . halimbawa crud then success ang pag create then kapag ni titingnan ko na sa database d na kikita . ano kaya problem kapag ganon ?

 

[zach0104]

Tignan mo yung posting mo mismo sa android studio. Tama ba sya? Try mo kaya lagyan ng try catch. Much better kung ipost mo yung code mo on how you post your data to your web service.

 

[aeganjoshua]

sge d na ba kailangan pang ipublish yon ? hanapin ko muna kung d ko mahanap code ako ulit ng bago.

 

[aeganjoshua]

Ms sql server ko sya icconnect e online

 

[aeganjoshua]

tsaka my nakita ako sa github na web service yon lng ginamit ko , okay lang ba yon ?

 

[zach0104]

Kahit anong database engine pa gamit mo, okay lang yan. Basta yung web service ay na access yung database server mo. Usually, dinedeploy ko yung web service kasama ng database server ko.

 

[aeganjoshua]

my gnwa ako ngayon yung jdbc . yung web service ko na delete ko files e

 

[aeganjoshua]

baka nagttry kna din nito baka matulungan mo ko

 

[aeganjoshua]

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;
}
}
}

 

[aeganjoshua]

Connection Class

public class ConnectionClass {

String ip = "192.168.137.147:1433";
String db = "RegistrationForm";
String un = "admin";
String password = "sa";

@SuppressLint("NewApi")
public Connection CONN() {
StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();
StrictMode.setThreadPolicy(policy);
Connection conn = null;
String ConnURL = null;

try {
Class.forName("net.sourceforge.jtds.jdbc.Driver");
ConnURL = "jdbc:jtds:sqlserver://" + ip + "/" + db+ ";user=" + un + ";password=" + password + ";";

conn = DriverManager.getConnection(ConnURL);

}catch (SQLException se)
{
Log.e("error here 1 : ", se.getMessage());
}
catch (ClassNotFoundException e)
{
Log.e("error here 2 : ", e.getMessage());
}
catch (Exception e)
{
Log.e("error here 3 : ", e.getMessage());
}

return conn;
}
}

 

[aeganjoshua]

eto yung output

 

[zach0104]

Parang hindi naman web services ang ginawa mo. Direct connection sa database yan, which is not recommended.

 

[PHC-Rafael]

You do not have permission to view the full content of this post. Log in or register now.

 

[aeganjoshua]

Parang hindi naman web services ang ginawa mo. Direct connection sa database yan, which is not recommended.

oo jdbc yan . nawala yung code ko dito sa computer. haha d ko ata na backup. ggwa nlng ako ng bagong web service

 

[aeganjoshua]

You do not have permission to view the full content of this post. Log in or register now.

ano po yan sir ?