create table login_user(
userpk NUMBER(20) not null,
username VARCHAR2(20) not null,
password VARCHAR2(20) not null,
lastlogindatedate not null ,
login_number NUMBER(20) not null
);
insert into login_user values(20050304442474,'liyqi','1234',to_date('2008-1-28','yyyy-mm-dd'),0);
insert into login_user values(20050304442475,'yurengl','1234',to_date('2008-1-28','yyyy-mm-dd'),0);
insert into login_user values(20050304442476,'renyli','1234',to_date('2008-1-28','yyyy-mm-dd'),0);
insert into login_user values(20050304442477,'zhuangww','1234',to_date('2008-1-28','yyyy-mm-dd'),0);
insert into login_user values(20050304442478,'yangsj','1234',to_date('2008-1-28','yyyy-mm-dd'),0);
insert into login_user values(20050304442479,'wangrh','1234',to_date('2008-1-28','yyyy-mm-dd'),0);
insert into login_user values(20050304442480,'wuzh','1234',to_date('2008-1-28','yyyy-mm-dd'),0);
commit;
SQL> select * from login_user;
USERPK USERNAME
PASSWORDLASTLOGINDATE LOGIN_NUMBER
---------- -------------------- -------------------- -------------- ----------------------------------
2.0050E+13 liyqi
1234
28-1月 -08
0
2.0050E+13 yurengl
1234
28-1月 -08
0
2.0050E+13 renyli
1234
28-1月 -08
0
2.0050E+13 zhuangww
1234
28-1月 -08
0
2.0050E+13 yangsj
1234
28-1月 -08
0
2.0050E+13 wangrh
1234
28-1月 -08
0
2.0050E+13 wuzh
1234
28-1月 -08
0
已选择7行。
问题:
LASTLOGINDATE 字段标识用户最后一次登录的时间,由前台程序更新,
LOGIN_NUMBER 是新加的列,要实现用户登录一次(也就是说某行数据的 LASTLOGINDATE字段被更新时),LOGIN_NUMBER的值就自动加1
如何实现
[ 本帖最后由 gaiwei666 于 2008-4-8 17:28 编辑 ]
|