Android通过使用jtds.jar这个工具访问指定IP地址电脑上的sqlserver2008 数据库

jtds.jar 的下载链接     也可以自行百度。jtds.jar 的文档

CSDN  这编辑器使用不习惯。每一次都不想来CSDN发博客。我都编辑了几次了。

Android 如何访问SqlServer？？？？？下面来解释解释一下   ，

如何访问？

<span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;">
</span>

<span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;">和一般的Java连接数据库没啥区别。加入jtds 类库，然后写连接方法，下面是通过java 来测试数据的</span>

<pre name="code" class="java"><span style="font-size:18px;">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 {
			System.out.println("0");
			Class.forName("net.sourceforge.jtds.jdbc.Driver");
			System.out.println("1");

			con = DriverManager
					.getConnection("jdbc:jtds:sqlserver://" + ip + ":1433/"
							+ db + ";charset=utf8; useLOBs=false", user, pwd);
			System.out.println("value of conn is " + con);

		} catch (ClassNotFoundException e) {
			e.printStackTrace();
			System.out.println("2");
		} catch (SQLException e) {
			e.printStackTrace();
			System.out.println("3");
		}
		return con;
	}

	public static String testSQL() {
		String result = "时间  ---------  值-----名字\n";
		try {
			Connection conn = getSQLConnection("**.**.**.**", "sa", "123456",
					"test");
			String sql = "select top 10 * from contents";
			Statement stmt = conn.createStatement();
			ResultSet rs = stmt.executeQuery(sql);
			while (rs.next()) {// <code>ResultSet</code>
				String s0 = rs.getString("date");
				String s1 = rs.getString("value");
				String s2 = rs.getString("name");
				result += s0 + "-" + 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();
	}

}</span>

在Android中的调用： 

 Android中做耗时的操作，就不能在主线程中执行，访问数据库这种耗时的操作当然得开启新的线程。下面是MainActivity的代码，懒得解释了，直接上代码

package com.example.androidsql;

import android.os.Bundle;
import android.app.Activity;
import android.os.Handler;
import android.os.Message;
import android.view.View;
import android.widget.TextView;

public class MainActivity extends Activity {

	private View btnTest;
	private View btnClean;
	private TextView tvTestResult;

	@Override
	protected 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());
	}

	private View.OnClickListener getClickEvent() {
		return new View.OnClickListener() {
			@Override
			public void onClick(View v) {
				tvTestResult.setText("...");
				if (v == btnTest) {
					test();

				}
			}
		};
	}

	/**
	 * 开启新的线程，访问数据库
	 */
	private void test() {
		Runnable run = new Runnable() {
			@Override
			public 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>

jtds.jar 的下载链接     也可以自行百度。jtds.jar 的文档