迷你项目的前端和后端选择 [英] Choice of front end and back end for mini project

问题描述

我是一名计划做迷你项目的大学生。我决定将学院数据库与我们身份证中已有的条形码联系起来。通过使用条形码扫描器，可以扫描条形码以单独检索该特定学生的数据。

我担心哪个数据库可用作后端，访问或sql。此外，我将学生详细信息存储为excel文件。人们建议我使用访问权限，因为更容易将excel文件转换为访问数据库。但我不确定访问是否支持客户端服务器模型，因为数据库将被所有人访问同时部门。

我也不确定使用哪个前端以表格格式显示数据。我可以使用vb或任何其他前端???数据库的数据应该可以从前端和后端修改。我读了某人的访问问题，他们建议他们可以在访问数据库中显示详细信息而没有任何特殊的前端...其他人说我们可以使用excel作为后端并使用html将数据显示为前端....是否可能???

我对vb，sql知之甚少。但我必须承认我只是一个业余爱好者......我完全迷茫。请建议一个与windows xp OS兼容的前端和后端.........

I'm a college student planning to do a mini project. I'v decided to link the college database with the bar code that is already present in our id cards. By using a bar code scanner the bar code can be scanned to retrieve that particular student's data alone..
I'm wary of which database to use as back end, access or sql. Moreover I have the student details stored as excel files.People suggested I use access, as it is easier to convert excel files to access database.But I'm not sure if access would support client server model because the database will be accessed by all departments simultaneously.
I'm also not sure of which front end to use to display the data in forms format.Can I use vb or any other front end??? The data of the database should be modifyable from the front as well as the back end.. I read someone's reply for a access question in which they suggested they could display the details in access database without any special frontend...Some others say that we could use excel as backend and use html to display the data as front end....Is it possible???
I have little knowledge of vb,sql. But i must admit i'm only a Amateur.. I'm totally confuse. Please suggest a front and back end which is compatible with windows xp OS.........

推荐答案

这个问题在快速回答中无法回答论坛。我能做的最好的事情是建议后端使用SQL; Microsoft提供了各种版本，您可以从Express或Compact版本开始，以简化操作。但是，您仍然需要在数据库中设计实际表，因此您需要对预期要保存的数据以及如何处理它们进行一些分析。您可以使用OLEDB将Excel文件转换为SQL，如使用MS Excel（xls / xlsx）使用MDAC和Oledb [ ^ ]。至于前端，您需要确定这将是Windows窗体还是Web应用程序，以及您将使用哪种语言进行编码。



当我说，这不是一个容易回答的问题。

This question is impossible to answer in a Quick Answers forum. The best I can do is suggest for backend you use SQL; Microsoft offers various versions and you could start with the Express or Compact editions for simplicity. However, you still need to design the actual tables in the database so you will need to do some analysis of the data you expect to hold and how you need to process it. You can convert an Excel file to SQL by the use of OLEDB as described in Working with MS Excel(xls / xlsx) Using MDAC and Oledb[^]. As for the front end, you need to decide whether this will be Windows Form or Web application, and which language you are going to use to code in.

As I said, it's not an easy one to answer.

头号答案总是你知道什么。如果你不知道自己在做什么，那么这将会非常糟糕。我并不是所有人都在做大学项目，而是我不知道自己在做什么。



访问几乎总是一个糟糕的选择，因为你的目标肯定是培养在现实世界中重要的技能。如果您想通过Web显示数据，ASP.NET MVC就是您的选择。但是，当然，您无法从网站上运行条形码扫描仪。所以我认为这是一个客户端应用程序，最多只能查看数据的网站。



首先要确保你对自己的内容有足够的了解尝试，你将能够完成它。不要以为你可以选择一些东西并让人们上网完成所有的工作，而不是学习。

The number one answer is always 'what do you know'. If you have no clue what you're doing, then this is going to end badly. I don't get all the people doing 'college projects' that start with 'I have no idea what I'm doing'.

Access is nearly always a bad choice though, because your goal is surely to develop skills that will matter in the real world. If you want to show data via the web, ASP.NET MVC is the way to go. But, of course, you can't run a barcode scanner from a website. So I think this is a client app, AND a website to view the data, at most.

Start by feeling sure you know enough about what you're about to attempt, that you'll be able to finish it. Don't think you can choose something and get people online to do all the work, that's not learning.

这篇关于迷你项目的前端和后端选择的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！