Description: 【SSD7】-EX3答案(queries.sql)2008-08-01 16:48/*1.Display the ID, first name, and joining date of each member whose ID begins with the letters "A%B" or "A&B" and who joined the library no later than Nov. 30, 1997. */ SELECT libid,fname,Join_date FROM MEMBER4 WHERE (libid like 'A\%B%' escape '\' or libid like 'A&B%') and Join_date 1 AND SUM(Qty) > 10 ORDER BY SUM(Qty) ASC /*3.List the IDs and first names of all the members who have read less than 5% of the total number of books read from the library, in non-decreasing order of the number of books read by each.*/ SELECT member4.libid,fname,SUM(TimesRead) AS TotalTimesRead FROM MEMBER4 INNER JOIN READ_BY4 ON MEMBER4.libid = READ_BY4.libid GROUP BY MEMBER4.libid,fname HAVING SUM(TimesRead) 1) ORDER BY fname ASC; /*5.List the names of the suppliers and their respective average quantities of title orders received, whose average quantities of title orders received is more than the average quantity of an order in the system.*/ SELECT SUPPLIER4.name,AVG(Qty) AS Avg_qty FROM SUPPLIER4 INNER JOIN (ORDERED4 INNER JOIN PURCHASE_ORDER4 ON PURCHASE_ORDER4.PoNum = ORDERED4.PoNum) ON SUPPLIER4.Supplier_Id = ORDERED4.Supplier_Id GROUP BY SUPPLIER4.name,ORDERED4.Supplier_Id HAVING AVG(Qty) > (SELECT AVG(Qty) FROM PURCHASE_ORDER4) /*6.List alphabetically the first names and IDs of all the male members of the library who joined before Oct. 10, 1995, who have read only five or fewer different titles, and who have not read the same title twice or more*/ SELECT MEMBER4.fname,MEMBER4.libid,READ_BY4.TimesRead,COUNT (DISTINCT CallNumber) FROM MEMBER4 INNER JOIN READ_BY4 ON MEMBER4.libid = READ_BY4.libid WHERE MEMBER4.Gender = 'M' AND Join_date < '1995-10-10'AND TimesRead < 2 GROUP BY MEMBER4.fname,MEMBER4.libid,READ_BY4.TimesRead HAVING COUNT (DISTINCT CallNumber) <= 5 Platform: |
Size: 873693 |
Author:c978645312@163.com |
Hits:
Description: 这是一个基于命令行交互方式的议程（agenda）管理系统(采用面向对象方法和Java 语言开发)
版本：1.01
编程语言：Java
所用平台：Windows XP sp2+ Eclipse 3.2 + JDK 1.5.0
完成日期：2006-11-13
[主要功能说明]：已注册到系统的用户（user）可添加（add）、删除（delete）、查询（query）系统中记录的会议（meeting）安排；系统还提供新用户注册（register）、清除（clear）某一用户所有会议安排等管理功能。-This is an interactive command-line based on the agenda (agenda) management system (using object-oriented methods and the development of Java language) Version: 1.01 programming language: Java platforms used: Windows XP sp2+ Eclipse 3.2+ JDK 1.5.0 completed日期:2006-11-13 [the main functions of note]: registered to the system user (user) can be added (add), delete (delete), query (query) system to record the meeting (meeting) arrangements system also provides New User Registration (register), clear (clear) all meetings of a particular arrangement of user management functions. Platform: |
Size: 190464 |
Author:redsunworld |
Hits:
Description: 自己编写的一个用于查找java类所在包的完整源程序,编程环境是Eclipse+JDK1.5.压缩包中包括了帮助(运行后也可以查看帮助菜单).是windows风格的运行界面.建议您自己做一个可双击运行的.jar使用就更方便了.-I have written a java category used to find the complete source code where the package, the programming environment is Eclipse+ JDK1.5. Compressed package includes help (after running can also check the Help menu). Is to run windows-style interface. Recommendations your own can be a double-click operation. jar to use even more convenient. Platform: |
Size: 97280 |
Author:张 |
Hits:
Description: 打开两个以上的窗口来进行聊天, 即连续运行两次即可.
Windows 下可以点击 编译.bat 和 运行.bat 来编译, 运行.
项目代码也可以导入 Eclipse 运行.-Two or more windows open for a chat, that is twice continuous operation. Windows can click on the compiler. Bat and run. Bat to compile, run. Project code can also run into Eclipse. Platform: |
Size: 11264 |
Author:ywy |
Hits:
Description: 这是我自己用Qt写的读取.segy格式的文件并显示出.segy中所有道的平面图。对刚接触地震数据处理的同学们很有用哦。This is a program written by myself to get seismic datas from a .segy file and draw ichnography with those datas!I think it is readableness!对了，这是在Windows下模拟Linux下的Qt+eclipse+Mingw下开发的哈！-This is what I use Qt to write their own reading. Segy formats and shows. Segy all Road Plan. Of seismic data processing刚接触classmates Oh very useful. This is a program written by myself to get seismic datas from a. Segy file and draw ichnography with those datas! I think it is readableness! Yes, it is in Windows under Linux under simulated Qt+ Eclipse+ Mingw developed Kazakhstan ! Platform: |
Size: 3913728 |
Author:yangyan |
Hits:
Description: eclipse tools 很重要 java 编译运行环境，程序很小但效率很高，是很好工具。-eclipse tools is very important to compile java runtime environment, the program small but highly efficient and is a very good instrument. Platform: |
Size: 545792 |
Author:bl.yang |
Hits:
Description: ARM Cross Development with Eclipse.
Eclispe is IDE environment which can work on different platforms - Linux, Windows etc. The manual explains how to configure the eclipse to use a gnu arm cross compiler and set up a complete Development environment for arm platforms.-ARM Cross Development with Eclipse.
Eclispe is IDE environment which can work on different platforms- Linux, Windows etc. The manual explains how to configure the eclipse to use a gnu arm cross compiler and set up a complete Development environment for arm platforms. Platform: |
Size: 8079360 |
Author:hgs |
Hits:
Description: 开发环境: jdk1.5.0_07,Microsoft Windows XP Professional Verson 2002 Service Pack2(日文),IE 6.0 SP2，Eclipse3.2
运行环境：JDK,IE
运行：
1． 在环境变量中配置好java path。运行Run.bat。(也可以将工程导入Eclipse，执行CommonSourceCollectTool.java，或者在工程目录下运行java src.my.tool.CommonSourceCollectTool)（一定要配好path）
-Development Environment: jdk1.5.0_07, Microsoft Windows XP Professional Verson 2002 Service Pack2 (in Japanese), IE 6.0 SP2, Eclipse3.2 operating environment: JDK, IE run: 1. In the environment variable configured java path. Run Run.bat. (You can also project into Eclipse, the implementation of CommonSourceCollectTool.java, or in the project directory, run java src.my.tool.CommonSourceCollectTool) (must be equipped with a good path) Platform: |
Size: 658432 |
Author:秦书玉 |
Hits:
Description: this a java decompiler which has an“Eclipse” gui-this is a java decompiler which has an“Eclipse” gui Platform: |
Size: 680960 |
Author:郑龙龙 |
Hits:
Description: 用Java语言开发的一个小小画图板，模拟windows系统自带的画图板。
使用方法，把DrawBoard.rar包解压缩到Eclipse的workspace文件夹路径下，运行MainWindow.java即可运行-With the Java language developed by a small drawing board, the system comes with simulated windows drawing board. Use to extract DrawBoard.rar package Eclipse' s workspace folder path, run to run MainWindow.java Platform: |
Size: 179200 |
Author:chenzhou |
Hits:
Description: When you start to program in OpenGL, you might need a decent Integrated Development Environ-
ment (IDE). Being free, open-source and platform independent, Eclipse (http://www.eclipse.
org/) is an excellent choice. Although officially a Java Development Environment, Eclipse can
work with C, C++, COBOL, Python, Perl, PHP, and other programming languages by means
of an extensible plug-in system. This section will offer a step-by-step guide on how to configure
Eclipse for C++ and OpenGL on Windows and Ubuntu (Linux). At the time of writing the version
of Eclipse is 3.5.1 (Galileo), and I used Windows 7 Ultimate x64 and Linux Mint 8 32bit (based on
Ubuntu 9.10). Getting everything to work on Ubuntu is easier and less time consuming, so if you
wanted to try Linux at some point, now might be the right time.
Platform: |
Size: 151552 |
Author:akram |
Hits:
Description: The application reads picture-files in standard Windows BMP-format from a SD-Card and shows them on a 2.8" color-LCD-module (320*240 px). The following hard- and software has been used:
DPF Hardware: STM32 Mini Board (STM32 "medium density") with 2.8" TFT addon-board (available i.e. through taobao)
JTAG-"cable": Amontec JTAGkey2
Toolchain: Codesourcery G++ (GNU) lite for ARM-EABI
IDE: Eclipse with CDT and CDT hardware-debugging-plugin
gdb-Server for debugging and programming ("load"): OpenOCD
FAT code from Chan, STMicroelectronics StdPerLib
Software for picture conversion and scaling on PC: XnView Platform: |
Size: 3461120 |
Author:Taha Rehman |
Hits:
Description: 实现了所有WINDOWS系统自带记事本的所有功能，并添加了一些其他功能。所有代码是本人全部写的，无任何抄袭。直接用Eclipse导入运行即可。我是个初学者，站长大哥给审核下啊-WINDOWS system to achieve all of this comes with all the features of Notepad, and add some additional features. All my code is all written without any plagiarism. Can be run directly into Eclipse. I am a beginner, the owners brother to audit under the ah. . Platform: |
Size: 79872 |
Author:Smile |
Hits:
Description: PhoneGap 1.6.0::
Prerequisite Software
PhoneGap requires you have the following software installed:
1. Eclipse Integrated Design Environment (IDE), a program to write code and manage software development
2. Java Development Kit (JDK), the Java compiler and support tools
3. The Android Software Development Kit (SDK), base code and emulators for developing Android apps
4. Android Development Toolkit (ADT), a plug-in for Eclipse that makes Android development seamless
5. Apache Ant, a program that automates software build processes (similar to make )
6. Ruby, a programming language
7. Git Bash, an alternative command program for Windows environments (Windows only)
-PhoneGap 1.6.0::
Prerequisite Software
PhoneGap requires you have the following software installed:
1. Eclipse Integrated Design Environment (IDE), a program to write code and manage software development
2. Java Development Kit (JDK), the Java compiler and support tools
3. The Android Software Development Kit (SDK), base code and emulators for developing Android apps
4. Android Development Toolkit (ADT), a plug-in for Eclipse that makes Android development seamless
5. Apache Ant, a program that automates software build processes (similar to make )
6. Ruby, a programming language
7. Git Bash, an alternative command program for Windows environments (Windows only)
Platform: |
Size: 14158848 |
Author:djlam |
Hits:
Description: 传统的手工点菜方式由于其难计算、难查找、难更改、易出错、效率低等缺点已逐渐退出了酒店等高等消费场所的服务管理平台。层出不穷的各类酒店点菜管理系统也应运而生，呈现出多元化的发展。该项目主要以Windows为操作平台，Java为开发语言，SQLServer2008为数据库，Eclipse为开发工具,使用JDBC连接。前台界面实现可视化，方便顾客的选择。后台管理为数据库，管理菜品的增、删、改、查的实现都借以数据库实现。项目目标即为完整的实现该系统，让客户满意。(The traditional manual la carte system has gradually dropped out of the service management platform such as hotels and other higher places because of its difficult to calculate, difficult to find, difficult to change, error prone, low efficiency and so on. Various hotel ordering management systems emerge in an endless stream, showing a diversified development. The project mainly uses Windows as the operating platform, Java as the development language, SQLServer2008 as the database, Eclipse as the development tool, and the JDBC connection. Visual interface to facilitate the choice of customers. Background management for the database, management of dishes to increase, delete, change, check the implementation of database to achieve. Project objectives are the complete implementation of the system to the satisfaction of the customer.) Platform: |
Size: 41095168 |
Author:张张997
|
Hits:
Description: 服务器,在用eclipse开发程序的时候，必须配置的东西(Server, something that must be configured when developing a program with eclipse) Platform: |
Size: 10237952 |
Author:故事的小红花
|
Hits:
Search - eclipse windows a