connecting SQL database to android

Question

I am a new at Android apps. I want to connect the eclipse to SQL Server database. I created a database using Sql Server 2005 and use it in my website which implemented using asp.NET. Now I want to use the same database in my Android application because the the website and the application are linked together. I googled how to connect thee android with the sql database and I found that I should download (mysql-connector-java-5.1.18.jar) and include it into my project libraries using Build Path. I downloaded it but I don't know how to access to my sql database now?!

Answer 1

First of all, You will need to add a jar file to your project library as SQL Server 2000 Driver for JDBC Service. My target is SQL Server 2000, it will require the jar file called “sqljdbc4.jar”. This is not supported on Microsoft website now, you can download it here. For other versions of SQL Server, here is the link of SQL Server 2000 Driver for JDBC Service.

The following is the code for connection MS SQL Server and select some records from a testing table.

import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Main {
public static void main(String[] args) throws SQLException, ClassNotFoundException 
   {
    Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");  
    Connection conn = DriverManager.getConnection("jdbc:sqlserver://HOSP_SQL1.company.com;user=name;password=abcdefg;database=Test");
    System.out.println("test");
    Statement sta = conn.createStatement();
    String Sql = "select * from testing_table";
    ResultSet rs = sta.executeQuery(Sql);
    while (rs.next()) {
        System.out.println(rs.getString("txt_title"));
    }
}
}

Answer 2

Use PHP script to connect SQL server.

Create PHP script and upload it into your FTP server. call the PHP file URL from your android application

Try below link.

connect to MS SQL Server database..

http://webcheatsheet.com/php/connect_mssql_database.php

http://webcheatsheet.com/php/connect_mysql_database.php

Run php script stored in the server..

Run php script stored in the server?