public void insertShow(Show show) 
{
		
		DbConnection dbconObj=new DbConnection();
		Connection con=null;
		Statement stmt=null;
		
		try{
			
			con=dbconObj.getDbConnection();
			stmt=con.createStatement();
			stmt.executeQuery("INSERT INTO G4_show VALUES('"+show.getShow_ID()+"',"+show.getShow_Date()+",'"+show.getSlot()+"','"+show.getSeat_Capacity()+"','"+show.getSeat_Occupancy()+"','"+show.getMovie_ID()+"')");
			System.out.println("one row inserted ");
			}
		catch(SQLException sqex){
			System.out.println(sqex);
		}
		/*finally{
			stmt.close();
			con.close();
			System.out.println("Connection closed successfully");
		}*/
        

	}