indexer.java

Grid based Search Engine

		            catch(SQLException ex)
		            	{
		            		System.err.println("SQLException2: "+ex.getMessage());
		                }

		        }


	        public boolean matchedRecord1(String key,String fileAddress)
	        	{
	        		boolean flag=false;
	        		String query;
			query=" select KEYWORD,URLADDRESS from INDEXTABLE "+
					"where KEYWORD='"+key.toLowerCase()+"' and URLADDRESS='"+fileAddress+"'";



		            try
		            	{
		            		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		            	}
		            catch(java.lang.ClassNotFoundException e)
		            	{
		            		System.err.print("ClassNotFoundException: ");
		            		System.err.println(e.getMessage());
		                }

		            try
		            	{
			          
		            		con=DriverManager.getConnection(connectionAddress,"",
		            		"");
		            		stmt=con.createStatement();
                                        rs=stmt.executeQuery(query);
		            		if(rs.next()==true)
		            		{
		            			flag= true;
		            		   	//System.out.println(flag);
		            		}
		            		else
		            		{
		            		   	flag= false;
		            		 	//System.out.println(flag);

		            		}
		            		stmt.close();
		            		con.close();
			       

		            	}
		            catch(SQLException ex)
		            	{
		            		System.err.println( "SQLException3: "+ex.getMessage());
		                }
		       		return flag;


		            }
	        public boolean matchedRecord2(String key,String fileAddress)
	        	{
	        		boolean flag=false;
	        		String query;
			query=" select KEYWORD,URLADDRESS from INDEXTABLE "+
					"where KEYWORD='"+key.toLowerCase()+"' and URLADDRESS='"+fileAddress+"'";



		            try
		            	{
		            		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		            	}
		            catch(java.lang.ClassNotFoundException e)
		            	{
		            		System.err.print("ClassNotFoundException: ");
		            		System.err.println(e.getMessage());
		                }

		            try
		            	{
			          
		            		con1=DriverManager.getConnection(connectionAddress1,"",
		            		"");
		            		stmt=con1.createStatement();
                                        rs=stmt.executeQuery(query);
		            		if(rs.next()==true)
		            		{
		            			flag= true;
		            		   	//System.out.println(flag);
		            		}
		            		else
		            		{
		            		   	flag= false;
		            		 	//System.out.println(flag);

		            		}
		            		stmt.close();
		            		con1.close();
			       

		            	}
		            catch(SQLException ex)
		            	{
		            		System.err.println( "SQLException3: "+ex.getMessage());
		                }
		       		return flag;


		            }
	        public boolean matchedRecord3(String key,String fileAddress)
	        	{
	        		boolean flag=false;
	        		String query;
			query=" select KEYWORD,URLADDRESS from INDEXTABLE "+
					"where KEYWORD='"+key.toLowerCase()+"' and URLADDRESS='"+fileAddress+"'";



		            try
		            	{
		            		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		            	}
		            catch(java.lang.ClassNotFoundException e)
		            	{
		            		System.err.print("ClassNotFoundException: ");
		            		System.err.println(e.getMessage());
		                }

		            try
		            	{
			          
		            		con2=DriverManager.getConnection(connectionAddress2,"",
		            		"");
		            		stmt=con2.createStatement();
                                        rs=stmt.executeQuery(query);
		            		if(rs.next()==true)
		            		{
		            			flag= true;
		            		   	//System.out.println(flag);
		            		}
		            		else
		            		{
		            		   	flag= false;
		            		 	//System.out.println(flag);

		            		}
		            		stmt.close();
		            		con2.close();
			       

		            	}
		            catch(SQLException ex)
		            	{
		            		System.err.println( "SQLException3: "+ex.getMessage());
		                }
		       		return flag;


		            }
	        public boolean matchedRecord4(String key,String fileAddress)
	        	{
	        		boolean flag=false;
	        		String query;
			query=" select KEYWORD,URLADDRESS from INDEXTABLE "+
					"where KEYWORD='"+key.toLowerCase()+"' and URLADDRESS='"+fileAddress+"'";



		            try
		            	{
		            		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		            	}
		            catch(java.lang.ClassNotFoundException e)
		            	{
		            		System.err.print("ClassNotFoundException: ");
		            		System.err.println(e.getMessage());
		                }

		            try
		            	{
			          
		            		con3=DriverManager.getConnection(connectionAddress3,"",
		            		"");
		            		stmt=con3.createStatement();
                                        rs=stmt.executeQuery(query);
		            		if(rs.next()==true)
		            		{
		            			flag= true;
		            		   	//System.out.println(flag);
		            		}
		            		else
		            		{
		            		   	flag= false;
		            		 	//System.out.println(flag);

		            		}
		            		stmt.close();
		            		con3.close();
			       

		            	}
		            catch(SQLException ex)
		            	{
		            		System.err.println( "SQLException3: "+ex.getMessage());
		                }
		       		return flag;


		            }

	            public void updateRecord1(String key,String fileAddress)
		           {

				String updateString;
				updateString="update INDEXTABLE"+
					" set FREQUENCY=FREQUENCY+1" + " where KEYWORD='"+key.toLowerCase()+"' and URLADDRESS='"+fileAddress+"'";


		            try
		            	{
		            		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		            	}
		            catch(java.lang.ClassNotFoundException e)
		            	{
		            		System.err.print("ClassNotFoundException: ");
		            		System.err.println(e.getMessage());
		                }

		            try
		            	{
			     
		            		con=DriverManager.getConnection(connectionAddress,"",
		            		"");
		            		stmt=con.createStatement();
		            		stmt.executeUpdate(updateString);
		            		stmt.close();
		            		con.close();
			          
		            	}
		            catch(SQLException ex)
		            	{
		            		System.err.println("SQLException4: "+ex.getMessage());
		                }

		          }
	            public void updateRecord2(String key,String fileAddress)
		           {

				String updateString;
				updateString="update INDEXTABLE"+
					" set FREQUENCY=FREQUENCY+1" + " where KEYWORD='"+key.toLowerCase()+"' and URLADDRESS='"+fileAddress+"'";


		            try
		            	{
		            		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		            	}
		            catch(java.lang.ClassNotFoundException e)
		            	{
		            		System.err.print("ClassNotFoundException: ");
		            		System.err.println(e.getMessage());
		                }

		            try
		            	{
			     
		            		con1=DriverManager.getConnection(connectionAddress1,"",
		            		"");
		            		stmt=con1.createStatement();
		            		stmt.executeUpdate(updateString);
		            		stmt.close();
		            		con1.close();
			          
		            	}
		            catch(SQLException ex)
		            	{
		            		System.err.println("SQLException4: "+ex.getMessage());
		                }

		          }

	            public void updateRecord3(String key,String fileAddress)
		           {

				String updateString;
				updateString="update INDEXTABLE"+
					" set FREQUENCY=FREQUENCY+1" + " where KEYWORD='"+key.toLowerCase()+"' and URLADDRESS='"+fileAddress+"'";


		            try
		            	{
		            		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		            	}
		            catch(java.lang.ClassNotFoundException e)
		            	{
		            		System.err.print("ClassNotFoundException: ");
		            		System.err.println(e.getMessage());
		                }

		            try
		            	{
			     
		            		con2=DriverManager.getConnection(connectionAddress2,"",
		            		"");
		            		stmt=con2.createStatement();
		            		stmt.executeUpdate(updateString);
		            		stmt.close();
		            		con2.close();
			          
		            	}
		            catch(SQLException ex)
		            	{
		            		System.err.println("SQLException4: "+ex.getMessage());
		                }

		          }

	            public void updateRecord4(String key,String fileAddress)
		           {

				String updateString;
				updateString="update INDEXTABLE"+
					" set FREQUENCY=FREQUENCY+1" + " where KEYWORD='"+key.toLowerCase()+"' and URLADDRESS='"+fileAddress+"'";


		            try
		            	{
		            		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		            	}
		            catch(java.lang.ClassNotFoundException e)
		            	{
		            		System.err.print("ClassNotFoundException: ");
		            		System.err.println(e.getMessage());
		                }

		            try
		            	{
			     
		            		con3=DriverManager.getConnection(connectionAddress3,"",
		            		"");
		            		stmt=con3.createStatement();
		            		stmt.executeUpdate(updateString);
		            		stmt.close();
		            		con3.close();
			          
		            	}
		            catch(SQLException ex)
		            	{
		            		System.err.println("SQLException4: "+ex.getMessage());
		                }

		          }

	    	}