从 SQL Server（服务器端）获取数据到 JavaScript（客户端）
我一直在寻找关于如何有效地从 SQL Server 读取数据以在基于 JavaScript 的 timeline< 中使用的良好新手建议/a>.请考虑一下我以前从未做过这样的事情。我有基本的oop知识并且想使用json，我写过小型java应用程序，但从未使用过javascript（尽管我认为在java之后进入它的基础知识不会很难）。
所以我真正要求的是有人帮助我了解需要采取哪些步骤才能实现这一目标；我需要知道什么、如何使用它以及按什么顺序使用它。
该数据库将包含大约五万到超过一百万个条目，这是大量的 GPS 坐标、年份数字和短字符串。
任何帮助将不胜感激。请记住，我是个新手，所以没有什么是太基础的！ :]
I have been looking for good newbie-advice on how to efficiently read data from an SQL Server to use in a JavaScript based timeline. Please consider that I have never done anything like this before. I have basic oop knowledge and would like to use json, I have written small java apps, but never used javascript (although I suppose it won't be very hard to get into the basics of it after java).
So really what I'm asking is for someone to help me get an overview over what steps need to be taken to make this happen; what do I need to know, how do I use it and in what order.
The database will contain from around fifty thousand to over a million entries, this is a lot of gps coordinates, year numbers and short strings.
Any help would be greatly appreciated. Please keep in mind I am fairly new, so nothing is too basic! :]
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
如果有一个中介器位于您的 javascript 与之交互的 [web] 服务器上，并在需要时向 SQL Server 请求其他信息，情况又如何呢？如果您要使用 ASP.Net，则页面方法 可能是一个不错的选择，甚至直接调用普通的旧 Web 服务 可能是一个合适的替代方案。
您可能可以使用这两个选项，而不是在单个 JavaScript 文件中加载所有数据库条目。只是一个想法。
What about having a mediator that sits on the [web] server that your javascript interacts with and asks for additional information from the SQL Server as it is needed. If you were to use ASP.Net then Page Methods might be a good option or even calling plain old web services directly might be a suitable alternative.
Both of these options might be something that you could use rather than loading up all of your DB entries in a single JavaScript file. Just a thought.