- Category:
- Java Develop
- Tags:
-
[WORD]
- File Size:
- 159kb
- Update:
- 2015-07-24
- Downloads:
- 0 Times
- Uploaded by:
- 陈兰儿
Description: Refer to the following SQL commands shown, create user information table userinfo in MySQL or Oracle s.
create table userinfo (
code varchar (4) not null PRIMARY KEY,- user code
name varchar (10),- the user s name
password varchar (6),- user password
email varchar (40),- user s email address
primary key (code))
Data user information table as follows:
Code Name Email Address Password
7101 Song Xiaomei 123456 xiaomei@yahoo.com.cn
7102 Off Song-Jie 654321 songjie@263.net
7103 Li Xiaomei 123654 xiaomei@yahoo.com.cn
7104 Zhangsong Yan 456123 songyan@yahoo.com.cn
7105 Wangya Jie 321456 yajie@hotmail.com
7106 whispered 654321 xiaosheng@263.net
Write JDBC application, do the following:
(1) First, insert data into user information table, and then displayed on the screen.
(2) the code for the user s password to 7104: 888,999 and then displayed on the screen.
(3) the code 7106 user records deleted.
(4) establish the login screen shown below, enter user code and pa
To Search:
File list (Check if you may need any files):
2013212680-陈兰儿-实验十.doc
Download