import java.sql.*;

import java.text.*;


/**
 *
 */
public class SQLTester {
	
	public SQLTester(){
		
		try{
			Connection connection = null;
			
			Class.forName("org.postgresql.Driver").newInstance();
			
			System.out.println("Getting JDBC Connection");
								
			String DBURL 	= "jdbc:postgresql://133.88.30.173:5557/wbi_db";
			String DBUserName = "wbi_user";
			String DBPassword= "";
			
			System.out.println("Database URL: "+DBURL);
			System.out.println("DBUserName: "+DBUserName);
			System.out.println("DBPassword: "+DBPassword);
			
			
			String SQLquery = "select * from xworlds_events";
			connection = DriverManager.getConnection (DBURL, DBUserName, DBPassword);
			
			Statement statement = connection.createStatement();
			ResultSet resultset = statement.executeQuery(SQLquery);
			
			while(resultset.next()){
				
				int event_id = resultset.getInt("event_id");
				java.sql.Timestamp 	recordDate = resultset.getTimestamp("event_time");
				
				
				
				String recordDateString = recordDate.toString();
				long timeData = recordDate.getTime();
				
				
					
					
				System.out.println("event_id: "+event_id);
				System.out.println("timeData: "+timeData);
				System.out.println("event_time: "+recordDate);
				System.out.println("recordDateString: "+recordDateString);
				
				System.out.println("event_time: "+recordDate);
				
				
				//GetSystemTS(String INPUTformat)
				
				
				
				
				
		  
			}
			
			resultset.close();
			statement.close();
			
			
			
			connection.close();
		} catch(Exception sqle){
			System.out.println("ERROR: "+sqle.getMessage());
		}
		
	}
	
	private String GetSystemTS(String INPUTformat) {
		SimpleDateFormat formatter = new SimpleDateFormat (INPUTformat);
		java.util.Date currentTime = new java.util.Date();
		String OUTPUTtime = formatter.format(currentTime);

		return OUTPUTtime; 
	} //end SystemTS class

	

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		new SQLTester();
	}

}






