首页 \ 问答 \ 什么是Web应用程序中的n层架构范围？(What are n-tier architecture scope in web-application?)

什么是Web应用程序中的n层架构范围？(What are n-tier architecture scope in web-application?)

我发现了n-tier Web应用程序概念，如下所示：
1-数据库（包括数据库业务和表或存储过程以及所有数据库内容）
2-网络。 数据（包括实体和存储库）
3-网络。 模型（包括非实体的一些简单模型可以转移到客户端）
4-网络。 业务（在某些应用程序中被承认它不是强制性的，但它包括一些功能，例如如何计算事物）
5-网络。 服务（包括SOAP restful应用程序上的Web API）
6-网络。 安全性（它包括一些您想要的自定义安全性，但它不是强制性的）
7-网络。 客户端（包括客户端功能，如jquery，mvvm和其他一些类似身份验证，在UI中实现的证券）
8-网络。 扩展（包括额外的辅助方法和包装器对象）
9-网络。 处理程序（包括所有处理程序和模块）
这些层可以放在不同的项目上，它们可以由MVC实现，甚至可以通过asp.net实现，具有相同的概念。
我想知道我的理解是否正确？ 还是有更好的主意？ 你能扩展它们还是有限且足够？
请指导我们有什么标准？

I've found out n-Tier web application concept like following categories:
1- Database (including database business and table or store procedures and all database stuff)
2- Web. Data (including entities and repositories)
3- Web. Model (including not entities some simple model can transfer to client)
4- Web. Business (in some application is admitted it is not mandatory but it includes some functionality such as how to calculates things)
5- Web. Service (including web API on SOAP restful application)
6- Web. Security (it includes some custom security as you wish but it is not mandatory)
7- Web. Client (including client-side functionalities like jquery, mvvm and some other like authentication, securities implemented in UI)
8- Web. Extension (including extra helper methods and wrapper objects)
9- Web. Handler (including all handler and modules)
These layers could be placed on different projects they could be implemented by MVC or even by asp.net of course with the same concept.
I was wondering if my understanding was right or not? or got any better idea? Could you expand them more or are they limited and enough?
Please guide me what are standards about them?

原文：https://stackoverflow.com/questions/16895079

更新时间：2023-06-15 08:06

最满意答案

 这是过去十天的查询。  
 select sysdate - (level-1)
        , level as day_order
 from dual
 connect by level <= 10;
 
 你的月份查询看起来非常过分。 这将做同样的事情：  
select to_char(add_months(trunc(sysdate, 'MM'), 1 - level), 'Month')
       , level as month_order
from dual
connect by level <= 7;
 
 
 
  “假设数据在今天的日期有效，其余9天没有任何数据，但必须将计数显示为零”  
 
 在外连接中使用生成的结果集：  
with q as (
 select sysdate - (level-1) as dt
        , level as day_order
 from dual
 connect by level <= 10 
)
select q.dt as txn_date
      , sum(t42.col1)
from q
     left outer join t42
      on t42.transaction_date = q.dt
group by q.dt;

Here's a query for the last ten days. 
 select sysdate - (level-1)
        , level as day_order
 from dual
 connect by level <= 10;
 
Your month query seems extremely over-engineered. This would do the same thing: 
select to_char(add_months(trunc(sysdate, 'MM'), 1 - level), 'Month')
       , level as month_order
from dual
connect by level <= 7;
 
 
 
 "Let suppose if the data is available on today's date and remaining 9 date's doesn't have any data but it has to display the count as zero" 
 
Use the generated result set in an outer join: 
with q as (
 select sysdate - (level-1) as dt
        , level as day_order
 from dual
 connect by level <= 10 
)
select q.dt as txn_date
      , sum(t42.col1)
from q
     left outer join t42
      on t42.transaction_date = q.dt
group by q.dt;

什么是Web应用程序中的n层架构范围？(What are n-tier architecture scope in web-application?)

最满意答案

相关问答

SYSDATE与列的日期之间的Oracle时差(Oracle Time Difference between SYSDATE and Date From Column)[2022-03-28]

性能差异很大：使用sysdate vs使用预格式化日期(Large performance difference: Using sysdate vs using pre-formatted date)[2021-12-10]

如何比较sysdate和CSV文件中存储的日期(How to compare the sysdate and the date stored in CSV file)[2022-10-13]

在Oracle集群中，sysdate会始终返回一致的答案吗？(In an Oracle cluster will sysdate always return a consistent answer?)[2022-05-27]

SYSDATE的时间段(Time bracket for SYSDATE)[2022-09-09]

TIMESTAMP和SYSDATE(TIMESTAMP and SYSDATE)[2024-02-27]

需要返回sysdate和过去的9个日期(Need to return sysdate and past 9 dates)[2022-05-06]

与sysdate进行sql date比较的最佳方法是？ - 在due_date中添加30天(Best way to get sql date comparisons with sysdate?- adding 30 days to due_date)[2023-01-30]

Sysdate减去2天不同(Sysdate minus 2 different days)[2022-03-04]

根据sysdate过期的日期是如何逾期的，本周已经过期了(How does the date has been overdue based on sysdate which got overdue in present week)[2023-08-08]

相关文章

最新问答