建立连接到SQL Server的Web应用程序的步骤 [英] Steps to build a web app connected to SQL server

问题描述

第一次在这里提出问题，我觉得这个问题有点白痴，但我认为我可能会在这里得到一些有用的信息.我是数据分析师，在Tableau中创建报表并使用SQL Server.我对使用Java，Javascript和HTML进行编程有一些最低限度的经验.作为一种可用于创建更复杂/更具创意的仪表盘的强大语言，D3确实引起了我的极大兴趣.我本质上想使用D3和Javascript基于SQL Server上存储的数据来创建仪表板，但由于从未构建过Web应用程序，因此我为完成这一壮举所需要做的一切感到有些不知所措.我知道我需要一个API等，但我不确定要实现这一切所需的步骤.谁能从鸟瞰图"中向我解释(逐步)我需要做什么，所以我对我应该朝哪个方向有所了解?谢谢.

First time asking a question here and I feel like a noob for asking this but I figured I might get some helpful info here. I work as a data analyst creating reports in Tableau and working with SQL server. I've had some minimal experience programming in Java, Javascript, and HTML. D3 has really peaked my interest as a powerful language that could be used to create more complex/creative dashboards. I essentially would like to use D3 and Javascript to create dashboards based off data housed on SQL server but having never built a web app I'm a little overwhelmed at what all I would need to do to accomplish such a feat. I know I would need an API etc, I'm just not sure of the steps needed to make it all happen. Can anyone explain to me what I would need to do (step by step) from a "birds eye view", so I have a good idea of what direction I need to go in? Thanks.

推荐答案

1. 选择一种编程语言(例如Java或JavaScript).
2. 选择一个Web服务器，您可以在该Web服务器上运行用该语言编写的服务器端代码(例如Tomcat或Node.js).
3. 找到一种可以与您正在使用的SQL Server交互的编程语言的库.
4. 编写一个服务器端程序(使用您选择的语言)，该程序可以:

1. Pick a programming language (e.g. Java or JavaScript).
2. Pick a web server that you can run server side code written in that language on (e.g. Tomcat or Node.js).
3. Find a library for that programming language that can interact with the SQL server you are using.
4. Write a server side program (in your language of choice) that can:

1. 从HTTP请求中读取数据.
2. 使用它来查询数据库.
3. 在HTTP响应中返回该数据(可能格式为JSON).

(Node.js从技术上讲不是Web服务器，但是运行用JS编写的服务器端代码的通常方法是在JS中编写一个具有内置Web服务器的程序，然后使用Node运行该程序. js).

(Node.js isn't technically a web server, but the usual way to run server side code written in JS is to write a program in JS that has a built-in web server and then run that program with Node.js).

这篇关于建立连接到SQL Server的Web应用程序的步骤的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！