1.连接：
conn system/manager;
2.建新用户：
create user shipping identified by shipping123;
3.授所有权限：
grant dba,connect,resource to shipping;
4.一个公用的序列
create sequence common_seq
start with 1
increment by 1
minvalue 1
maxvalue 9999
nocycle
nocache
5.用户信息表
create table setting_user (
id number(4),
num varchar2(50),
passwd varchar2(50),
branch varchar2(255),
loginIP varchar2(20),
input date default sysdate
);
insert into setting_user (id,num,passwd,branch) values(common_seq.nextval,'21010','21010123123','test');