用户管理系统



系统层次：



common -> Get Connection

-> UserInfo(id,name,pass,email,power)



DAO ->userDAO(注册、删除、查询等功能)



Service ->userService(调用DAO中的方法)



VIEW ->普通用户界面，管理员界面，超级用户界面





数据库表：userinfo

序列:seq_user



create table userinfo

(

id number(10) primary key,

name varchar(20) not null,

pass varchar(20) not null,

email varchar(50),

power varchar(20) default 普通用户

)



create sequence seq_user

start with 1

increment by 1

maxvalue 100000

nocycle

nocache





获取键盘输入：

Scanner input new Scanner(System.in)

String name input.next() -　　　　　　　　　　　　　　　　　　user management system　　　　　　　　　　　　　　　　　　





The system level:





Common- > Get the Connection

- > the UserInfo (id, name, pass, email, power)

　　　

DAO- > userDAO (register, delete, query and other functions)





Service- > userService (called methods in the DAO)





The VIEW- > common user interface, the administrator interface, the user interface









Database tables: the userinfo

Sequence: seq_user





The create table the userinfo

(

Id number (10) primary key,

The name varchar (20) not null,

Pass a varchar (20) not null,

Email varchar (50),

Power varchar (20) default　ordinary users

)





The create sequence seq_user

Start with 1

Increment by 1

Maxvalue 100000

nocycle

Nocache









To obtain the keyboard:

Scanner input　 new Scanner (System. In)

String name　 input. Next ()