Location:
Search - jdbc d
Search list
Description:
数据库表结构
用SQL Server建立数据库
数据库名：questionnaire
Questions表
QuestionID 索引投票主题
Questions 存储投票主题内容
Isvisable 标识投票是否在前台显示
Date 记录投票发布时间
IsOpen 标识投票结果是否向投票用户公开
Items表
ItemID 索引投票选项
QuestionID 关联投票主题
Item 存储投票选项内容
ItemCount 投票记数
Admins表
AdminName 管理员用户名
AdminPwd 管理员密码
说明
1)管理员登陆帐号和密码都是admin。
2)数据库连接方式是使用JDBC For SQL Server驱动。用户使用时要修改opendata.jsp文件，修改SQL Server登陆用户名和密码。
3)目前的数据库连接、访问、修改都是通过页面完成，效率不是太高，在新版本中将使用JavaBeans实现。
4)新版本将添加如下功能：管理员权限设置、投票主题发布可选择单选或多选、投票者留言反馈等。
5)这是我用JSP做的第一个小项目，希望能与更多的朋友交流，我的信箱：fangpeng8118@21cn.com （阿房）
-structure of the database tables with SQL Server database database name : Questions questionnaire table QuestionID Index vote theme Q uestions storage vote Isvisable theme logo in the foreground polling showed Date voting records issued IsOpen logo vote whether to vote users open Items Table ItemI D QuestionID index options linked to the voting voting voting theme Item storage options as ItemC voting been credited several Admins Table AdminName administrators manage user name AdminPwd Members password Note 1) administrators landing account and password are admin. 2) The database connection is to use SQL Server For JDBC driver. When the user to amend opendata.jsp documents, changes SQL Server username and password. 3) the current database connections, access, modify through the pages are co
Platform: |
Size: 67832 |
Author: 陈寻 |
Hits:
Description: The JICQ is the bureau area which JAVA writes according to \"Customer s Machine/Server\"(C/S) mode message solid hour correspond by letter tool system, the system adopted the SQL Server2000 of Microsoft company as a backstage database, the system passes a JDBC interview database. The system is divided into the server procedure and customer s procedure two parts, server and customer adoption \"Transmission Control Protocol\"(TCP), connect a word (Socket) conjunction through a set, the adoption \"User Datagram Protocol \"(UDP) of the customer s, pass a data report a set to connect a word (DatagramSocket) establishment a conjunction. The system has customer registration, customer to register, increase good friend, delete good friend and send out and receive news etc. function.-JICQ The bureau is the area which write Java s according to the "Customer s Machine / Server" (C / S) mode message solid hour correspond by letter tool system. the system adopted the SQL Server2000 of Micros oft company as a backstage database, the system passes a database JDBC interview. Th e system is divided into the server procedure an d customer s procedure two parts. server and customer adoption "Transmission Co. ntrol Protocol "(TCP), connect a word (Socket) through a conjunction s et. the adoption "User Datagram Protocol" (UDP) of the customer s, pass a data report a set to connect a word (Datagr amSocket) establishment a conjunction. The sy stem has customer registration, customer to register, increase good friend, delete good friend and send out and
Platform: |
Size: 17802 |
Author: 乔峰 |
Hits:
Description: Oracle JDBC 的javaDoc -Oracle JDBC javaDoc
Platform: |
Size: 198656 |
Author: 朱晓峰 |
Hits:
Description:
数据库表结构
用SQL Server建立数据库
数据库名：questionnaire
Questions表
QuestionID 索引投票主题
Questions 存储投票主题内容
Isvisable 标识投票是否在前台显示
Date 记录投票发布时间
IsOpen 标识投票结果是否向投票用户公开
Items表
ItemID 索引投票选项
QuestionID 关联投票主题
Item 存储投票选项内容
ItemCount 投票记数
Admins表
AdminName 管理员用户名
AdminPwd 管理员密码
说明
1)管理员登陆帐号和密码都是admin。
2)数据库连接方式是使用JDBC For SQL Server驱动。用户使用时要修改opendata.jsp文件，修改SQL Server登陆用户名和密码。
3)目前的数据库连接、访问、修改都是通过页面完成，效率不是太高，在新版本中将使用JavaBeans实现。
4)新版本将添加如下功能：管理员权限设置、投票主题发布可选择单选或多选、投票者留言反馈等。
5)这是我用JSP做的第一个小项目，希望能与更多的朋友交流，我的信箱：fangpeng8118@21cn.com （阿房）
-structure of the database tables with SQL Server database database name : Questions questionnaire table QuestionID Index vote theme Q uestions storage vote Isvisable theme logo in the foreground polling showed Date voting records issued IsOpen logo vote whether to vote users open Items Table ItemI D QuestionID index options linked to the voting voting voting theme Item storage options as ItemC voting been credited several Admins Table AdminName administrators manage user name AdminPwd Members password Note 1) administrators landing account and password are admin. 2) The database connection is to use SQL Server For JDBC driver. When the user to amend opendata.jsp documents, changes SQL Server username and password. 3) the current database connections, access, modify through the pages are co
Platform: |
Size: 67584 |
Author: 陈寻 |
Hits:
Description: The JICQ is the bureau area which JAVA writes according to "Customer s Machine/Server"(C/S) mode message solid hour correspond by letter tool system, the system adopted the SQL Server2000 of Microsoft company as a backstage database, the system passes a JDBC interview database. The system is divided into the server procedure and customer s procedure two parts, server and customer adoption "Transmission Control Protocol"(TCP), connect a word (Socket) conjunction through a set, the adoption "User Datagram Protocol "(UDP) of the customer s, pass a data report a set to connect a word (DatagramSocket) establishment a conjunction. The system has customer registration, customer to register, increase good friend, delete good friend and send out and receive news etc. function.-JICQ The bureau is the area which write Java s according to the "Customer s Machine/Server" (C/S) mode message solid hour correspond by letter tool system. the system adopted the SQL Server2000 of Micros oft company as a backstage database, the system passes a database JDBC interview. Th e system is divided into the server procedure an d customer s procedure two parts. server and customer adoption "Transmission Co. ntrol Protocol "(TCP), connect a word (Socket) through a conjunction s et. the adoption "User Datagram Protocol" (UDP) of the customer s, pass a data report a set to connect a word (Datagr amSocket) establishment a conjunction. The sy stem has customer registration, customer to register, increase good friend, delete good friend and send out and
Platform: |
Size: 17408 |
Author: 乔峰 |
Hits:
Description: 一个简单的留言网上留言系统，适合初学者学习，希望大家喜欢-A simple message online message system, suitable for beginners to learn, I hope you like
Platform: |
Size: 33792 |
Author: li |
Hits:
Description: jdbc 连接程序, 初学者的好帮手，你可以下载它，首先要安装好数据库和插件-JDBC SQL PROGRAME,IT S very good for you i d like to introduce to you,it very useful
Platform: |
Size: 481280 |
Author: yinyu |
Hits:
Description: 说明：
此组件为操作数据库的组件，实现了jdbc的功能，还包含了一些分页功能，实现事务的功能等。
组件中有一些静态的方法，在这些方法中包含了开关数据库的操作，所以用户不需要实例化对象就可以用类名调用这个方法，同时实现对数据库的操作。
组件中非静态的方法则需要实例化对象才可以调用，在实例化过程中会调用构造方法，开启数据库，在最后还要调用关闭数据库的方法。
在测试例子中用了一个main()方法，用户只需将环境配好，运行一下main方法就可以看到结果。
环境搭建：
1.首先建一个web工程。
2.在工程src下面新建两个包smart.css.database和smart.css.util。
3.将Source下的DBHandle.java考到smart.css.database,DateUtils考到smart.css.util下。
4.将Sample下的文件也考到smart.css.database包下。
5.将Enviroument下的jar文件考到WebRoot下的WEB-INF下面。
-Description:
This component for operating the database components, to achieve the jdbc function, but also contains a number of paging capability to achieve affairs functions.
Component has some static methods, these methods include the switching operation of the database, so users do not need an instance of an object can use the class name to call this method, while achieving the operation of the database.
Component Central Africa static method you need to instantiate an object before they can call, in the instantiation process will call the constructor method, open the database, but also in the final call to close the database.
In the test case using a main () method, the user simply with a good environment, running about main ways you can see the result.
Environmental structures:
1. First, to build a web project.
2. In the new project src the following two packages smart.css.database and smart.css.util.
3. DBHandle.java the Source under test to smart.css.database, D
Platform: |
Size: 1187840 |
Author: 姜晓燕 |
Hits:
Description: java
养成良好编程习惯，新建项目时在D盘创建1个目录放入自己的项目，学习结束后将这个目录放自己的U盘中以备家中复习 - String url = "jdbc:oracle:thin:@localhost:1522:accp11g"
String username = "game"
String password = "123"
String driverName = "oracle.jdbc.driver.OracleDriver"
Class.forName(driverName)
return DriverManager.getConnection(url, username, password)
Platform: |
Size: 1146880 |
Author: chenchen |
Hits: