用jtds连接sqlserver问题，在eclipse下连接成功在android studio下失败

gongjinwei 2017-09-05 10:59:04
近来想学习android studio连接sql2008在网上都是eclipse的例子，下面的例子我在eclipse中测试成功，在android studio中无论是jtds-1.3.1还是jtds-1.2.7都不成功， 加载驱动Class.forName("net.sourceforge.jtds.jdbc.Driver");是成功的，连接数据库 con = DriverManager.getConnection("jdbc:jtds:sqlserver://" + ip + ":1433/" + db + ";charset=utf8", user, pwd);是不成功的，而为什么在eclipse下就能成功呢，刚学 android studio 请各位高手指点，谢谢
DataBaseUtil.java类
package com.example.administrator.myapplication1;

/**
* Created by Administrator on 2017/8/26.
*/
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("192.168.0.103", "sa", "******", "zxks");
String sql = "select top 10 * from ry100";
Statement stmt = conn.createStatement();// 閸掓稑缂揝tatement
ResultSet rs = stmt.executeQuery(sql);
while (rs.next())
{// <code>ResultSet</code>
String s1 = rs.getString("test_id");
String s2 = rs.getString("test_name");
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();
}
}


MainActivity1.java

package com.example.administrator.myapplication1;
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;
import android.support.v7.app.AppCompatActivity;

//import java.sql.Connection;



public class MainActivity1 extends AppCompatActivity
{
private View btnTest;
private View btnClean;
private View button1;
private TextView tvTestResult;



@Override
protected void onCreate(Bundle savedInstanceState)
{

super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main1);
btnTest=findViewById(R.id.btnTestSql);
btnClean=findViewById(R.id.btnClean);
tvTestResult = (TextView)findViewById(R.id.tvTestResult);
// button1 = findViewById(R.id.button1);
btnTest.setOnClickListener(getClickEvent());
btnClean.setOnClickListener(getClickEvent());
// button1.setOnClickListener(getClickEvent());
// Thread thread = new Thread(cont);
// thread.start();

}

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_main1
<?xml version="1.0" encoding="utf-8"?>
<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="com.example.administrator.myapplication1.MainActivity1">
<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>
...全文
650 11 打赏 收藏 转发到动态 举报
写回复
用AI写文章
11 条回复
切换为时间正序
请发表友善的回复…
发表回复
RohsZ 2017-11-02
  • 打赏
  • 举报
 回复
我后来时检查网络才解决的······
RohsZ 2017-11-02
  • 打赏
  • 举报
 回复
引用 4 楼 gongjinwei 的回复:
出错提示为： 09-06 07:29:59.496 2801-3090/com.example.administrator.myapplication1 W/System.err: java.sql.SQLException: Network error IOException: socket failed: EACCES (Permission denied) 09-06 07:29:59.497 2801-3090/com.example.administrator.myapplication1 W/System.err: at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:421) 09-06 07:29:59.497 2801-3090/com.example.administrator.myapplication1 W/System.err: at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:188) 09-06 07:29:59.497 2801-3090/com.example.administrator.myapplication1 W/System.err: at java.sql.DriverManager.getConnection(DriverManager.java:179) 09-06 07:29:59.497 2801-3090/com.example.administrator.myapplication1 W/System.err: at java.sql.DriverManager.getConnection(DriverManager.java:213) 09-06 07:29:59.497 2801-3090/com.example.administrator.myapplication1 W/System.err: at com.example.administrator.myapplication1.DataBaseUtil.getSQLConnection(DataBaseUtil.java:21) 09-06 07:29:59.497 2801-3090/com.example.administrator.myapplication1 W/System.err: at com.example.administrator.myapplication1.DataBaseUtil.testSQL(DataBaseUtil.java:39) 09-06 07:29:59.497 2801-3090/com.example.administrator.myapplication1 W/System.err: at com.example.administrator.myapplication1.MainActivity1$2.run(MainActivity1.java:67) 09-06 07:29:59.497 2801-3090/com.example.administrator.myapplication1 W/System.err: at java.lang.Thread.run(Thread.java:818) 09-06 07:29:59.497 2801-3090/com.example.administrator.myapplication1 W/System.err: Caused by: java.net.SocketException: socket failed: EACCES (Permission denied) 09-06 07:29:59.497 2801-3090/com.example.administrator.myapplication1 W/System.err: at libcore.io.IoBridge.socket(IoBridge.java:623) 09-06 07:29:59.497 2801-3090/com.example.administrator.myapplication1 W/System.err: at java.net.PlainSocketImpl.create(PlainSocketImpl.java:198) 09-06 07:29:59.497 2801-3090/com.example.administrator.myapplication1 W/System.err: at java.net.Socket.startupSocket(Socket.java:582) 09-06 07:29:59.497 2801-3090/com.example.administrator.myapplication1 W/System.err: at java.net.Socket.tryAllAddresses(Socket.java:128) 09-06 07:29:59.497 2801-3090/com.example.administrator.myapplication1 W/System.err: at java.net.Socket.<init>(Socket.java:178) 09-06 07:29:59.497 2801-3090/com.example.administrator.myapplication1 W/System.err: at java.net.Socket.<init>(Socket.java:150) 09-06 07:29:59.497 2801-3090/com.example.administrator.myapplication1 W/System.err: at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:249) 09-06 07:29:59.497 2801-3090/com.example.administrator.myapplication1 W/System.err: at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:322) 09-06 07:29:59.498 2801-3090/com.example.administrator.myapplication1 W/System.err: ... 7 more 09-06 07:29:59.498 2801-3090/com.example.administrator.myapplication1 W/System.err: Caused by: android.system.ErrnoException: socket failed: EACCES (Permission denied) 09-06 07:29:59.498 2801-3090/com.example.administrator.myapplication1 W/System.err: at libcore.io.Posix.socket(Native Method) 09-06 07:29:59.498 2801-3090/com.example.administrator.myapplication1 W/System.err: at libcore.io.BlockGuardOs.socket(BlockGuardOs.java:282) 09-06 07:29:59.498 2801-3090/com.example.administrator.myapplication1 W/System.err: at libcore.io.IoBridge.socket(IoBridge.java:608) 09-06 07:29:59.498 2801-3090/com.example.administrator.myapplication1 W/System.err: ... 14 more 09-06 07:29:59.498 2801-3090/com.example.administrator.myapplication1 E/AndroidRuntime: FATAL EXCEPTION: Thread-144 Process: com.example.administrator.myapplication1, PID: 2801 java.lang.NullPointerException: Attempt to invoke interface method 'java.sql.Statement java.sql.Connection.createStatement()' on a null object reference at com.example.administrator.myapplication1.DataBaseUtil.testSQL(DataBaseUtil.java:41) at com.example.administrator.myapplication1.MainActivity1$2.run(MainActivity1.java:67) at java.lang.Thread.run(Thread.java:818) 09-06 07:30:04.820 2801-3090/? I/Process: Sending signal. PID: 2801 SIG: 9
网络错误了，建议在进行连接数据库操作前进行网络检查
RohsZ 2017-09-27
  • 打赏
  • 举报
 回复
楼主解决了吗，我现在也是这样的我问题····
huskyui 2017-09-27
  • 打赏
  • 举报
 回复
不数据库是sqlite的吗，
jklwan 2017-09-06
  • 打赏
  • 举报
 回复
不成功报什么错呢，别只发代码，发错误日志。参考别人的链接
gongjinwei 2017-09-06
  • 打赏
  • 举报
 回复
连接数据库 con = DriverManager.getConnection("jdbc:jtds:sqlserver://" + ip + ":1433/" + db + ";charset=utf8", user, pwd); 这句提示 java.sql.SQLException: Network error IOException: socket failed: EACCES (Permission denied)
gongjinwei 2017-09-06
  • 打赏
  • 举报
 回复
在真机和模拟器下测试都是一样的，在eclipse下连接成功在android studio下失败
gongjinwei 2017-09-06
  • 打赏
  • 举报
 回复
出错提示为： 09-06 07:29:59.496 2801-3090/com.example.administrator.myapplication1 W/System.err: java.sql.SQLException: Network error IOException: socket failed: EACCES (Permission denied) 09-06 07:29:59.497 2801-3090/com.example.administrator.myapplication1 W/System.err: at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:421) 09-06 07:29:59.497 2801-3090/com.example.administrator.myapplication1 W/System.err: at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:188) 09-06 07:29:59.497 2801-3090/com.example.administrator.myapplication1 W/System.err: at java.sql.DriverManager.getConnection(DriverManager.java:179) 09-06 07:29:59.497 2801-3090/com.example.administrator.myapplication1 W/System.err: at java.sql.DriverManager.getConnection(DriverManager.java:213) 09-06 07:29:59.497 2801-3090/com.example.administrator.myapplication1 W/System.err: at com.example.administrator.myapplication1.DataBaseUtil.getSQLConnection(DataBaseUtil.java:21) 09-06 07:29:59.497 2801-3090/com.example.administrator.myapplication1 W/System.err: at com.example.administrator.myapplication1.DataBaseUtil.testSQL(DataBaseUtil.java:39) 09-06 07:29:59.497 2801-3090/com.example.administrator.myapplication1 W/System.err: at com.example.administrator.myapplication1.MainActivity1$2.run(MainActivity1.java:67) 09-06 07:29:59.497 2801-3090/com.example.administrator.myapplication1 W/System.err: at java.lang.Thread.run(Thread.java:818) 09-06 07:29:59.497 2801-3090/com.example.administrator.myapplication1 W/System.err: Caused by: java.net.SocketException: socket failed: EACCES (Permission denied) 09-06 07:29:59.497 2801-3090/com.example.administrator.myapplication1 W/System.err: at libcore.io.IoBridge.socket(IoBridge.java:623) 09-06 07:29:59.497 2801-3090/com.example.administrator.myapplication1 W/System.err: at java.net.PlainSocketImpl.create(PlainSocketImpl.java:198) 09-06 07:29:59.497 2801-3090/com.example.administrator.myapplication1 W/System.err: at java.net.Socket.startupSocket(Socket.java:582) 09-06 07:29:59.497 2801-3090/com.example.administrator.myapplication1 W/System.err: at java.net.Socket.tryAllAddresses(Socket.java:128) 09-06 07:29:59.497 2801-3090/com.example.administrator.myapplication1 W/System.err: at java.net.Socket.<init>(Socket.java:178) 09-06 07:29:59.497 2801-3090/com.example.administrator.myapplication1 W/System.err: at java.net.Socket.<init>(Socket.java:150) 09-06 07:29:59.497 2801-3090/com.example.administrator.myapplication1 W/System.err: at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:249) 09-06 07:29:59.497 2801-3090/com.example.administrator.myapplication1 W/System.err: at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:322) 09-06 07:29:59.498 2801-3090/com.example.administrator.myapplication1 W/System.err: ... 7 more 09-06 07:29:59.498 2801-3090/com.example.administrator.myapplication1 W/System.err: Caused by: android.system.ErrnoException: socket failed: EACCES (Permission denied) 09-06 07:29:59.498 2801-3090/com.example.administrator.myapplication1 W/System.err: at libcore.io.Posix.socket(Native Method) 09-06 07:29:59.498 2801-3090/com.example.administrator.myapplication1 W/System.err: at libcore.io.BlockGuardOs.socket(BlockGuardOs.java:282) 09-06 07:29:59.498 2801-3090/com.example.administrator.myapplication1 W/System.err: at libcore.io.IoBridge.socket(IoBridge.java:608) 09-06 07:29:59.498 2801-3090/com.example.administrator.myapplication1 W/System.err: ... 14 more 09-06 07:29:59.498 2801-3090/com.example.administrator.myapplication1 E/AndroidRuntime: FATAL EXCEPTION: Thread-144 Process: com.example.administrator.myapplication1, PID: 2801 java.lang.NullPointerException: Attempt to invoke interface method 'java.sql.Statement java.sql.Connection.createStatement()' on a null object reference at com.example.administrator.myapplication1.DataBaseUtil.testSQL(DataBaseUtil.java:41) at com.example.administrator.myapplication1.MainActivity1$2.run(MainActivity1.java:67) at java.lang.Thread.run(Thread.java:818) 09-06 07:30:04.820 2801-3090/? I/Process: Sending signal. PID: 2801 SIG: 9
gongjinwei 2017-09-05
  • 打赏
  • 举报
 回复
怎没有人回答呢？
gongjinwei 2017-09-05
  • 打赏
  • 举报
 回复
想在android studio下开发
android 连接 sqlserver jtds-1.2.7.jar
android studio 或者 Eclipse 均可以通过 jtds-1.2.7.jar 直接连接sqlserver数据库，非常好用。
Android studio连接sqlserver数据库
android
Android 通过jdbc直接连接SQLserver数据库
由于项目上有需求，需要通过android移动终端直接向pc端的sqlserver数据库上写数据，由于各种原因，无法通过接口来实现，所以就研究了一下，其中也遇到很多问题，翻墙出去看了很多大神的解决方案才搞定，在这里记录一下，给自己和需要的童鞋点帮助。        首先，看到这个需求的时候，第一之间就想到了我们在pc端通过java进行数据库连接使用的是jdbc技术，那么既然android也是基于j
Android 连接 SQL Server （jtds方式）——上
本文将介绍开发Android程序，连接SQL Server，通过第三方包jtds的方式。 如果你有同样的需求，请跟着做一遍，博主将以最详细的方式，进行介绍。 首先说明，Java、Android连接SQL Server并不是常见的方式，原因是SQL Server的微软的产品，没有打算让Java、Android直接连接，所以能连上的，都是在Java、Android使用第三方的包， 目前总共...
java 做app和sql_java-如何将Android Studio与SQL Server数据库连接...
我们目前遇到的问题与此处相同：How to connect Android Studio with SQL Server database,但尚未得到解答.我们还使用sqljdb4.jar文件在Eclipse上成功建立了连接,我们在android上尝试了与Eclipse中相同的代码,但仅在Eclipse上有效.我们还尝试了另一个驱动程序jtds1.3.1.jar,但它也不起作用我们用x和y替换了登...
Android

80,349

社区成员

91,287

社区内容

发帖
与我相关
我的任务
社区描述
移动平台 Android
androidandroid-studioandroidx 技术论坛（原bbs）
社区管理员
  • Android
  • yechaoa
  • 失落夏天
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章