<%@page import="java.sql.*, java.util.*" session="false" isThreadSafe="true" errorPage="ErrorPage.jsp"%>
<%

	String queryString=request.getQueryString();
	int intUrl=-1;
	String url_id="";
	String url="";
	
	if(queryString!=null)
	{
		intUrl=queryString.indexOf("url_id");
		url_id=queryString.substring(intUrl+7);
		
		HashMap urlsMap=(HashMap)application.getAttribute("urlsMap");
		
		if(urlsMap==null || urlsMap.get(url_id)==null){
			String DRIVER = "org.gjt.mm.mysql.Driver";
			String CONN_DB = "jdbc:mysql:///admin";
			String USER_ID = "fish";
			String USER_PASSWD = "bl00p!";
			Connection con=null;

			try 
			{
				Class.forName(DRIVER);
				con = DriverManager.getConnection(CONN_DB, USER_ID, USER_PASSWD);
				String sql ="select url_string from urls where url_id=?";

				PreparedStatement ps = con.prepareStatement(sql);
				ps.setString(1,url_id);

				ResultSet rs=ps.executeQuery();
				if(rs.next()){
					url=rs.getString("url_string");
				}
				
				if(urlsMap==null){
					urlsMap=new HashMap();
				}
				
				urlsMap.put(url_id, url);
				application.removeAttribute("urlsMap");
				application.setAttribute("urlsMap", urlsMap);
				
				if(rs!=null)
					rs.close();
				if(ps!=null)
					ps.close();
				if(con!=null)
					con.close();
				
			} 
			catch( Exception e ) 
			{
				e.printStackTrace();
			}	
			finally {
				try {
					if(con!=null)
						con.close();
				}
				catch(Exception e) {
					e.printStackTrace();
				}
			}

		}
		else{
			url=(String)urlsMap.get(url_id);
		}
		
		response.sendRedirect(url);
	}
	else
	{
			response.sendRedirect("http://www.tugboatmedia.com/");
	}

%>