日期:2014-05-16  浏览次数:20355 次

JSP+Oracle实现简单的分页
oracle脚本:drop table t_student cascade constraints;

?

/*==============================================================*/
/*?Table:?t_student???????????????????????????????????????????*/
/*==============================================================*/
create?table?t_student??(
???s_id??????????????
char(10)????????????????????????not?null,
???s_name?????????????varchar2(
20)????????????????????not?null,
???s_age??????????????
char(2)?????????????????????????not?null,
???s_sex??????????????
char(2)?????????????????????????not?null,
???s_class????????????varchar2(
20),
???constraint?PK_T_STUDENT?primary?key?(s_id)
);

insert?into?t_student?values(
'0001','张三','20','','08级二班')?;
insert?into?t_student?values(
'0002','李四','21','','08级二班'