管理SQL数据库的应用程序开发 [英] Application Development for managing SQL Database

问题描述

你好

我对使用Azure很陌生，但是我想知道是否有人对他们认为是可行的，最佳的构建解决方案的方法提出了建议.

因此，我想从网站联系表单提交数据并将其保存到我的Azure SQL数据库中.这部分很容易设置.

现在的目标是创建一个界面或应用程序，工作人员(具有登录名的用户)可以使用该界面或应用程序登录并按下按钮/更新字段等，这与数据库中记录的数据相对应.在此示例中，说网站联系表是针对学生的 谁想学习一门课程.他们的详细信息已提交到数据库，现在工作人员需要一种方法来获取(例如)以下接口:

• 更新名称，电话号码，电子邮件等
• 选择/取消选择不同的设置，例如学生已获批准
• 打印出报告或学生名单
• 将学生分配到不同的组
• 如果可能，工作人员可以通过office365商业版登录我的组织

现在给出这些示例，问题不是如何"完成上述操作，而是更多的内容"可用于生成以上操作.

我最初的想法是，可以使用webapp来完成此操作，以便他们可以在线登录，这可能是由我以前使用过的Java推动的(尽管我通常会更容易地找到网络语言).

到目前为止，该解决方案涉及(在我的脑海中)一个webapp(Java)和一个SQL数据库，但是强烈建议使用Azure的其他资源来帮助自动化或简化编程.

您有什么想法?

谢谢！

解决方案

你好 https://www.codeproject.com/Articles/1254806/Authentication-and-Authorization-in-ASP-NET-Core-2

Hello,

I'm quite new to using Azure, but I was wondering if some people had suggestions to what they think may be a viable and best method of building a solution.

So I want to submit data from a website contact form and save it into my Azure SQL database. This part is easy to setup.

Now the goal is to create an interface or app which staff members (users with logins) can use to login and press buttons / update fields, etc, which corresponds to the data recorded in the database. In this example, say the website contact form is for students who want to study a course. Their details get submitted to the database, now staff need a way to get behind an interface to (e.g.):

• update names, phone numbers, emails, etc
• tick / untick different settings e.g. student has been approved
• print out reports or lists of students
• assign students to different groups
• if possible, staff can login through office365 business for my organisation

Now given these examples, the question isn't 'how' the above can be done, but more of 'what' can be used to produce the above.

My first thoughts were that this could possibly be done using a webapp so they can login online, perhaps fuelled by Java which I've used before (though web languages I find easier generally).

The solution so far involves (in my head) a webapp (Java) and an SQL database, but other resources from Azure are very much recommended to help automate or cut out programming.

What are your thoughts?

Thank you!

解决方案

Hello zaknokimi,

You have put across your requirement very clearly and you seem to know exactly what you want to accomplish. So you are half way through already :)

Yes a typical WebApp and an SQL database can help you achieve what you require.

You can use the default ASP.Net Web Application template to generate all the logic (Logic screens - Sign up, Sign in, forgot password, backend tables etc) you need for authentication without having to write any code at all.

You can take it one level further to allow users login via Office 365 accounts.

Please refer to this code project article

https://www.codeproject.com/Articles/1254806/Authentication-and-Authorization-in-ASP-NET-Core-2

Thanks,

Kalyan

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