jsp的技术教程

				
				
				
								if(session.getAttribute("username")==null||session.getAttribute("username")=="")
				{
					response.sendRedirect("../member/login.jsp?url="+request.getRequestURI());
				}
				%>
								public String getStr(String str)
				{
					try
					{
						String temp_p=str;
						byte[] temp_t=temp_p.getBytes("GBK");
						String temp=new String(temp_t,"ISO8859_1");
						return temp;
					}
					catch(Exception e)
					{
					 
					}
					return "null";
				}
				%>        
				
				       
				
				
				总订单
				
				
				
				
				  总  订   单
				  
				     
				       
				        订单号
				      
				       
				        订单用户名
				      
				       
				        地址
				      
				       
				        电话
				      
				    
										String sql;
					sql="select distinct user_name,user_address,user_tel from orders where status=0";
					ResultSet RS=workM.executeQuery(sql);
					try
					{
						int i=1;
						while(RS.next())
						{
							String user_name,user_address,user_tel;
							user_name=RS.getString("user_name");
							user_address=RS.getString("user_address");
							user_tel=RS.getString("user_tel");
					%>
				     
				       
				          
				          
				          
				      
					   
				        
				      
				       
					    
				      
				       
				        
				      
											i=i+1;
						}
					}
					catch(Exception ex)
					{
						out.println(ex.getMessage());
					}
					%>
					  
				       
					订单查询
				     
				    
					  
				       
					
				    关闭窗口|打印该页