如何从sqlserver获取数据到移动应用程序 [英] how to get data from sqlserver to application in mobile

问题描述

i需要从Android服务器上获取数据从sql server到我的应用程序



1.安装sql server 2008并创建一个数据库



2.使用jtds和sqljdbc4 jar文件创建示例项目。



我的代码

Hi,

i need to get data from sql server to my application in android mobile for that one

1. Installed sql server 2008 and created one database

2. Created sample project with jtds and sqljdbc4 jar files.

my code

public class ConnectionTask extends AsyncTask<void,>
	{
		 Connection conn = null;
		  String connString = "jdbc:jtds:sqlserver://localhost:1433/Sample";
		@Override
		protected String doInBackground(Void... params) {
			
			 try {
	             String driver = "net.sourceforge.jtds.jdbc.Driver";
	             Class.forName(driver);
	          
	           
	            String username = "";
	            String password = "";
	            conn = DriverManager.getConnection(connString,username,password);
	            Log.d("Connection","open");       
	            Statement stmt = conn.createStatement();    
	            ResultSet reset = stmt.executeQuery("select * from sree");

	           //Print the data to the console    
	          while(reset.next()){
	            Log.d("Data:",reset.getString(1));
	          
	          }
	         conn.close();

	      } catch (Exception e)       
	         { 
	             Log.d("Error connection","" +
	           e.getMessage());
	          }
			return null;
		}
}

但它显示无法连接到系统和ConnREFuse这样的



提前感谢

but it showing unable to connect to system and ConnREFuse like that

thanks in advance

推荐答案

在CP上看到类似的问题：如何通过jbdc将android应用程序连接到sql server [ ^ ]

See similar question on CP: how to connect android application to sql server through jbdc[^]

这篇关于如何从sqlserver获取数据到移动应用程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！