program SQL

解决打不开SQL Server配置管理器的问题 最近被Sql Server搞得贼烦,下了俩次SQL SERVER,重装了一次系统,先对这次遇到的问题发一下感慨:深深地意识到权限的重要性了,一般计算机里面的软件都有不同的访问权限,普通用户(Users)、管理员(Administrators)、SYSTEM等等,以不同的身份去对这个软件进行操作时,就会有不同的访问权限,一般Administrator的权限是最大的   1)安... 阅读详情

Java Python DDWT Assignment Two
Version Changes Details
Version 1.0 Initial Release
Version 1.1 Updated Task 1 to reflect task is to cover all card types
 
Pokemon League
 
All work is to be done individually and must be your own work. You must not share your @razor code or SQL with anyone else.  You must only submit code you have personally written (with the exception of utilising bootstrap html template examples). If you use other resources, you must include direct links to those resources as HTML/@razor comments at the bottom of the relevant files.  You are also reminded that use of AI tools for assignments in this course is considered academic misconduct.
Your task is to complete several web pages to search, view and add data relating to the South Australian Pokemon League database.  Do not leave this to the last minute as it is not possible to finish the project without prior thought to the implementation.  Writing queries is one thing but implementing SQL with programming logic in @Razor and HTML combined with Bootstrap presentation does require serious thought to get the desired functionality and outcomes!
Task
A web application containing the necessary database and MVC Views has already been created for you.  This can be downloaded from the assessments tab on the course website.  Your task is to complete several pages:
1. Views/PokemonCards/Index.cshtml
2. Views/PokemonCards/Detail.cshtml
3. Views/PokemonDecks/Index.cshtml
4. Views/PokemonDecks/Details.cshtml
5. Views/Tournaments/Index.cshtml
6. Views/Tournaments/Detail.cshtml
with the necessary layout using the WebMatrix data library, HTML, bootstrap v5.x and @Razor code.  Start by working on the PokemonCards/Index page that allows a person to view all the Pokemon cards in the database.  You will need to determine the best layout to present the data to our users and ensure you implement HTML Validation to reduce errors. Once this is working, start implementing the other pages in the order above.
Task 1: Pokemon Cards [30%]
url: PokemonCards/Index
This page is intended to display a comprehensive list of all cards available in the database. The page should retrieve all cards and display their attributes such as name, type, HP, Trainer type, energy type and any other relevant statistics, depending on what type of card they are. Users should be able to view this information in a clear and organized manner.
• HTML/Bootstrap Layout:
o Use Bootstrap's table or card components to present each card in an organized fashion.
o Include a search bar at the top of the page to allow users to filter cards by name or element  (if relevant). Utilize Bootstrap's form controls and grid system to ensure responsiveness.
o Implement a dropdown menu to filter by card type (Pokemon, Trainer, Energy)
o Each card entry should include a button or link that directs the user to the detail page for that specific card (PokemonCards/Detail?cardID=xx).
 
 
 
url: PokemonCards/Detail?cardID=xx
The detail page provides in-depth information about a specific card. It should display all detailed attributes such as the card's image, name, type, HP, attacks, any special abilities, trainer text, energy type or descriptions, etc. The page should retrieve the details of the card based on the cardID passed via the query string.
• HTML/Bootstrap Layout:
o Present the card's information in a visually appealing layout.
o Display the card image prominently.
o Include a back button to return to the index page.
o Use Bootstrap's alert components to handle and display error messages if an invalid cardID is provided or if the card is not found.
 
 
Task 2: Pokemon Decks [30%]
url: /PokemonDecks/Index
This page displays a list of all Pokémon decks stored in the database. It should retrieve the decks and display information such as the deck name, creator, and the number of cards in each deck. Users should be able to sort or filter the list of decks.
• HTML/Bootstrap Layout:
o Use a card layout to present each deck's information.
o Provide sorti program、 SQL ng options for deck name and player name.
o Each deck entry should include a link or button to view its details (PokemonDecks/Detail?deckID=xx).
 
url: /PokemonDecks/Detail?deckID=xx
The detail page shows comprehensive information about a selected Pokémon deck, including the list of Pokémon cards it contains. It should retrieve the deck details and associated cards using the deckID.
• HTML/Bootstrap Layout:
o Display the deck's name and creator prominantly.
o List the cards in the deck, using Bootstrap's list group or card deck components.
o Each card in the list should link to its respective detail page.
 
Task 3: Tournaments [30%]
url: /Tournaments/Index
This page lists all tournament results available in the database. It should display information such as tournament name, date, location, and status. Users should be able to browse through the list and view tournament results of interest.
• HTML/Bootstrap Layout:
o Use a table or card layout to present each tournament's information.
o Include filters or search functionality to help users find tournaments by name, date, or location.
o Each tournament entry should include a link or button to view more details about the tournament (Tournaments/Detail?tournamentID=xx).
 
url: /Tournaments/Detail?tournamentID=xx
The detail page provides comprehensive information about a specific tournament. It should display details such as the tournament name, date, location, participants, and match results.
• HTML/Bootstrap Layout:
o Display the tournament's information prominently at the top of the page.
o List the participants and match results, using bootstrap elements
o Include navigation buttons to return to the tournaments index page.
o Implement error handling using Bootstrap alerts if an invalid tournamentID is provided or if the tournament is not found.
 
Mark Breakdown
Pages [90%]
• Correct SQL statements
• Correctly structured HTML in pages
• P Grade: Basic bootstrap implementation, basic query implementation, very simplistic.  Basic HTML and HTML Forms understanding.
• C Grade: Good bootstrap implementation and some investigation of bootstrap documentation.  Basic usage of bootstrap utilities.  SQL queries acceptable, somewhat optimised.  Code quality basic including expected HTML Forms attributes etc.  Consistent layout and professional looking pages as expected when using bootstrap CSS correctly.
• D Grade: Excellent use of bootstrap documentation and classes demonstrating investigation and experimentation of what’s available to create excellent looking customised layouts.  SQL Queries are optimised, well crafted, page structure shows in-depth knowledge and thought of functionality.  HTML is optimised to reduce errors and improve user experience.  SQL demonstrates thought and includes aggregate and sub-queries to provide additional and useful information. All tables available used to obtain relevant information. Professional looking pages
• HD Grade: Extensive exploration of bootstrap documentation and classes to create a custom layout using the available classes.  Razor code demonstrates experimentation with conditional statements around HTML, managing various value conditions with suitable messages, well structured and thoughtful code to reduce errors.  SQL demonstrates thought and includes aggregate and sub-queries to provide additional and useful information that is efficiently combined with Razor Code. All tables available used to obtain relevant information. Professional looking pages.
HTML Validation [10%]
• Check that your final generated HTML is valid and does not contain any errors.  You will need to run your page, then right click on it in the web browser and select “View Source” to check the html.   Images should have custom alt text etc.  
 
Note: All code must be done using the style and approach utilised throughout the course – you must not utilise lambda/LINQ expressions and your code must demonstrate the basic concepts covered based on the WebMatrix library         

program sql 立即下载

相关推荐

sql:program以编程方式构建sql查询

sql:program以编程方式构建sql查询

基础-SQL

听一位技术大牛说一句话,一流的人才做规范,二流的人才做服务,三流的人才做应用 所以越是普遍和抽象的 越是技术的本质。 insert into account values ('A-9732','Perrvridge',1200) select A1,A2,....,An from r1,r2,...,rm where P select branch_name from loan s...

program哲学 387

从服装打版到激光切割:二维异形件排版算法在实际生产中的避坑指南

本文深入探讨二维异形件排版算法在服装、家具等行业的实际应用,对比NFP和重叠移除两种核心策略的优缺点,并提供算法落地的五大实战陷阱与解决方案。通过案例分析和技术要点解析,帮助生产管理者提升材料利用率5%-15%,优化生产效率。

weixin_28717431的博客 418

mysql表 spid program_SQL Server 常用近百条SQL语句(收藏版)

1. sqlserver查看实例级别的信息,使用SERVERPROPERTY函数select SERVERPROPERTY ('propertyname')2. 查看实例级别的某个参数XX的配置select * from sys.configurations where name='XX'3. 更改实例级别的某个参数XX的值sp_configure 'XX','0'RECONFIGURE WITH...

weixin_33506920的博客 421

【无人机设计与控制】基于PID控制的四旋翼无人机系统Matlab仿真

本文设计并仿真了基于PID控制的四旋翼无人机系统。首先,建立了四旋翼无人机的数学模型,涵盖了无人机的动力学和控制系统。通过PID控制器对四旋翼的姿态和位置进行控制,以实现其稳定飞行。使用MATLAB/Simulink对该系统进行仿真,验证了PID控制算法在四旋翼控制中的有效性。仿真结果表明,PID控制能够较好地调节四旋翼的飞行姿态,并有效抑制外部干扰,使得无人机能够保持平稳飞行。

2401_84610415的博客 1804

值得苦练的100道Python经典练手题(全网最全,附详细答案,建议收藏)

这100道Python练习题涵盖了从基础语法到高级算法、从数据库操作到Web开发的各个方面,是备考数据库系统工程师的绝佳素材。建议按照章节顺序逐一练习,遇到难点可反复钻研,真正掌握每一道题背后的知识点。通过这些练习,不仅能提升Python编程能力,还能加深对数据库系统原理的理解,为考试和实际工作打下坚实基础。

yue_yun_的博客 9409

详解#program

C和C++的每个实现对它的主机或操作系统都支持一些独有的特征。例如,某些程序须对存放数据的存储器区域进行精确的控制,或必须控制特定函数接受参量的方式。#pragma指令对每个编译器给出了一个方法,在保持与C和C++语言完全兼容的情况下,给出主机或操作系统专有的特征。依据定义,编译指示是机器或操作系统专有的,且对于每个编译器都是不同的。语法#pragma 语言符号字符串语言符号字符串是给出特有编译

1万+

别再为GEE注册发愁了!用谷歌Cloud Project,5分钟搞定谷歌地球引擎账户(保姆级图文)

本文提供2024最新版谷歌地球引擎(GEE)账户注册的保姆级教程,通过谷歌Cloud Project快速完成注册,5分钟极速通关。详细解析注册前的准备、分步图解流程、常见误区及解决方案,帮助用户避开90%的注册陷阱,直达GEE核心功能区。

weixin_42557830的博客 203

Program SQL

● Pros:● Pros:● Cons:● Pros:● Cons:Reasoning2. LoRAUsing LLMsSupabase:required.

sentitto的博客 964

单机多环境部署apollo 2.3.0

理解apollo的整体架构后,对比nacos配置中心功能点,其设计的复杂度以及完整度相较nacos而言更为丰富 对于不同的环境,例如 FAT, PRO 在部署时进程已经完全物理隔离,并且每个环境config/adminservice依赖的数据也完全物理隔离(连接不同的db),在数据隔离与安全方面做的很完善,但同时也提升了架构的复杂度 而 portal 可以管理多个环境,单节点部署虽然有单点问题,但并不会影响业务从configservice读取配置, 挂掉只要重启就可以,只是在

Life is a starting point everywhere 1302

水文仿真软件:HEC-RAS (Hydrologic Engineering Center‘s River Analysis System)_(7).一维非稳态水力模型

自定义脚本是通过编程语言(如 Python)编写的一系列自动化任务,可以帮助用户更高效地处理数据和运行模型。编写脚本:使用 Python 或其他编程语言编写自定义脚本。集成脚本:将脚本集成到 HEC-RAS 中,实现自动化数据处理和模型运行。

kkchenjj的博客 933

讲解 program、SQL编程语言辅导

Overviewsongs.Important:url = '',= 200) {"Adele","Stormzy","Rita Ora"1),n)) )= 200) {return(NA)list() }if (!} else {})n)) )= 200) {list(})})followersgenrespopularityname TEXT,url TEXT) ")) ")Conclusionfeatures).

Ccio0612的博客 1104

Python爬虫实战:利用Requests-HTML与异步技术高效爬取B站视频信息及弹幕数据分析

B站的弹幕,远非简单的评论功能,它是一种独特的、实时互动的社交方式,是观众情感的集体宣泄和共鸣。无论是用于内容创作者优化视频结构,还是用于社会学、传播学的研究,亦或是简单的个人兴趣分析,都具备极高的价值。stop_words = {'的', '了', '是', '我', '你', '他', '她', '它', '在', '有', '不', '吗', '吧', '啊', '这', '那'}本文不仅是代码的堆砌,更注重原理的剖析、反爬策略的应对以及工程化的思考,旨在为读者提供一份紧跟技术前沿的实战指南。

2201_76125261的博客 391

oracle concurrent program session and sql

SELECT req.request_id,req.logfile_node_name node,req.oracle_process_id,req.enable_trace,dest.VALUE || '/' || lower...

congqishi0629的博客 153

通过InoDriverShop伺服调试软件连接汇川SV660F系列伺服的具体方法示例

通过InoDriverShop伺服调试软件连接汇川SV660F系列伺服的具体方法示例

Robot_PLC_HMI_Automation 1万+

复分析 阿尔福斯(Ahlfors) 第三版答案 英文

答案分为十章,有部分习题没有答案,全英文复分析阿尔福斯(Ahlfors) 第三版答案

The compile process for COBOL program with SQL

Due to the COBOL program is embedded with SQL statements,its complication is a little different from the normal COBOL program. Here is some instruction to understand the way to compile a program with

Designing Life 697

汉书HE8,好用的汇编代码编写工具

汉书HE8,好用的汇编代码编写工具早期编写汇编代码所用功能强大

SQL Server 2005 Beta 2 Service Broker: Stored Procedure acts as a service program

SQL Server 2005 Beta 2 Service Broker: Stored Procedure acts as a service program   Posted by: Rickie Lee (www.cnblogs.com/rickie) Date: Apr. 2005 这里演示同一个SQL Server中不同数据库之间的基于Service Broker的异步消息传递...

weixin_33976072的博客 74

jdk-8u144-linux-x64.tar.gz.

该资源为搭建Linux系统Java环境用,资源的后缀为tar.gz格式的压缩包

假人有限元模型

假人模型,车辆碰撞假人有限元模型,适合做乘员安全的研究者利用

Scheduling a Concurrent program

EBS中的Program是可以根据需求周期性运行的,比如‘Purge Logs and Closed System Alerts’ Program,我们需要每天运行来清理日渐庞大的日志表,周期性运行Program的方法。 路径:Submit Request > Schedule 1.As Soon as Possible:立即运行你的Program 2.Once:在一个具体的

田攀的日志 2984
上一篇: CS 336 java/c++
下一篇: CMPT 401 c++
priorityqueue3
博客等级 码龄2年 252粉丝 40原创
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付:10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值