应用程序开发建议 [英] Suggestions for application development

问题描述

已要求我创建一个在线目录"，用户可以在其中查看项目，选定的用户可以添加项目.我已经在MSAccess中开发了许多应用程序，因此我有VB经验，也有很多使用Dreamweaver的网站，并且我对HTML和javascript的经验很少.

目前，我唯一的数据库选项看起来像SQL Server(而不是MySQL)，而Dreamweaver CS6似乎不能很好地工作.我已经尝试过使用Dreamweaver创建asp和asp.net页面，并且可以使数据库连接并列出记录，但无法使插入工作.我只是一直在使用插入记录向导，想知道是否应该尝试仅在服务器上创建查询并使用存储过程.我知道ASP现在旧"了，所以我应该推动使用MSSQL和PHP还是尝试使用ASP和旧ADO正常工作?因为有更多可用的支持和扩展，对我来说学习ASP.Net会更好吗?

I''ve been asked to create an online ''catalog'' where users can view items and selected users can add items. I''ve developed lots of applications in MSAccess so I have VB experience and also quite a few websites using Dreamweaver, and I''ve got some minimal HTML and javascript experience.

Currently, my only database option looks like SQL server, (not MySQL) and Dreamweaver CS6 doesn''t seem to work well with it. I''ve tried creating asp and asp.net pages using Dreamweaver and can get the database to connect and list the records but can''t get the insert to work. I''ve only been playing with the insert record wizard and wonder if I should try just creating queries on the server and using the stored procedures. I know ASP is ''old'' now so should I be pushing to use MSSQL and PHP or try to things working using ASP and the old ADO? Would it be better for me to learn ASP.Net since there is more support and extensions available?

推荐答案

您有非常正确的主意，ASP肯定是旧的并使用它，尤其是调试可能会很痛苦(至少是IMO).确实没有最佳"出路，因为实际上有数十种用于Web应用程序开发的选项. RubyOnRails，Python，PHP，Java，ASP.NET等以及更多各有各的优缺点.

我个人会推荐ASP.NET(即，如果您可以保护Visual Studio 2010/2012和SQL Server 2005+的合法副本).您当然可以下载免费的速成版，然后开始使用它们. ASP.NET与SQL Server集成度很高，并且与其他开源技术的兼容性也越来越高，例如MySQL，Memcached，MongoDB等或与.NET兼容.我认为Dreamweaver可以用于设计网页，尽管它不是我的首选设计工具.

未来几天，HTML5将会有巨大的发展，因此绝对值得一看.实际上，ASP.NET的新版本已经符合HTML5.

我也使用过一些PHP和MySQL，但只有在您可以精心构造应用程序以将前端标记与业务逻辑分开的情况下，它才有效.有些人倾向于使用像Zend这样的开放源代码框架，尽管我不知道它如何处理语言的固有碎片和缺乏强类型化的内容.

但是话又说回来，这就是我的观点.希望我能给您一些启发.

欢呼

You have got pretty much the right idea, ASP is definitely old and working with it and especially debugging can be a pain (at least IMO). There is no "best" way out really since there are literally dozens of options for web application development. RubyOnRails, Python, PHP, Java, ASP.NET etc and even more have all got their merits and demerits.

I personally would recommend ASP.NET (i.e. if you can secure a legal copy of Visual Studio 2010/2012 & SQL Server 2005+). You can certainly download the express editions that are free and start getting your feet wet with those. ASP.NET has great integration with SQL Server and its increasingly getting compatible with other open source technologies as well for e.g. MySQL, Memcached, MongoDB etc or these are getting compatible with .NET. Dreamweaver is OK for designing web pages i suppose though its not my preferred design tool.

There is gonna be a massive push for HTML5 in the coming days so its definitely worth having a look at that as well. Infact, new version of ASP.NET is already HTML5 compliant.

I have used some PHP and MySQL as well, but it only works if you can painstakingly structure your application to separate front end mark-up from the business logic. Some people tend to use open source frameworks for that like Zend, although I have no idea how it deals with the language''s inherent fragmentation and lack of strong typing.

But then again, that''s my views. Hope I have shed some light to give you some idea.

Cheers

我认为MSAccess和VB(特别是如果您指的不是VB.NET)值得浪费时间.当然，做一些更严肃的事情，开始使用.NET，ADO.NET和ASP.NET(可选).

另外，当您问学习{0}会更好吗……"时，您的意思是而不是{2}"吗?这取决于您想要成为什么样的专业人士.在许多其他情况下，更好的建议是两者"或"{0}，也{1}"，而不是代替".

—SA

I don''t think MSAccess and VB (especially if you mean something which is not VB.NET) worth wasting time. Of course, do something more serious, start using .NET, ADO.NET and, optionally, ASP.NET.

Also, when you are asking "would it be better to learn {0}", …, do your really mean "instead of {2}"? It depends on how professional you want to be. In many other cases, the better advice would be "both" or "{0}, and {1} as well", not "instead of".

—SA

为什么在古老的技术中发展成AFAIK已死?可能还需要学习一些新的东西(以及可销售的东西)，并在ASP.NET中开发新的应用程序.

Why develop in an ancient technology that AFAIK is dead? Might as well learn something new (and marketable) and develop your new application in ASP.NET.

这篇关于应用程序开发建议的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！