【Android解决方案】连接SQL Server

案例说明

前一段时间要做一个用Android平板连接SQL的项目，在这种情况下，我就想到了两种方案：

1）Android Client  + Webservice + SQL的方式来连接

2）Android Client + SQL

本人一直都在用第一种方案做的，都很坚持第一种方案，但由于客户的环境加上其他因素，不能用第一种方案来做，所以就用了第二种；

技术概要

由于SQL官方的驱动不能直接用于Android上运行，所以就在网上搜了一些资料，看到了JTDS驱动，这个是开源的，网址是：http://sourceforge.net/projects/jtds/files/

现在最新的版本是1.3.0,但这个版本不能在Android上用，因为1.3.0是支持Java7的，Android不支持Java7，所以我就选择了1.2.7的版本; 

开发环境

Windows7 x64 专业版 

Android4.0.2

Eclipse4.2+ADT 21+SDK 21

代码实现

以下是数据库连接和测试类DataBaseUtil.java，注意修改连接字符串

package com.example.androidsql;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement; public class DataBaseUtil{private static Connection getSQLConnection(String ip, String user, String pwd, String db){Connection con = null;try{Class.forName("net.sourceforge.jtds.jdbc.Driver");con = DriverManager.getConnection("jdbc:jtds:sqlserver://" + ip + ":1433/" + db + ";charset=utf8", user, pwd);} catch (ClassNotFoundException e){e.printStackTrace();} catch (SQLException e){e.printStackTrace();}return con;}public static String testSQL(){String result = "字段1  -  字段2\n";try{Connection conn = getSQLConnection("xx.xx.xx.xx", "sa", "123", "DataBaseName");String sql = "select top 10 * from UserTable";Statement stmt = conn.createStatement();// 閸掓稑缂揝tatementResultSet rs = stmt.executeQuery(sql);while (rs.next()){// <code>ResultSet</code>閺堬拷鍨甸幐鍥ф倻缁楊兛绔寸悰锟�String s1 = rs.getString("Name1");String s2 = rs.getString("Name2");result += s1 + "  -  " + s2 + "\n";System.out.println(s1 + "  -  " + s2);}rs.close();stmt.close();conn.close();} catch (SQLException e){e.printStackTrace();result += "查询数据异常!" + e.getMessage();}return result;}public static void main(String[] args){testSQL();}}

MainActivity.java

package com.example.androidsql;import android.os.Bundle;import android.os.Handler;import android.os.Message;import android.app.Activity;import android.view.Menu;import android.view.View;import android.widget.TextView;public class MainActivity extends Activity{private View btnTest;private View btnClean;private TextView tvTestResult;@Overrideprotected void onCreate(Bundle savedInstanceState){super.onCreate(savedInstanceState);setContentView(R.layout.activity_main);btnTest=findViewById(R.id.btnTestSql);btnClean=findViewById(R.id.btnClean);tvTestResult = (TextView)findViewById(R.id.tvTestResult);btnTest.setOnClickListener(getClickEvent());btnClean.setOnClickListener(getClickEvent());}@Overridepublic boolean onCreateOptionsMenu(Menu menu){// Inflate the menu; this adds items to the action bar if it is present.getMenuInflater().inflate(R.menu.main, menu);return true;} private View.OnClickListener getClickEvent(){return new View.OnClickListener(){@Overridepublic void onClick(View v){tvTestResult.setText("...");if(v==btnTest){test();}}};}private void test(){Runnable run = new Runnable(){@Overridepublic void run(){String ret = DataBaseUtil.testSQL();Message msg = new Message();msg.what=1001;Bundle data = new Bundle();data.putString("result", ret);msg.setData(data);mHandler.sendMessage(msg);}};new Thread(run).start(); }Handler mHandler = new Handler(){public void handleMessage(android.os.Message msg) {switch (msg.what){case 1001:String str = msg.getData().getString("result");tvTestResult.setText(str);break;default:break;}};};}

activity_main.xml

<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"    xmlns:tools="http://schemas.android.com/tools"    android:layout_width="match_parent"    android:layout_height="match_parent"    android:paddingBottom="@dimen/activity_vertical_margin"    android:paddingLeft="@dimen/activity_horizontal_margin"    android:paddingRight="@dimen/activity_horizontal_margin"    android:paddingTop="@dimen/activity_vertical_margin"    tools:context=".MainActivity" ><Button     android:id="@+id/btnTestSql"    android:layout_width="wrap_content"     android:layout_height="wrap_content"    android:text="@string/testSQL"/><Button     android:id="@+id/btnClean"    android:layout_width="wrap_content"     android:layout_height="wrap_content"    android:layout_alignParentRight="true"    android:text="@string/clean"/>    <TextView        android:id="@+id/tvTestResult"        android:layout_width="wrap_content"        android:layout_height="wrap_content"        android:layout_below="@id/btnTestSql"        android:text="@string/hello_world" /></RelativeLayout>

strings.xml

<?xml version="1.0" encoding="utf-8"?><resources>    <string name="app_name">AndroidSQL</string>    <string name="action_settings">Settings</string>    <string name="hello_world">Hello world!</string><string name="testSQL">测试SQL</string><string name="clean">清除数据</string></resources>

Demo下载地址： 

http://download.csdn.net/detail/yaoneng119/5309160