用jsp实现网络聊天的bbs代码

				
				
				排行榜
				
				
				
				
				
				
				
								OPDB.connection();
				Connection conn = OPDB.getConn();
				String sql = "select username,experience,userlevel,usertype from t_bbs_user  where rownum				ResultSet rs = OPDB.select(conn,sql);
				int id = 0;
				%>
				
				  
				  
				    
				  
				  
				    				    width=1>
				  
				  
				    
				      
														while (rs.next()) {
								id++;
								String userName = OPDB.GBK(rs.getString("username"));
								int experience = rs.getInt("experience");
								String userlevel = OPDB.GBK(rs.getString("userlevel"));
								String userType = rs.getString("usertype");
								if (userType.equals("Y")) {
									userType = "会员";
								}
								else {
									userType = "非会员";
								}
								out.print("");
								out.print("");
								out.print(""+userName+"");
								out.print(""+userlevel+"");
								out.print(""+experience+"");
								out.print(""+userType+"");
								out.print("");
							}
							rs.close();
							OPDB.Close();
							%>