package serverBag;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import publicBag.ConnectDB;

public class MusicFinder {

	/**
	 * @param args
	 */
	private Connection con;
	public MusicFinder()
	{
		try
        {
            con = ConnectDB.connectMusicDB();            	
        }
        catch(Exception e)
        {
            e.printStackTrace();           
        }
	}
	public ResultSet findMusicByName(String type,String name)
	{		
        try
        {        	
            PreparedStatement stat = 
            	con.prepareStatement("SELECT cMusicName,cSingerName,cCDName,dtSendTime,vDownAddr " +
					            		"FROM Musics m JOIN MusicCD cd ON m.iCDID=cd.iCDID " +
					            		"JOIN Singer s ON cd.iSingerID=s.iSingerID " +
					            		"WHERE " + type + "=?");
		
            stat.setString(1,name);                    
            ResultSet res = stat.executeQuery();    
            return res;
                       
        }
        catch(Exception e)
        {
            e.printStackTrace();
            return null;
        } 		
	}
	public ResultSet findSingerCDInfo()
	{		
        try
        {        	
            PreparedStatement stat = 
            	con.prepareStatement("SELECT iCDID,cCDName,mPrice,cSingerName,cd.vPhoto,dtSendTime " +
            			"FROM MusicCD cd JOIN Singer s ON cd.iSingerID=s.iSingerID ORDER BY dtSendTime DESC");		
                               
            ResultSet res = stat.executeQuery();    
            return res;
                       
        }
        catch(Exception e)
        {
            e.printStackTrace();
            return null;
        } 		
	}
}