详细说明:参照如下所示的SQL命令,在MySQL或Oracle数据库中创建用户信息表“userinfo”。
create table userinfo(
codevarchar(4) not null PRIMARY KEY, 用户代码
namevarchar(10), 用户姓名
password varchar(6), 用户密码
email varchar(40), 用户电子邮件地址
primary key(code))
用户信息表中的数据如下:
代码姓名密码电子邮件地址
7101宋晓梅123456xiaomei@yahoo.com.cn
7102关松杰654321songjie@263.net
7103李晓梅123654xiaomei@yahoo.com.cn
7104张松岩456123songyan@yahoo.com.cn
7105王亚杰321456yajie@hotmail.com
7106曲小声654321xiaosheng@263.net
编写JDBC应用程序,完成以下操作:
(1)首先将数据插入到用户信息表中,然后在屏幕上显示出来。
(2)将代码为7104用户的密码改为:888999,然后在屏幕上显示出来。
(3)将代码为7106的用户记录删除。
(4)建立如下图所示的登录界面,输入“用户代码”及“密码”信息后,单击“确定”按钮,如在用户信息表“userinfo”中能找到匹配的记录,则输出“登录成功”的信息,否则输出“登录失败”。-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 pass