java»ñµÃmssqlÊý¾Ý¼¯µÄÎÊÌâ
ÓÉÓÚ×î½üҪдһ¸ö·ÖÒ³µÄ³ÌÐò£¬ÔÚÍøÉÏÕÒÁ˸ö´æ´¢¹ý³Ì£»
create procedure add_pp_SqlPager
@sqlstr nvarchar(4000), --²éѯ×Ö·û´®
@currentpage int, --µÚNÒ³
@pagesize int --ÿҳÐÐÊý
as
set nocount on
declare @P1 int, --P1ÊÇÓαêµÄid
@rowcount int
exec sp_cursoropen @P1 output ,@sqlstr,@scrollopt=1,@ccopt=1,@rowcount=@rowcount output
set @currentpage=(@currentpage-1)*@pagesize+1
exec sp_cursorfetch @P1,16,@currentpage,@pagesize
exec sp_cursorclose @P1
set nocount off
µ«ÊÇËü·µ»ØÁ½¸öÊý¾Ý¼¯ºÏ£¬µÚÒ»¸öÊǿռ¯ºÏ¡£ÎÒҪȡµÚ¶þ¸ö£¬ÇëÎÊÈçºÎÓÃjava³ÌÐòÈ¡µÃ£¿Ð»Ð»
È¡µ½È«²¿½á¹û¼¯ ·ÅÒ»¸ölistÀïÃæ
ÔÙÅжÏ
¿´ÎҵIJ©¿ÍÀïÃæÓÐÒ»¸öhibernateµ÷Óô洢¹ý³ÌµÄÀý×Ó
ÎÒ²»ÐèÒªÓÃhibernate°¡£¬´ó¸ç£¡
1Â¥µÄ¿ÉÐÐ
Ïà¹ØÎÊ´ð£º
<%@page language="java" contentType="text/html;charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="db" class="wang.connectDB"/>
< ......
ÎÒÏÖÔÚÓÃstruts2¿ò¼Ü,ÐèҪʹÓÃajaxʵÏÖ¾Ö²¿Ë¢Ð£¬µ«ÊÇ´ÓÈÝÆ÷Àï·µ»ØµÄÖµ²»ÖªµÀÔõô´Óstruts.xmlÅäÖÃÎļþÀïÓ³Éäµ½jspÒ³ÃæÀÒÔǰservletÀïдout.orint("xxxxx")¾Í¿ÉÒԵõ½~£¬µ«ÊÇÏÖÔÚÓÃstruts¾Í²»ÖªµÀÔõôР......
ÎÒÏëÎÒjavaÕâÒ»·½Ãæ·¢Õ¹£¬ÓÐÄÄһλ¸ßÊÖ¿ÉÒÔ¸æËßÎÒ£¬Ïë³ÉΪһÃûJAVA±à³Ì¸ßÊÖ£¬Ëû±ØÐëҪѧϰµÄ֪ʶÂ𣿱ÈÈç˵ÎÒѧÍêÁËJAVAµÄ»ù´¡ÖªÊ¶Ö®ºóÎҸðÑÄ¿¹â·ÅÔÚÄÄÒ»·½Ã棬½ÓÏÂÀ´ÎÒÔÚѧϰÓйØJAVAµÄʲô֪ʶ£¿ÅóÓÑà ......
¹¤×÷ÐèÒª Çó´ó¼Ò°ïæд¸ö³ÌÐò
ÎÒÊÇѧC++µÄ ²»¶®JAVA
±àдһ¸öJavaÓ¦ÓóÌÐò£¬¶ÔÓÚ¸ø¶¨µÄÒ»¸ö×Ö·û´®µÄ¼¯ºÏ£¬¸ñʽÈ磺
{aaa bbb ccc}£¬ {bbb ddd}£¬{eee fff}£¬{ggg}£¬{ddd hhh}
ÒªÇ󽫯äÖн»¼¯²»Îª¿ÕµÄ ......
<html><head><title>[@title]</title>
<meta http-equiv=Content-Type content="text/html; charset=gb2312">
<script language='javascript'>
function diyCheck ......