e代劍客——溫柔一刀
          
				
          生活就像海洋，只有意志堅強的人，才能到達彼岸
          
			          		
		
          
	
          

          

          
	
          
		
          
			
 
 ::
首頁 ::
新隨筆 ::
聯系 ::
聚合
 ::
管理 ::


			
			
				

          
	
          
		
          
			
			
			
				 
				76 
				隨筆 ::
				7 文章
				::
				215 評論
				::
				0 Trackbacks
			
		
          
	
          

          

			          		
		
          
	
          

          


          


          
	
					

          
	
	
	
          
		
		
          ?
          
		
          
				
				
				<%
				
				
						@?page?contentType
						=
						"
						text/html;charset=GB2312
						"
						?
				
				%>
				
						
          
						
						
				          
				<%
				
				
						@?page?import
						=
						"
						java.sql.*
						"
						?
				
				%>
				
						
          
						
				          
				<
				HTML
				>
				
						
          
						
				          
				<
				BODY
				>
				
						
          
						
						?          
				<%
				
				
						?Connection?con;
          ????Statement?sql;?
          ????ResultSet?rs;
          ????try
          ????{
          ??????Class.forName(          
						"
						sun.jdbc.odbc.JdbcOdbcDriver
						"
						);
          ????}
          ????catch(ClassNotFoundException?e)
          ????{
          ??????out.print(          
						"
						類找不到！
						"
						);
          ????}
          ????try?
          ????{??
          ?????????con          
						=
						DriverManager.getConnection(
						"
						jdbc:odbc:testDB
						"
						);
          ?????????sql          
						=
						con.createStatement();
          ?????????rs          
						=
						sql.executeQuery(
						"
						SELECT?*?FROM?userTable
						"
						);
          ?????????out.print(          
						"
						<Table?Border>
						"
						);
          ?????????out.print(          
						"
						<TR><td?colspan=8?align=center>用戶數據</td></tr>
						"
						);???
          ?????????out.print(          
						"
						<TR>
						"
						);
          ????????????out.print(          
						"
						<Td?width=100?>
						"
						+
						"
						用戶ID號
						"
						);
          ????????????out.print(          
						"
						<Td?width=50?>
						"
						+
						"
						用戶名
						"
						);
          ????????????out.print(          
						"
						<Td?width=100>
						"
						+
						"
						用戶真實姓名
						"
						);
          ????????????out.print(          
						"
						<Td?width=50>
						"
						+
						"
						年齡
						"
						);
          ????????????out.print(          
						"
						<Td?width=50>
						"
						+
						"
						性別
						"
						);
          ????????????out.print(          
						"
						<Td?width=100>
						"
						+
						"
						聯系地址
						"
						);
          ????????????out.print(          
						"
						<Td?width=100>
						"
						+
						"
						聯系電話
						"
						);
          ????????????out.print(          
						"
						<Td?width=100>
						"
						+
						"
						添加時間
						"
						);
          ?????????out.print(          
						"
						</TR>
						"
						);
          ???????          
						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>
						"
						)?;?
          ????????}
          ????????out.print(          
						"
						</Table>
						"
						);
          ????????con.close();
          ?????}
          ???catch(SQLException?e1)?
          ???{
          ??????out.print(          
						"
						SQL異常！
						"
						);
          ???}
          ?          
				          
				%>
				
						
          
						
				          
				</
				BODY
				>
				
						
          
						
				          
				</
				HTML
				>
				
						
          
						
						
          
						
				          
		
          

	
          
	
	
          
		posted on 2006-04-25 18:09 溫柔一刀 閱讀(208) 評論(0)  編輯  收藏  所屬分類: java相關 
	
          

          







          
	    
    




          








          

				

          




          聯系偶 zhupanjava@gmail.com 
溫柔一刀

          

    







          
        
	




主站蜘蛛池模板：
枣阳市|
华蓥市|
大港区|
巴青县|
靖边县|
兴仁县|
溧阳市|
五华县|
多伦县|
定远县|
漠河县|
德化县|
新邵县|
从化市|
潜山县|
长垣县|
博兴县|
诸城市|
云和县|
桓仁|
屏山县|
遂平县|
保亭|
古蔺县|
林甸县|
高雄县|
富顺县|
兰西县|
湛江市|
平泉县|
青海省|
射洪县|
通道|
尚义县|
莆田市|
仪陇县|
乌恰县|
溧阳市|
宣城市|
当阳市|
铜山县|