<rt id="bn8ez"></rt>
<label id="bn8ez"></label>
  • 

    • <span id="bn8ez"></span>
    

    <label id="bn8ez"><meter id="bn8ez"></meter></label>
    

    
    

    




    







												


        

    
	

    
	
    
		
    
			
				
    e代劍客——溫柔一刀
    
				
    生活就像海洋，只有意志堅(jiān)強(qiáng)的人，才能到達(dá)彼岸
    
			    		
		
    
	
    

    

    
	
    
		
    
			
 
 ::
首頁(yè) ::
新隨筆 ::
聯(lián)系 ::
聚合
 ::
管理 ::


			
			
				

    
	
    
		
    
			
			
			
				 
				76 
				隨筆 ::
				7 文章
				::
				215 評(píng)論
				::
				0 Trackbacks
			
		
    
	
    

    

			    		
		
    
	
    

    


    


    
	
					

    
	
	
	
    
		
		
    ?
    
		
    
				
				分頁(yè)顯示記錄

    
				<%
				
				
						@?page?contentType
						=
						"
						text/html;charset=GB2312
						"
						?
				
				%>
				
						
    
						
						
				    
				<%
				
				
						@?page?import
						=
						"
						java.sql.*
						"
						?
				
				%>
				
						
    
						
						
				    
				<%
				
				
						
								
    
								
						    
						int
						?dipage
						=
						1
						;
						//
						當(dāng)前頁(yè)碼數(shù)默認(rèn)為1
    
						String
						?pages
						=
						request.getParameter(
						"
						dipage
						"
						);
    
						if
						(pages
						==
						null
						)
    {
    ??pages    
						=
						"
						1
						"
						;
    }
    try
    {
    ??dipage    
						=
						Integer
						.parseInt(pages);
    }
    catch(Exception?e)
    {
    ??dipage    
						=
						1
						;?
    }
    
				    
				%>
				
						
    
						
				    
				<
				HTML
				>
				
						
    
						
				    
				<
				title
				>
				用戶(hù)數(shù)據(jù)
				</
				title
				>
				
						
    
						
				    
				<
				BODY
				>
				
						
    
						
						?    
				<%
				
				
						?Connection?con;
    ????Statement?sql;?
    ????ResultSet?rs;
    ????try
    ????{
    ??????Class.forName(    
						"
						com.microsoft.jdbc.sqlserver.SQLServerDriver
						"
						);
    ????}
    ????catch(ClassNotFoundException?e)
    ????{
    ??????out.print(    
						"
						類(lèi)找不到！
						"
						);
    ????}
    ????try?
    ????{??
    ?????????con    
						=
						DriverManager.getConnection(
						"
						jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=testDatabse
						"
						,
						"
						sa
						"
						,
						""
						);
    ?????????sql    
						=
						con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
    ?????????rs    
						=
						sql.executeQuery(
						"
						SELECT?*?FROM?userTable
						"
						);
    ?????????    
						int
						?countRecord
						=
						0
						;
						//
						記錄條數(shù)
    ?????????    
						int
						?countPageRecord
						=
						0
						;
						//
						每頁(yè)記錄條數(shù)
    ?????????    
						int
						?countPage
						=
						0
						;
						//
						總頁(yè)數(shù)
    ?????????countPageRecord    
						=
						5
						;
						//
						每頁(yè)5條記錄，要設(shè)置每頁(yè)記錄條數(shù)就更改這個(gè)變量的值
    ?????????    
						//
						得到記錄的條數(shù)
    ?????????rs.last();
    ?????????countRecord    
						=
						rs.getRow();
    ?????????    
						//
						得到總頁(yè)數(shù)
    ?????????    
						if
						(countRecord
						/
						countPageRecord
						==
						0
						)
    ????????????countPage    
						=
						countRecord
						/
						countPageRecord;
    ?????????    
						else
						
								
    
								????????????countPage    
						=
						countRecord
						/
						countPageRecord
						+
						1
						;
    ?????????    
						//
						把記錄指針移至當(dāng)前頁(yè)第一條記錄之前
    ?????????    
						if
						((dipage
						-
						1
						)
						*
						countPageRecord
						==
						0
						)
    ????????????rs.beforeFirst();
    ?????????    
						else
						
								
    
								????????????rs.absolute((dipage    
						-
						1
						)
						*
						countPageRecord);
    ?????????out.print(    
						"
						<Table?Border?style='font-size:?10pt'>
						"
						);
    ?????????out.print(    
						"
						<TR><td?colspan=8?align=center>用戶(hù)數(shù)據(jù)</td></tr>
						"
						);???
    ?????????out.print(    
						"
						<TR>
						"
						);
    ????????????out.print(    
						"
						<Td?width=60?>
						"
						+
						"
						用戶(hù)ID號(hào)
						"
						);
    ????????????out.print(    
						"
						<Td?width=50?>
						"
						+
						"
						用戶(hù)名
						"
						);
    ????????????out.print(    
						"
						<Td?width=100>
						"
						+
						"
						用戶(hù)真實(shí)姓名
						"
						);
    ????????????out.print(    
						"
						<Td?width=40>
						"
						+
						"
						年齡
						"
						);
    ????????????out.print(    
						"
						<Td?width=40>
						"
						+
						"
						性別
						"
						);
    ????????????out.print(    
						"
						<Td?width=100>
						"
						+
						"
						聯(lián)系地址
						"
						);
    ????????????out.print(    
						"
						<Td?width=100>
						"
						+
						"
						聯(lián)系電話(huà)
						"
						);
    ????????????out.print(    
						"
						<Td?width=100>
						"
						+
						"
						添加時(shí)間
						"
						);
    ?????????out.print(    
						"
						</TR>
						"
						);
    ???????    
						int
						?i
						=
						0
						;
    ???????    
						while
						(rs.next())
    ???????{?out.print(    
						"
						<TR>
						"
						);
    ?????????????out.print(    
						"
						<TD?>
						"
						+
						rs.getLong(
						1
						)
						+
						"
						</TD>
						"
						);
    ?????????????out.print(    
						"
						<TD?>
						"
						+
						rs.getString(
						2
						)
						+
						"
						</TD>
						"
						);?
    ?????????????out.print(    
						"
						<TD?>
						"
						+
						rs.getString(
						4
						)
						+
						"
						</TD>
						"
						);
    ?????????????out.print(    
						"
						<TD?>
						"
						+
						rs.getInt(
						"
						user_age
						"
						)
						+
						"
						</TD>
						"
						);?
    ?????????????out.print(    
						"
						<TD?>
						"
						+
						rs.getString(
						"
						user_sex
						"
						)
						+
						"
						</TD>
						"
						);
    ?????????????out.print(    
						"
						<TD?>
						"
						+
						rs.getString(
						"
						user_address
						"
						)
						+
						"
						</TD>
						"
						);
    ?????????????out.print(    
						"
						<TD?>
						"
						+
						rs.getString(
						"
						user_telephone
						"
						)
						+
						"
						</TD>
						"
						);
    ?????????????out.print(    
						"
						<TD?>
						"
						+
						rs.getString(
						"
						add_time
						"
						)
						+
						"
						</TD>
						"
						);
    ????????out.print(    
						"
						</TR>
						"
						)?;
    ????????i    
						++
						;
    ????????    
						if
						(i
						>=
						countPageRecord)?break;?
						//
						當(dāng)前頁(yè)顯示完，則退出循環(huán)
    ????????}
    ????????out.print(    
						"
						<TR><td?colspan=8?align=center>
						"
						);
    ???????????out.print(    
						"
						共
						"
						+
						countRecord
						+
						"
						條記錄,共
						"
						+
						countPage
						+
						"
						頁(yè)，當(dāng)前第
						"
						+
						dipage
						+
						"
						頁(yè)，每頁(yè)
						"
						+
						countPageRecord
						+
						"
						條記錄，
						"
						);
    ???????????    
						if
						(dipage
						==
						1
						)
						//
						當(dāng)前是首頁(yè)
    ??????????????;
    ???????????    
						else
						//
						當(dāng)前不是首頁(yè)
    ???????????{
    ??????????????out.print(    
						"
						<a?href=userPage1.jsp?dipage=1>首頁(yè)</a>，
						"
						);
    ??????????????out.print(    
						"
						<a?href=userPage1.jsp?dipage=
						"
						+
						(dipage
						-
						1
						)
						+
						"
						>上一頁(yè)</a>,
						"
						);
    ???????????}
    ???????????    
						if
						(dipage
						==
						countPage)
						//
						當(dāng)前是末頁(yè)
    ??????????????;
    ???????????    
						else
						//
						當(dāng)前不是末頁(yè)
    ???????????{
    ??????????????out.print(    
						"
						<a?href=userPage1.jsp?dipage=
						"
						+
						(dipage
						+
						1
						)
						+
						"
						>下一頁(yè)</a>,
						"
						);
    ??????????????out.print(    
						"
						<a?href=userPage1.jsp?dipage=
						"
						+
						countPage
						+
						"
						>末頁(yè)</a>
						"
						);
    ???????????}??????????
    ???????????
    ???????????out.print(    
						"
						</td></tr>
						"
						);?
    ????????out.print(    
						"
						</Table>
						"
						);
    ????????con.close();
    ?????}
    ???catch(SQLException?e1)?
    ???{
    ??????out.print(    
						"
						SQL異常！
						"
						);
    ???}
    ?    
				    
				%>
				
						
    
						
				    
				</
				BODY
				>
				
						
    
						
				    
				</
				HTML
				>
				
						
    
						
						
    
						
				    
		
    

	
    
	
	
    
		posted on 2006-04-25 18:16 溫柔一刀 閱讀(159) 評(píng)論(0)  編輯  收藏  所屬分類(lèi): java相關(guān) 
	
    

    







    
	    
    




    








    

				

    




    聯(lián)系偶 zhupanjava@gmail.com 
溫柔一刀

    

    







    
        
	



主站蜘蛛池模板：
亚洲人成亚洲人成在线观看
|
2022国内精品免费福利视频|
亚洲一区精品伊人久久伊人
|
俄罗斯极品美女毛片免费播放
|
免费a级毛片视频|
中文在线免费观看|
国产成人精品日本亚洲18图|
亚洲av无码专区在线观看素人|
久久久久久噜噜精品免费直播|
亚洲人成在线播放|
青青草原亚洲视频|
99久久这里只精品国产免费|
一区在线免费观看|
亚洲国产精品成人精品软件|
青青青国产色视频在线观看国产亚洲欧洲国产综合
|
亚洲中文字幕无码久久综合网|
97视频免费在线|
jizz18免费视频|
亚洲冬月枫中文字幕在线看|
亚洲一区二区三区免费|
午夜精品在线免费观看|
久久精品一区二区免费看|
黄色三级三级免费看|
亚洲av极品无码专区在线观看|
亚洲无线码在线一区观看|
韩国18福利视频免费观看|
久久免费的精品国产V∧|
免费一级毛片在线播放视频免费观看永久|
亚洲精品电影在线|
亚洲精品国产成人影院|
青青青国产免费一夜七次郎|
免费人成在线观看69式小视频|
h在线看免费视频网站男男|
亚洲熟妇AV一区二区三区宅男|
久久亚洲AV成人无码国产|
亚洲综合网站色欲色欲|
国产一级高清视频免费看|
人禽杂交18禁网站免费|
国产乱子精品免费视观看片|
免费在线看黄的网站|
国产免费一区二区三区免费视频|