<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
			
		
    
	
    

    

			    		
		
    
	
    

    


    


    
	
					

    
	
	
	
    
		
		
    ?
    
		
    
				
				移動(dòng)查詢(xún)

    
				<%
				
				
						@?page?contentType
						=
						"
						text/html;charset=GB2312
						"
						?
				
				%>
				
						
    
						
						
				    
				<%
				
				
						@?page?import
						=
						"
						java.sql.*
						"
						?
				
				%>
				
						
    
						
				    
				<
				HTML
				>
				
						
    
						
				    
				<
				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
						"
						,
						"
						6599996
						"
						);
    ?????????sql    
						=
						con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
    ?????????rs    
						=
						sql.executeQuery(
						"
						SELECT?*?FROM?userTable
						"
						);
    ?????????rs.last();    
						//
						移動(dòng)到最后一行
    ?????????    
						int
						?rowNumber
						=
						rs.getRow();
						//
						得到最后一行的行號(hào)
    ?????????out.print(    
						"
						<Table?Border>
						"
						);
    ?????????out.print(    
						"
						<TR><td?colspan=8?align=center>用戶(hù)數(shù)據(jù)(逆序輸出，共
						"
						+
						rowNumber
						+
						"
						條記錄)</td></tr>
						"
						);???
    ?????????out.print(    
						"
						<TR>
						"
						);
    ????????????out.print(    
						"
						<Td?width=100?>
						"
						+
						"
						用戶(hù)ID號(hào)
						"
						);
    ????????????out.print(    
						"
						<Td?width=50?>
						"
						+
						"
						用戶(hù)名
						"
						);
    ????????????out.print(    
						"
						<Td?width=100>
						"
						+
						"
						用戶(hù)真實(shí)姓名
						"
						);
    ????????????out.print(    
						"
						<Td?width=50>
						"
						+
						"
						年齡
						"
						);
    ????????????out.print(    
						"
						<Td?width=50>
						"
						+
						"
						性別
						"
						);
    ????????????out.print(    
						"
						<Td?width=100>
						"
						+
						"
						聯(lián)系地址
						"
						);
    ????????????out.print(    
						"
						<Td?width=100>
						"
						+
						"
						聯(lián)系電話(huà)
						"
						);
    ????????????out.print(    
						"
						<Td?width=100>
						"
						+
						"
						添加時(shí)間
						"
						);
    ?????????out.print(    
						"
						</TR>
						"
						);
    ???????rs.afterLast();    
						//
						移動(dòng)到最后一行的后面
    ???????    
						while
						(rs.previous())
    ???????{?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>
						"
						)?;?
    ????????}
    ???????rs.absolute(    
						2
						);
						//
						移動(dòng)到第2行
    ???????out.print(    
						"
						<TR><td?colspan=8?align=center>指定輸出第2個(gè)用戶(hù)的數(shù)據(jù)</td></tr>
						"
						);
    ???????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>
						"
						)?;?
    ????????out.print(    
						"
						</Table>
						"
						);
    ????????con.close();
    ?????}
    ???catch(SQLException?e1)?
    ???{
    ??????out.print(    
						"
						SQL異常！
						"
						);
    ???}
    ?    
				    
				%>
				
						
    
						
				    
				</
				BODY
				>
				
						
    
						
				    
				</
				HTML
				>
				
						
    
						
						
    
						
						
    
						
				    
		
    
		
    
				
				?
    

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

    







    
	    
    




    








    

				

    




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

    

    







    
        
	



主站蜘蛛池模板：
国产午夜成人免费看片无遮挡|
国产福利视精品永久免费|
久久精品国产亚洲av高清漫画|
精品久久久久久久久免费影院|
亚洲高清毛片一区二区|
久久亚洲精品无码|
国产免费爽爽视频免费可以看|
2021在线观看视频精品免费|
免费无码婬片aaa直播表情|
亚洲剧场午夜在线观看|
亚洲国产另类久久久精品|
免费在线观看理论片|
毛片免费在线视频|
国内永久免费crm系统z在线|
91在线免费观看|
麻豆一区二区三区蜜桃免费|
亚洲一区二区三区免费观看|
亚洲国产高清在线|
亚洲色精品aⅴ一区区三区|
国产精品久免费的黄网站|
欧美日韩国产免费一区二区三区|
很黄很污的网站免费|
亚洲免费视频一区二区三区|
国产精品亚洲一区二区三区久久
|
亚洲国产天堂久久综合|
91在线品视觉盛宴免费|
91福利视频免费|
免费观看91视频|
1000部啪啪未满十八勿入免费|
丁香花免费完整高清观看|
日韩免费视频在线观看|
天天摸夜夜摸成人免费视频|
另类免费视频一区二区在线观看|
免费A级毛片无码A∨中文字幕下载|
成人无码区免费A∨直播|
一级毛片**免费看试看20分钟|
老子影院午夜伦不卡亚洲|
亚洲乱码无限2021芒果|
亚洲av日韩av永久无码电影|
亚洲熟妇av午夜无码不卡|
亚洲人成网站看在线播放|