Introduction - If you have any usage issues, please Google them yourself
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