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 的文档