search
HomeDatabaseMysql TutorialAndroid访问Sqlserver

Android访问Sqlserver

Jun 07, 2016 pm 03:51 PM
androidsqlservercompanyaccessneed

由于公司需求,要做安卓软件实现查询企业Erp系统的报表资料, 在网上找了各种资料,想实现手机直接连接Sqlserver,折腾很久都以失败告终。 目前,安卓不能直接连接Sqlserver,安卓不能用PC的JDBC驱动Jar包提供的API连接数据库。 比较快捷的方法是利用WebServi

由于公司需求,要做安卓软件实现查询企业Erp系统的报表资料,

在网上找了各种资料,想实现手机直接连接Sqlserver,折腾很久都以失败告终。

目前,安卓不能直接连接Sqlserver,安卓不能用PC的JDBC驱动Jar包提供的API连接数据库。

比较快捷的方法是利用WebService作为桥梁,安卓端获得WebService提供的数据然后进行xml解析。

使用Visual Stuido能很快捷的创建、发布WebService服务,安卓只要根据SOAP协议和提供的函数接口 向WebService发送请求,就能得到xml数据。

在Visual Stuido 2012下创建、发布WebService方法:

步骤一 创建WebService项目

新建-选择“Web”-选择“ASP.NEt 空 Web应用程序”

Android访问Sqlserver

步骤二 添加Web服务

右击项目名,选择“添加”-选择“Web服务”,输入项名称,确定。

Android访问Sqlserver

接着在asmx.cs文件中编写安卓要访问的函数。

发布至iis方法:(前提是先安装IIS,建立一个站点,安装配置iis方法网上教程很多)

右击项目名-选择“发布”-在配置文件中新建配置文件-下一步,发布方法选择“文件系统”-下一步,选择“目标位置”发布到IIS已创建好的站点中-下一步,“配置”选择release,最后发布。

Android访问Sqlserver

Android访问Sqlserver

Android访问Sqlserver

Android访问Sqlserver

Android访问Sqlserver

Android访问Sqlserver

到此为止,只要打开IIS服务,在浏览器输入你电脑的IP:端口号/webservice文件,就能访问到WebService的接口了

Android访问Sqlserver


若要将安卓应用在广域网下查看Sqlserver数据,必须配置WebService的Web.config文件,允许远程访问函数接口

 在Web.config文件的

        <!-- 添加如下代码,允许远程调用函数接口-->
    <webservices>
      <protocols>
        <add name="HttpSoap"></add>
        <add name="HttpPost"></add>
        <add name="HttpGet"></add>
        <add name="Documentation"></add>
      </protocols>
    </webservices>

ps:后期会补充WebService和安卓客户端的代码


Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
What Are the Limitations of Using Views in MySQL?What Are the Limitations of Using Views in MySQL?May 14, 2025 am 12:10 AM

MySQLviewshavelimitations:1)Theydon'tsupportallSQLoperations,restrictingdatamanipulationthroughviewswithjoinsorsubqueries.2)Theycanimpactperformance,especiallywithcomplexqueriesorlargedatasets.3)Viewsdon'tstoredata,potentiallyleadingtooutdatedinforma

Securing Your MySQL Database: Adding Users and Granting PrivilegesSecuring Your MySQL Database: Adding Users and Granting PrivilegesMay 14, 2025 am 12:09 AM

ProperusermanagementinMySQLiscrucialforenhancingsecurityandensuringefficientdatabaseoperation.1)UseCREATEUSERtoaddusers,specifyingconnectionsourcewith@'localhost'or@'%'.2)GrantspecificprivilegeswithGRANT,usingleastprivilegeprincipletominimizerisks.3)

What Factors Influence the Number of Triggers I Can Use in MySQL?What Factors Influence the Number of Triggers I Can Use in MySQL?May 14, 2025 am 12:08 AM

MySQLdoesn'timposeahardlimitontriggers,butpracticalfactorsdeterminetheireffectiveuse:1)Serverconfigurationimpactstriggermanagement;2)Complextriggersincreasesystemload;3)Largertablesslowtriggerperformance;4)Highconcurrencycancausetriggercontention;5)M

MySQL: Is it safe to store BLOB?MySQL: Is it safe to store BLOB?May 14, 2025 am 12:07 AM

Yes,it'ssafetostoreBLOBdatainMySQL,butconsiderthesefactors:1)StorageSpace:BLOBscanconsumesignificantspace,potentiallyincreasingcostsandslowingperformance.2)Performance:LargerrowsizesduetoBLOBsmayslowdownqueries.3)BackupandRecovery:Theseprocessescanbe

MySQL: Adding a user through a PHP web interfaceMySQL: Adding a user through a PHP web interfaceMay 14, 2025 am 12:04 AM

Adding MySQL users through the PHP web interface can use MySQLi extensions. The steps are as follows: 1. Connect to the MySQL database and use the MySQLi extension. 2. Create a user, use the CREATEUSER statement, and use the PASSWORD() function to encrypt the password. 3. Prevent SQL injection and use the mysqli_real_escape_string() function to process user input. 4. Assign permissions to new users and use the GRANT statement.

MySQL: BLOB and other no-sql storage, what are the differences?MySQL: BLOB and other no-sql storage, what are the differences?May 13, 2025 am 12:14 AM

MySQL'sBLOBissuitableforstoringbinarydatawithinarelationaldatabase,whileNoSQLoptionslikeMongoDB,Redis,andCassandraofferflexible,scalablesolutionsforunstructureddata.BLOBissimplerbutcanslowdownperformancewithlargedata;NoSQLprovidesbetterscalabilityand

MySQL Add User: Syntax, Options, and Security Best PracticesMySQL Add User: Syntax, Options, and Security Best PracticesMay 13, 2025 am 12:12 AM

ToaddauserinMySQL,use:CREATEUSER'username'@'host'IDENTIFIEDBY'password';Here'showtodoitsecurely:1)Choosethehostcarefullytocontrolaccess.2)SetresourcelimitswithoptionslikeMAX_QUERIES_PER_HOUR.3)Usestrong,uniquepasswords.4)EnforceSSL/TLSconnectionswith

MySQL: How to avoid String Data Types common mistakes?MySQL: How to avoid String Data Types common mistakes?May 13, 2025 am 12:09 AM

ToavoidcommonmistakeswithstringdatatypesinMySQL,understandstringtypenuances,choosetherighttype,andmanageencodingandcollationsettingseffectively.1)UseCHARforfixed-lengthstrings,VARCHARforvariable-length,andTEXT/BLOBforlargerdata.2)Setcorrectcharacters

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

MinGW - Minimalist GNU for Windows

MinGW - Minimalist GNU for Windows

This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

DVWA

DVWA

Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

PhpStorm Mac version

PhpStorm Mac version

The latest (2018.2.1) professional PHP integrated development tool