今天举例来说一下一天的成果------Android直接连接远程数据库
环境
数据库:SQLServer2005
连接驱动:JDTS(此处下载)
安卓虚拟机版本:2.3.3
代码如下
/*author:MonnaLisa
* date:2013/1/23
* Android Connect Database for JTDS(JDBC)
*/
package com.example.demo8;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import android.app.Activity;
import android.os.Bundle;
public class MainActivity extends Activity {
/** Called when the activity is first created. */
private static final String DRIVER = "net.sourceforge.jtds.jdbc.Driver";
//数据库ip必须要写绝对的ip地址,不可写localhost和127.0.0.1.因为那样写会认为是模拟器本机,而不是pc机
private static final String URL = "jdbc:jtds:sqlserver://192.168.1.96/test";
private static final St