Location:
Search - eclipse sql
Search list
Description: sql连eclipse方法
Platform: |
Size: 164053 |
Author: 尹辉 |
Hits:
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: 基于jsp+javabean+tomcat+eclipse+SQLServer2000的酒店信息服务系统（原创）具有客房信息发布，客房信息修改，客房信息查询，客房酒店预订，客房远程预订，客人离店结算等功能模块-based on jsp javabean tomcat eclipse CRM hotel information system (original) with Rooms release of information, Rooms information changes Rooms Information, room hotel reservations, room remote reservations, guests Check Out settlement function modules
Platform: |
Size: 131072 |
Author: 张永伟 |
Hits:
Description: 这是我用eclipse+tomcat开发的一个很小的
管理系统,用到了jsp和javabean,其中有一个goods.sql文件是数据库的脚本.因为我刚学J2EE,做得不好的地方,请原谅-eclipse tomcat with the development of a small management system, and uses jsp javabean, which goods.sql document is a database script. Because I just learning J2EE, are doing well, please forgive
Platform: |
Size: 388096 |
Author: 浪漫天使 |
Hits:
Description: 基于jsp+javabean+tomcat+eclipse+SQLServer2000的酒店信息服务系统（原创）具有客房信息发布-based on jsp javabean tomcat eclipse CRM hotel information system (original) has released information Rooms
Platform: |
Size: 50176 |
Author: zn |
Hits:
Description: Java项目开发实用案例之公司办公信息管理系统
本系统为公司办公信息管理系统EIMS，主要用来管理公司的员工信息和财务信息，并提供公司内部信息交流平台。
文件说明：
/EIMS/project－Eclipse/WSAD/Lomboz/MyEclipse开发环境下的工程文件目录；
?
/EIMS/database－SQL Server 2000环境下的数据库数据文件和日志文件；
?
/EIMS/war－通过Eclipse/WSAD/Lomboz/MyEclipse导出的war文件；
/EIMS/doc－本案例相关的文档；
详细安装及使用指导请参考/EIMS/doc文档-Java project to develop practical Case corporate office information management system of the system of the company office information management system EC EIMS mainly used to manage the company's employees and financial information and provide internal information exchange platform. This document explains :/EI/project-Eclipse/WSAD/Lomboz/MyEcli pse development environment under the project directory;/EI/database-SQL Server 2000 database environment and the data files log files;/EIMS/war- through Eclipse/WSAD/Lomboz/MyEclips e derived war;/EIMS/doc- this case the relevant documentation; details of the installation and use reference guide/EI/doc file
Platform: |
Size: 4345856 |
Author: andy |
Hits:
Description: 学生档案管理系统 eclipse开发
数据库用的是SQL Sever
详细见里面的说明-students file management systems eclipse with the development of the database is SQL Server see details inside Note
Platform: |
Size: 803840 |
Author: yangshuolei |
Hits:
Description: >项目名称:电脑电子商务平台
>1.运行环境JDK1.6+Oracle10g+Tomcat5.5
>2.开发工具: MyEclipse Enterprise Workbench 项目名称:电脑电子商务平台
1.运行环境JDK1.6+Oracle10g+Tomcat5.5
2.开发工具: MyEclipse Enterprise Workbench 5.1.0 GA
3.开发框架:Struts1.38+Ibertis2.3
4.功能描述: 项目后台和前台.后台是网站管理员对商务网的产品和商品的分类进行管理,客户的会员管理前台显示最新的产品信息,会员注册登
陆后可以享用购物车和网上订购产品功能.
使用说明:
1.数据库配置,在ORACLE10的客户工具运行ddl里的CREATE TABLE SHOP.sql创建数据库表
2.用MyEclipse上传项目到tomcat5.5中,然后启动tomcat.
3.系统后台数据管URL是http://localhost:8080/omegshop/admin/adminLogin.jsp
默认的用户名是admin,密码admin.
4.系统前台URL是http://localhost:8080/omegshop/index.jsp,
注册用户名: member
密码: member
Platform: |
Size: 4100096 |
Author: 林生 |
Hits:
Description: eclipse中开发的航空票务系统源代码，平台：Windows Xp
Java平台：JDK1.4
Server：Tomcat5.0.28
开发环境：Eclipse3.1和Eclipse3.0
-eclipse in the development of aviation ticketing system source code, platform: Windows XpJava platform: JDK1.4Server: Tomcat5.0.28 development environment: Eclipse3.1 and Eclipse3.0
Platform: |
Size: 18104320 |
Author: benben |
Hits:
Description: 通过对企业的报刊订阅业务进行分析、调查，报刊订阅管理系统主要实现以下功能：
①录入功能：录入订阅人员信息、报刊基本信息；
②订阅功能：订阅人员订阅报刊（并计算出其金额）；
③查询功能：按人员查询、按报刊查询、按部门查询有关订阅信息，对查询结果能进行预览和打印；
④统计功能：按报刊统计、按人员统计、按部门统计，对统计结果能进行预览和打印；
⑤系统维护：如数据安全管理（含备份与恢复）、操作员管理、权限设置等；
⑥开发环境：JAVA(Eclipse + SWT Designer)、SQL SERVER 2000、Windows XP Professional
-err
Platform: |
Size: 4096 |
Author: 吴佳 |
Hits:
Description: 创建数据库的一点小知识,使用MYSQL+ jsp+ eclipse.-To create a little database knowledge, the use of MYSQL+ Jsp+ Eclipse.
Platform: |
Size: 3072 |
Author: zhangjian |
Hits:
Description: 博客管理系统。安装说明：
1、在SQLSERVER中创建blog数据库并创建登陆帐号blog：blog，然后在SQL Server查询分析器中运行doc目录下db.sql创建所有表；
2、将工程导入Eclipse；
3、部署工程；
4、运行tomcat；
5、进入tomcat管理web后台，
在Tomcat->Service->Host->Context(blog)->Resources->Data Sources中添加
Data Source URL: jdbc:jtds:sqlserver://${dbhost}:1433 DatabaseName=blog
JDBC Driver Class: net.sourceforge.jtds.jdbc.Driver
User Name: blog
Password: blog
6、done!-Blog management system. Installation instructions: 1, create a blog in SQLSERVER database and create a login account blog: blog, and then in the SQL Server Query Analyzer run the doc directory to create all db.sql table 2, will be the project into Eclipse 3, the deployment of engineering 4, running tomcat 5, enter the tomcat management web background, in the Tomcat-> Service-> Host-> Context (blog)-> Resources-> Data Sources add Data Source URL: jdbc: jtds: sqlserver:// $ (dbhost): 1433 DatabaseName = blog JDBC Driver Class: net.sourceforge.jtds.jdbc.Driver User Name: blog Password: blog6, done!
Platform: |
Size: 947200 |
Author: |
Hits:
Description: 功能：用jsp实现图书馆管理系统网站
开发环境
操作系统：linux操作系统Ubuntu7.04
数据库：Mysql数据库、图形化Mysql数据库管理器：Mysql Query Browser
开发平台：Eclipse开发平台、Myeclipse插件
服务器：Tomcat5.5
开发语言：JSP、JavaScript、Html
-Functions: with jsp library management system to achieve site development environment operating system: linux operating system Ubuntu7.04 database: Mysql database, graphical Mysql database manager: Mysql Query Browser Development Platform: Eclipse development platform, Myeclipse server plug-ins: Tomcat5.5 language development: JSP, JavaScript, Html
Platform: |
Size: 479232 |
Author: dufeilong |
Hits:
Description: 一个简单的局域网网聊天程序
用Eclipse编写 数据库为SQL Server2-A simple LAN chat program with Eclipse for the preparation of the database SQL Server2
Platform: |
Size: 477184 |
Author: |
Hits:
Description: 本系统采用struts+spring+hibernate架构，重在讲述三者结合在一起的应用开发，所有源程序都有详细的注释，供入门者学生参考，未经作者允许不得用于商业用途，只能用于教学或个人学习。
程序只是整个系统中的一个模块，用于和各位程序爱好者交流之用。
下载地址: http://www.ejunnet.com/chinamobile.rar
使用方法：
(1)在oracle数据库中运行数据库脚本文件cnc.sql.
(2)用eclipse(或其它开发工具)直接导入工程.
(3)将spring配置文件applicationContext.xml中数据库连接地址改为您自已的地址。
(4)部署到tomcat服务器中即可运行(jdk1.5以上).
用户名和密码均为：admin
Platform: |
Size: 3994624 |
Author: peacenik |
Hits:
Description: 1、在Eclipse中导入工程，可以通过Eclipse中的菜单File→Import→Existing Projects intoWorkspace中选择Project；
2、在MySQL中创建数据库，使用MySQL Control Center执行database目录下的dbscript.sql数据库脚本文件创建数据库SQL语句创建数据库和表及数据；
3、设置数据库连接配置，修改doc目录下的exam.xml文件，将其中的数据库用户名和密码设置为实际的用户名和密码；
4、将doc目录下的exam.xml文件拷贝到Tomcat的安装目录下的conf\Catalina\localhost文件夹下，并修改exam.xml文件中的docBase，将该值指向该工程目录，如"F:\jsp\21\WebRoot"；
5、确保Tomcat安装目录的common\lib下mysql-connector-java-3.0.16-ga-bin.jar类包文件，如果没有拷贝WebRoot\WEB-INF\lib目录下的mysql-connector-java-3.0.16-ga-bin.jar类包文件到Tomcat安装目录的common\lib下；
6、启动Tomcat，在浏览器输入http://localhost:8080/exam，使用账号s0001，密码s0001登陆，后台管理使用账号admin，密码dmin登陆。
Platform: |
Size: 2760704 |
Author: 张磊 |
Hits:
Description: sql连eclipse方法-sql even eclipse method
Platform: |
Size: 163840 |
Author: 尹辉 |
Hits:
Description: 通过数据库录入学生数据信息，基于eclipse 数据库 SQL server 2-Student data entry through a database of information, based on the eclipse database SQL server 2
Platform: |
Size: 36864 |
Author: luo |
Hits:
Description: 学生成绩管理系统，具有搜索视图，ECLIPSE开发平台，SQL数据库。用户名和密码都为admin-Student achievement management system, with a search view, ECLIPSE development platform, SQL database. User name and password for admin
Platform: |
Size: 958464 |
Author: 周朵 |
Hits:
Description: 自己写的一个图书馆管理。GUI。eclipse下用jigloo创建画的界面，使用sql server数据库-A library written in their own management. GUI. eclipse create a painting using jigloo interface, use the sql server database
Platform: |
Size: 116736 |
Author: 陈佳金 |
Hits: