لك مني هدية أو أجرك::: إن زودتني بهذا البرنامج:::

السلام عليك

ادهب الى هدا الموقعhttp://www.mooj3.jeeran.com

 you can answer this proplem with database 
1.write a class in java. this class can read a text file and save all  Adresses in Vector or ArrayList than insert the adresses in  a table of database ( for Ex. Adress_Tabel )
2. excute the sql statment 

"select  distinct Adress from Adress_Table order by Adress"
with JDBC

please try with this Algorithm and if you aproplem please send me e-mail

/* this is not the progam but code for Algorithm*/
import java.io.*;
import java.util.*;
import java.sql.*;

class Save_Adress
{
Vector all_adress=null;
Vector my_adress=null;
public static void main(String args[])
{

 String txt = readFromFile("adress.txt");
 all_adress=set_allAdress_in_vector(txt);
connect();
insert_all_Adress(all_adress);
String sel="select distinct Adress from Adress_Table order by Adress";
my_adress=getSelect(sel);
OutResult(my_adress);
disconnect();
}

public void OutResult(Vector vec);/write the Adresses in the Console/

public void connect();/* for connect with database*/

public void disconnect();/*for disconnect with DB*/

public Vector set_allAdress_in_vector(String str );

public getAdress(String txt);

public String  getInsertForAdress(String adr)
{
  return "insert into Adress_Table(Adress)value ("+adr+)";

}

public void excute_in_DB(string str);

public void insert_all_Adress(Vector vec)
{
if(vec==null||vec.size()==0) 
return;
for(int i=0;i{
  String str=getInsertForAdress((String)vec.elmentAt(i));
   void excute_in_DB(string str);


  }
}


}

/*Another and simple method */

the Emails muss in textfile as

xxx@sbs.com

xxy@zzz.net

Or you musst uese TokenString in the mehod readfile

import java.io.*;
import java.util.*;
public class FileEmails
{

    FileReader _idocfile=null;
    BufferedReader _buffin=null;
    HashMap hm=new HashMap();

public FileEmails()
{

}

public String readFile(String inFileName)
    {
        String quell ="";
        String in;
        try
        {
            _idocfile = new FileReader(inFileName);
            _buffin = new BufferedReader(_idocfile);
            StringBuffer strBuf=new StringBuffer();



	        while ((in = _buffin.readLine())!= null)                        
            {	 
	                hm.put(in,"");                         

	        }

        }
        catch (FileNotFoundException e)
        {
            System.out.println(e.toString());
        }
        catch (Exception e)
        {   
            System.out.println(e.toString());

        }
        finally
        {
            try
            {
	            _buffin.close();
                _idocfile.close();     
            }
            catch (Exception e)
            {
                 System.out.println(e.toString());
            }
        }

        return quell;
    }

public void outEmails()
{

     for (Iterator e=hm.keySet().iterator();e.hasNext();)
                    {
                        String fkey=(String)e.next();
                        if(fkey!=null&&fkey.length()>0&&fkey.trim().length()>0)
                        System.out.println(fkey);

                    }
}
public static void main(String[] args)
{
    FileEmails myEmails=new FileEmails();
    myEmails.readFile("mails.txt");
    myEmails.outEmails();
}
}