android studio2.2 连接 SqlServer 2008 R2

最新推荐文章于 2022-07-05 10:23:14 发布

谁学逆向工程

最新推荐文章于 2022-07-05 10:23:14 发布

阅读量464

点赞数

分类专栏： Android 文章标签： android sqlserver

本文链接：https://blog.csdn.net/xiaoyuanyuan2009/article/details/119062014

版权

Android 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

电脑：win7旗舰版64位

Android studio：2.2

Java：java -version -> 1.8

SqlServer：SqlServer 2008 R2

手机：华为畅享5（安卓5.1）

1权限


<uses-permission android:name="android.permission.INTERNET" />
<uses-permission android:name="android.permission.ACCESS_NETWORK_STATE" />
<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" />

2jar包

jdts1.2.7.jar 和 sqljdbc.jar下载

3代码（1）全局变量

public class QuanJuBianLiang {
static public String driverName = "net.sourceforge.jtds.jdbc.Driver";
static public String dbURL;//="jdbc:jtds:sqlserver://192.168.xxx:1433;DatabaseName=JDBCDemo";//数据库连接url
static public String userName;// = "sa";//数据库用户名
static public String userPwd;// = "sasasa";//数据库密码
static public Connection con;
}

代码（2）按钮单击

new Thread(new Runnable() {
@Override
public void run() {
try {
    Class.forName(QuanJuBianLiang.driverName);
    QuanJuBianLiang.con = DriverManager.getConnection(QuanJuBianLiang.dbURL,QuanJuBianLiang.userName,QuanJuBianLiang.userPwd);

String sql ="insert into tbnode values('"+"ceshi"+"',3,"+"'zifucuan',"+"555,666)";
PreparedStatement psql = QuanJuBianLiang.con.prepareStatement(sql);
psql.executeUpdate();

/*
String sql = "select * from \"dbo\".tbnode ";
Statement st = QuanJuBianLiang.con.createStatement();
ResultSet rs = st.executeQuery(sql);
while (rs.next()) {
 Log.i("MainActivity666", rs.getString("NodeCode"));
 Log.i("MainActivity666", rs.getString("NodeType"));
 Log.i("MainActivity666", rs.getString("NodeName"));
 Log.i("MainActivity666", rs.getString("IsWarehouse"));
 Log.i("MainActivity666", rs.getString("IsAssetUser"));
}
rs.close();
st.close();
QuanJuBianLiang.con.close();
*/
 } catch (Exception e) 
{
e.printStackTrace();
Looper.prepare();
Toast.makeText(getApplicationContext(), "数据库连接失败异常", Toast.LENGTH_SHORT).show();
Looper.loop();
}
}
 }).start();