文章列表
分页类：
package com.zhao.page;
public class PageCut {
private int pageSize;
private int countRecord;
private int countPage;
private int startIndex;
private int endIndex;
private int nowPage;
public PageCut(int pageSize, int countRecord, int nowPage) {
super();
this.page ...
//更新过期的
update
capture set flag=1 where (extract (epoch from now())::bigint-extract (epoch from capture_time )::bigint)>time_val
--系统表
pg_stat_activity 数据库活动进程视图
Pg_database 系统数据库字典
Pg_stat_database系统统计数据库字典视图
Pg_stat_sys_tables 系统字典表
Pg_stat_sys_indexes系统字典表索引
Pg ...
创建表： create table myuser(id numeric(5,0) not null,name varchar(20) not null,sex varchar(8) not null)insert into myuser values(1 , '李亚希' , '男' );创建存储过程CREATE LANGUAGE plpgsql;CREATE OR REPLACE FUNCTION getUsers()RETURNS refcursor AS $$DECLARE recordcur refcursor;BEGINOPEN recordcur FORSELECT id ...