Create Sequence Sequence_Name //建序列 Increment By 1 //增加为1 Start With 1 //开始为1 Maxvalue 99999999 //最大 cache 20 Create Trigger Trigger_Name //创建触发器 Before Insert On Table_Name //条件 For Each Row // Begin select Sequence_Name.nextval into :new.ID from dual; //ID加1 end;
/*************************************************************************** * 获取分页的全部信息 */ public List getAllI(int UserID, int nPageSize,int nPageNum) { ArrayList list = new ArrayList(); String sql = "select ID,to_Char(AddDate,'yyyy-mm-dd') as sDate, rowNum a ...
<script language="javascript"> var arrPro=new Array("北京","上海","天津"); function setPro(sValue){ var obj=document.getElementById("selProvince"); if(arrPro.length>0){ var nID=0; for(var i=0;i<arrPro.length;i++){ var oOption=document.createElement("OPTION"); oOption.val ...
function checkAll(){ var objCheck=document.getElementsByName("chk"); var obj=document.getElementById("chkAll"); for(var i=0;i<objCheck.length;i++){ if(obj.checked){ objCheck[i].checked=true; }else{ objCheck[i]. ...
http://h50237.www5.hp.com/iPortal/Template/Publication/Common/OneColumnWithLogo.aspx?PublicationID=71314e53-cc92-4c44-ac50-a7534a2d7ed6 MD5 md5=new MD5(); md5.getMD5ofStr(。。);
SmartUpload upLoad = new SmartUpload(); //SmartUpload组件 try { upLoad.initialize(getServlet().getServletConfig(),request,response); upLoad.upload(); or upLoad.upload(“。。。”); } catch (Exception e1) { // TODO Auto-generated catch block e1.printStackTrace(); } ...
父页面: function setChannel(){ var sID=document.getElementById("txtSID").value; if(navigator.appName=="Netscape"){ window.open("vip_w.jsp?sID="+sID,"","top=50,left=300,modal=yes,width=500,height=600,resizable=no,scrollbars=yes"); } else{ var sReturnValue=showModalDialog("vi ...
public boolean isNumeric(String s) { Pattern pattern = Pattern.compile("[0-9]*"); Matcher matcher = pattern.matcher(s); return matcher.matches(); } function isNumeric(value){ var returnValue = true; var re = new RegExp("^([0-9]+)$"); if(value.s ...
2007-12-12

存储过程 分页

关键字: 存储过程
CREATE OR REPLACE PACKAGE CURSPKG AS TYPE refCursorType IS REF CURSOR; procedure sp_Page(p_PageSize int, --每页记录数 p_PageNo int, --当前页码,从 1 开始 p_SqlSelect varchar2, --查询语句,含排序部分 p_SqlCount varchar2, --获取记录总数的查 ...
转载 Class aClass = Class.forName(xxx.xx.xx);   Object anInstance = aClass.newInstance();   Class.forName("").newInstance()返回的是object   but there is some limit for this method to create instance   that is your class constructor should no contain parameters, and you should cast the instance manual ...