How to retrieve data from SQL Database in web service using Android?

Hello Friends,
Myself Prashant.

Me giving u WebService Example for Android.

Part - 1:
In this part I giving small demo for webservice running in Android device.
From this link you can find this example. Where I give Comment for webservice demo.
Please all of you check it.
http://lukencode.com/2010/04/27/calling-web-services-in-android-using-httpclient/#comment-179

Part - 2: Webservice running in Android with database connectivity
Now I am running database connectivity and return value from database and showing in Android device.
Here i m using Microsoft SQL connectivity. You can use your way.
For that u have to download this file
SQL connectivity jar file for webservice:
http://www.4shared.com/file/IxoPooiE/sqljdbc.html
Ksoap Library File for android project.
http://www.4shared.com/file/uOhx5aoj/ksoap2-android-assembly-24-jar.html

This is good example for you all.

First We create Dynamic Project usign Eclipse
Add this package and class.
Package Name: org.webservice.pa
Class Name : GetDatabaseRecords.java
and also create once class for bean.(Setter-Getter Property).
Class Name : BookData.java


BookData.java

package org.webservice.pa;

public class BookData {
public String bookCode;
public String bookName;
public String authorName;

public String getBookCode() {
return bookCode;
}
public void setBookCode(String bookCode) {
this.bookCode = bookCode;
}
public String getBookName() {
return bookName;
}
public void setBookName(String bookName) {
this.bookName = bookName;
}
public String getAuthorName() {
return authorName;
}
public void setAuthorName(String authorName) {
this.authorName = authorName;
}

}


GetDatabaseRecords.java

package org.webservice.pa;
public class GetDatabaseRecords{

public BookData[] getBookDetails{
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
ArrayList bookDataList = new ArrayList();
BookData bookData = null;
try
{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");//Driver Name
con = DriverManager.getConnection("connectionUrl");//connection URL
stmt = con.createStatement();
rs = stmt.executeQuery("select * from BookDetails");//Table Name
while (rs.next())
{
bookData= new BookData();
bookData.setBookCode(rs.getString("bookCode"));
bookData.setBookName(rs.getString("bookName"));
bookData.setAuthorName(rs.getString("authorName"));
bookDataList.add(bookData);
}
}catch (Exception e)
{
e.printStackTrace();
}
finally {
try {
rs.close();
} catch(Exception e) {}
try {
stmn.close();
} catch(Exception e) {}
try {
con.close();
} catch(Exception e) {}
}
return (BookData[])bookDataList.toArray(new BookData[bookDataList.size()]);
}
}

Now Right click on GetDatabaseRecords.java file and select "WebService" option.
Now further step is same as posted my Part 1:
Click finish.
and test your service it will return BookData object.
Here our Dynamic WebProject task is completed.


Now you want to create Android Project for calling above WebService.
Now u add "ksoap" library File in android project:
Download from here:
http://www.4shared.com/file/uOhx5aoj/ksoap2-android-assembly-24-jar.html

public class MainActivity extends Activity {
private String METHOD_NAME = "getBookDetails"; // our webservice method name
private String NAMESPACE = "http://pa.webservice.org"; // Here package name in webservice with reverse order.
private String SOAP_ACTION = NAMESPACE + METHOD_NAME; // NAMESPACE + method name
private static final String URL = "http://192.168.1.1:8080/WebServiceDemo/services/GetDatabaseRecords?wsdl"; // you must use ipaddress here, don't use Hostname or localhost

public void onCreate(Bundle icicle)
{
super.onCreate(icicle);
setContentView(R.layout.main);
TextView tv = (TextView) findViewById(R.id.txtsearch);
try
{
SoapObject request = new SoapObject(NAMESPACE, METHOD_NAME);
SoapSerializationEnvelope envelope = new SoapSerializationEnvelope(SoapEnvelope.VER11);
envelope.setOutputSoapObject(request);
HttpTransportSE androidHttpTransport = new HttpTransportSE(URL);
androidHttpTransport.call(SOAP_ACTION,envelope);
SoapObect so = (SoapObject)envelope.bodyIn;

System.out.println("Counter: "+so.getPropertyCount());

for(int i =0; i < so.getPropertyCount(); i++){
SoapObject soap = (SoapObject) so.getProperty(i);
System.out.println("BookCode :: "+ soap.getProperty("bookCode"));
System.out.println("BookName :: "+ soap.getProperty("bookName"));
System.out.println("AuthorName :: "+ soap.getProperty("authorName"));
}

tv.setText(so.toString());
} catch (Exception E) {
E.printStackTrace();
tv.setText("ERROR:" + E.getClass().getName() + ": " + E.getMessage());
}
}
}


Now you can run your project and it's work fine
:)

And if you have any doubt just tell me.


Thanks & Regards,
Prashant Adesara.

How to add two values using Webservice in Android

I am running webservice successfully.
I am giving sample code will help you.

first create Dynamic Web project using eclipse.
and create one class : Converter.java
This class place under this package: org.web.example

package org.web.example

public class Converter {
public int sum(int i, int j) {
return (i + j);
}
}

now select Converter.java file and do right click and

New–> Other–> Web Services–> and select Web Service
There are two option
1. Web Service Type
2. Client Type
in first point you have to select slider as a Start

Service:
and in second point you have to select slider as a Test

Client
and click on Finish button.

You web Service will run automatically. Just check your

webservice will work properly or not.

Main Steps:
Now most important thing is you have to download ksoap2

jar file
download from here
http://www.4shared.com/file/uOhx5aoj/ksoap2-android-

assembly-24-jar.html

Now Create Android Project
and copy paste this code

import org.ksoap2.SoapEnvelope;
import org.ksoap2.serialization.SoapObject;
import

org.ksoap2.serialization.SoapSerializationEnvelope;
import org.ksoap2.transport.AndroidHttpTransport;

import android.app.Activity;
import android.os.Bundle;
import android.widget.TextView;

public class MainActivity extends Activity {
private String METHOD_NAME = “sum”; // our

webservice method name
private String SOAP_ACTION =

“http://example.web.org/” + METHOD_NAME; // here your

package name in webservice but in reverse order + method

name
private String NAMESPACE =

“http://example.web.org”; // Here package name in

webservice with reverse order.
private static final String URL =

“http://192.168.1.2:8787/WebServiceDemo/services/Convert

er?wsdl”; // you must use ipaddress here, don’t use

Hostname or localhost

@Override
public void onCreate(Bundle icicle) {
super.onCreate(icicle);
setContentView(R.layout.main);

((TextView) findViewById

(R.id.txtsearch)).setText(“Hello”);
try {
SoapObject request = new

SoapObject(NAMESPACE, METHOD_NAME);

request.addProperty(“i”, 5);
request.addProperty(“j”, 15);
SoapSerializationEnvelope

envelope = new SoapSerializationEnvelope

(SoapEnvelope.VER11);
envelope.dotNet = true;
envelope.setOutputSoapObject

(request);

AndroidHttpTransport

androidHttpTransport = new AndroidHttpTransport(URL);
androidHttpTransport.call

(SOAP_ACTION,envelope);

Object result =

envelope.getResponse();
System.out.println(“Result : ” +

result.toString());
((TextView) findViewById

(R.id.txtsearch)).setText(result.toString());

} catch (Exception E) {
E.printStackTrace();
((TextView) findViewById

(R.id.txtsearch)).setText(“ERROR:”
+ E.getClass

().getName() + “: ” + E.getMessage());
}
}

And run it will give sum of two value

Thanks & Regards,

Prashant Adesara

Welcome to my Blog

Hello Friends.