update db

[duhit Choudhary]

package com.iremote.itunes;


import java.util.List;
import java.util.LinkedList;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import org.apache.log4j.Logger;
import org.apache.log4j.PropertyConfigurator;

public class DBReader {
	Logger log = Logger.getLogger(XmlReader.class);
	List<String> idList = new LinkedList<String>();
	
	public List<String> getAllTrackIdFromDB()
	{
		log.info("started");
		
		//TODO configure url 
		String connectionURL = "jdbc:mysql:////localhost:3306/mymovie?useUnicode=yes&characterEncoding=UTF-8";  //machine name, port number, database name
		String user = "root"; String pass="duhit";
        Connection connection = null;
        Statement statement = null;
        ResultSet resultSet = null;
        //TODO include tv shows and videos section
        String queryString =" SELECT track_id FROM track WHERE track_id !=0 "+
        					" UNION "+
        					" SELECT track_id FROM movie WHERE track_id!=0 ";
        log.info("entering try");
        try 
        {
        	
        	Class.forName("com.mysql.jdbc.Driver");
            
        	connection = DriverManager.getConnection(connectionURL, user, pass);
        	
        	statement = connection.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
        	
        	resultSet = statement.executeQuery(queryString);
			
        
			while(resultSet.next())
			{
				//TODO column name. might break if the column is renamed
				idList.add(resultSet.getString("track_id"));
			}
			
        }
        catch (Exception e) 
        {
			log.error("exception in db access",e);
		}
        
       
       //System.out.println("--------"+idList);

		
		return idList;
	}
	public static void main(String[] args) {
		PropertyConfigurator.configure("E:\\lib\\Log4J.properties");
		DBReader reader = new DBReader();
		reader.getAllTrackIdFromDB();
	}
}

this is the class by which i can get the trackId of the song present in the db.

package com.iremote.itunes;

import java.util.HashMap;
import java.util.List;
import java.util.Map;
import org.apache.commons.configuration.ConfigurationException;
import org.apache.commons.configuration.HierarchicalConfiguration;
import org.apache.commons.configuration.XMLConfiguration;
import org.apache.log4j.Logger;
import org.apache.log4j.PropertyConfigurator;

public class XmlReader {
	Logger log = Logger.getLogger(XmlReader.class);
    Track obj = new Track();
    Map<String,Track> trackMap = null;
    
    @SuppressWarnings("unchecked")
	public Map<String, Track> getTracksFromXml(String path)
    {

        try
        {
        	XMLConfiguration config;
        	//TODO configure url
        	if(path==null||"".equals(path))
        		 config = new XMLConfiguration("C:/Users/pbsl/Documents/itunes.xml");
        	else
        		config = new XMLConfiguration(path);
	       
	        List<HierarchicalConfiguration> fields = config.configurationsAt("Tracks.Track");
	        trackMap = new HashMap<String, Track>(fields.size());
	        String isUrl,  title, fileFormat, location, artist, genre, album, trackId,runTime;
	        for(HierarchicalConfiguration sub : fields)
	        {
	             
	            isUrl = sub.getString("Track-Type"); 
	            fileFormat = sub.getString("Kind");
	            title = sub.getString("Name");
	            location = sub.getString("Location");
	            artist = sub.getString("Artist");
	            trackId = sub.getString("Track-ID");
	            runTime = sub.getString("Total-Time");
	            genre = sub.getString("Genre");
	            album = sub.getString("Album");
	         
	
	            Track track = new Track();
	            if(isUrl.equalsIgnoreCase("file"))
	            	track.setIsUrl(0);
	            else
	            	track.setIsUrl(1);
	          
	            track.setFileFormat(fileFormat);
	            track.setTitle(title);
	            track.setLocation(location);
	            track.setArtist(artist);
		        track.setTrackId(Integer.parseInt(trackId));  
		        if (runTime==null)
		        	track.setRunTime(0);   
		        else  
		        	track.setRunTime(Integer.parseInt(runTime));
		        
		        track.setGenre(genre);
		        track.setAlbum(album);
	            
	            trackMap.put(trackId,track);
            }
        }
        catch (ConfigurationException e)
        {
           log.error(e.getMessage());
        	e.printStackTrace();
        }
        catch(Exception ex)
        {
        	log.error(ex.getMessage());
        	ex.printStackTrace();
        }
        
        return trackMap;
    }
    
    @SuppressWarnings("unused")
	public static void main(String as[])
    {
    	//TODO configure url
    	PropertyConfigurator.configure("E:\\lib\\Log4J.properties");
    	XmlReader xmlReader = new XmlReader();
    	Map<String, Track> tracks = xmlReader.getTracksFromXml("");
    	
    	Logger.getLogger(XmlReader.class).info("--------------size");
    	
    }
}

this is the class to get the trackId of the songs which are currently in the xml file.

now i want to compare those two different trackId and if there is any update in the xml (i.e. entry of the new song with different trackId or deletion of old song) after which trackId will not match each other then change accordingly in DB via sql query through java. please guide me about how can i be able to compare those trackid one by one and make the program further. i also wan to do that in the separate thread class which continously do the same task.

thanks in adavance.

[fred rosenberger]

I doubt you will get much help here with a post like that. If you haven't read it, you should probably check out the entries in our HowToAskQuestionsOnJavaRanch (<--click that) FAQ. Generally speaking, overly broad or general "guide me" questions don't work well here.

However, if you have a specific, focused question, you will get more help than you could ever hope for.

[duhit Choudhary]

i am sorry about my way of asking question. but i just want the solution about how can i be able to compare those two different trackId, rest all thing i am able to do.
thanks by the way.. from the next time i keep that thing in mind.

[nir sharma]

duhit Choudhary wrote:how can i be able to compare those two different trackId

well, cant you take trackIds from the hashmap (using keySet()) and compare with the trackIds in list through nested for loops?